TNS-12571 TNS:packet writer failure 1

[THoey]

About once a week, one of my instances locks up. I looked at the dump logs and found the following:

TNS-12571 TNSacket writer failure

I looked this up in the documentation and it says:

TNS-12571 TNSacket writer failure

Cause: An error occurred during a data send. This message is not normally visible to the user.

Action: For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Customer Support.

Also, according to the dump files, it is not the same query every time, but seems to be against the same table. So, I am not sure if rerunning the query with tracing on will help. Also, each of these select queries are run by a process by Crystal Reports.

Any ideas?

System Specifics:
Oracle 8.1.7 on NT 4.0. SP6a
Four database instances
Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[THoey]

In addition, I found the following in the tsorALRT.log for today:

Fri Apr 12 07:24:35 2002
KCF: write/open error block=0x5993 online=1
file=7 D:\ORACLE\ORADATA\TSOR\DR01.DBF
error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because
another process has locked a portion of the file.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 445

Does this help? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[karluk]

You "unable to write" error looks like the same one we used to get with Veritas Backup Exec software. We had two Backup Exec jobs on our server - one to backup the Oracle db and the other to backup the non database files. When we first set up the non Oracle job it tried to backup everything, including the database files. Periodically there would be contention and the db would crash. We fixed this problem by modifying the non Oracle job to exclude all database files.

I guess the moral is that Oracle can't handle this kind of contention, so you should find out what is locking your file and prevent it from happening in the future.

I don't know if this problem is related to your TNS-12571 error. I would guess that they are separate issues.

 

[THoey]

Thanks again Karluk. Both errors consistantly happen hand in hand, so we are fairly sure it is causing both. That backup software sounds familiar, but I am not sure if that is what we were using or what we recently changed to.

I will get with my NT administrator and have him exclude the Oracle specific datafiles directories.

Thanks again for the always timely and great help... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...