ORA-600(kjzhablar:idx)错误【转】-CSDN博客

http://yangtingkun.itpub.net/post/468/526353

错误信息为：

Sat May 14 18:54:55 EAT 2011
Errors in file /oracle/app/admin/orcl/bdump/orcl1_diag_3889.trc:
ORA-00600: internal error code, arguments: [kjzhablar:idx], [1], [1], [0x9FFFFFFFFD343AB4], [], [], [], []
Sat May 14 18:54:57 EAT 2011
Trace dumping is performing id=[cdmp_20110514185457]

对应的TRACE文件包含下面的信息：

*** 2011-05-14 18:54:52.638
Switch to short timeout for ipc polling
a session (kjzha) is registered
session (kjzha) is about to end
Registered session (kjzha)[11][4][0][1] is cleaned up
Switch to long timeout for ipc polling
Switch to short timeout for ipc polling
a session (kjzha) is registered
*** 2011-05-14 18:54:55.828
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kjzhablar:idx], [1], [1], [0x9FFFFFFFFD343AB4], [], [], [], []
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+64 call ksedst1() 000000000 ? 000000001 ?
ksedmp()+2176 call ksedst() 000000000 ?
C000000000000D20 ?
4000000003EC4A80 ?
000000000 ? 000000000 ?
000000000 ?
ksfdmp()+112 call ksedmp() 000000003 ?
9FFFFFFFFFFFBB00 ?
60000000000AF0E0 ?
9FFFFFFFFFFFC0D0 ?
C000000000000999 ?
4000000003F0CAF0 ?
kgerinv()+304 call ksfdmp() 9FFFFFFFFFFFC660 ?
000000003 ?
9FFFFFFFFFFFC0E0 ?
60000000000AF0E0 ?
C000000000000612 ?
40000000097509D0 ?
kgeasnmierr()+144 call kgerinv() 60000000000318D0 ?
40000000019720C0 ?
6000000000032988 ?
40000000019720C0 ?
9FFFFFFFFFFFC6A0 ?
kjzhablar()+1008 call kgeasnmierr() 60000000000318D0 ?
60000000002F0E78 ?
60000000002F0E88 ?
6000000000032D00 ?
000000000 ?

这种有后台进程导致的ORA-600错误，多半和bug有关，查询MOS文档Bug 9062296 - DIAG process gets ORA-600[kjzhablar:idx] in RAC env [ID 9062296.8]描述的就是这个错误。在Rac环境的一个节点上DIAG进程出现这个ORA-600错误。

这个错误一般发生在读取V$SESSION的阻塞会话信息时，确认影响的版本是10.2.0.4正是当前的版本，Oracle将在解决这个bug的超集bug:9322219时将这个问题解决。因此这个bug在10.2.0.5.5中被修正。

Oracle给出的临时解决方案是通过设置隐含参数_diag_daemon为FLASE，来禁用DIAG进程。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7191998/viewspace-757273/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7191998/viewspace-757273/