Home » RDBMS Server » Server Administration » TNS listener could not resolve service name (oracle 9.2.0.1 , Windows XP)
TNS listener could not resolve service name [message #393602] Mon, 23 March 2009 09:44 Go to next message
padhuoracle
Messages: 26
Registered: March 2009
Location: Chennai
Junior Member
Hi,

I had created a database called "test" in machine A. After that I installed oracle 9i client in machine B , placed the tns entries in Machine B. from Machine B, I am unable to connect "Test" database which is located in Machine A.

Please find the error message.


ORA-12154: TNS:could not resolve service name

regards,
Padhu.
Re: TNS listener could not resolve service name [message #393603 is a reply to message #393602] Mon, 23 March 2009 09:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve the connect identifier specified
 *Cause:  A connection to a database or other service was requested using
 a connect identifier, and the connect identifier specified could not
 be resolved into a connect descriptor using one of the naming methods
 configured. For example, if the type of connect identifier used was a
 net service name then the net service name could not be found in a
 naming method repository, or the repository could not be
 located or reached.
 *Action:
   - If you are using local naming (TNSNAMES.ORA file):
      - Make sure that "TNSNAMES" is listed as one of the values of the
        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA)
      - Verify that a TNSNAMES.ORA file exists and is in the proper
        directory and is accessible.
      - Check that the net service name used as the connect identifier
        exists in the TNSNAMES.ORA file.
      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
        file.  Look for unmatched parentheses or stray characters. Errors
        in a TNSNAMES.ORA file may make it unusable.
   - If you are using directory naming:
      - Verify that "LDAP" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Verify that the LDAP directory server is up and that it is
        accessible.
      - Verify that the net service name or database name used as the
        connect identifier is configured in the directory.
      - Verify that the default context being used is correct by
        specifying a fully qualified net service name or a full LDAP DN
        as the connect identifier
   - If you are using easy connect naming:
      - Verify that "EZCONNECT" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Make sure the host, port and service name specified
        are correct.
      - Try enclosing the connect identifier in quote marks.

   See the Oracle Net Services Administrators Guide or the Oracle
   operating system specific guide for more information on naming.

Regards
Michel
Re: TNS listener could not resolve service name [message #393604 is a reply to message #393602] Mon, 23 March 2009 09:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

>ORA-12154: TNS:could not resolve service name
SEARCH this forum & GOOGLE for this FAQ!
Re: TNS listener could not resolve service name [message #393605 is a reply to message #393602] Mon, 23 March 2009 09:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be there is a problem with the tns entries.
May be there is a problem with the listener entries in server A.
THis is very common issue.
Please search forum/google/docs before posting.
Re: TNS listener could not resolve service name [message #393964 is a reply to message #393605] Wed, 25 March 2009 04:05 Go to previous messageGo to next message
sameer_2230
Messages: 19
Registered: March 2009
Location: India
Junior Member

go on cmd prompt

SET ORACLE_SID=test
SET ORACLE_PATH=yuor oracle_home path

N try
Re: TNS listener could not resolve service name [message #393965 is a reply to message #393964] Wed, 25 March 2009 04:06 Go to previous message
sameer_2230
Messages: 19
Registered: March 2009
Location: India
Junior Member

sqlplus /nolog

SQL>connect / @test as sysdba
Previous Topic: Finding information about updated tables
Next Topic: configure OCA with Oracle application server
Goto Forum:
  


Current Time: Wed Jul 03 00:45:48 CDT 2024