Home » RDBMS Server » Networking and Gateways » TNSName Fail (10g, R2, Windows 2003)
TNSName Fail [message #321826] Wed, 21 May 2008 07:22 Go to next message
Messages: 17
Registered: September 2006
Junior Member
Hi All..

I'm using the net manager to create my tnsname, but i've faced a problem when use the tnsname. The destination of my tnsname is an active instance on an oracle 9i server. My tnsname description is :


I got an error message "ORA-12547:TNS: Lost Contact", whereas network ping method return

C:\Documents and Settings\Thio>ping

Pinging with 32 bytes of data:

Reply from bytes=32 time<1ms TTL=127
Reply from bytes=32 time<1ms TTL=127
Reply from bytes=32 time<1ms TTL=127
Reply from bytes=32 time<1ms TTL=127

Ping statistics for
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

When i try to change the host with target machine's computer name, I got an error message "ORA-12545:connect failed because target or object does not exist"

what should i do to fix these..?


[Updated on: Wed, 21 May 2008 07:23]

Report message to a moderator

Re: TNSName Fail [message #321837 is a reply to message #321826] Wed, 21 May 2008 08:10 Go to previous message
Michel Cadot
Messages: 68601
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12547: TNS:lost contact
 *Cause: Partner has unexpectedly gone away, usually during process
 *Action: Investigate partner application for abnormal termination. On an
 Interchange, this can happen if the machine is overloaded.

ORA-12545: Connect failed because target host or object does not exist
 *Cause: The address specified is not valid, or the program being
 connected to does not exist.
 *Action: Ensure the ADDRESS parameters have been entered correctly; the
 most likely incorrect parameter is the node name.  Ensure that the
 executable for the server exists (perhaps "oracle" is missing.)
 If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
 host name to a numeric IP address and try again.

Previous Topic: ora-12224
Next Topic: How to upgrade NET80 of forms6i
Goto Forum:

Current Time: Mon Mar 04 12:25:42 CST 2024