问题描述
客户的10.2.0.1 RAC for AIX数据库在关闭一个节点时碰到这个错误。
告警日志中信息如下:
Tue Jan 10 21:11:42 2012 Shutting down instance (immediate) License high water mark = 721 Tue Jan 10 21:11:42 2012 Stopping Job queue slave processes Tue Jan 10 21:11:42 2012 Job queue slave processes stopped ALL dispatchers AND shared servers shutdown Tue Jan 10 21:11:52 2012 PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump Tue Jan 10 21:12:04 2012 PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump Tue Jan 10 21:12:12 2012 Shutting down instance (abort) License high water mark = 721 Tue Jan 10 21:12:13 2012 Errors IN file /u01/app/oracle/admin/wdyx/udump/wdyx1_ora_1434094.trc: ORA-27300: OS system dependent operation:invalid_process failed WITH STATUS: 0 ORA-27301: OS failure message: Error 0 ORA-27302: failure occurred at: skgpstime3 ORA-27144: attempt TO KILL process failed
专家解答
显然SHUTDOWN IMMEDIATE无法正常关闭数据库,必须使用SHUTDOWN ABORT来完成数据库的关闭操作,但是SHUTDOWN ABORT在关闭时引发了ORA-27144错误。
在MOS文档The following Errors are reported during Shutdown Immediate: ORA-27300, ORA-27301, ORA-27302, ORA-27144 [ID 1186504.1]描述了这个问题,Oracle给出的建议是直接忽略这个问题。
文档中出现这个错误的是10.2.0.4版本,但是在出现ORA-27144错误后能正常关闭,而不像当前10.2.0.1版本这样,在SHUTDOWN IMMEDIATE时出现PMON failed to acquire latch信息,而SHUTDOWN ABORT后才出现ORA-27144错误。
看来升级到高版本虽然不能完全的解决这个问题,但是至少可以解决SHUTDOWN IMMEDIATE无法正常关闭的问题。
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。