Solved

TNS-12560 protocol adapter error from client (Oracle developer 6i) / TNS 12571 error

Posted on 2004-04-24
7
10,479 Views
Last Modified: 2013-12-12
We have many client machines (oracle developer 6i installed which has Oracle 8i client) suddenly stopping connections to the database (Oracle 9i). tnsnames.ora is fine, because it used to connect before. I can ping to the database host, but when doing tnsping80 to the tns entry it is giving TNS-12560 protocol adapter error or TNS 12571 packet writer failure. I tried to re-install Oracle, but no use. Finally we have to re-intsall win2K/Win XP and install Oracle Dev 6i again to solve the problem.
Please give advice.
Thanks..
0
Comment
Question by:reeyag
  • 3
  • 2
7 Comments
 
LVL 6

Expert Comment

by:musdu
Comment Utility
Hi,

do all clients get this error? Developer6i patch13 is certified against a oracle9i database. Which patch do you have?

regards.
0
 

Author Comment

by:reeyag
Comment Utility
Even with developer 6i rel. 2 (for xp) and patch 15, the problem was not solved.
0
 
LVL 6

Expert Comment

by:musdu
Comment Utility
Hi,

I could not find a solution in Metalink. They say that some spyware can cause this error. So you may install a program to clear spyware and try again.

regards.

From:  Oracle, Dagmar Thompson  10-Feb-04 13:45
Subject: Re : ORA 12571: TNS Packet Writer Failure

One of the things we are seeing lately, is that the different "spyware" software products are causing problems with oracle connections.

These products are getting installed on peoples computers without the end-users consent or knowledge. It happens as there result of the end-user going to some website that is using this tool to gather information about the end-user's cruising habits.

The solution is to uninstall the spyware program and add a tool that will keep these tools from being installed or enables.

If everything was working and suddenly stops, this is were I would start.

The next step is ask what changed and start working backward from there. Other things to check, are is the a firewall between the client and the server? If so did someone change the firewall configuration. Is there a hardware failure on this one client.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:reeyag
Comment Utility
Recently we got 1 case of each error on Win XP PCs in remote sites. They are not connected to internet.

There is a firewall between client and server, but other PCs in the site are able to access the server. We brought the PC to IT, where server is located and gave a local IP, but still the problem was there.

I re-installed oracle developer 6i rel.2 for XP, installed the patch 15, but of no use. So we had to format the PC as usual.

In another remote site, when we got ORA-12560 error, we restarted the PC and logged in as different domain user. Then it got connected, again we logged in as the first domain user again it connected.
0
 
LVL 6

Expert Comment

by:musdu
Comment Utility
Good morning,

I am not sure it will be usefull but have you tried to start a sql trace? In oracle home  under net80\admin there's a file named sqlnet.ora. If you set below parameters, it provides you a detailed sql trace;

trace_level_client = 16
trace_file_client =  d:\dev\cli.trc

connect to the database and examine the cli.trc file.

regards.
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
Comment Utility
PAQed - no points refunded (of 500)

DarthMod
Community Support Moderator
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now