Nibble Guru - Computing queries demystified Wednesday, December 03, 2008
Home
My Account / Register
Login / Logout
Post your Problem!
Search

About Us
Contact Us



List Home > Databases > Oracle >   [ Post New Problem ]

Welcome back !
TrackingID : 263
Posted : Tuesday, December 23rd, 2003 05:48:59 AM
By : pessegueiro
TNS-12571: TNS:packet writer failureConfiguration:
connecting to sqlplus in windowsxp by Anonymous Ghost on August 07th, 2002 03:38:05 PM
I installed oracle 8i enterprise edition on windows xp PC but when I want to go in sqlplus it gives an error ORA-12571 TNS:Packet write failure but if I connect to sqlplus in dos mode i.e at the command prompt then it connects and works fine bu not in gui mode.Can anyone help me on this.
Thanks

Additional Comments:
sqlnet.log
-------------------
Fatal NI connect error 12571, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1526))(CONNECT_DATA=(SID=xxxxx72)(CID=(PROGRAM=C:orantBINifrun60.EXE)(HOST=xxxxxxxxx)(USER=xxxxxxxx))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.6.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.0.6.3.0 - Production
Time: 23-DEC-2003 11:16:44
Tracing not turned on.
Tns error struct:
nr err code: 12206
TNS-12206: TNS:received a TNS error during navigation
ns main err code: 12571
TNS-12571: TNS:packet writer failure
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
-------------------
Help
Operating System : Microsoft Windows XP Prof.
CPU/Processor : Intel 2000 MHz
RAM : Actual:512 MB
Hard Disk : 40, Space: 20 GB, RPM:7200

Related Problems :
Comments :
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on February 23rd, 2004 07:30:23 AM
I am having the same problem. Please help. THANKS Alice

alice.utter@usag.apg.army.mil
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on March 29th, 2004 01:07:05 AM
uninstall Mcafee or other virus scan applications
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on April 26th, 2004 11:17:55 AM
If you are facing this ora-12571 error, Please use below:

try:
TNS: Packet writer failure occurs during install of oracle 9i
file: .\ora92\network\admin\sqlnet.ora

Previous --> SQLNET.AUTHENTICATION_SERVICES= (NTS)
Actually --> SQLNET.AUTHENTICATION_SERVICES= (NONE)
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on May 20th, 2004 06:38:04 AM
Hi All
There is solution for TNS write packet failure error . follow these setps to resolve the issue

1) Uninstall the TCP/IP
2) Export the registry
3) remove all the winsock entry from registry
4) restart the PC
5) install TCP/IP
6) Try to connect to database if you get diffrent error (other than TNS write packet error ) then
7) Uninstall and reinstall the SQL
This steps will resolve the TNS write packet failure error ..

Regards
Prashanth
prashanth.rao@oracle.com
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on June 03rd, 2004 03:06:34 PM
>try:
>TNS: Packet writer failure occurs >during install of oracle 9i
>file: .\ora92\network\admin\sqlnet.ora

>Previous --> >SQLNET.AUTHENTICATION_SERVICES= (NTS)
>Actually --> >SQLNET.AUTHENTICATION_SERVICES= (NONE)

The above worked (at least I was able to create a default database). Thanks!
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on June 09th, 2004 05:00:58 AM
i have installed oracle 6i forms and reports on windows 2000 professional while connecting to database sql plus release 8.0 and Oracle 9i ( 9.2) it gives error 12571
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on July 07th, 2004 11:27:06 PM
I installed oracle 8i enterprise edition on windows xp PC but when I want to go in sqlplus it gives an error ORA-12571 TNS:Packet write failure but if I connect to sqlplus in dos mode i.e at the command prompt then it connects and works fine bu not in gui mode.Can anyone help me on this.
Thanks
SOLUTION that worked and SIMPLE by Anonymous Ghost on July 21st, 2004 05:07:53 AM
The following DOES NOT work for me.

>Previous --> >SQLNET.AUTHENTICATION_SERVICES= (NTS)
>Actually --> >SQLNET.AUTHENTICATION_SERVICES= (NONE)

Prashanth suggestion would probably work, but IF oracle was working, and then stopped working - think about what you changed. I recently was debugging some network traffic - I read the article talking about how Winsock 1.1 cannot pass sockets between processes, blah blah.

End result I uninstalled WinPCap and Ethereal (and some spyware, how did that get there?) and Oracle worked after a restart.

My advice, uninstall some new programs, esp. if they are network oriented, and might have changed your winsock version.

Please post if this works for you.
WHAT is: TNS-12571: TNS:packet writer failure by Anonymous Ghost on July 22nd, 2004 09:21:28 AM
What causes this error message?

Thanks
Cindy !@
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on August 03rd, 2004 08:38:18 AM
This error is usually caused by spyware or adware that is installed on the computer. You may want to run a spyware removal tool (such as Spybot Search and Destroy) to fix such problems. Another cause I have seen for this error having a content filtering program (such as NetNanny) installed; either uninstall that program, or configure it so that it allows the program(s) you are using to pass unfiltered.
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on August 07th, 2004 02:54:58 AM
Hello Prashanth,



I found your notes below when I was looking for my Oracle connection problem.

It solved my problem fast and saved my time after 10 hours searching about the problem source.



Thank you very much



Regards,

Mehrvash
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on August 13th, 2004 04:33:37 PM
I resolved my problem running a spyware removal tool, thanks
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on September 20th, 2004 10:12:02 PM
removing spyware worked for me too
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on January 07th, 2005 12:55:15 PM
I removed all spywares and I have not installed any new programs. But still I am getting this error when I am trying through Tora, Toad or Workflow. Everything worked fine till 2 days ago. I am working on a laptop running Windows XP home.
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on January 12th, 2005 02:07:27 PM
Hi!

I have the same problem!
I'm using a Forms 6i client.
When I try to connect to the DB (9i) I get the ora-12571 error!

I don't know what to do!
It's not a problem with the firewall or the mcaffee.

pleas help me!

thanks!!
Re: TNS-12571: TNS:packet writer failure by hishivani on May 13th, 2005 01:28:12 AM
i m having problem when ever i try to connect with oracle client, start sqlplus i give my username and password and Database name, it gives me error
TNS packet writer failure.
How can i remove this error from my system
Re: TNS-12571: TNS:packet writer failure by Anonymous Ghost on August 04th, 2005 11:33:30 AM
remove tns

Related Problems :
Post a Note :
UserName (not required in anonymous posts)
Password (not required in anonymous posts)
Post Anonymous (check this only if you wish to post anonymously.)
Subject
Comment (limited HTML allowed)



List Home > Databases > Oracle >   [ Post New Problem ]
Copyright © 2001-2008, Nibble Guru