?
Solved

SQLSETCONNECTATTR ORA-12571

Posted on 2003-03-26
6
Medium Priority
?
479 Views
Last Modified: 2011-04-14
I have instaled a ORACLE DATABASE 8.0.5 OVER WINDOWS 2000 PROF and obtain this error with a new client too in WINDOWS 2000 SP3 WITH THE DEVELOPER 6.
0
Comment
Question by:juanho
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 4

Expert Comment

by:Binary1
ID: 8214531
I found two separate references for this error number that may help.


I found the following for ORA-12571 at http://www.cryer.co.uk/brian/oracle/ORA12571.htm


Symptom:
The database halts or the current session is terminated with the error:

ORA-12571: TNS:packet writer failure

The error may be observed by a session currently using the database and will appear in the alert log file.

Possible causes and remedies:
With Oracle 8.0.4 onwards, this error may indicate that the database is in the process of being shut down.

This error has been observed when there was a loose cable connection to the SCSI disk array (on an Oracle Parallel Server system). Related errors were also subsequently noted in the NT event log.

If this is the cause then the remedy is to check all the cable connections. Do this by hand rather then visually, since a cable not being firmly in place could cause the problem.

Daniel Haller Strahm has reported that this problem can also be caused by an IP address conflict (Oracle 9.0.1). Windows will normally log an IP conflict in the event log and show a pop up alert - but only if it detects the conflict.

Check that no other computer on the network has the same IP address as the machine on which the problem has been reported.


--------------------------------------------
The following was found at: http://www.oracle-error.com/ora-12571.htm


What causes this error?
This error occurs due to a failure in datasend.

--------------------------------------------

How to fix it
If the client cannot send data to the server, it throws back an TNS error. Check if the database is available and whether you can see the database through the network. Try TNSPING for the DB or use ODBC-Test to check if the host is reachable.

Starting in Oracle 8.0.4, the shutdown mechanism has changed. Clients that are connected to ORACLE during a SHUTDOWN ABORT / IMMEDIATE / TRANSACTIONAL now receive one of the following errors on any subsequent SQL operations:

ORA-03113: end-of-file on communication channel
ORA-12571: TNS:packet writer failure

So, you have to reconnect once the database has been started and execute the command.

0
 

Author Comment

by:juanho
ID: 8220768
The database not in shutdown progress, theis database is actually accessed by another clients.

In this machine the SQL Plus 9.2.0.1.0 Works ok, but in the same machine we install a developer 6, that contains another SQL Plus 8.0.5.0.0 This not runs ok.

I have some experience with configurate TNSNAMES and SQLNET files.

The machine is a new P4, is probabily a processor problem?, what you say?.

Thanks.
0
 

Author Comment

by:juanho
ID: 8223347
ERROR SOLVE DESINSTALING THE MCAFEE VIRUSCAN.
0
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 
LVL 4

Accepted Solution

by:
Binary1 earned 2000 total points
ID: 8224785
I'm glad to hear it. I keep hearing of more and more problems with programs when Virus Scan software is running.
0
 

Expert Comment

by:Luca_66
ID: 8523476
How resolve the problem without uninstalling McAfee Viruscan ?

In my company we got licenses from McAfee products and some IMPORTANT application running on Oracle; there wasn't the problem with the old version of McAfee viruscan (4.0.3a), but we should upgrade to the new version (7.0) (the old version will be soon unsupported).
I got the problem installing the new version of viruscan on a client on wich the old version of viruscan dosn't run (win2000 with SP 3) and it is a client for the Oracle application.

Thanks a lot.
0
 

Expert Comment

by:Luca_66
ID: 8781494
I found how to resolve the problem without uninstalling McAfee Viruscan;
In the viruscan program just deactivate the "HAWK for e-mail" ("Hawn per Posta Elettronica" in italian) option; leave all others option activated.
Magically the connection to Oracle works again.
I wonder what kind of protection i'm giving up unselecting such an option, but, i think, is better than completely uninstallig the antivirus.

Bye.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

765 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