7 Replies Latest reply on Feb 2, 2014 5:18 PM by Baris Yildirim

    Unable to resolve ORA-12154: TNS:could not resolve the connect identifier specified

    Karki

      Hi Friends,

       

      I am unable to resolve ORA-12154: TNS:could not resolve the connect identifier specified, error:

       

      C:\Windows\system32>sqlplus scott/tiger@ORADATA

      SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 2 13:46:10 2014

      Copyright (c) 1982, 2010, Oracle.  All rights reserved.

      ERROR:

      ORA-12154: TNS:could not resolve the connect identifier specified

       

      SQL> select database_name from v$database;

      DATABASE_NAME

      ----------------------------------------------------

      ORADATA

       

      SQL> select instance_name from v$instance;

      INSTANCE_NAME

      ----------------

      oradata

       

      tnsnames.ora

      ============

      ORADATA =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL=TCP)(HOST=himanshu-PC)(PORT=1521))

          )

          (CONNECT_DATA =

      (SERVICE_NAME = oradata)

        (SERVER = DEDICATED)

          )

        )

       

      listener.ora

      =========

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCP)(HOST = himanshu-PC)(PORT = 1521))

          )

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

          )

        )

      SID_LIST_LISTENER =

        (SID_LIST =

          (SID_DESC =

            (GLOBAL_DBNAME = ORADATA)

            (ORACLE_HOME = G:\app\himanshu\product\11.2.0\dbhome_1)

            (SID_NAME = oradata)

          )

        )

       

       

      sqlnet.ora

      ========

      SQLNET.AUTHENTICATION_SERVICES = (NTS)

       

       

       

      C:\Windows\system32>lsnrctl status

       

       

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 02-FEB-2014 13:53:37

       

       

      Copyright (c) 1991, 2010, Oracle.  All rights reserved.

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=himanshu-PC)(PORT=1521)))

      STATUS of the LISTENER

      ------------------------

      Alias                     LISTENER

      Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production

      Start Date                02-FEB-2014 13:29:35

      Uptime                    0 days 0 hr. 24 min. 6 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   G:\app\himanshu\product\11.2.0\dbhome_1\network\admin\listener.ora

      Listener Log File         g:\app\himanshu\diag\tnslsnr\himanshu-PC\listener\alert\log.xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=himanshu-PC)(PORT=1521)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

      Services Summary...

      Service "ORADATA" has 2 instance(s).

        Instance "ORADATA", status UNKNOWN, has 1 handler(s) for this service...

        Instance "oradata", status READY, has 1 handler(s) for this service...

      Service "ORADATAXDB" has 1 instance(s).

        Instance "oradata", status READY, has 1 handler(s) for this service...

      The command completed successfully

       

       

      Kindly guide whats wrong with my configuration.