Skip to content

ORA-00600: internal error code

03/07/2012

When shutting down the database, I encountered the following:

SQL> shutdown immediate
Database closed.
Database dismounted.
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []

CAUSE.

The cause of the error is that there are still objects in the library cache when the database shutdowns. The database is fine; there is no damage to or problem with the system.

SOLUTION.

Bug 4483084 is fixed in 11.1.0.6, the error can be safely ignored as it does not indicate a problem with the database. A work around to avoid the problem, or if the database appears hung on shutdown, is as follows:

shutdown abort
startup restrict
shutdown immediate

Bug 7572335 is fixed in 11.2 and 10.2.0.5 with one-off fixes available for 10.2.0.4 and 11.1.0.7. This bug is caused when cursors have been marked as kept in the shared pool, e.g. by using the dbms_shared_pool.keep function on an open query in v$sqlarea.

FURTHER INFORMATION.

Search “My Oracle Support” for 153788.1, the first result will be the ORA-600 / ORA-7445 Look-up Tool.

The ORA-600 Error Code is selected by default.
Enter the Error Code First Argument, in this example, “LibraryCacheNotEmptyOnClose”.
Select the Oracle RDBMS Version, in this example, “10.2.0.3”.
Click Look-up Error.

A dialog box appears with Document 466425.1 linked. Open this link.

The article states that it is a partially published OERI note. There is a related article (365103.1 ORA-600 [LibraryCacheNotEmptyOnClose] Reported At Shutdown).

Also Known Bugs are listed; 7572335 and 4483084.

Advertisements

From → ORA Errors, Oracle

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: