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

最新推荐文章于 2021-04-12 02:58:51 发布

huang_tg

最新推荐文章于 2021-04-12 02:58:51 发布

阅读量4.8k

点赞数

分类专栏： ERRORS ORACLE 文章标签： oracle patch system os unix server

本文链接：https://blog.csdn.net/huang_tg/article/details/6207614

版权

ORACLE 同时被 2 个专栏收录

67 篇文章 0 订阅

订阅专栏

ERRORS

22 篇文章 0 订阅

订阅专栏

今天检查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