无需归档

在 alert 日志中，经常会看到 "Fatal NI connect error 12537" 与 "opiodr aborting process" 报错。

对于 "Fatal NI connect error 12537"：

$ oerr ora 12537
12537, 00000, "TNS:connection closed"
// *Cause: "End of file" condition has been reached; partner has disconnected.
// *Action: None needed; this is an information message.

对于 "opiodr aborting process"：

This is an informational message only. The intention of the message is to ensure that the alert captures information about processes that exit unusually. The message was added in 11g.

一个告警示例为：

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

"unknown" => means that the Oracle process name (Shadow, background) could not be determined.
"ospid (28342)" => this is the OS pid of the process which opiodr is aborting
"as a result of" => this precedes the error message which is the reason for opiodr to kill the process
"ORA-28" => this is the reason that opiodr killed the process. In this case, it is ora-28.

以 ORA- 开头的代码是 opiodr 杀掉进程的原因，可以通过 oerr 工具查询，也可以上 MOS 查询。