ORA-12543: TNS:destination host unreachable but telnet and tnsping works

oracle sqlplus telnet tnsnames
Martinus_ picture Martinus_ · May 27, 2014 · Viewed 52.6k times · Source

Last days i stay face to face with a strange oracle problem. I have defined database in tnsnames.ora. Oracle client is installed , client and client/bin have been added to PATH.

Ping works, tnsping works, I can connect to host by database port with telnet.

When I try to run application that tries to connect to db I got

ORA-12543: TNS:destination host unreachable

It is the same situation when I try to connect by sqlplus

sqlplus username/password@TNSNAME

Situation occurred only on one workstation, it's mean in common it should works.

WS is windows 7 64 bit.
Database :

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

Answer

Estin Chin picture Estin Chin · Jun 2, 2015

I was having the same problem, I resolved it by changing my password and removing "@" character. It worked for me.

@ is to tell SQL plus which connection identifier (service name/sid) we want to connect. In short, avoid using this character in password.

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I spool to a CSV formatted file using SQLPLUS?

I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or any language to do it. I must use SQLPLUS. How do I do it?

Read More
How to display databases in Oracle 11g using SQL*Plus

With help of this command show databases; I can see databases in MySQL. How to show the available databases in Oracle?

Read More