Home » RDBMS Server » Server Administration » ORA-00600: LibraryCacheNotEmptyOnClose
ORA-00600: LibraryCacheNotEmptyOnClose [message #223545] Fri, 09 March 2007 07:11 Go to next message
buck444
Messages: 80
Registered: January 2006
Location: Luxembourg
Member
Hello,

the Enterprise manager is showing me the following alert:

ORA-error stack (00600[LibraryCacheNotEmptyOnClose]) logged in D:\ORACLE\ADMIN\prod\BDUMP\alert_prod.log.


It appears when i'm shutting down the database for cold backup with:

shutdown immediate


This shutdown process creates the following entry in the alert_prod.log:

Tue Mar 06 21:55:01 2007
Shutting down instance: further logons disabled
Tue Mar 06 21:55:01 2007
Stopping background process QMNC
Tue Mar 06 21:55:01 2007
Stopping background process CJQ0
Tue Mar 06 21:55:02 2007
Stopping background process MMNL
Tue Mar 06 21:55:03 2007
Stopping background process MMON
Tue Mar 06 21:55:04 2007
Shutting down instance (immediate)
License high water mark = 86
Tue Mar 06 21:55:04 2007
Stopping Job queue slave processes
Tue Mar 06 21:55:04 2007
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Tue Mar 06 21:55:13 2007
ALTER DATABASE CLOSE NORMAL
Tue Mar 06 21:55:13 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Mar 06 21:55:13 2007
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 785
Successful close of redo thread 1
Tue Mar 06 21:55:14 2007
Completed: ALTER DATABASE CLOSE NORMAL
Tue Mar 06 21:55:14 2007
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 d:\oracle\admin\prod\udump\prod_ora_3688.trc
Tue Mar 06 21:55:16 2007
Errors in file d:\oracle\admin\prod\udump\prod_ora_3688.trc:
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []


It is not marked as "critical" in the Enterprise manager, but i would like to make sure that the method of shutting down for the cold backup is ok.

Oracle Version: 10.2.0.3.0

Thanks for any ideas / pointings to the right direction.


[Updated on: Fri, 09 March 2007 07:14]

Report message to a moderator

Re: ORA-00600: LibraryCacheNotEmptyOnClose [message #223555 is a reply to message #223545] Fri, 09 March 2007 07:49 Go to previous messageGo to next message
buck444
Messages: 80
Registered: January 2006
Location: Luxembourg
Member
Hi,

just to inform anyone who might have this alert: i've found a forum discussion at the OTN: http://forums.oracle.com/forums/thread.jspa?messageID=1725800&#1725800

[Updated on: Fri, 09 March 2007 07:50]

Report message to a moderator

Re: ORA-00600: LibraryCacheNotEmptyOnClose [message #487809 is a reply to message #223545] Sun, 02 January 2011 05:52 Go to previous message
psaleh
Messages: 1
Registered: April 2008
Junior Member
According to metalink note 4483084.8, it is a bug in versions 10.2.0.1 - 10.2.0.4 and can be safely ignored. It's fixed in 11.1.0.6.
Previous Topic: Allocating extent to a clob column of a table!
Next Topic: chaning of SID oracle Database
Goto Forum:
  


Current Time: Tue Apr 23 09:21:21 CDT 2024