Home » RDBMS Server » Networking and Gateways » "ERROR: ORA-12203: TNS:unable to connect to destination"
"ERROR: ORA-12203: TNS:unable to connect to destination" [message #18824] Sat, 16 February 2002 20:23 Go to next message
krahuman
Messages: 18
Registered: January 2002
Junior Member
Hai ora 8i experts !

i am having ora 8i db configuration problem for a long time.
i install d2k with or 8i in a winnt server.
i am getting the message
"ERROR: ORA-12203: TNS:unable to connect to destination"
what is wrong with this ?
this is my tnsname.ora
mydatabase.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = myserver)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = myserver)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)

according to one your instruction i edit tnsname.ora as

mydatabase =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = myserver)
(Port = 1521))
)
(CONNECT_DATA = (SID = mydatabase)
)
then i am getting the message

"ERROR: ORA-12154: TNS:could not resolve service name"

what should i do ?
i am at the end.
krahuman
Re: "ERROR: ORA-12203: TNS:unable to connect to destination" [message #18825 is a reply to message #18824] Sun, 17 February 2002 06:43 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
did u double check your server name (or ipaddress) and database name?.

Trouble shoot:
1)
from dos-prompt , try this

c:>ping myserver

if it gives timed out error, means your computer couldnot see server machine.

2) check domain name parameter in sqlnet.ora parameter.
Previous Topic: Connectivity Problem
Next Topic: TNS error
Goto Forum:
  


Current Time: Tue Feb 20 18:41:14 CST 2024