Today I suddenly encountered a ORA-00600 error while shutting down the database normally in the test environment, my database version is 10.2.0.411: 32: 57MYHSZHLC @ SYSgt; shutdownimmedi
Today I suddenly encountered a ORA-00600 error while shutting down the database normally in the test environment, my database version is 10.2.0.411: 32: 57 MYHSZHLC @ SYSgt; shutdown immedi
Today I suddenly encountered a ORA-00600 error while shutting down the database normally in the test environment, my database version is 10.2.0.4
11:32:57 MYHSZHLC @ SYS> shutdown immediate
Database closed.
Database dismounted.
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], [], []
Check the MOS and find that this is an Oracle Bug, and there is no corresponding patch in 10.2.0.4,However, this Bug can be ignored!
However, you can also use the "alter system flush SHARED_POOL" SQL statement to clear the libray pool before each shutdown to solve the problem,But I decided there was no need!
ORA-600 [Librarycachenotemptyonclose] Reported At Shutdown [ID 365103.1]
Modification time: 14-DEC-2011 type PROBLEM status PUBLISHED
In this Document
Applies to: Oracle Server-Enterprise Edition-Version: 10.2.0.1 to 10.2.0.5-Release: 10.2 to 10.2
Information in this document applies to any platform.
Symptomso 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
O Using the Mechanic described in Note 301171.1 to pin objects in the Shared Pool
Might cause the error. The problem disappears when the pinning of objects is stopped
Deactivating the associated triggers.
CauseThis may be due to unpublished Bug 4483084 'ora-600 [LIBRARYCACHENOTEMPTYONCLOSE]'
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.
There is a separate issue, Bug 7572335: ORA-600 [LIBRARYCACHENOTEMPTYONCLOSE]/ORA-600 [730] during shutdown, which can occur if child cursors are still marked 'kept 'in the library cache at shutdown. if you are not sure which issue you are encountering, please submit your traces to Global Software Support.
Solution
Bug 4483084 is fixed in 11.1.0.6.
Due to the nature of the fix, it is not possible to backport to earlier releases.
The error can be safely ignored as it does not indicate a problem with the database.
Bug 7572335 is fixed in 11.2 and 10.2.0.5But there are also one-off fixes available on top of 10.2.0.4 and 11.1.0.7.
DescriptionORA-600 [LibraryCacheNotEmptyOnClose] can occur during shutdown. workaround Ignore the error as it just indicates that there aresome items in the library cache when closing downthe instance. the error itself occurs AFTER the databaseclose and dismount stages so only affects the instanceshudown itself. datafiles have been closed cleanly. if the database appears hung on the shutdown, or toavoid the error use the following shutdown commands: shutdown abortstartup restrictshutdown immediateNote: it is not possible to get one-off patches for this issue in any 10g release. please note: The above is a summary description only. actual symptoms can vary. matching to any symptoms here does not confirm that you are encountering this problem. for questions about this bug please consult Oracle Support.
