TNS-12543: TNS:destination host unreachable 3.网络层面排查1521端口 以db11g环境为例说明: [oracle@db11g ~]$ netstat -ano|grep 1521 tcp6 0 0 :::1521 :::* LISTEN off (0.00/0/0) unix 2 [ ACC ] STREAM LISTENING 26303 /var/tmp/.oracle/sEXTPROC1521 使用telnet工具定位: [root@bogon ~]#...
Attempting tocontact(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.19)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=jyadg)))TNS-12543:TNS:destination host unreachable[oracle@db11g~]$ tnsping jycasTNSPing UtilityforLinux:Version11.2.0.3.0-Production on13-MAY-202308:09:17Copyright...
TNS-12543: TNS:destination host unreachable 二：出错原因 机器的防火墙已开启，但没有开放该1521端口 ...
IPSEC造成网络Destination host unreachable 2012-03-23 12:26 −Destination host unreachable 一般解决办 起因: 安装VC++重新启动计算机后,电脑上不去网 症状: 本机IP 192.168.0.99 子网掩码:255.255.255.0 网关:192.168.0.1 DNS:192.168.0.1 解决: 首先,把网线拔了重新插了数... ...
ORA-12543: TNS:destination host unreachable SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus --//使用Net Manager打开tnsnames.ora文件正常,说明文件没有问题. --//进入E:\app\oracle\product\12.2.0\dbhome_1\network\admin目录观察,发现 ...
看看你的数据库用户有没有远程访问的权限，另外注意端口号。。。
但是tnsnames.ora 中HOST = 字段指定的IP无法PING通。 测试结果: TNSPING和SQLPLUS报错均为: TNS-12543: TNS:destination host unreachable 实验数据: [oracle@bys001 admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora ...
$ tnsping jycas TNS Ping Utility for Linux:...-12543: TNS:destination host unreachable 1.检查防火墙和SElinux状态 2.确认克隆的网卡是否正常 3.网络层面排查1521端口 1.检查防火墙和SElinux...-12543: TNS:destination host unreachable 3.网络层面排查1521端口以db11g环境为例说明: [oracle@db11g ~]$ ...
12543, 00000, "TNS:destination host unreachable" // *Cause: Contact can not be made with remote party. // *Action: Make sure the network driver is functioning and the network is up. [oracle@ora2 ~]$ AnORA-12543most commonly indicates a problem either resolving the host name given in th...
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.19)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jyadg))) TNS-12543: TNS:destination host unreachable [oracle@db11g ~]$ tnsping jycas ...