ORA-00600 12807 Oracle建表失败

若在使用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:

  • Internal Error May Occur (ORA-600)
  • ORA-600 [12807]
  • Constraint Related

 

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




Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *