问题描述
在客户的9208 RAC环境中碰到了这个错误。
相信信息如下:
Thu Oct 13 18:07:25 2011 Shutting down instance: further logons disabled Shutting down instance (immediate) License high water mark = 369 Thu Oct 13 18:07:45 2011 ALTER DATABASE CLOSE NORMAL Thu Oct 13 18:07:45 2011 SMON: disabling tx recovery SMON: disabling cache recovery Thu Oct 13 18:07:45 2011 Shutting down archive processes Archiving IS disabled Thu Oct 13 18:07:45 2011 ARCH shutting down ARC0: Archival stopped Thu Oct 13 18:07:45 2011 ARCH shutting down ARC1: Archival stopped Thu Oct 13 18:07:45 2011 Thread 2 closed at log SEQUENCE 39936 Successful close OF redo thread 2 Thu Oct 13 18:07:48 2011 Completed: ALTER DATABASE CLOSE NORMAL Thu Oct 13 18:07:48 2011 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving IS disabled Shutting down archive processes Archiving IS disabled Archive process shutdown avoided: 0 active ARCH: Archiving IS disabled Shutting down archive processes Archiving IS disabled Archive process shutdown avoided: 0 active Thu Oct 13 18:12:48 2011 SHUTDOWN: waiting FOR detached processes TO terminate. Thu Oct 13 18:17:31 2011 IPC Send timeout detected. Sender ospid 446682 OUT OF MEMORY FOR message buffers Thu Oct 13 18:20:23 2011 Errors IN file /u01/product/admin/RAC/bdump/rac2_lms0_446682.trc: ORA-00600: internal error code, arguments: [kjccgmb:1], [], [], [], [], [], [], [] Thu Oct 13 18:20:23 2011 Errors IN file /u01/product/admin/RAC/bdump/rac2_lms0_446682.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-00600: internal error code, arguments: [kjccgmb:1], [], [], [], [], [], [], [] OUT OF MEMORY FOR message buffers Thu Oct 13 18:22:03 2011 Errors IN file /u01/product/admin/RAC/bdump/rac2_lms0_446682.trc: ORA-00600: internal error code, arguments: [kjccgmb:1], [], [], [], [], [], [], [] ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-00600: internal error code, arguments: [kjccgmb:1], [], [], [], [], [], [], [] Thu Oct 13 18:22:04 2011 Errors IN file /u01/product/admin/RAC/bdump/rac2_lms0_446682.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-00600: internal error code, arguments: [kjccgmb:1], [], [], [], [], [], [], [] ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-00600: internal error code, arguments: [kjccgmb:1], [], [], [], [], [], [], [] Thu Oct 13 18:25:31 2011 Starting ORACLE instance (normal)
专家解答
查询了一下metalink,确实有一篇文章和当前的描述很相似,问题同样是出在LMS进程上。但是区别在于,bug描述的问题导致实例发挥例CRASH,而当前是在手工运行SHUTDOWN IMMEDIATE操作所引发的问题。
由于是关闭实例所触发的问题,因此如果不是经常出现,可以直接忽略掉这个错误。
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。