ORA00600:[kole_t2u], [34], [], [], [], [], [], [], [], [], [], []

  这段时间,我们公司的生产库在流备份端经常出现ORA-00600:[kole_t2u], [34], [], [], [], [], [], [], [], [], [], []这一报错信息。通过报警日志找到相应的TRC文件。
 
文件内容如下:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 8 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:12601M/24565M, Ph+PgF:37117M/48349M
Instance name: kingstrm
Redo thread mounted by this instance: 1
Oracle process number: 10
Windows thread id: 2608, image: ORACLE.EXE (AS02)
 
 
*** 2012-03-21 16:55:25.046
*** SESSION ID:(60.5278) 2012-03-21 16:55:25.046
*** CLIENT ID:() 2012-03-21 16:55:25.046
*** SERVICE NAME:(SYS$USERS) 2012-03-21 16:55:25.046
*** MODULE NAME:(STREAMS) 2012-03-21 16:55:25.046
*** ACTION NAME:(STREAMS Apply Server) 2012-03-21 16:55:25.046
 
 03/21/2012 16:55:03Unhandled datatype (112) found in kzabndinf
cur=12 bnd=01 dty=112
 
*** 2012-03-21 16:55:26.843
DDE: Problem Key 'ORA 600 [kole_t2u]' was flood controlled (0x2) (incident: 67484)
ORA-00600: 内部错误代码, 参数: [kole_t2u], [34], [], [], [], [], [], [], [], [], [], []
FGA Policy Audit Initialization has Error 600
 
*** 2012-03-21 16:55:28.187
DDE: Problem Key 'ORA 600 [ORA-00600: 内部错误代码, 参数: [kole_t2u], [34], [], [], [], [], [], [], [], [], [], []
]' was flood controlled (0x2) (incident: 67485)
ORA-00600: 内部错误代码, 参数: [kole_t2u], [34], [], [], [], [], [], [], [], [], [], []
 
  看到报错信息中存在“FGA Policy Audit Initialization has Error 600”这样的内容。从谷哥跟度娘那搜索到eagle的一篇文章,但是最终日志找不到相似的地方,只能硬着头皮去临时解决一下问题,结果第二天,这问题又重现了。这次的报错中也能找到“FGA Policy Audit Initialization has Error 600”,这使我不得不认真的研究一下这是什么问题导致的。跟warehouse讨论了一下无结果找了一下资料看了看,就找当时在这个库搞审计的哥们了解清楚这个库的一些情况,他说应该是pool的设置问题,但是我老是觉得不是这个问题引起的。其实,这个是备份库,审计弄不弄并无什么大碍的,所以当时我想把审计给停掉。那问题应该是可以解决的。突然,一点灵光,我前段时间撤换数据库的时候把重新跑了一下审计的脚本,我估计是跟那有关系,在备库中重新跑了一下审计。该错误暂时还没有呈现。
原文地址:https://www.cnblogs.com/nolanchan/p/8016319.html