| "ERROR: ORA-12203: TNS:unable to connect to destination" [message #18824] |
Sat, 16 February 2002 20:23  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
