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;
/