本篇内容介绍了“通过lsnrctl stop、lsnrctl start无法启动Oracle dblink的监听怎么办”的有关知识,在实际案例的操作过程中,不少人都会遇到这样的困境,接下来就让小编带领大家学习一下如何处理这些情况吧!希望大家仔细阅读,能够学有所成!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 agentUnable to retrieve text of NETWORK/NCR message 65535ORA-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 PRODService “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 servi免费云主机域名ce…The command completed successfullySQL> set linesize 600SQL> set pagesize 600SQL> select owner,object_name from dba_objects where object_type=’DATABASE LINK’;OWNER OBJECT_NAME——————————————————————————————————————————– ——————————————————————————————————————————–PUBLIC DEV_LINK.BENLAILIFE.COMPUBLIC GUOFANG.BENLAILIFE.COMPUBLIC MYODBC.BENLAILIFE.COMPUBLIC PROD_BAK_DBLINK.BENLAILIFE.COMAPPS 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 agentUnable to retrieve text of NETWORK/NCR message 65535ORA-02063: preceding 2 lines from MYODBCPS:CUX_IMP_INTERFACE_HEADERS是MySQL的表。监听正常后:SQL> select count(*) from CUX_IMP_INTERFACE_HEADERS@MYODBC.BENLAILIFE.COM;COUNT(*)———-2570886“通过lsnrctl stop、lsnrctl start无法启动Oracle dblink的监听怎么办”的内容就介绍到这里了,感谢大家的阅读。如果想了解更多行业相关的知识可以关注百云网站,小编将为大家输出更多高质量的实用文章!
相关推荐: redis中lpush、rpush、lset、lrem是什么
小编给大家分享一下redis中lpush、rpush、lset、lrem是什么,希望大家阅读完这篇文章后大所收获,下面让我们一起去探讨吧!1.lpush在key对应 list的头部添加字符串元素2.rpush在key对应 list 的尾部添加字符串元素3.li…
免责声明:本站发布的图片视频文字,以转载和分享为主,文章观点不代表本站立场,本站不承担相关法律责任;如果涉及侵权请联系邮箱:360163164@qq.com举报,并提供相关证据,经查实将立刻删除涉嫌侵权内容。