天天看点

ORA-27300,ORA-27301,ORA-27302: failure occurred at: skgpalive1(原创)

故障报错如下

Wed Mar 07 16:42:43 GMT+08:00 2012Errors in file /oracle10g/app/oracle/admin/zgscdb/udump/zgscdb1_ora_55247194.trc:

ORA-27300: OS system dependent operation:invalid_process_id failed with status: 0

ORA-27301: OS failure message: Error 0

ORA-27302: failure occurred at: skgpalive1

ORA-27300,ORA-27301,ORA-27302事实上有很多报错原因,主要是数据库和操作系统交互时引起的报错,大部分为bug,上述报错是由于bug 10010310引起的,需要打patch 10010310补丁。metalink上的具体信息如下

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.5 and later   [Release: 10.2 and later ]

Information in this document applies to any platform.

Database alert_<ORACLE_SID>.log shows following error and keeps running:

Errors in file /u04/admin/njord/udump/njord_ora_25895.trc:

ORA-27300: OS system dependent operation:invalid_process_id failed with status: 0

ORA-27301: OS failure message: Error 0

ORA-27302: failure occurred at: skgpalive1

Applied 10.2.0.5 patch set.

This is caused by ​​bug 10010310​​

​​bug 10010310​​​ is fixed in 11.2.0.3, 12.1 and above. Please check ​​patch 10010310​​ for existing interim patches.

​​BUG:10010310​​​ - ORA-27300: INVALID_PROCESS_ID FAILED WITH STATUS: 0; ORA-27302: SKGPALIVE1

​​​BUG:10154137​​​ - ORA-27300: OS SYSTEM DEPENDENT OPERATION:INVALID_PROCESS_ID FAILED WITH STATUS 0

​​​BUG:10207340