This discussion is archived
1 2 3 Previous Next 34 Replies Latest reply: Feb 15, 2013 9:37 AM by sb92075 RSS

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

adf009 Explorer
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    Post Listener.ora
    Db Version
    lsnrctl status

    How you connect ?
  • 2. Re: ORA-12154:TNS:could not resolve the connect identifier specified
    sb92075 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    :-)

    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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
    adf009 Explorer
    Currently Being Moderated
    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
    adf009 Explorer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    -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
    adf009 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points