ITPub博客

首页 > Linux操作系统 > Linux操作系统 > SHUTDOWN IMMEDIATE出现ORA-27144错误

SHUTDOWN IMMEDIATE出现ORA-27144错误

原创 Linux操作系统 作者:yangtingkun 时间:2012-02-10 23:58:33 0 删除 编辑

客户的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无法正常关闭的问题。

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-716078/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10366576