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.