| Very urgent ORA-12154 TNS Could not resolve service name error [message #73113] |
Wed, 04 February 2004 04:43  |
Shanker
Messages: 9
Registered: April 2002
|
Junior Member |
|
|
I am trying to setup multi-master replication in oracle 9i. I had created a master group and trying to add destination site. I am getting the error
ORA-12154 TNS could not resolve service name
BEGIN Dbms_Repcat.Add_Master_Database('EROOMTEST', 'EROOM4.US.ORACLE.COM'); END;
*
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 4248
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2148
ORA-06512: at "SYS.DBMS_REPCAT", line 146
ORA-06512: at line 1
5. C:oracleora90networkADMIN>tnsping eroom4
TNS Ping Utility for 32-bit Windows: Version 9.0.1.1.1 - Production on 03-FEB-20
04 10:33:11
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:oracleora90networkadminsqlnet.ora
C:oracleora90networkADMINtnsnames.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = nssqldev)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = EROOM4)))
OK (60 msec)
======Attempted solutions.
1. tnsping to SID name it is ok.
2. GLOBAL_NAMES exists
3. I just removed the DEFAULT DOMAIN parameter
and NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
and only left SQLNET.AUTHENTICATION_SERVICES= (NTS)
in my sqlnet.ora file .
The above solution is suggested in this forum.
Nothing works.
Please help me. It is very urgent
====================
|
|
|
|
|
|
| Re: Very urgent ORA-12154 TNS Could not resolve service name error [message #74321 is a reply to message #73113] |
Sun, 14 November 2004 00:28  |
chavda Ramesh
Messages: 1
Registered: November 2004
|
Junior Member |
|
|
helo respected sir/madam,
when i connect with oracle8i i got the messagae tns error ora-12154.tns could not resolve
service.so pls help me with full code and example how
can i solve this problem.when i create new sid from
wizard and test then it gives error that test did not
complete successfully.so psl give me full detail how
can i solve problem.
i am connecting database with .net application and in connection string i am using
provider,data source,uid and password.
hoping to hear very soon from you
Thanks a lot.
chavda
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
