前段时间遇到了一个600错误,刚开始下了我一身冷汗,后来网上查了一下资料,呼。。。。。。
1. 情况描述
shutdown 10.2.0.4 版本的instance时报错:
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
SQL> conn / as sysdba
Connected.
SQL> show parameter instance
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string rcat
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\ORACLE\PRODUCT\10.2.0\DB_1\
DATABASE\SPFILERCAT.ORA
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
2. 原因
This is due to unpublished Bug 4483084 'ORA-600 [LIBRARYCACHENOTEMPTYONCLOSE]' This is a bug in that an ORA-600 error is reported when it is found that something is still going on during shutdown.
It does not indicate any damage or a problem in the system.ORA-600 [LibraryCacheNotEmptyOnClose] is reported in the alert.log on shutdown.
The error can be safely ignored as it does not indicate a problem with the database.
参考文献:
1. ORA-600 [Librarycachenotemptyonclose] Reported At Shutdown [ID 365103.1]
2. http://space.itpub.net/7607759/viewspace-441034
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9252210/viewspace-630919/ ,如需转载,请注明出处,否则将追究法律责任。