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