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

​