Database crashes with ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []

 Cause

Unpublished Bug: 4483084 says that this particular ORA-600 error can be ignored as it means nothing - there is no error.

This ORA-600 is in itself harmless and indicates that some other activity was taking place in the database at the time of shutdown; it can be safely ignored as there is no problem with the database.

Solution

1. Upgrade to database version 11.1.0.6 when it is available

OR as a work around after seeing the error

2  use addbctl.sh script to start the Database again

OR

3.  After googling in the web, two triggers were suggested to resolve this issue:

CREATE or replace TRIGGER flush_shared_pool

BEFORE SHUTDOWN ON DATABASE

BEGIN

  execute immediate 'ALTER SYSTEM FLUSH SHARED_POOL';

EXCEPTION

  WHEN OTHERS THEN

  RAISE_APPLICATION_ERROR (num => -20000, msg => 'Error flushing pool');

END;

CREATE or replace TRIGGER flush_shared_pool

BEFORE SHUTDOWN ON DATABASE

BEGIN

  execute immediate 'alter TRIGGER SYS.OLAPISTARTUPTRIGGER DISABLE';

  execute immediate 'ALTER TRIGGER SYS.OLAPISHUTDOWNTRIGGER DISABLE';

  execute immediate 'ALTER SYSTEM FLUSH SHARED_POOL';

  execute immediate 'alter TRIGGER SYS.OLAPISTARTUPTRIGGER ENABLE';

  execute immediate 'ALTER TRIGGER SYS.OLAPISHUTDOWNTRIGGER ENABLE';

EXCEPTION

  WHEN OTHERS THEN

  RAISE_APPLICATION_ERROR (num => -20000, msg => 'Error flushing pool');

END;

Alert log

Wed Jan 05 06:10:01 2011
ARCH shutting down
ARC0: Archival stopped
Wed Jan 05 06:10:02 2011
Thread 1 closed at log sequence 12677
Successful close of redo thread 1
Wed Jan 05 06:10:02 2011
Completed: ALTER DATABASE CLOSE NORMAL
Wed Jan 05 06:10:02 2011
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\product\10.2.0\admin\ORCLPROD\udump\ORCLPROD_ora_828.trc
Wed Jan 05 06:10:06 2011
Errors in file d:\oracle\product\10.2.0\admin\ORCLPROD\udump\ORCLPROD_ora_828.trc:
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []