通过lsnrctlstop、lsnrctlstart无法启动Oracledblink的监听怎么办

本篇内容介绍了“通过lsnrctl stop、lsnrctl start无法启动Oracle dblink的监听怎么办”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

成都创新互联公司服务紧随时代发展步伐，进行技术革新和技术进步，经过10年的发展和积累，已经汇集了一批资深网站策划师、设计师、专业的网站实施团队以及高素质售后服务人员，并且完全形成了一套成熟的业务流程，能够完全依照客户要求对网站进行成都网站制作、成都网站设计、外贸营销网站建设、建设、维护、更新和改版，实现客户网站对外宣传展示的首要目的，并为客户企业品牌互联网化提供全面的解决方案。

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的监听怎么办”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注创新互联网站，小编将为大家输出更多高质量的实用文章！