ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]怎么解决？

关闭数据库时提示ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]

这个错误是一个bug引发，可以忽略，对数据库和系统没有任何影响。

下面是oracle metalink的搜索结果：

 ORA-600 [Librarycachenotemptyonclose] Reported At Shutdown [ID 365103.1]

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.

Symptoms

o  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 mechanism 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 by
deactivating the associated triggers.

Cause

This 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.5 but there are also one-off fixes available on top of 10.2.0.4 and 11.1.0.7.