若在使用Oracle过程中遇到ORA-00600: internal error code, arguments: [12807], [], [], [], [], [], [], [] 错误 ,特别是 金蝶EAS 应用 使用过程中遇到该错误;则说明可能该Oracle数据库的CON$约束基础表的上限耗尽。该错误会导致后续无法创建任何表和临时表。
针对该问题,一般需要通过打PATH后者重建数据库解决。25343563 : MECHANISM TO REUSE CON# , CON$表上的CON# 可重用。
对于特别大的数据库和停机时间较短的数据库,诗檀软件可以提供快速恢复服务。
Bug 13781691 ORA-600 [12807] if CON$.CON# very high due to bug 13784384
Affects:
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected (Not specified) Versions confirmed as being affected
- 11.2.0.3
- 11.2.0.2
- 11.1.0.7
- 10.2.0.5
Platforms affected Generic (all / most platforms affected)
Fixed:
The fix for 13781691 is first included in
- 12.1.0.1 (Base Release)
- 11.2.0.4 (Server Patch Set)
Symptoms: |
Related To: |
|
|
Description
An ORA-600[12807] occurs if CON$.CON# reaches a very high value. This typically can occur due to bug 13784384. This fix raises the upper limit of CON$.CON# for cases where it has hit the limit. Note: It is vital to also find the cause of CON$.CON# increasing so much and ensure that cause is patched otherwise you may hit this new higher limit. Workaround None
Leave a Reply