If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > TNS-12560: TNS:protocol adapter error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Saint Lucia
Posts: 14
Still the same problem. Anything in the registry that I should look for?
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On