Home » SQL & PL/SQL » Client Tools » TNS ora error (oracle,9.2.0.8,window)
TNS ora error [message #348114] Mon, 15 September 2008 12:24 Go to next message
vickey_sagar1
Messages: 77
Registered: August 2007
Location: pune
Member

Hi All,

I have install oracle 9i in window m/c. while installation oracle I have given following Credential

Port= 2030
sid=omkar

After installation I saw the tnsora file .It's having below entry.

OMKAR = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = 
        (PROTOCOL = TCP)
        (HOST = sagar-wxp)
        (PORT = 1521)
      )
    )
    (CONNECT_DATA = 
      (SERVER = DEDICATED)
      (SERVICE_NAME = omkar)
    )
  )



when I am trying to connect oracle through below command I am getting ORA-12154: TNS:could not resolve service name.

sqlplus scott/tiger@omkar


but I am able to connect through sqlplus scott/tiger. Could you please advice what is the problem.


Thanks,
Sagar
Re: TNS ora error [message #348115 is a reply to message #348114] Mon, 15 September 2008 12:26 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

12154, 00000, "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.

Re: TNS ora error [message #348124 is a reply to message #348114] Mon, 15 September 2008 13:21 Go to previous messageGo to next message
vickey_sagar1
Messages: 77
Registered: August 2007
Location: pune
Member

Thx for replay.

As i have installed oracle first time. So could you please elabore more using an example.

Thanks,
Sagar
Re: TNS ora error [message #348126 is a reply to message #348124] Mon, 15 September 2008 13:29 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
We have not much chance to elaborate with "an" example, since there are 14 different reasons mentioned in the help messages anacedent posted alone.

Try following the Troubleshooting Oracle Net Services Guide, depending on which error you actually get.

Previous Topic: Import Data issue in toad
Next Topic: sqlplus issue
Goto Forum:
  


Current Time: Tue Dec 06 12:32:34 CST 2016

Total time taken to generate the page: 0.13432 seconds