共计 2464 个字符，预计需要花费 7 分钟才能阅读完成。
行业资讯
数据库
关系型数据库
通过 lsnrctl stop、lsnrctl start 无法启动 Oracle dblink 的监听怎么办
本篇内容介绍了“通过 lsnrctl stop、lsnrctl start 无法启动 Oracle dblink 的监听怎么办”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让丸趣 TV 小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！
Oracle dblink 监听不能简单重启监听。
通过 lsnrctl stop、lsnrctl start 无法启动 Oracle dblink 的监听。
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 监听方式：
[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 的表。
监听正常后：
SQL select count(*) from CUX_IMP_INTERFACE_HEADERS@MYODBC.BENLAILIFE.COM;
COUNT(*)
———-
2570886
“通过 lsnrctl stop、lsnrctl start 无法启动 Oracle dblink 的监听怎么办”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注丸趣 TV 网站，丸趣 TV 小编将为大家输出更多高质量的实用文章！
