Oracle出现ORA-27300,ORA-27301,ORA-27302报错的最终解决办法

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:603

Oracle出现ORA-27300,ORA-27301,ORA-27302报错的最终解决办法

数据库最近总是出与以下报错

Mon Dec 30 19:21:35 CST 2013
Errors in file /oracle/app/oracle/admin/ora/udump/ora2_ora_26615.trc:
ORA-27300: 操作系统系统相关操作: invalid_process_id 失败, 状态为: 0
ORA-27301: 操作系统故障消息: Error 0
ORA-27302: 错误发生在: skgpalive1
Mon Dec 30 19:21:35 CST 2013
Errors in file /oracle/app/oracle/admin/ora/udump/ora2_ora_26615.trc:
ORA-27300: 操作系统系统相关操作: invalid_process_id 失败, 状态为: 0
ORA-27301: 操作系统故障消息: Error 0
ORA-27302: 错误发生在: skgpalive1
Mon Dec 30 19:21:35 CST 2013
Errors in file /oracle/app/oracle/admin/ora/udump/ora2_ora_26615.trc:
ORA-27300: 操作系统系统相关操作: invalid_process_id 失败, 状态为: 0
ORA-27301: 操作系统故障消息: Error 0
ORA-27302: 错误发生在: skgpalive1

经分析,以上报错是oracle的一个bug:10010310引起的,需要打patch 10010310补丁。bug 10010310在oracle 11203中已经修复,在当前版本可以应用patch 10010310规避。

官方针对这个报错的解释如下:

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_.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.

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】