shutdown碰到一个ORA-00600
碰到一个ORA-00600
SQL> conn / as sysdba
已联机.
SQL> shutdown immediate;
数据库关闭.
数据库已卸除.
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
SQL> startup mount
ORACLE 执行处理已启动.
Total System Global Area 1258291200 bytes
Fixed Size 1298280 bytes
Variable Size 310378648 bytes
Database Buffers 939524096 bytes
Redo Buffers 7090176 bytes
数据库已挂载.
SQL> alter database archivelog;
已更改数据库.
SQL> alter database open;
已更改数据库.
According to Metalink note 4483084.8 "Bug 4483084 - OERI[LibraryCacheNotEmptyOnClose] on shutdown" this error message could be
ignored. Bug is fixed in 11.1.0.6.
数据库从Linux平台(oracle 10.2.0.4.0 32bit)移转到windows(oracle 10.2.0.4 64bit)，在数据库shutdown时偶尔会出现此错误。
参考网上资料，建立一个触发器避免问题的出现：
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;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9932141/viewspace-630527/ ，如需转载，请注明出处，否则将追究法律责任。
