TNS-12545、TNS-12560、TNS-00515和Linux Error: 111: Connection refused

0    48    1

👉 本文共约1564个字,系统预计阅读时间或需6分钟。

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

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!

# 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

标签:

头像

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

17 + 7 =

 

嘿,我是小麦,需要帮助随时找我哦
  • 18509239930
  • 个人微信

  • 麦老师QQ聊天
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部
返回顶部