这个问题貌似经常出现,杭州某IDC和广州某IDC之间的网络老是中断!NND,难道某IDC又要说是公网问题??
downstream site 的alert.log 报如下错误:
Fri Mar 30 12:11:17 GMT+08:00 2012Propagation Schedule for (STRMADMIN.MARS_CAP_QUEUE, "STRMADMIN"."MARS_APP_QUEUE"@GZPROD.DEST) encountered following error:
ORA-12170: TNS:Connect timeout occurred
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1034
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7902
ORA-06512: at "SYS.DBMS_AQADM", line 631
ORA-06512: at line 1
检查传播进程发现状态是disabled:
bash-3.2$ ./show_all_propagation.sh
***************************
Show all propagation
---------------------------------------------------------------------------------------------------------------------
Propagation Source Source Queue Destination Destination Destination Queue to Negative Rule
Name Queue Owne Name Queue Owner Queue Name DB Link Queue Set Name Status
------------- ---------- ----------------- ----------- ---------------- ------------ ---------- ------------- --------
PROPA_GZDB STRMADMIN MARS_CAP_QUEUE STRMADMIN MARS_APP_QUEUE GZPROD.DEST TRUE DISABLED
重新测试网络连接后重启传播进程:
bash-3.2$ ./start_propagation.sh PROPA_GZDB
PL/SQL procedure successfully completed.
再次检查状态:
bash-3.2$ ./show_all_propagation.sh
***************************
Show all propagation
---------------------------------------------------------------------------------------------------------------------
Propagation Source Source Queue Destination Destination Destination Queue to Negative Rule
Name Queue Owne Name Queue Owner Queue Name DB Link Queue Set Name Status
------------- ---------- ----------------- ----------- ---------------- ------------ ---------- ------------- --------
PROPA_GZDB STRMADMIN MARS_CAP_QUEUE STRMADMIN MARS_APP_QUEUE GZPROD.DEST TRUE ENABLED
bash-3.2$
检查捕获经常,Y的已经开始干活了!
鄙视一下某IDC,经常拿公网问题来做挡箭牌,客户准备将机器挪走了,你们自己去玩吧!
阅读(1854) | 评论(0) | 转发(0) |