共計 2464 個字符，預計需要花費 7 分鐘才能閱讀完成。
行業(yè)資訊
數(shù)據(jù)庫
關系型數(shù)據(jù)庫
通過 lsnrctl stop、lsnrctl start 無法啟動 Oracle dblink 的監(jiān)聽怎么辦
本篇內容介紹了“通過 lsnrctl stop、lsnrctl start 無法啟動 Oracle dblink 的監(jiān)聽怎么辦”的有關知識，在實際案例的操作過程中，不少人都會遇到這樣的困境，接下來就讓丸趣 TV 小編帶領大家學習一下如何處理這些情況吧！希望大家仔細閱讀，能夠學有所成！
Oracle dblink 監(jiān)聽不能簡單重啟監(jiān)聽。
通過 lsnrctl stop、lsnrctl start 無法啟動 Oracle dblink 的監(jiān)聽。
dblink 查詢報錯：
SQL select count(*) from CUX_IMP_INTERFACE_HEADERS@MYODBC.BENLAILIFE.COM;
select count(*) from CUX_IMP_INTERFACE_HEADERS@MYODBC.BENLAILIFE.COM
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from MYODBC
正確重啟 Oracle dblink 監(jiān)聽方式：
[oraprod@erpdbp PROD_erpdbp]$ pwd
/u01/prod/db/12.1.0/appsutil/scripts/PROD_erpdbp
[oraprod@erpdbp PROD_erpdbp]$ /u01/prod/db/12.1.0/appsutil/scripts/PROD_erpdbp/addlnctl.sh stop PROD
[oraprod@erpdbp PROD_erpdbp]$ /u01/prod/db/12.1.0/appsutil/scripts/PROD_erpdbp/addlnctl.sh start PROD
[oraprod@erpdbp PROD_erpdbp]$ /u01/prod/db/12.1.0/appsutil/scripts/PROD_erpdbp/addlnctl.sh status PROD
Service PROD has 2 instance(s).
Instance PROD , status UNKNOWN, has 1 handler(s) for this service…
Instance PROD , status READY, has 1 handler(s) for this service…
Service ebs_patch has 1 instance(s).
Instance PROD , status READY, has 1 handler(s) for this service…
Service myodbc3 has 1 instance(s).
Instance myodbc3 , status UNKNOWN, has 1 handler(s) for this service…
Service myodbc4 has 1 instance(s).
Instance myodbc4 , status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
SQL set linesize 600
SQL set pagesize 600
SQL select owner,object_name from dba_objects where object_type= DATABASE LINK
OWNER OBJECT_NAME
——————————————————————————————————————————– ——————————————————————————————————————————–
PUBLIC DEV_LINK.BENLAILIFE.COM
PUBLIC GUOFANG.BENLAILIFE.COM
PUBLIC MYODBC.BENLAILIFE.COM
PUBLIC PROD_BAK_DBLINK.BENLAILIFE.COM
APPS TEST_TO_PROD.TEST.BENLAILIFE.COM
報錯：
SQL select count(*) from CUX_IMP_INTERFACE_HEADERS@MYODBC.BENLAILIFE.COM;
select count(*) from CUX_IMP_INTERFACE_HEADERS@MYODBC.BENLAILIFE.COM
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from MYODBC
PS：
CUX_IMP_INTERFACE_HEADERS 是 MySQL 的表。
監(jiān)聽正常后：
SQL select count(*) from CUX_IMP_INTERFACE_HEADERS@MYODBC.BENLAILIFE.COM;
COUNT(*)
———-
2570886
“通過 lsnrctl stop、lsnrctl start 無法啟動 Oracle dblink 的監(jiān)聽怎么辦”的內容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業(yè)相關的知識可以關注丸趣 TV 網(wǎng)站，丸趣 TV 小編將為大家輸出更多高質量的實用文章！
