oracle启动监听报错TNS-12543: TNS:destination host unreachable

jiawang · 发表于 2025-8-12 15:46:35

报错现象：客户连接远程连接不上数据库，报错如下：

44610689aeed2189be.png (12.56 KB, 下载次数: 237)

2025-8-12 15:35 上传

查看监听状态：

[grid@hisce ~]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-AUG-2025 15:24:08
Copyright (c) 1991, 2021, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hisce)(PORT=1521)))
TNS-12543: TNS:destination host unreachable
TNS-12560: TNS:protocol adapter error
  TNS-00513: Destination host unreachable
Linux Error: 113: No route to host
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date             11-AUG-2025 03:49:25
Uptime                   0 days 23 hr. 34 min. 45 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/19.12.0/grid/network/admin/listener.ora
Listener Log File       /u01/app/grid/diag/tnslsnr/hisce/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hisce)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

查看IP地址
[root@hisce ~]# ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
   valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
   valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
link/ether fe:fc:fe:03:c4:2d brd ff:ff:ff:ff:ff:ff
    inet 192.168.19.208/24 brd 192.168.19.255 scope global noprefixroute eth0
   valid_lft forever preferred_lft forever
inet6 fe80::19c2:9e11:658c:512b/64 scope link noprefixroute
   valid_lft forever preferred_lft forever
3: virbr0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default qlen 1000
link/ether 52:54:00:fa:dd:e2 brd ff:ff:ff:ff:ff:ff
inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0
   valid_lft forever preferred_lft forever
4: virbr0-nic: <BROADCAST,MULTICAST> mtu 1500 qdisc pfifo_fast master virbr0 state DOWN group default qlen 1000
link/ether 52:54:00:fa:dd:e2 brd ff:ff:ff:ff:ff:ff
[root@hisce ~]#

发现当前IP地址为 192.168.19.208，hosts文件里面设置的是192.168.19.44，修改hosts文件后，成功启动监听

[root@hisce ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1       localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.19.208 hisce
[root@hisce ~]#

重启监听成功
[grid@hisce ~]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-AUG-2025 15:28:02
Copyright (c) 1991, 2021, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hisce)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date             12-AUG-2025 15:27:50
Uptime                   0 days 0 hr. 0 min. 11 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/19.12.0/grid/network/admin/listener.ora
Listener Log File       /u01/app/grid/diag/tnslsnr/hisce/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hisce)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@hisce ~]$

帐号		自动登录	找回密码
密码			注册

[Oracle] oracle启动监听报错TNS-12543: TNS:destination host unreachable