又是一个和SHUTDOWN有关的ORA-600错误。
同样和HP UNIX上的10204数据库,不过这个数据库并非是RAC环境,因此这个错误和RAC也没有关系。
Mon Oct 18 15:49:32 2010
Shutting down instance: further logons disabled
Mon Oct 18 15:49:33 2010
Stopping background process QMNC
Mon Oct 18 15:49:33 2010
Stopping background process CJQ0
Mon Oct 18 15:49:35 2010
Stopping background process MMNL
Mon Oct 18 15:49:36 2010
Stopping background process MMON
Mon Oct 18 15:49:37 2010
Shutting down instance (immediate)
License high water mark = 19
Mon Oct 18 15:49:37 2010
Stopping Job queue slave processes, flags = 7
Mon Oct 18 15:49:37 2010
Process OS id : 360277 alive after kill
Errors in file
Mon Oct 18 15:49:37 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Mon Oct 18 15:49:40 2010
ALTER DATABASE CLOSE NORMAL
Mon Oct 18 15:49:40 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Oct 18 15:49:40 2010
Shutting down archive processes
Archiving is disabled
Mon Oct 18 15:49:45 2010
ARCH shutting down
ARC1: Archival stopped
Mon Oct 18 15:49:50 2010
ARCH shutting down
ARC0: Archival stopped
Mon Oct 18 15:49:51 2010
Thread 1 closed at log sequence 69
Successful close of redo thread 1
Mon Oct 18 15:49:52 2010
Completed: ALTER DATABASE CLOSE NORMAL
Mon Oct 18 15:49:52 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
System State dumped to trace file /fgms/oracle10g/admin/B1FGMS/udump/b1fgms_ora_360308.trc
Mon Oct 18 15:49:54 2010
Errors in file /fgms/oracle10g/admin/B1FGMS/udump/b1fgms_ora_360308.trc:
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
这个错误并不是什么大问题,也不会造成什么危害,这是数据库关闭后,在library cache中仍然存在对象,其实ORA-600的这个参数LibraryCacheNotEmptyOnClose已经明确的说明导致这个600错误的原因了。
在metalink文档ID 365103.1中描述了这个bug:Bug 4483084。Oracle在11g中fixed了这个问题,而确认影响的版本是从10201到10204.