精华内容
下载资源
问答
  • TNS-12543: TNS:destination host unreachable

    万次阅读 2015-07-07 14:40:38
    TNS-12543: TNS:destination host unreachable 二:出错原因 机器的防火墙已开启,但没有开放该1521端口 三:解决办法 vi /etc/sysconfig/iptables 直接在配置文件里已有的-A INPUT那些命

    一:问题描述


    配完远程配置连接,用tnsping service_name结果报错:

    TNS-12543: TNS:destination host unreachable

    二:出错原因


    机器的防火墙已开启,但没有开放该1521端口


    三:解决办法


    vi /etc/sysconfig/iptables

    直接在配置文件里已有的-A INPUT那些命令下面

    添加一行:

    -A INPUT -m state --state NEW -m tcp -p tcp --dport 1521-j ACCEPT

    重启防火墙

    [root@ser6-52 mongodb]# /etc/init.d/iptables restart

    iptables: Setting chains to policy ACCEPT: filter          [  OK  ]

    iptables: Flushing firewall rules:                         [  OK  ]

    iptables: Unloading modules:                               [  OK  ]

    iptables: Applying firewall rules:                         [  OK  ]

     


    展开全文
  • write(1, "TNS-12543: TNS:destination host "..., 44) = 44   Also, it is possible that telnet may hang on 1521 port, but is ok on other port # telnet xx.xx.xx.xx 1521 Trying... ^C# ...
        

    In this Document

    Symptoms
    Cause
    Solution


    APPLIES TO:

    Oracle Net Services - Version 11.2.0.3 and later
    Information in this document applies to any platform.

    SYMPTOMS

    When attempting to tnsping a remote server, 
    the following error occurs.

    ERROR
    -----------------------
     tnsping orcl

    TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 24-MAY-2013 15:47:42
    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 = xx.xx.xx.xx)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
    TNS-12543: TNS:destination host unreachable

    tnsnames.ora is well configured. lsnrctl status returns normal. orcl instance is registered normally to listener. ping the host succeed

    ping xx.xx.xx.xx
    PING xx.xx.xx.xx (xx.xx.xx.xx) 56(84) bytes of data.
    64 bytes from xx.xx.xx.xx: icmp_seq=1 ttl=63 time=0.671 ms

    Strace shows that the tnsping failed with below errors

    strace -o a.txt tnsping orcl

    $cat a.txt

    ........

    getsockopt(4, SOL_SOCKET, SO_SNDBUF, 0x7fff2b16c0fc, 0x7fff2b16c0f8) = -1 EBADF (Bad file descriptor)
    getsockopt(4, SOL_SOCKET, SO_RCVBUF, 0x7fff2b16c0fc, 0x7fff2b16c0f8) = -1 EBADF (Bad file descriptor)
    lseek(3, 39936, SEEK_SET)               = 39936
    read(3, "\r\0\3650\0\0V\0\3660\0\0t\0\3670\0\0\217\0\3700\0\0\246\0\3710\0\0\277\0"..., 512) = 512
    write(1, "TNS-12543: TNS:destination host "..., 44) = 44

     

    Also, it is possible that telnet may hang on 1521 port, but is ok on other port


    # telnet xx.xx.xx.xx 1521
    Trying...
    ^C# 
    # telnet xx.xx.xx.xx 22
    Trying...
    Connected to xx.xx.xx.xx.

    Trying same operation on server locally can succeed.

    tnsping orcl

    TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 27-MAY-2013 15:21:06

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

    Used parameter files:
    /home/oracle/app/product/11.2.0/dbhome_1/network/admin/sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
    OK (0 msec)

     

    CAUSE

    This might be a network issue with either the underlying transport not being able to contact the host, or a firewall is blocking this client or connection.

    Make sure the network is functioning correctly.

     



     

    SOLUTION

    Contact OS/network admin to fix the network issue.
     



    About Me


    ..........................................................................................................................................................................................................................................................................................................

    ● 本文来自于MOS转载文章,(文档 ID  1556918.1)

    ● 本文在itpub(http://blog.itpub.net/26736162)、博客园(http://www.cnblogs.com/lhrbest)和个人微信公众号(xiaomaimiaolhr)上有同步更新

    ● QQ群:230161599  微信群:私聊

    ● 小麦苗分享的其它资料:http://blog.itpub.net/26736162/viewspace-1624453/

    ● 小麦苗云盘地址http://blog.itpub.net/26736162/viewspace-1624453/

    ● QQ群: 230161599   微信群:私聊

    ● 联系我请加QQ好友(642808185),注明添加缘由

    ●【版权所有,文章允许转载,但须以链接方式注明源地址,否则追究法律责任】

    ..........................................................................................................................................................................................................................................................................................................

    手机长按下图识别二维码或微信客户端扫描下边的二维码来关注小麦苗的微信公众号:xiaomaimiaolhr,免费学习最实用的数据库技术。



    来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26736162/viewspace-2125538/,如需转载,请注明出处,否则将追究法律责任。

    展开全文
  • TNS-12543: TNS:destination host unreachable 客户端连接 服务 端报错 odb1.test.com-PROD1>sqlplus sys/oracle@ORCL_192.168.0.221 as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Sat Jan 23 12:12:29 ...

    环境:
    oracle服务端:
    oracle 10.2.0.5
    rhel 5.4 32bit
    ip 192.168.0.221

    数据库相关信息
    SQL> show parameter name

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    db_file_name_convert                 string
    db_name                              string      orcl
    db_unique_name                       string      orcl
    global_names                         boolean     FALSE
    instance_name                        string      orcl
    lock_name_space                      string
    log_file_name_convert                string
    service_names                        string      orcl


    oracle客户端(ip:192.168.0.121,主机名:odb1.test.com)
    tns:

    ORCL_192.168.0.221 =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.221)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl)
        )
      )

    ==================================================================================================

    故障现象:
    客户端tnsping服务端报错
    odb1.test.com-PROD1>tnsping ORCL_192.168.0.221

    TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 23-JAN-2016 12:05:21

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

    Used parameter files:
    /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora

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

    客户端连接服务端报错
    odb1.test.com-PROD1>sqlplus sys/oracle@ORCL_192.168.0.221 as sysdba

    SQL*Plus: Release 11.2.0.3.0 Production on Sat Jan 23 12:12:29 2016

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

    ERROR:
    ORA-12543: TNS:destination host unreachable

    Enter user-name: 
    ERROR:
    ORA-01017: invalid username/password; logon denied

    Enter user-name: 
    ERROR:
    ORA-01017: invalid username/password; logon denied

    SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
    odb1.test.com-PROD1>

    分析诊断后,发现是服务端主机的防火墙开启,阻塞1521端口,导致1521端口不通。
    odb1.test.com-PROD1>ping -c 3 192.168.0.221
    PING 192.168.0.221 (192.168.0.221) 56(84) bytes of data.
    64 bytes from 192.168.0.221: icmp_seq=1 ttl=64 time=0.486 ms
    64 bytes from 192.168.0.221: icmp_seq=2 ttl=64 time=0.346 ms
    64 bytes from 192.168.0.221: icmp_seq=3 ttl=64 time=0.348 ms

    --- 192.168.0.221 ping statistics ---
    3 packets transmitted, 3 received, 0% packet loss, time 2000ms
    rtt min/avg/max/mdev = 0.346/0.393/0.486/0.067 ms
    odb1.test.com-PROD1>

    [root@rhel ~]# service iptables status
    Table: filter
    Chain INPUT (policy ACCEPT)
    num  target     prot opt source               destination         
    1    RH-Firewall-1-INPUT  all  --  0.0.0.0/0            0.0.0.0/0           

    Chain FORWARD (policy ACCEPT)
    num  target     prot opt source               destination         
    1    RH-Firewall-1-INPUT  all  --  0.0.0.0/0            0.0.0.0/0           

    Chain OUTPUT (policy ACCEPT)
    num  target     prot opt source               destination         

    Chain RH-Firewall-1-INPUT (2 references)
    num  target     prot opt source               destination         
    1    ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0           
    2    ACCEPT     icmp --  0.0.0.0/0            0.0.0.0/0           icmp type 255 
    3    ACCEPT     esp  --  0.0.0.0/0            0.0.0.0/0           
    4    ACCEPT     ah   --  0.0.0.0/0            0.0.0.0/0           
    5    ACCEPT     udp  --  0.0.0.0/0            224.0.0.251         udp dpt:5353 
    6    ACCEPT     udp  --  0.0.0.0/0            0.0.0.0/0           udp dpt:631 
    7    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:631 
    8    ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0           state RELATED,ESTABLISHED 
    9    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           state NEW tcp dpt:21 
    10   ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           state NEW tcp dpt:22 
    11   ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           state NEW tcp dpt:23 
    12   REJECT     all  --  0.0.0.0/0            0.0.0.0/0           reject-with icmp-host-prohibited 
    [root@rhel ~]# 

    临时解决方法:关闭防火墙。
    [root@rhel ~]# service iptables stop
    Flushing firewall rules: [  OK  ]
    Setting chains to policy ACCEPT: filter [  OK  ]
    Unloading iptables modules: [  OK  ]

    再次tnsping,成功ping通。
    odb1.test.com-PROD1>tnsping ORCL_192.168.0.221

    TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 23-JAN-2016 12:17:44

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

    Used parameter files:
    /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora

    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.221)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
    OK (0 msec)
    odb1.test.com-PROD1>

    再次连接,成功连接数据库。
    odb1.test.com-PROD1>sqlplus sys/oracle@ORCL_192.168.0.221 as sysdba

    SQL*Plus: Release 11.2.0.3.0 Production on Sat Jan 23 12:17:24 2016

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

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL> show parameter name

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    db_file_name_convert                 string
    db_name                              string      orcl
    db_unique_name                       string      orcl
    global_names                         boolean     FALSE
    instance_name                        string      orcl
    lock_name_space                      string
    log_file_name_convert                string
    service_names                        string      orcl
    SQL> exit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    odb1.test.com-PROD1>

    永久解决方法:
    检查发现1521端口没有在/etc/sysconfig/iptables列表。假如重启了操作系统,防火墙再次开启,1521端口又会被阻塞。
    于是把1521端口加入/etc/sysconfig/iptables列表,这样1521端口永远不会被阻塞。

    [root@rhel ~]# cat /etc/sysconfig/iptables
    # Firewall configuration written by system-config-securitylevel
    # Manual customization of this file is not recommended.
    *filter
    :INPUT ACCEPT [0:0]
    :FORWARD ACCEPT [0:0]
    :OUTPUT ACCEPT [0:0]
    :RH-Firewall-1-INPUT - [0:0]
    -A INPUT -j RH-Firewall-1-INPUT
    -A FORWARD -j RH-Firewall-1-INPUT
    -A RH-Firewall-1-INPUT -i lo -j ACCEPT
    -A RH-Firewall-1-INPUT -p icmp --icmp-type any -j ACCEPT
    -A RH-Firewall-1-INPUT -p 50 -j ACCEPT
    -A RH-Firewall-1-INPUT -p 51 -j ACCEPT
    -A RH-Firewall-1-INPUT -p udp --dport 5353 -d 224.0.0.251 -j ACCEPT
    -A RH-Firewall-1-INPUT -p udp -m udp --dport 631 -j ACCEPT
    -A RH-Firewall-1-INPUT -p tcp -m tcp --dport 631 -j ACCEPT
    -A RH-Firewall-1-INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
    -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 21 -j ACCEPT
    -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
    -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 23 -j ACCEPT
    -A RH-Firewall-1-INPUT -p tcp -m state --state NEW -m tcp --dport 1521 -j ACCEPT 
    -A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited
    COMMIT
    [root@rhel ~]# 





    来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24626891/viewspace-2122469/,如需转载,请注明出处,否则将追究法律责任。

    转载于:http://blog.itpub.net/24626891/viewspace-2122469/

    展开全文
  • 今天在给几个库做映射的时候,用tnsping,有一个库老是有问题,在客户端配置 tnsping NFTTEST Used TNSNAMES adapter to resolve the alias Attempting t...
    今天在给几个库做映射的时候,用tnsping,有一个库老是有问题,在客户端配置
    tnsping NFTTEST
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.198.51)(PORT = 1563))) (CONNECT_DATA = (SERVICE_NAME = NFTTEST)))
    TNS-12543: TNS:destination host unreachable

    但是能够Ping通
    > ping 172.19.198.51
    PING 172.19.198.51 (172.19.198.51) 56(84) bytes of data.
    64 bytes from 172.19.198.51: icmp_seq=1 ttl=64 time=0.582 ms
    64 bytes from 172.19.198.51: icmp_seq=2 ttl=64 time=0.429 ms
    ..
    --- 172.19.198.51 ping statistics ---
    2 packets transmitted, 2 received, 0% packet loss, time 1000ms
    ...

    尝试直连接,还是报了同样的错误。
    sqlplus n1/n1@172.19.198.51:1563/NFTTEST

    SQL*Plus: Release 11.2.0.2.0 Production on Tue Apr 8 13:54:23 2014

    Copyright (c) 1982, 2010, Oracle.  All rights reserved.

    ERROR:
    ORA-12543: TNS:destination host unreachable



    初步怀疑是tnsnames.ora里面的配置信息有问题,可能有格式化之类的问题。
    然后重新coyp,改成主机名。把NFTTEST编辑成一行,怎么试都是不行。

    然后我在服务器端尝试,竟然一点问题都没有,正常的登录,listener也是正常的。

    我比较了服务端,客户端的 /etc/hosts里面的Ip配置,都是一样的。

    在服务端重启了listener,再次尝试,没有问题,但是在客户端还是有问题。
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.19.198.51)(PORT=1563)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1563)))
    Services Summary...
    Service "NFTTEST" has 1 instance(s).
      Instance "NFTTEST", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    > tnsping NFTTEST

    TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 08-APR-2014 10:27:45

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

    Used parameter files:
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dbusgsnft4)(PORT = 1563))) (CONNECT_DATA = (SERVICE_NAME = NFTTEST)))
    OK (0 msec)
    然后在服务端用sqlplus连接都是没有问题的。客户端还是不行。

    为了查看更详细的信息,在服务器端尝试一下strace.
    munmap(0x2b57e9832000, 4096)            = 0
    socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 4
    fcntl(4, F_SETFL, O_RDONLY|O_NONBLOCK)  = 0
    connect(4, {sa_family=AF_INET, sin_port=htons(1563), sin_addr=inet_addr("172.19.198.51")}, 16) = -1 E INPROGRESS (Operation now in progress)
    times({tms_utime=0, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 2174636906
    mmap(NULL, 528384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2b57e9a62000
    poll([{fd=4, events=POLLOUT}], 1, 60000) = 1 ([{fd=4, revents=POLLOUT}])
    getsockopt(4, SOL_SOCKET, SO_ERROR, [519270883345301504], [4]) = 0
    fcntl(4, F_GETFL)                       = 0x802 (flags O_RDWR|O_NONBLOCK)
    fcntl(4, F_SETFL, O_RDWR)               = 0
    getsockname(4, {sa_family=AF_INET, sin_port=htons(31292), sin_addr=inet_addr("172.19.198.51")}, [549755813904]) = 0
    getsockopt(4, SOL_SOCKET, SO_SNDBUF, [8458000068614604252], [4]) = 0
    getsockopt(4, SOL_SOCKET, SO_RCVBUF, [8458000068614641056], [4]) = 0
    setsockopt(4, SOL_TCP, TCP_NODELAY, [1], 4) = 0
    fcntl(4, F_SETFD, FD_CLOEXEC)           = 0
    rt_sigaction(SIGPIPE, {0x1, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x325400ebe0}, {SIG_DFL, [], 0}, 8) = 0
    write(4, "\0W\0\0\1\0\0\0\1:\1,\0\0 \0\377\377\177\10\0\0\1\0\0\35\0:\0\0\0\0"..., 87) = 87
    read(4, "\0I\0\0\4\0\0\0\"\0\0=(DESCRIPTION=(TMP=)("..., 8208) = 73
    setsockopt(4, SOL_SOCKET, SO_SNDTIMEO, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
    setsockopt(4, SOL_SOCKET, SO_RCVTIMEO, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
    close(4)                                = 0
    lseek(3, 27136, SEEK_SET)               = 27136
    read(3, "\16\0\335\t\0\0\\\0\336\t\0\0\214\0\255\r\0\0\270\0\256\r\0\0\272\0\257\r\0\0\366\0"..., 512) = 512
    write(1, "OK (10 msec)\n", 13)          = 13
    munmap(0x2b57e9790000, 135168)          = 0
    munmap(0x2b57e976f000, 135168)          = 0
    munmap(0x2b57e974e000, 135168)          = 0
    munmap(0x2b57e972d000, 135168)          = 0
    munmap(0x2b57e97b1000, 528384)          = 0
    munmap(0x2b57e9a62000, 528384)          = 0
    munmap(0x2b57e9622000, 1090528)         = 0
    close(3)                                = 0
    exit_group(0)                           = ?


    然后在客户端试一下
    connect(4, {sa_family=AF_INET, sin_port=htons(1563), sin_addr=inet_addr("172.19.198.51")}, 16) = -1 EINPROGRESS (Operation now in progress)
    times({tms_utime=0, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1799838785
    mmap(NULL, 528384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2b3e1ce2e000
    poll([{fd=4, events=POLLOUT}], 1, 60000) = 1 ([{fd=4, revents=POLLERR|POLLHUP}])
    getsockopt(4, SOL_SOCKET, SO_ERROR, [519270883345301617], [4]) = 0
    close(4)                                = 0
    getsockopt(4, SOL_SOCKET, SO_SNDBUF, 0x7fff4451cd1c, 0x7fff4451cd18) = -1 EBADF (Bad file descriptor)
    getsockopt(4, SOL_SOCKET, SO_RCVBUF, 0x7fff4451cd1c, 0x7fff4451cd18) = -1 EBADF (Bad file descriptor)
    lseek(3, 39936, SEEK_SET)               = 39936
    read(3, "\r\0\3650\0\0V\0\3660\0\0t\0\3670\0\0\217\0\3700\0\0\246\0\3710\0\0\277\0"..., 512) = 512
    write(1, "TNS-12543: TNS:destination host "..., 44) = 44
    munmap(0x2b3e1cb5d000, 135168)          = 0
    munmap(0x2b3e1cb3c000, 135168)          = 0
    munmap(0x2b3e1cb1b000, 135168)          = 0
    munmap(0x2b3e1cafa000, 135168)          = 0
    munmap(0x2b3e1cb7e000, 528384)          = 0
    munmap(0x2b3e1ce2e000, 528384)          = 0
    munmap(0x2b3e1c9ef000, 1090528)         = 0
    close(3)                                = 0
    exit_group(1)                           = ?

    这样一来问题看似比较明显了,很可能是防火墙或者是其他的网络设置的问题,
    发给客户的时候,客户还让我反复验证一下是不是tnsnames.ora。sqlnet.ora的问题,最后还是然他们再检查一下,结果还真有问题,防火墙对于那个端口有限制,重新分配了一下,问题就解决了。

    当然,对于这个问题,MOS上有一篇相关的文档说明,可以参考一下。
    (Doc ID 1556918.1)

    来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23718752/viewspace-1138082/,如需转载,请注明出处,否则将追究法律责任。

    转载于:http://blog.itpub.net/23718752/viewspace-1138082/

    展开全文
  • Linux下监听程序TNS-12543错误解决方法 原创 2010年10月15日 17:22:00 标签:linux /oracle /虚拟机 /network /vmware /jboss .15105 . 遇到的问题:安装虚拟机Vmware之后,打开系统项目虚拟机,经过以下处理步骤 ...
  • Common causes for the ORA-12543 error include: Network driver not functioning There is a problem resolving the host name given in the address parameter of the tnsnames entry Network is ...
  • oracle之 dblink 报ORA-03113 TNS-12543

    千次阅读 2018-01-12 09:56:17
    -- 数据库 alert 告警日志,查看 ora-02063 ORA-03113 报错的周边信息,发现有 TNS-12543 目标主机不可达 -- reco进程的trace文件,发现有ORA-12543 TNS 目标主机不可达  后,部门...
  • http://www.pitt.edu/~hoffman/oradoc/server.804/a58312/newch255.htm http://blog.itpub.net/3326/viewspace-607363 http://ywqboy.blog.sohu.com/116254573.html 转载于:https://www.cnblogs.com/John...
  • 今天在给几个库做映射的时候,用tnsping,有一个库老是有问题,在客户端配置tnsping NFTTESTUsed TNSNAMES adapter to resolv...
  • ORA-12543: TNS: 无法连接目标主机问题

    千次阅读 2020-07-03 10:56:26
    启动 SQLPLUS 无法连接目标主机问题 通过数据库配置助手创建数据库中,用户密码避免使用“@”字符,否则会出现 在修改密码后,可正常连接。
  • 环境: Oracle 11gR2 RAC, CentOS 5.6通过SCAN访问RAC database, 不时出现ORA-12543: TNS:destination host unreachable,经查只有一个scan ...
  • ![图片说明](https://img-ask.csdn.net/upload/201809/29/1538188827_73623.png)
  • ORA-12543: TNS:destination host unreachable 错误原因: sqlnet.ora文件中的NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT ),添加ezconnect参数值,所以如果指定数据库实例,必须要跟上主机ip地址。...
  • (能看到这个说明防火墙是通的,服务器连接连上了,但是下一步,TNS监听过不去) 解决方法:打开即可 启动监听:lsnrctl start  查看监听:lsnrctl status  停止监听:lsnrctl stop  如果不行,就有删除监听...
  • Caused by: java.sql.SQLException: ORA-12543: TNS: 无法连接目标主机 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ...
  • Oracle TNS报错大全

    2018-03-13 15:10:12
    1、tnsnames.ora文件名被修改 TNS-03505: Failed to resolve name 2、IP或hostname无法ping通 TNS-12543: T...

空空如也

空空如也

1 2
收藏数 37
精华内容 14
关键字:

tns12543