| per.oracle 8 in win 98 - tns name lookup failure [message #18404] |
Wed, 30 January 2002 06:09  |
marvin
Messages: 3
Registered: January 2002
|
Junior Member |
|
|
ora-12545 tns : name look up failure.
what should i do ?
this is my tnsname.ora file
khuda.world
( description =
( address_list =
( address =
( community = tcp.world
( protocol = tcp
( host = localhost
( port = 1521)
)
( address =
( community = tcp.world
( protocol = tcp
( host = localhost)
( port = 1526)
)
)
((connect_data = ( sid_orcl)
)
)
urgent please
|
|
|
|
| Re: per.oracle 8 in win 98 - tns name lookup failure [message #18405 is a reply to message #18404] |
Wed, 30 January 2002 06:39  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
this is my tnsnames.ora file , have a look at it and make changes accordingly. (mydb is my database SID)
if use khuda.world in tnsnames, default_domain parameter in sqlnet.ora should be world. (my suggestion is remove .world from tnsnames and remove default_domain entry from sqlnet.ora)
xyz =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mydb)
)
)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
