TNS-12543: TNS:destination host unreachable

最新推荐文章于 2023-09-02 15:00:44 发布

原创最新推荐文章于 2023-09-02 15:00:44 发布 · 6.7k 阅读

0 ·

CC 4.0 BY-SA版权

高级实验专栏收录该内容

15 篇文章

订阅专栏

问题描述

[oracle@udbs01 ~]$ tnsping u01sby1

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 27-MAY-2021 23:31:06

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = udbs02)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = u01sby1)))
TNS-12543: TNS:destination host unreachable

原因

[oracle@udbs01 ~]$ telnet udbs02 1521
Trying 目标IP地址...
telnet: connect to address 目标IP地址: No route to host

[root@udbs01 ~]# service iptable status

[root@udbs01 ~]# cat /etc/selinux/config

解决

[root@udbs01 ~]# chkconfig iptables off

[root@udbs01 ~]# service iptable stop

[root@udbs01 ~]# service iptable status

[oracle@udbs01 ~]$ telnet udbs02 1521
Trying 目标IP地址...
Connected to udbs02.
Escape character is '^]'.

Nice！！！

[oracle@udbs01 ~]$ tnsping u01sby1

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 27-MAY-2021 23:32:00

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = udbs02)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = u01sby1)))
OK (10 msec)