ORA-12543: TNS:destination host unreachable

by Eric Jenkinson on July 16, 2010

Categories: Errors

Tagged: , , , ,

Connectivity errors are common questions on Oracle related forums and in many cases they are highly misunderstood by the poster of the questions and some responders.

This aim of this document is to show a method for diagnosis and resolution to a scenario in which an ORA-12543 is raised during the connection to a database.


You attempt a connection to database through SQL*Plus and you receive the following error.

SQL*Plus: Release Production on Wed Jun 30 11:06:18 2010

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

SQL> connect hr@proddb
Enter password:
ORA-12543: TNS:destination host unreachable


Diagnosis process:

If you are unfamiliar with the error use the oerr utility to get more information on the error.

[oracle@ora2 ~]$ oerr ora 12543
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 ~]$

An ORA-12543 most commonly indicates a problem either resolving the host name given in the ADDRESS parameter of the tnsnames entry or that the network is unavailable. In some cases it could also be that the database server down.

If you were to trace the connection attempt you would see something similar to the following.

(3086649024) niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=prod)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=proddb)(CID=(PROGRAM=sqlplus)(HOST=ora2.localdomain)(USER=oracle))))
(3086649024) nscall: connecting...
(3086649024) nttbnd2addr: using host IP address:
(3086649024) nsopen: opening transport...
(3086649024) nttcni: Tcp conn timeout = 60000 (ms)
(3086649024) nttcni: trying to connect to socket 8.
(3086649024) ntt2err: soc 8 error - operation=1, ntresnt[0]=513, ntresnt[1]=101, ntresnt[2]=0
(3086649024) nserror: nsres: id=0, op=65, ns=12543, ns2=12560; nt[0]=513, nt[1]=101, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
(3086649024) nsopen: unable to open transport
(3086649024) nioqper:  error from nscall
(3086649024) nioqper:    ns main err code: 12543
(3086649024) nioqper:    ns (2)  err code: 12560
(3086649024) nioqper:    nt main err code: 513
(3086649024) nioqper:    nt (2)  err code: 101
(3086649024) nioqper:    nt OS   err code: 0
(3086649024) niqme: reporting NS-12543 error as ORA-12543
(3086649024) niotns: Couldn't connect, returning 12543

Looking at the trace we can see that TNS was unable to open transport to the host.

Below are the following possible issues ranging from least probable to most probable.

The database server is down– Possible and can be easily verified.
The network is down – Probable as simple ping test to another server that is known to be up can narrow down the issue some.
The IP address is incorrect in either the host file or the DNS– Most likely the case. Even if you do not know the IP address, if you factor out the other two possibilities all you are left with is this one.


Correct the incorrect IP address in the hosts file/DNS or resolve the network outage.


  • Rubino (March 16, 2013 9:18 am)

    i have a similar problem but i have been unable to find an answer from the net. I have 2 VMs on VirtualBox. Each of them have an oracle 11gr2 runnig. i can ping each other, but tnsping is not working, i can also ping the host succesfully.
    This is what i get:
    tnsping MIGRDB01
    Used parameter files:
    TNS-03505: Failed to resolve name
    cat /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
    ADR_BASE = /u01/app/oracle
    cat /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
    OLAPDB =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oldbapex.localdomain)(PORT = 1521))

    MIGRDB01 =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10gTo11g.localdomain)(PORT = 1521))
    This is my listener:
    (ADDRESS = (PROTOCOL = TCP)(HOST = oldbapex.localdomain)(PORT = 1521))

    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    (PROGRAM = extproc)
    (SID_DESC =
    (ORACLE_HOME =/u01/app/oracle/product/11.2.0/dbhome_1)
    ADR_BASE_LISTENER = /u01/app/oracle
    The listener is up and runing in both databases (on different VMs)
    the tnsnames can ping itself successfully

    Is there anything wrong with the listener?

    need someone help plz

  • Srinivas Reddy (May 2, 2013 7:19 am)

    Hi Eric Jenkinson ..

    Excellent blog all the articles are very good, and easy to understand ….

  • kamran (August 27, 2013 1:04 am)


    I also faced this issue . As per I can remember this error occurred due to @ character was used in the password of my database.

    Plz check once and lets know the result.



  • Agi (December 16, 2013 10:29 am)

    Thanks Kamran, I did have same Error, but Finally I found it is password matter

  • Nithesh (April 19, 2014 1:45 am)

    Thanks a lot kamram, your post helped me. I was wondering to resolve this issue & thank god i got your post & i changed my password & its working now. Thanks a lot

  • Jois (May 21, 2014 5:23 am)

    Thanks kamran .It is the @ character in password.

  • Mamacita (June 24, 2014 2:25 am)

    Thenk yu, Kamran. You was very helpful. Same probs here

  • Karthik (December 18, 2014 12:54 pm)

    Hi guys , I’ve got a same issue till now am facing the issue. Just now I’ve understand through your replys how to change password I’ve@ character in between my password could you please explain me detailed info for changing the password…

  • Hamid (May 26, 2015 5:41 am)


    Solution problem oracle error 12543
    first finished password
    and i changed name” hamid@77100
    second appear this problem

    best Regards

  • Jyothi (July 11, 2015 4:35 pm)

    But I don’t have @ in any of my account passwords, but still the tnsping is not working

  • narsimha (January 4, 2016 12:53 am)

    I installed two oracle Linux in VMware workstation and I configured both network settings and I can ping two hosts but I couldn’t connect through tns . I have problem with TNS-12543: TNS:destination host unreachable. I can ping host

    plz give me solution

  • Sujata (January 25, 2016 2:45 am)

    Hi Guys,

    I have a @ character in my password, please let me know how to change the password

  • Subhani (June 22, 2016 8:27 am)

    This post is very useful, i have solved the issue

Post A Comment