Packet Write Failure error in Oracle 8.1.5

6925 pts.
Tags:
Oracle 8.1.5
Oracle error messages
Oracle stored procedures
Packet Write Failure
I am using Oracle 8.1.5 with MS Dot NET 2005 on Windows XP with service pack 2. When I am sending data through a stored procedure, it is giving the error of "TNS:12571 : packet write failure" but it’s adding record in table, but truncated data in some columns and no data in the rest of the columns. Can you help? Moderator Note: This is a submitted question

Answer Wiki

Thanks. We'll let you know when a new response is added.

Has this worked before ? If yes, did you install some programs recently ?

Some antivirus programs, or network monitoring programs can make this happen, or any application using winsock. If you have such software installed, try uninstalling it.

If this is not the case, try changing the authentication service to NONE in the sqlnet.ora file:

<pre>SQLNET.AUTHENTICATION_SERVICES= (NONE) </pre>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following