opiodr aborting process unknown ospid (70758) as a result of ORA-28

早上巡检时发现告警日志中有大量如下的log：
opiodr aborting process unknown ospid (45394) as a result of ORA-28

问题分析

在Oracle 11.1.0.6 和 11.1.0.7 的版本中，存在一个bug：6377339。 其会在alert log 显示如下信息：

 ORA-28 : opiodr aborting process unknown ospid (21016_3086862016)

这样的提示信息会让我们产生疑惑. 所以在Oracle 11.2 版本中对这个bug进行修复，修复之后的提示信息变成了：

opidcl abortingprocess unknown ospid (32110) as a result of ORA-28

opiodr aborting process信息仅仅是一个消息，它是Oracle 11g里新添加的一个消息，用来记录进程的异常退出。

该消息一般用来记录有权限的用户kill 的session信息。

解释

“unknown” => means it is not a background or shadow process that is killed
“ospid (XXXXX)” => this is the OS pid of the process which opiodris aborting
“as a result of” => this precedes the error message which is thereason for opiodr to kill the process
“ORA-28” => this is the reason that opiodr killed the process. Inthis case, it is ora-28.

参考

“opiodr abortingprocess” Messages in Alert.Log [ID 1230858.1]

Bug 6377339 - Misleading alertlog message for “opiodr aborting” [ID 6377339.8]