Oracle dblink监听不能简单重启监听。（MySQL的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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22996654/viewspace-2660098/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
