例行检查时发现在 alert log 中有貌似警告信息， 虽然不是很频繁， 但是一天的alert log中还是有好几条 ：
opiodr aborting process unknown ospid (9875) as a result of ORA-609
opidcl aborting process unknown ospid (8200) as a result of ORA-604
架构是 ： Oracle 10.2.0.2.0 RAC 三节点 + 单机 Active Data Guard , 实时同步 。
报这些信息时 ， ORA-609 一般伴随着下面的这些信息 ：
1250 ***********************************************************************
1251
1252 Fatal NI connect error 12170.
1253
1254 VERSION INFORMATION:
1255 TNS for Linux: Version 11.2.0.2.0 - Production
1256 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
1257 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
1258 Time: 19-JUL-2011 08:18:07
1259 Tracing not turned on.
1260 Tns error struct:
1261 ns main err code: 12535
1262
1263 TNS-12535: TNS
peration timed out1264 ns secondary err code: 12606
1265 nt main err code: 0
1266 nt secondary err code: 0
1267 nt OS err code: 0
1268 Client address:
1269 opiodr aborting process unknown ospid (24329) as a result of ORA-609
1270 Tue Jul 19 08:19:32 2011
1271
1272
1273 ***********************************************************************
1274
1275 Fatal NI connect error 12170.
1276
1277 VERSION INFORMATION:
1278 TNS for Linux: Version 11.2.0.2.0 - Production
1279 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
1280 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production
1281 Time: 19-JUL-2011 08:19:32
1282 Tracing not turned on.
1283 Tns error struct:
1284 ns main err code: 12535
1285
1286 TNS-12535: TNS
peration timed out1287 ns secondary err code: 12606
1288 nt main err code: 0
1289 nt secondary err code: 0
1290 nt OS err code: 0
1291 Client address:
1292 opiodr aborting process unknown ospid (24475) as a result of ORA-609
1293 Tue Jul 19 08:25:16 2011
ORA-604 报出来时没有什么征兆 及 上下文 ：
7631 Sun Jul 24 03:34:48 2011
7632 Archived Log entry 15972 added for thread 2 sequence 3521 ID 0x4fa453a7 dest 1:
7633 Sun Jul 24 03:43:36 2011
7634 LGWR: Standby redo logfile selected for thread 2 sequence 3523 for destination LOG_ARCHIVE_DEST_2
7635 Thread 2 advanced to log sequence 3523 (LGWR switch)
7636 Current log# 27 seq# 3523 mem# 0: +DATA/wsjdell/redo27a.log
7637 Current log# 27 seq# 3523 mem# 1: +INDX/wsjdell/redo27b.log
7638 Sun Jul 24 03:43:36 2011
7639 Archived Log entry 15978 added for thread 2 sequence 3522 ID 0x4fa453a7 dest 1:
7640 Sun Jul 24 03:50:54 2011
7641 opidcl aborting process unknown ospid (22950) as a result of ORA-604
7642 Sun Jul 24 03:53:10 2011
7643 LGWR: Standby redo logfile selected for thread 2 sequence 3524 for destination LOG_ARCHIVE_DEST_2
7644 Thread 2 advanced to log sequence 3524 (LGWR switch)
7645 Current log# 28 seq# 3524 mem# 0: +DATA/wsjdell/redo28a.log
7646 Current log# 28 seq# 3524 mem# 1: +INDX/wsjdell/redo28b.log
7647 Sun Jul 24 03:53:12 2011
7648 Archived Log entry 15980 added for thread 2 sequence 3523 ID 0x4fa453a7 dest 1:
7649 Sun Jul 24 03:59:13 2011
7650 opidcl aborting process unknown ospid (2478) as a result of ORA-604
7651 Sun Jul 24 03:59:22 2011
7652 opidcl aborting process unknown ospid (2698) as a result of ORA-604
7653 Sun Jul 24 04:01:47 2011
7654 LGWR: Standby redo logfile selected for thread 2 sequence 3525 for destination LOG_ARCHIVE_DEST_2
7655 Thread 2 advanced to log sequence 3525 (LGWR switch)
7656 Current log# 22 seq# 3525 mem# 0: +DATA/wsjdell/redo22a.log
7657 Current log# 22 seq# 3525 mem# 1: +INDX/wsjdell/redo22b.log
7658 Sun Jul 24 04:01:49 2011