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
SilverChi
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 :

Quote:
SPA_DIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.1.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SPA)
)
)



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

Quote:
C:\Documents and Settings\Thio>ping 10.5.1.6

Pinging 10.5.1.6 with 32 bytes of data:

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

Ping statistics for 10.5.1.6:
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..?

Regards..

[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: 64152
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
 startup.
 *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.

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


Current Time: Sat Dec 10 16:41:00 CST 2016

Total time taken to generate the page: 0.22976 seconds