If you are running Oracle 10gR2 10.2.0.1 to 10.2.0.5 and encounter this error
on shutdown you ran into either unpublished bug 4483084 or bug 7572335. Both
bugs deal with objects left in the library cache at shutdown and do not
indicate a problem in the data or database and can be ignored.
The bug is fixed in 10.2.0.5 and 11g. There might be patches availble for your
version so you should collect the alert log and associated trace files and
open a service request with Oracle Support.
A workaround is a to create a trigger to flush the shared pool at shutdown.
CREATE OR REPLACE TRIGGER ORA0600_LIBCNOTEMPTYONCLOSE BEFORE SHUTDOWN ON DATABASE BEGIN EXECUTE IMMEDIATE 'ALTER SYSTEM FLUSH SHARED_POOL'; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR (-20000,'Error flushing pool'); END; /