Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to start Oracle dblink monitoring through lsnrctl stop and lsnrctl start". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Oracle dblink snooping cannot simply restart snooping.

Oracle dblink snooping cannot be started through lsnrctl stop and lsnrctl start.

Dblink query error:

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

Restart Oracle dblink snooping mode correctly:

[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

Error report:

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 is MySQL's watch.

After the monitoring is normal:

SQL > select count (*) from CUX_IMP_INTERFACE_HEADERS@MYODBC.BENLAILIFE.COM

COUNT (*)

-

2570886

This is the end of the content of "what to do if you can't start Oracle dblink monitoring through lsnrctl stop and lsnrctl start". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.