【故障|监听】TNS-12545、TNS-12560、TNS-00515和Linux Error: 111

本文主要是介绍【故障|监听】TNS-12545、TNS-12560、TNS-00515和Linux Error: 111，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

【故障|监听】TNS-12545、TNS-12560、TNS-00515和Linux Error: 111: Connection refused  

 Linux Error: 111: Connection refused

[oracle@edsir4p1-PROD1 ~]$ ps -ef|grep tns

oracle    5462  5357  0 05:22 pts/2    00:00:00 grep tns

[oracle@edsir4p1-PROD1 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-SEP-2017 05:22:24

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production

System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/edsir4p1/listener/alert/log.xml

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edsor4p1.us.oracle.com)(PORT=1521)))

TNS-12545: Connect failed because target host or object does not exist

 TNS-12560: TNS:protocol adapter error

  TNS-00515: Connect failed because target host or object does not exist

   Linux Error: 111: Connection refused

Listener failed to start. See the error message(s) above...

[oracle@edsir4p1-PROD1 ~]$ more /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1       localhost.localdomain localhost

10.190.104.111  edsir4p1.us.oracle.com edsir4p1

10.190.104.28   edsir1p8.us.oracle.com edsir1p8

[oracle@edsir4p1-PROD1 ~]$ more /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = edsor4p1.us.oracle.com)(PORT = 1521))

  )

ADR_BASE_LISTENER = /u01/app/oracle

原因：主机名写错了。应该是edsir4p1.us.oracle.com，而不是edsor4p1.us.oracle.com 

修改之后：

[oracle@edsir4p1-PROD1 ~]$ more /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = edsir4p1.us.oracle.com)(PORT = 1521))

  )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@edsir4p1-PROD1 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-SEP-2017 05:30:08

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production

System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/edsir4p1/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edsir4p1.us.oracle.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edsir4p1.us.oracle.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                13-SEP-2017 05:30:08

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/edsir4p1/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edsir4p1.us.oracle.com)(PORT=1521)))

The listener supports no services

The command completed successfully

这篇关于【故障|监听】TNS-12545、TNS-12560、TNS-00515和Linux Error: 111的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！