| tns-12514 & TNS-03505: Failed to resolve name [message #63741] |
Wed, 03 November 2004 22:29  |
ramya
Messages: 87
Registered: August 2002
|
Member |
|
|
Hi all When i am trying to connect to a databaase in the server it
self(2 databases,OS win2kserver, oracle 9.2.0.3).I am getting following
error.Both databases are up.I am giving the error code using connect tosqlplus and tnsping also.I am giving the entries of tnsnames and sqlnet.In tnsnames i changed service_name to sid but no change.How to correct it
with regards
Ramya
SQL> conn system/oracle@test
ERROR:
ORA-12154: TNS:could not resolve service name
Warning: You are no longer connected to ORACLE.
SQL> conn system/oracle@test.oracle.aks.com
ERROR:
ORA-12154: TNS:could not resolve service name
tnsping test
Used parameter files:
C:oracleora92networkadminsqlnet.ora
C:oracleora92networkadmintnsnames.ora
TNS-03505: Failed to resolve name
1) TNsnames.ora
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.aks.com)(PORT = 1521))
)
(CONNECT_DATA =
(Service_name = test.oracle.aks.com)
(SERVER = DEDICATED)
)
)
2) sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (nts)
NAMES.DIRECTORY_PATH= (TNSNAMES,hostname)
NAMES.DEFAULT_DOMAIN = oracle.aks.com
|
|
|
|
|
|
| Re: tns-12514 & TNS-03505: Failed to resolve name [message #63749 is a reply to message #63741] |
Thu, 04 November 2004 10:53  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
what if you change tnsnames.ora as:
TEST.oracle.aks.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.aks.com)(PORT = 1521))
)
(CONNECT_DATA =
(Service_name = test.oracle.aks.com)
(SERVER = DEDICATED)
)
)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
