TNSName Fail [message #321826] |
Wed, 21 May 2008 07:22  |
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  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|