This discussion is archived
11 Replies Latest reply: Nov 1, 2012 2:43 AM by vinay.lakshmi RSS

ERROR: ORA-12560: TNS:protocol adapter error

953769 Newbie
Currently Being Moderated
OS: Windows 7 64-bit
Oracle 11g installed

Error Message:

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012

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

Enter user-name: Ajinkya
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Please Help!!
  • 1. Re: ERROR: ORA-12560: TNS:protocol adapter error
    sb92075 Guru
    Currently Being Moderated
    950766 wrote:
    OS: Windows 7 64-bit
    Oracle 11g installed

    Error Message:

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012

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

    Enter user-name: Ajinkya
    Enter password:
    ERROR:
    ORA-12560: TNS:protocol adapter error


    Please Help!!
    FAQ!

    are both OS Services for the listener & database started & running?
  • 2. Re: ERROR: ORA-12560: TNS:protocol adapter error
    EdStevens Guru
    Currently Being Moderated
    950766 wrote:
    OS: Windows 7 64-bit
    Oracle 11g installed

    Error Message:

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012

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

    Enter user-name: Ajinkya
    Enter password:
    ERROR:
    ORA-12560: TNS:protocol adapter error


    Please Help!!
    Too bad you didn't show the command that generated this ... where you actuall invoked sqlplus at the command line.... That has a bearing on this error.

    Typically this will result from
    1) not having ORACLE_SID properly set. Especially so on Windows.
    2) not having the db service started. See the windows services applet, services.msc
  • 3. Re: ERROR: ORA-12560: TNS:protocol adapter error
    953769 Newbie
    Currently Being Moderated
    hw do u do that? m totally new to dis.
  • 4. Re: ERROR: ORA-12560: TNS:protocol adapter error
    953769 Newbie
    Currently Being Moderated
    wn i start sql plus, it asks 4 login name and password.. after entering the password.. dis error is shown
  • 5. Re: ERROR: ORA-12560: TNS:protocol adapter error
    EdStevens Guru
    Currently Being Moderated
    950766 wrote:
    hw do u do that? m totally new to dis.
    Sigh ...

    Ok, step by step.

    In the lower left corner of your computer screen, you should see an icon that looks suspiciously like the Windows logo. This is common referred to as the Windows "start button".

    Click on it.

    That should result in a pop-up, commonly referred to as the Windows "Start Menu". At the bottom of that menu there should be an input field with the text "search programs and files". Click in that field to position your input cursor there.

    Enter the text "services.msc"

    This should result in one program listed, named "services.msc".

    Click on the icon for that program.

    That should result in the opening of the "services" applet. This lists all of the service programs that are running in windows.

    Scroll down the list, looking for anything that starts with "Oracle".

    Tell us the name of every service you see whose name starts with "Oracle"
  • 6. Re: ERROR: ORA-12560: TNS:protocol adapter error
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    if you check this forum i think you find more than 2000 thread talking about this error , i think we must create new topics for this error please search in forum before you post new topics.

    and what version of windows 7 you run ?
  • 7. Re: ERROR: ORA-12560: TNS:protocol adapter error
    ShankarViji Pro
    Currently Being Moderated
    Hi User,

    Welcome to Forum !!!

    Please check that the Connection String for the database exists in the TNSNAMES.ora File. Usually,
    it is located $ORACLE_HOME\ora81\network\ADMIN.

    Regarding ORACLE_HOME,

    Please read the Link below:

    ORACLE_HOME

    The Connection String for the database need to be added in the TNSNAMES.ORA.

    And, once done. You can check it by issuing the following command from Command Prompt.
    D:\>tnsping orcd
    
    TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 04-AUG-20
    12 14:35:19
    
    Copyright (c) 1997 Oracle Corporation.  All rights reserved.
    
    Used parameter files:
    C:\OraDevSuite\network\admin\sqlnet.ora
    C:\OraDevSuite\network\admin\tnsnames.ora
    
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
    (HOST = 12.77.1.19)(PORT = 1521))) (CONNECT_DATA = (SID = orcd)))
    OK (0 msec)
    
    D:\>
    Here, the orcd is the connection string we have added in the TNSNAMES.ora file.
    SID is used to uniquely identify a database on a system.

    Thanks,
    Shankar
  • 8. Re: ERROR: ORA-12560: TNS:protocol adapter error
    964419 Newbie
    Currently Being Moderated
    please check out login by using host name

    Example:

    c:\>sqlplus

    User: scott/tiger@orcl

    SQL>

    It worked for me. If i give it in this way it returns the error

    c:\>sqlplus

    User: scott/tiger

    ORA-12560: TNS: protocol adapter error

    Hope that would help you to solve the problem. I have check your thread today

    Thank You
    Shreyas
  • 9. Re: ERROR: ORA-12560: TNS:protocol adapter error
    EdStevens Guru
    Currently Being Moderated
    961416 wrote:
    please check out login by using host name

    Example:

    c:\>sqlplus

    User: scott/tiger@orcl

    SQL>

    It worked for me. If i give it in this way it returns the error

    c:\>sqlplus

    User: scott/tiger

    ORA-12560: TNS: protocol adapter error

    Hope that would help you to solve the problem.
    I doubt it, since you give no explanation of why it worked one way and not the other.
    I have check your thread today
    The thread you checked is nearly two-months old. Nearly two months without the OP responding with any of the already requested information. I seriously doubt he is watching this thread any more.

    >
    Thank You
    Shreyas
    Edited by: EdStevens on Sep 26, 2012 6:43 AM
  • 10. Re: ERROR: ORA-12560: TNS:protocol adapter error
    966024 Newbie
    Currently Being Moderated
    I had the same problem.

    windows environment
    I found out I recently installed instant client. Which I had to have instant client bin in the %PATH%.
    when I tried Where command; c:\users\xxx> where sqlplus
    I found out I have two sqlplus program which because of Path environment sqlplus from instant clien where executed first, which wrong.
    So I fixed the path environment and everything is all right.

    Good luck
  • 11. Re: ERROR: ORA-12560: TNS:protocol adapter error
    vinay.lakshmi Newbie
    Currently Being Moderated
    hey....simple...try to find listener.ora file is correct ornot...
    myne is

    # listener.ora Network Configuration File: D:\Oracle\Lakshmivinay\product\11.2.0\dbhome_1\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = D:\Oracle\Lakshmivinay\product\11.2.0\dbhome_1)
    (PROGRAM = extproc)
    (ENVS = "EXTPROC_DLLS=ONLY:D:\Oracle\Lakshmivinay\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    )

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

    ADR_BASE_LISTENER = D:\Oracle\Lakshmivinay