ora-600 内部错误[librarycachenotemptyonclose]

 

在测试机器上正常关闭数据库shutdown immediately遭遇ora-600 内部错误[librarycachenotemptyonclose]：

Alert告警文件最后有这样的信息：

Tue Apr 17 18:05:53 2012

Completed: ALTER DATABASE CLOSE NORMAL

Tue Apr 17 18:05:53 2012

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

System State dumped to trace file f:\oracle\product\10.2.0\admin\zxh\udump\zxh_ora_7780.trc

Tue Apr 17 18:05:59 2012

Errors in file f:\oracle\product\10.2.0\admin\zxh\udump\zxh_ora_7780.trc:

ORA-00600: 内部错误, 参数: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []

=====================================================================

上网查资料，发现是oracle的bug，影响的版本是企业版10.2.0.1到10.2.0.5（测试机的版本是10.2.0.3），已经在11g中fixed

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

In this Document
Symptoms
Cause
Solution
References

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

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.

If the database appears hung on the shutdown, or to avoid the error, use the following shutdown commands:

shutdown abort
startup restrict
shutdown immediate

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.

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

转载于:http://blog.itpub.net/21256317/viewspace-776756/