• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

SQLSETCONNECTATTR ORA-12571

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
juanho
Asked:
juanho
  • 2
  • 2
  • 2
1 Solution
 
Binary1Commented:
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
 
juanhoAuthor Commented:
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
 
juanhoAuthor Commented:
ERROR SOLVE DESINSTALING THE MCAFEE VIRUSCAN.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Binary1Commented:
I'm glad to hear it. I keep hearing of more and more problems with programs when Virus Scan software is running.
0
 
Luca_66Commented:
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
 
Luca_66Commented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now