当前位置:Gxlcms > 数据库问题 > [Oracle工程师手记]解决listener 的 TNS-12545 错误

[Oracle工程师手记]解决listener 的 TNS-12545 错误

时间:2021-07-01 10:21:17 帮助过:17人阅读


现象: 执行 lsnrctl start 来启动 listener,却失败了。

$ lsnrctl stat

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 09-APR-2021 23:45:02

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hst15574.mytst.com)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
$

 

$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 09-APR-2021 23:45:08

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

Starting /refresh/home/app/oracle/product/19.3.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /refresh/home/app/oracle/product/19.9.0/network/admin/listener.ora
Log messages written to /refresh/home/app/oracle/diag/tnslsnr/hst06027/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hst15574.mytst.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: 99: Cannot assign requested address

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

 检查 host 文件,没有发现有什么问题。

$
$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
$

 
再看 listener.ora 文件:

[oracle@hst06027 admin]$ cat /refresh/home/app/oracle/product/19.9.0/network/admin/listener.ora
# listener.ora Network Configuration File: /refresh/home/app/oracle/product/19.9.0/network/admin
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hst15574.mytst.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

 

再看hostname 的结果:

[oracle@hst06027 admin]$ cat /refresh/home/app/oracle/product/19.9.0/network/admin/listener.ora
# listener.ora Network Configuration File: /refresh/home/app/oracle/product/19.9.0/network/admin
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hst15574.mytst.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )


由于曾经改变了主机名,所以,listener.ora 中的主机名和 hostname 中的名字不同,导致无法运行listener。需要编辑修改 listener.ora :

$ vi /refresh/home/app/oracle/product/19.9.0/network/admin/listener.ora

 
确认:

$ cat /refresh/home/app/oracle/product/19.9.0/network/admin/listener.ora
# listener.ora Network Configuration File: /refresh/home/app/oracle/product/19.9.0/network/admin
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hst06027.mytst.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

 

再次启动,发现可以成功了。

[oracle@hst06027 admin]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 09-APR-2021 23:49:25

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

Starting /refresh/home/app/oracle/product/19.3.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /refresh/home/app/oracle/product/19.9.0/network/admin/listener.ora
Log messages written to /refresh/home/app/oracle/diag/tnslsnr/hst06027/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hst06027.mytst.com)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hst06027.mytst.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                09-APR-2021 23:49:26
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /refresh/home/app/oracle/product/19.9.0/network/admin/listener.ora
Listener Log File         /refresh/home/app/oracle/diag/tnslsnr/hst06027/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hst06027.mytst.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

 
等待两三分钟,确认 listener 的状态:

[oracle@hst06027 admin]$ lsnrctl stat

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 09-APR-2021 23:51:26

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hst06027.mytst.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                09-APR-2021 23:49:26
Uptime                    0 days 0 hr. 2 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /refresh/home/app/oracle/product/19.9.0/network/admin/listener.ora
Listener Log File         /refresh/home/app/oracle/diag/tnslsnr/hst06027/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hst06027.mytst.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "db193cdb", status READY, has 1 handler(s) for this service...
Service "appcon1" has 1 instance(s).
  Instance "db193cdb", status READY, has 1 handler(s) for this service...
Service "apppdb1" has 1 instance(s).
  Instance "db193cdb", status READY, has 1 handler(s) for this service...
Service "apppdb2" has 1 instance(s).
  Instance "db193cdb", status READY, has 1 handler(s) for this service...

 

[Oracle工程师手记]解决listener 的 TNS-12545 错误

标签:etc   prot   tns-12545   sts   instance   解决   bin   alert   erro   

人气教程排行