联系:手机/微信(+86 17813235971) QQ(107644445)
标题:ORA-600 [LibraryCacheNotEmptyOnClose] on shutdown
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
一、现象
alert.log中记录
Mon May 9 19:56:10 2011(shutdown 数据库过程中)
Errors in file /opt/oracle/admin/xunzhi/udump/xunzhi_ora_328.trc:
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
trace中记录
*** 2011-05-09 19:56:10.843 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], [] Current SQL information unavailable - no session. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedst()+31 call ksedst1() 000000000 ? 000000001 ? 7FFFB5A19840 ? 7FFFB5A198A0 ? 7FFFB5A197E0 ? 000000000 ? ksedmp()+610 call ksedst() 000000000 ? 000000001 ? 7FFFB5A19840 ? 7FFFB5A198A0 ? 7FFFB5A197E0 ? 000000000 ? ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ? 7FFFB5A19840 ? 7FFFB5A198A0 ? 7FFFB5A197E0 ? 000000000 ? kgerinv()+161 call ksfdmp() 000000003 ? 000000001 ? 7FFFB5A19840 ? 7FFFB5A198A0 ? 7FFFB5A197E0 ? 000000000 ? kgeasnmierr()+163 call kgerinv() 0068966E0 ? 01EFD6610 ? 7FFFB5A198A0 ? 7FFFB5A197E0 ? 000000000 ? 000000000 ? kglshu()+757 call kgeasnmierr() 0068966E0 ? 01EFD6610 ? 7FFFB5A198A0 ? 7FFFB5A197E0 ? 000000000 ? 000000001 ? kqlnfy()+468 call kglshu() 0068966E0 ? 000000000 ? 7FFFB5A198A0 ? 7FFFB5A197E0 ? 000000000 ? 000000001 ? kscnfy()+587 call kqlnfy() 000000018 ? 000000000 ? 7FFFB5A198A0 ? 7FFFB5A197E0 ? 000000000 ? 000000001 ? ksmshu()+269 call kscnfy() 000000018 ? 000000000 ? 000000000 ? 7FFFB5A197E0 ? 000000000 ? 000000001 ? opistp_real()+1052 call ksmshu() 000000018 ? 000000000 ? 000000000 ? 7FFFB5A197E0 ? 000000000 ? 000000001 ? opistp()+309 call opistp_real() 000000031 ? 000000002 ? 7FFFB5A1E560 ? 000000000 ? 000000000 ? 000000001 ? opiodr()+984 call opistp() 000000031 ? 000000002 ? 7FFFB5A1E560 ? 000000000 ? 000000000 ? 000000001 ? ttcpip()+1012 call opiodr() 000000031 ? 000000002 ? 7FFFB5A1E560 ? 000000000 ? 0059C02A8 ? 000000001 ? opitsk()+1322 call ttcpip() 00689E3B0 ? 000000001 ? 7FFFB5A1E560 ? 000000000 ? 7FFFB5A1E058 ? 7FFFB5A1E6C8 ? opiino()+1026 call opitsk() 000000003 ? 000000000 ? 7FFFB5A1E560 ? 000000001 ? 000000000 ? 4E5000B00000000 ? opiodr()+984 call opiino() 00000003C ? 000000004 ? 7FFFB5A1F728 ? 000000001 ? 000000000 ? 4E5000B00000000 ? opidrv()+547 call opiodr() 00000003C ? 000000004 ? 7FFFB5A1F728 ? 000000000 ? 0059C0460 ? 4E5000B00000000 ? sou2o()+114 call opidrv() 00000003C ? 000000004 ? 7FFFB5A1F728 ? 000000000 ? 0059C0460 ? 4E5000B00000000 ? opimai_real()+163 call sou2o() 7FFFB5A1F700 ? 00000003C ? 000000004 ? 7FFFB5A1F728 ? 0059C0460 ? 4E5000B00000000 ? main()+116 call opimai_real() 000000002 ? 7FFFB5A1F790 ? 000000004 ? 7FFFB5A1F728 ? 0059C0460 ? 4E5000B00000000 ? __libc_start_main() call main() 000000002 ? 7FFFB5A1F790 ? +244 000000004 ? 7FFFB5A1F728 ? 0059C0460 ? 4E5000B00000000 ? _start()+41 call __libc_start_main() 000723088 ? 000000002 ? 7FFFB5A1F8E8 ? 000000000 ? 0059C0460 ? 000000002 ?
二、问题展示形式
ORA-600 [LibraryCacheNotEmptyOnClose] is reported in the alert.log on shutdown
The trace file shows the following call stack trace and will also include a System State:
kglshu kqlnfy kscnfy ksmshu opistp_real opistp opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main libc_start_main
三、问题原因及其后果
This is a bug in that an ORA-600 error is reported when it is found during shutdown, after database close, that there are still objects in the library cache. It does not indicate any damage or a problem in the system.
Ignore the error as it just indicates that there are some items in the library cache when closing down the instance. The error itself occurs AFTER the database close and dismount stages so only affects the instance shutdown itself. Datafiles have been closed cleanly.