2018-06-06 KK日记，ora-609错误处理一例

一、案例

昨天，DBA反馈db1从5.26开始在alert_db1.log每一分钟出现4-6次"opiodr aborting process unknown ospid (30232) as a result of ORA-609"

二、问题

为什么这么频繁出现"opiodr aborting process unknown ospid (30232) as a result of ORA-609"？

三、 数据收集与分析

3.1 ora-609的解释

oracle> oerr ora 609 
00609, 00000, "could not attach to incoming connection"
// *Cause:  Oracle process could not answer incoming connection
// *Action: If the situation described in the next error on the stack
//         can be corrected, do so; otherwise contact Oracle Support.