Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2003
    Location
    Saint Lucia
    Posts
    14

    TNS-12560: TNS:protocol adapter error

    Hi All,
    I am trying to use oracle from a windows 2000 pc and I get the belows error. SQL Plus works fine but I still get this error.
    ************************************************** *********************
    Fatal NI connect error 12560, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.1 71.25)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=main )(CID=(PROGRAM=c:\bcg\bin\AdminVC6ORA816_31137.exe )(HOST=SLUL125)(USER=kenty.ramdatt))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
    Time: 11-FEB-2004 16:54:56
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNSrotocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 38
    nt OS err code: 0

    Can anyone help?

    Cheers

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    ensure that you can tnsping the instance from command line.
    check your SQLNET.ORA file and ensure that

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    Ensure that your oracle home is in the path statement...

    Problem sounds like the tnsnames.ora has a problem in it ...

    HTH
    Gregg

  3. #3
    Join Date
    Aug 2003
    Location
    Saint Lucia
    Posts
    14
    Hi,
    Tnsping is successful. I only have one sqlnet.org file located in the <c:\oracle\ora81\network\admin\sample> directory. I think this may be some missing or corrupted entry in the registry, but i'm not sure what to look for. Can you provide any more suggestions?

    Cheers

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Use Oracle net assistant to create a SQLNET.ORA file and ensure the TNSNAME.ORA file is ok... These are located in oracle_home\network\admin

    or create SQLNET.ORA

    # SQLNET.ORA Network Configuration File: C:\oracle\ora81\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    SQLNET.EXPIRE_TIME= 1

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    NAMES.DIRECTORY_PATH= (TNSNAMES)


    HTH
    Gregg

  5. #5
    Join Date
    Aug 2003
    Location
    Saint Lucia
    Posts
    14
    Still the same problem. Anything in the registry that I should look for?

  6. #6
    Join Date
    Aug 2003
    Location
    Saint Lucia
    Posts
    14
    Hi,
    I was finally able to resolve my problems, and I'm hoping that the information I provide here will assist someone:
    1. Uninstall Oracle client, removing folder C:\Oracle

    2. Remove all Oracle entries found in the registry under Hkey_Local_Machine.

    3. Enter registry and navigate to HKeyLM\system\CurrentControlSet\Services\Winsock. Delete the Winsock Key.

    4. Navigate to HKeyLM\System\CurrentControlSet\Services\Winsock2. Delete the Winsock2 key.

    5. Uninstall TCP/IP - Reason is because the winsock libary is corrupted and as a result Oracle cannot resolve your tns entries properly. After uninstall restart pc.

    6. Reinstall TCP/IP

    7. Reinstall Oracle and perform the necessary configuration.

    After you've done the necessary configuration, everything should be ok.
    If you encounter any problems, please send me an email at ramdattk@candw.lc, and I would be more than happy to assist you in resolving any issues relating to this problem.

    Cheers
    Kenty

  7. #7
    Join Date
    Mar 2004
    Posts
    1

    Insane

    Hi,

    Unfortunately your advise is unusable - It's not possible to uninstall all (9) Oracle products. Are you sure, there is no other solution? Following the Net Trace file (cli.trc) the problem is Oracle cannot locate tnsnames.ora... but I don't know why, because tnsping has no problems...

    ANy other suggestions, pls?

    Thanx in advance.

    Martin

  8. #8
    Join Date
    Jul 2009
    Posts
    1
    In order to enable Oracle on Windows firewall,the port 1521 has to be added to the Exceptions in the Windows firewall.

    Open firewall settings and ensure the listener port is not blocked.
    For example, on a Windows system, navigate to Control Panel-> Security Center-> Windows Firewall-> Exceptions. Click on Add port and add port 1521 or whatever port the listener is running on (see listener.ora).

    Refer Oracle faq for further details: ORA-12170 - Oracle FAQ

  9. #9
    Join Date
    Feb 2010
    Posts
    1
    As i had the same problem, with reinstall is no option,
    i checked the dns server. There was two names under
    the same address..

    Greets,
    Kuck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •