1 2 3 Previous Next 34 Replies Latest reply: Feb 15, 2013 11:37 AM by sb92075 RSS

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

    Tshifhiwa
      hi am geting this error
      ORA-12154:TNS:could not resolve the connect identifier specified
      my client listner is

      Edited by: adf009 on 2013/02/15 7:42 PM
        • 1. Re: ORA-12154:TNS:could not resolve the connect identifier specified
          Osama_Mustafa
          Post Listener.ora
          Db Version
          lsnrctl status

          How you connect ?
          • 2. Re: ORA-12154:TNS:could not resolve the connect identifier specified
            sb92075
            ADF007 wrote:
            hi am geting this error
            ORA-12154:TNS:could not resolve the connect identifier specified
            my client listner is

            # listener.ora Network Configuration File: C:\app\10017134\product\11.2.0\dbhome_1\network\admin\listener.ora
            # Generated by Oracle configuration tools.

            SID_LIST_LISTENER =
            (SID_LIST =
            (SID_DESC =
            (SID_NAME = SID)
            (ORACLE_HOME = C:\app\10017134\product\11.2.0\dbhome_1)
            (PROGRAM = extproc)
            (ENVS = "EXTPROC_DLLS=ONLY:C:\app\10017134\product\11.2.0\dbhome_1\bin\oraclr11.dll")
            )
            )

            LISTENER =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
            (ADDRESS = (PROTOCOL = TCP)(HOST = HOST)(PORT = 1521))
            )
            )

            LISTENER =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
            (ADDRESS = (PROTOCOL = TCP)(HOST = IP ADDRESS)( PORT = 1521))
            )
            )

            ADR_BASE_LISTENER = C:\app\10017134


            MY TNSNAME IS

            # tnsnames.ora Network Configuration File: C:\app\10017134\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
            # Generated by Oracle configuration tools.

            ORACLR_CONNECTION_DATA =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
            )
            (CONNECT_DATA =
            (SID = CLRExtProc)
            (PRESENTATION = RO)
            )
            )

            ORCL =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = HOST)(PORT = 1521))
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME =SERVICENAME)
            )
            )

            DEVOLTPDB =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = SID)
            )
            )

            THE FILE IS LOCATED AT C:\DevSuiteHome\NETWORK\ADMIN
            clues exist within listener.log file
            post last 50 - 100 lines after this error was just thrown
            • 3. Re: ORA-12154:TNS:could not resolve the connect identifier specified
              Sunny kichloo
              Have you tried using the search button of this forum .

              https://forums.oracle.com/forums/search.jspa?threadID=&q=ORA-12154&objID=f61&dateRange=thisyear&userID=&numResults=15
              • 4. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                Osama_Mustafa
                Sunny kichloo wrote:
                Have you tried using the search button of this forum .

                https://forums.oracle.com/forums/search.jspa?threadID=&q=ORA-12154&objID=f61&dateRange=thisyear&userID=&numResults=15
                if you want to count this error in this forum it will be more than 1 million :)
                • 5. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                  Sunny kichloo
                  :-)

                  But its better to use search button for common issues repeated in this forum.
                  • 6. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                    EdStevens
                    ADF007 wrote:
                    hi am geting this error
                    ORA-12154:TNS:could not resolve the connect identifier specified
                    my client listner is
                    "Client listener" is an oxymoron. The listener is, by definition, a server side process.

                    To diagnose a 12154, start here: http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/
                    and follow-up here: http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
                    # listener.ora Network Configuration File: C:\app\10017134\product\11.2.0\dbhome_1\network\admin\listener.ora
                    # Generated by Oracle configuration tools.

                    SID_LIST_LISTENER =
                    (SID_LIST =
                    (SID_DESC =
                    (SID_NAME = SID)
                    (ORACLE_HOME = C:\app\10017134\product\11.2.0\dbhome_1)
                    (PROGRAM = extproc)
                    (ENVS = "EXTPROC_DLLS=ONLY:C:\app\10017134\product\11.2.0\dbhome_1\bin\oraclr11.dll")
                    )
                    )

                    LISTENER =
                    (DESCRIPTION_LIST =
                    (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                    (ADDRESS = (PROTOCOL = TCP)(HOST = HOST)(PORT = 1521))
                    )
                    )

                    LISTENER =
                    (DESCRIPTION_LIST =
                    (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                    (ADDRESS = (PROTOCOL = TCP)(HOST = IP ADDRESS)( PORT = 1521))
                    )
                    )

                    ADR_BASE_LISTENER = C:\app\10017134


                    MY TNSNAME IS

                    # tnsnames.ora Network Configuration File: C:\app\10017134\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
                    # Generated by Oracle configuration tools.

                    ORACLR_CONNECTION_DATA =
                    (DESCRIPTION =
                    (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                    )
                    (CONNECT_DATA =
                    (SID = CLRExtProc)
                    (PRESENTATION = RO)
                    )
                    )

                    ORCL =
                    (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = HOST)(PORT = 1521))
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME =SERVICENAME)
                    )
                    )

                    DEVOLTPDB =
                    (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
                    (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SERVICE_NAME = SID)
                    )
                    )


                    MY SQLNET IS
                    # sqlnet.ora Network Configuration File: C:\app\10017134\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
                    # Generated by Oracle configuration tools.

                    # This file is actually generated by netca. But if customers choose to
                    # install "Software Only", this file wont exist and without the native
                    # authentication, they will not be able to connect to the database on NT.

                    SQLNET.AUTHENTICATION_SERVICES= (NTS)

                    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


                    THE FILE IS LOCATED AT C:\DevSuiteHome\NETWORK\ADMIN

                    Edited by: ADF007 on 2012/09/25 5:09 PM
                    So you showed us a bunch of configuration files, but you didn't show us the critical piece, the command you actually issued that resulted in the reported error.
                    • 7. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                      722837
                      You can provide the solution instead of listing the search pages .... It would have taken less trouble ......
                      • 8. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                        722837
                        Please let us know the way you are connecting .... That is the connect string you are using to make the connection.
                        • 9. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                          sb92075
                          Ajinkya wrote:
                          Please let us know the way you are connecting .... That is the connect string you are using to make the connection.
                          You can provide the solution instead of asking more questions.
                          • 10. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                            Oceaner
                            ADF112 wrote:
                            hi am geting this error
                            ORA-12154:TNS:could not resolve the connect identifier specified
                            my client listner is

                            # listener.ora Network Configuration File: C:\app\10017134\product\11.2.0\dbhome_1\network\admin\listener.ora
                            # Generated by Oracle configuration tools.

                            SID_LIST_LISTENER =
                            (SID_LIST =
                            (SID_DESC =
                            (SID_NAME = SID)
                            (ORACLE_HOME = C:\app\10017134\product\11.2.0\dbhome_1)
                            (PROGRAM = extproc)
                            (ENVS = "EXTPROC_DLLS=ONLY:C:\app\10017134\product\11.2.0\dbhome_1\bin\oraclr11.dll")
                            )
                            )

                            LISTENER =
                            (DESCRIPTION_LIST =
                            (DESCRIPTION =
                            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                            (ADDRESS = (PROTOCOL = TCP)(HOST = HOST)(PORT = 1521))
                            )
                            )

                            LISTENER =
                            (DESCRIPTION_LIST =
                            (DESCRIPTION =
                            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                            (ADDRESS = (PROTOCOL = TCP)(HOST = IP ADDRESS)( PORT = 1521))
                            )
                            )

                            ADR_BASE_LISTENER = C:\app\10017134


                            MY TNSNAME IS

                            # tnsnames.ora Network Configuration File: C:\app\10017134\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
                            # Generated by Oracle configuration tools.

                            ORACLR_CONNECTION_DATA =
                            (DESCRIPTION =
                            (ADDRESS_LIST =
                            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                            )
                            (CONNECT_DATA =
                            (SID = CLRExtProc)
                            (PRESENTATION = RO)
                            )
                            )

                            ORCL =
                            (DESCRIPTION =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = HOST)(PORT = 1521))
                            (CONNECT_DATA =
                            (SERVER = DEDICATED)
                            (SERVICE_NAME =SERVICENAME)
                            )
                            )

                            DEVOLTPDB =
                            (DESCRIPTION =
                            (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
                            (CONNECT_DATA =
                            (SERVER = DEDICATED)
                            (SERVICE_NAME = SID)
                            )
                            )


                            MY SQLNET IS
                            # sqlnet.ora Network Configuration File: C:\app\10017134\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
                            # Generated by Oracle configuration tools.

                            # This file is actually generated by netca. But if customers choose to
                            # install "Software Only", this file wont exist and without the native
                            # authentication, they will not be able to connect to the database on NT.

                            SQLNET.AUTHENTICATION_SERVICES= (NTS)

                            NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


                            THE FILE IS LOCATED AT C:\DevSuiteHome\NETWORK\ADMIN

                            Edited by: ADF007 on 2012/09/25 5:09 PM
                            You have not provided the connect string that you are using to connect. This error comes when the connect string that you are using doesnot exist in tnsnames.ora file on the machine from which you are making connection to database.
                            So, first check that connect string is correct that you are using and if it is correct, check that its entry is there in tnsnames.ora file.

                            Regards,
                            Navneet
                            • 11. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                              Tshifhiwa
                              am connecting via client am not in the server,and my sqnet is


                              # This file is actually generated by netca. But if customers choose to
                              # install "Software Only", this file wont exist and without the native
                              # authentication, they will not be able to connect to the database on NT.

                              Edited by: adf009 on 2013/02/15 7:45 PM
                              • 12. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                                Tshifhiwa
                                the log error is

                                TNS-12545: Connect failed because target host or object does not exist
                                TNS-12560: TNS:protocol adapter error
                                TNS-00515: Connect failed because target host or object does not exist
                                64-bit Windows Error: 49: Unknown error

                                Edited by: adf009 on 2013/02/15 7:15 PM
                                • 13. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                                  Osama_Mustafa
                                  -Post how you connect

                                  ex :sqlplus username/password@SID

                                  -post lsnrctl status
                                  -post tnsping SID
                                  • 14. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                                    Tshifhiwa
                                    am connecting using IDE TOAD am able to connect with SQL*PLUS without a problem



                                    TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 26-SEP-2
                                    012 08:07:36

                                    Copyright (c) 1997, 2003, Oracle. All rights reserved.

                                    Used parameter files:
                                    C:\DevSuiteHome\network\admin\sqlnet.ora

                                    Edited by: adf009 on 2013/02/15 7:17 PM
                                    1 2 3 Previous Next