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

At the end of shutting down a database, got ORA-00600 error in alert log:

Tue Feb  3 12:30:18 2009 Starting background process EMN0 EMN0 started with pid=29, OS id=21581 Tue Feb  3 12:30:18 2009 Shutting down instance: further logons disabled Tue Feb  3 12:30:18 2009 Stopping background process QMNC Tue Feb  3 12:30:18 2009 Stopping background process CJQ0 Tue Feb  3 12:30:20 2009 Stopping background process MMNL Tue Feb  3 12:30:21 2009 Stopping background process MMON Tue Feb  3 12:30:23 2009 Shutting down instance (immediate) License high water mark = 46 Tue Feb  3 12:30:23 2009 Stopping Job queue slave processes Tue Feb  3 12:30:23 2009 Job queue slave processes stopped All dispatchers and shared servers shutdown Tue Feb  3 12:32:55 2009 ALTER DATABASE CLOSE NORMAL Tue Feb  3 12:32:55 2009 SMON: disabling tx recovery SMON: disabling cache recovery Tue Feb  3 12:32:56 2009 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 33665 Successful close of redo thread 1 Tue Feb  3 12:32:56 2009 Completed: ALTER DATABASE CLOSE NORMAL Tue Feb  3 12:32:56 2009 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 /oracle/admin/mydb/udump/mydb_ora_1541.trc Tue Feb  3 12:32:59 2009 Errors in file /oracle/admin/mydb/udump/mydb_ora_1541.trc: ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []

Note:

1.       It is a bug in Oracle 10.2.0.1/2/3/4 identified as Bug 4483084 - OERI[LibraryCacheNotEmptyOnClose] on shutdown. The bug is fixed in 11.1.0.6 base release.

2.       The error can be ignored as it just indicates that there are some items in the library cache when closing down the instance. The error itself occurs AFTER the database close and dismount stages so only affects the instance shutdown itself. Datafiles have been closed cleanly.

3.       The error is annoying because the RMAN cold backup fails when the error happens.

4.       After googling the web, two triggers were suggested to solve the issue if you have not upgraded to 11.1.0.6:

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;

More Oracle DBA tips, please visit Oracle DBA Tips  

Database administrator (dba) (Oracle DBA)

Title: Database administrator (dba) (Oracle DBA)

Terms of Employment: Temporary, Full Time

Salary: To be negotiated

Anticipated Start Date: As soon as possible

Location: Brampton, Ontario (1 vacancy)

Skill Requirements:

Education: Completion of university

Credentials (certificates, licences, memberships, courses, etc.): Oracle Certification

Experience: 3 years to less than 5 years

Languages: Speak English, Read English, Write English

Specific Skills: Design and develop database, Design, construct, modify, implement and test data models and database management systems, Conduct research and provide advice to other informatics professionals regarding the selection application and implementation of database management tools, Operate database management systems to analyze data, Develop and implement data administration policy, standards and models, Research and document data requirements, data collection and administration policy, and data access rules, Develop policies and procedures for network access and usage and for the backup and recovery of data, Conduct research and provide advice to other information systems professionals regarding the collection, availability and suitability of data, Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models

Management Systems (erp or db): Data Warehouse, Erwin, Informix, Oracle / PL-SQL / CASE / Developer 2000 / Ingres

Essential Skills: Writing, Oral communication, Working with others, Problem solving, Decision making, Critical thinking

Other Information:Candidate must have at least 5 years experience with UNIX, Informatica Administration, Oracle Administration , MS Office and MS Office Visio

Employer: Apsoft Inc

How to Apply:

Please apply for this job only in the manner specified by the employer. Failure to do so may result in your application not being properly considered for the position.

By E-mail: hr.apsoft@gmail.com

Advertised until: 2009/02/25