ORA-27300 ORA-27301 ORA-27302: failure occurred at: skgpalive1

来源：互联网发布：sql 行转列编辑：程序博客网时间：2024/04/30 09:05

今天检查alert日志的时候发现的的错误:ORA-27300、ORA-27301、ORA-27302；oracle版本10.2.0.5 RAC ON HP UNIX 11.31。记录以下信息备查，参考metalink文章ID 1252265.1

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.

Symptoms

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

Changes

Applied 10.2.0.5 patch set.

Cause

This is caused by bug 10010310

Solution

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

References

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 - ORA-27302 SKGPALIVE1 AFTER UPGRADE TO 10.2.0.5.0