Packet Write Failure error in Oracle 8.1.5
Home > IT Answers > Oracle > Packet Write Failure error in Oracle 8.1.5
BrentSheets
6535 pts.
0
Q:
Packet Write Failure error in Oracle 8.1.5
Oracle stored procedures, Oracle 8.1.5, Oracle error messages, 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
ASKED: May 15 2009  8:30 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29855 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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:

SQLNET.AUTHENTICATION_SERVICES= (NONE)
Last Answered: May 19 2009  11:56 PM GMT by Carlosdl   29855 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0