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.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
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.
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.
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.
Business Accounts
Answer for Membership
by: Binary1Posted on 2003-03-26 at 16:18:31ID: 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/bri
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.co
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.