数据库关闭过程中出现这个错误。
错误信息如下:
Sat May 14 20:12:58 EAT 2011 Shutting down instance (immediate) Sat May 14 20:12:58 EAT 2011 Shutting down instance: further logons disabled Sat May 14 20:13:00 EAT 2011 Stopping background process CJQ0 Sat May 14 20:13:00 EAT 2011 Stopping background process QMNC Sat May 14 20:13:01 EAT 2011 Stopping background process MMNL Sat May 14 20:13:02 EAT 2011 Stopping background process MMON License high water mark = 537 Sat May 14 20:13:04 EAT 2011 Job queue slave processes stopped Waiting FOR dispatcher 'D000' TO shutdown ALL dispatchers AND shared servers shutdown Sat May 14 20:13:07 EAT 2011 ALTER DATABASE CLOSE NORMAL Sat May 14 20:13:07 EAT 2011 SMON: disabling tx recovery SMON: disabling cache recovery Sat May 14 20:13:07 EAT 2011 Block CHANGE tracking service stopping. Sat May 14 20:13:07 EAT 2011 Stopping background process CTWR Sat May 14 20:13:12 EAT 2011 Shutting down archive processes Archiving IS disabled Sat May 14 20:13:17 EAT 2011 ARCH shutting down ARC1: Archival stopped Sat May 14 20:13:22 EAT 2011 ARCH shutting down ARC0: Archival stopped Sat May 14 20:13:23 EAT 2011 Thread 2 closed at log SEQUENCE 58833 Successful close OF redo thread 2 Sat May 14 20:14:49 EAT 2011 Completed: ALTER DATABASE CLOSE NORMAL Sat May 14 20:14:49 EAT 2011 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 Sat May 14 20:14:52 EAT 2011 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_lms4_27651.trc: ORA-00600: internal error code, arguments: [kjbclose:L], [0xC00000091DF8B308], [], [], [], [], [], [] Sat May 14 20:14:54 EAT 2011 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_lms5_27653.trc: ORA-00600: internal error code, arguments: [kjbclose:L], [0xC000001124FB8998], [], [], [], [], [], [] Sat May 14 20:14:59 EAT 2011 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_lms4_27651.trc: ORA-00600: internal error code, arguments: [kjbclose:L], [0xC00000091DF8B308], [], [], [], [], [], [] Sat May 14 20:14:59 EAT 2011 LMS4: terminating instance due TO error 484 Sat May 14 20:15:01 EAT 2011 Shutting down instance (abort) License high water mark = 537 Sat May 14 20:15:05 EAT 2011 Instance TERMINATED BY LMS4, pid = 27651 Sat May 14 20:15:06 EAT 2011 Instance TERMINATED BY USER, pid = 15724 |
虽然这个错误发生在系统进程LMS上,但是由于是在关闭数据库的阶段,因此可能是由于数据库关闭状态导致。
在MOS文档Bug 10209426 RAC instance crash due to ORA-600 [kjbclose:L] in LMS描述了这个bug,确认影响版本为10.2.0.4,而Oracle目前还没有确认解决这个bug的版本。而这个bug的产生可能与关闭远端并行服务通信产生的锁有关。
而对于当前的环境而言,本身就是在数据库的关闭阶段,因此即使产生了CRASH也并不会造成太严重的后果,无非是将SHUTDOWN IMMEDIATE升级为SHUTDOWN ABORT。
如果在其他情况下碰到这个错误,需要随时关注Oracle是否提供专门的PATCH解决这个问题。