opiodr aborting process unknown ospid (9875) as a result of ORA-609

Oracle  11.2.0.2.0  ,    Linux AS  5.3  64bit   

例行检查时发现在 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 out
1264     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 out
1287     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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-703798/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-703798/