Forms Error : ORA-12571 TNS Packet Writer Failure [message #100846] |
Thu, 25 December 2003 00:25 |
Denis Dudhia
Messages: 3 Registered: December 2000
|
Junior Member |
|
|
I have a D2K / Oracle application. D2K application and Oracle Database are hosted on separate servers.
Problem is with one of the PCs with Windows 2000 Professional. I have installed Oracle Forms and Reports Runtime on this PC. Now when I try running the Application, I get an error something like this:
"ORA-12571 - TNS: Packet Writer Failure".
I tried uninstalling and re-installing Oracle (even removed all the registry entries). But this does not work.
Everything is perfect with the Network configuration. Also there are lot of other Windows 2000 Professional Systems that are running the same application properly without any error.
Can anyone out there, give me the solution for above stated problem?
|
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #100854 is a reply to message #100846] |
Tue, 20 January 2004 13:10 |
Allen Effenberger
Messages: 3 Registered: January 2004 Location: Bi-Mon-Sci-Fi-Con!
|
Junior Member |
|
|
i know this is a month later than you posted, but... oh well.
many times i've been able to correct this problem by downloading and running ad / spy detection software (but not always). In the cases where it hasn't worked, unfortunately a reformat has been the fix :(
more recently i discovered the "netstat" command. The last couple of times i've seen this error, a persistent http connection has shown up (to a different site both times, but i forgot to look at the two machines i fixed yesterday with ad-aware). it is my belief (but i havent any empirical evidence) that it's this persistent connection that's killing the packets before they go.
editing the sqlnet.ora file has never worked for me. also, this shouldn't have to be done if it worked before, then failed, and then oracle was reinstalled.
sometimes you'll find ugly connections in your c:winntsystem32driversetchosts file, however.
i've even disabled tcp/ip or blown away the whole stack and rebuilt it (though i've never changed a network card in the attempt to fix it), and seen the connection remain. the two may be unrelated, but it seems suspicious to me.
i (and my co-workers) are still searching searching for a quick fix (which doesn't entail a wipe).
in all of the cases where ad-aware has fixed it (i'm sure something like spybot would have fixed it too), there was a TON of downloadware on board, or "internet games" or browser enhancers / enhancements (gator, euniverse, kazaa and its plug-ins, "rapid blaster", and more)
|
|
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #100902 is a reply to message #100846] |
Wed, 11 February 2004 18:05 |
Shamsur Rahman Chowdhury
Messages: 2 Registered: February 2004
|
Junior Member |
|
|
Oracle 8i & D2K was installed in my m/c with W2K server. It got infected with virus. Before it got infected, Oracle was running fine. I re-installed W2K and I installed D2K again. But when I try to connect this m/c with other Oracle server in my network with SQL PLUS it gives error: 'Packet writer failure'. Please help me with solution.
Chowdhury S.R
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #100907 is a reply to message #100846] |
Thu, 12 February 2004 20:59 |
Sajid Hameed
Messages: 2 Registered: February 2004
|
Junior Member |
|
|
Change your sqlora.net file, that will find you on oracle installed directory e.g, d:oracle9inetworkadmin
comments all lines and save it.
after that, during installation may be a error occurd as DB_BLOCK_SIZE. and the error give u exact block size, that size u will change in Parameter file.
u will successfull.
|
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #100924 is a reply to message #100846] |
Thu, 19 February 2004 14:17 |
Chris
Messages: 128 Registered: November 1998
|
Senior Member |
|
|
Hi,
just my .02 cents. If you have Marketscore on your computer, you will get this error when trying to log in via sqlplus, etc. It is because Marketscore reroutes all your internet traffic to their proxy servers... thereby monitoring your surfing habits and screwing up your oracle connections.
It is extremely difficult to remove! I finally had to go to their website and followed their procedures to remove the software.
One way you can tell is to download Ad-Aware. get the latest reference file.
1. Do a scan. You will see marketscore entries - one of which says "Netsetter"
2. delete these entries and reboot your computer.
3. when booted, redo the scan. If you still get entries, you need to go to their website to get rid of it because Ad-Aware cannot. (don't believe me? redo steps 2-3 a few dozen times and you will get the idea)
Anyways, I hope this helps you guys.
|
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #100950 is a reply to message #100915] |
Tue, 02 March 2004 09:56 |
sat
Messages: 3 Registered: January 2001
|
Junior Member |
|
|
I have the oracle 8.1.7 installed on my pc... i've running the program for about a month now and then last night I got this error message when trying to run the application for reports. I am able to login via SQLPLUS though......I don't understand what happened
can anyone help.
Thanks
|
|
|
|
|
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #101036 is a reply to message #100907] |
Thu, 01 April 2004 00:30 |
Sajid Hameed
Messages: 2 Registered: February 2004
|
Junior Member |
|
|
With reference to my Previous posted message, It was successful, after some time, I had found same Error again "TNS Packet Writer Error". I m using Windows-2000 Server.
The Error was occur due to the Network Switch, the port blocked the packets, the system was running very smooth on the network, but when I opened the SQL the above error was occured.
For solving the problem, You can Switch Off the Switch / Hub and then restart it. After that u will able to login.
|
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #101050 is a reply to message #100962] |
Thu, 01 April 2004 23:00 |
Senthil Kumar Kanagaraj
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
Hello All,
I have tried "JCharb on March 05, 2004" reply for this TNS pocket failure error and It has solved the problem.
If you are facing this ora-12571 error, Please use below:
try:
TNS: Packet writer failure occurs during install of oracle 9i
file: .ora92networkadminsqlnet.ora
Previous --> SQLNET.AUTHENTICATION_SERVICES= (NTS)
Actually --> SQLNET.AUTHENTICATION_SERVICES= (NONE)
Hope this helps.
Cheers,
/Senthil...
|
|
|
TNS Packet Writer Failureor : ORA- [message #101052 is a reply to message #100880] |
Wed, 07 April 2004 05:01 |
ahameed
Messages: 6 Registered: February 2004
|
Junior Member |
|
|
I am using window 2000 professional edition
i create general purpose database in oracle 8i version 8.1.7.0.0 on backend database is working correctly but when i connect form 6i (form builder) with this database it prompt me folowing message
ora 12571:TNS Packet wirter failure
GIVE ME SOLUTION
|
|
|
TNS Packet Writer Failureor : ORA- [message #101053 is a reply to message #100880] |
Wed, 07 April 2004 05:06 |
ahameed
Messages: 6 Registered: February 2004
|
Junior Member |
|
|
I am using window 2000 professional edition
i create general purpose database in oracle 8i version 8.1.7.0.0 on backend database is working correctly but when i connect form 6i (form builder) with this database it prompt me following message
ora 12571:TNS Packet wirter failure
GIVE ME SOLUTION
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #101062 is a reply to message #100880] |
Sat, 10 April 2004 22:55 |
ahameed
Messages: 6 Registered: February 2004
|
Junior Member |
|
|
I am using window 2000 professional edition
i create general purpose database in oracle 8i version 8.1.7.0.0 on backend database is working correctly but when i connect form 6i (form builder) with this database it prompt me following message.
ora 12571:TNS Packet wirter failure. TNS service is also stated i give correct host name
correct port name
database name
and instances name but problem remain same
GIVE ME SOLUTION
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #101063 is a reply to message #100880] |
Sat, 10 April 2004 22:57 |
ahameed
Messages: 6 Registered: February 2004
|
Junior Member |
|
|
I am using window 2000 professional edition
i create general purpose database in oracle 8i version 8.1.7.0.0 on backend database is working correctly but when i connect form 6i (form builder) with this database it prompt me following message.
ora 12571:TNS Packet wirter failure. TNS service is also stated i give correct host name
correct port name
database name
and instances name but problem remain same
GIVE ME SOLUTION
THANKS
|
|
|
SOLUTION : ORA-12571 TNS Packet Writer Failure [message #101080 is a reply to message #100846] |
Thu, 22 April 2004 01:11 |
dipti
Messages: 3 Registered: April 2004
|
Junior Member |
|
|
I was also facing the same problem Ora-12571:TNS:packet writer failure with Microsoft 2000 professional oracle 9i 2 release and forms 6i.
I couldnt connect from the oracle sqlplus with the instance.
The problem was....that the tcp/ip protocol was not working . so we configured the listner.the listner.ora contect is:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 000.000.0.0)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(SERVER = 000.000.0.0)(PIPE = rameshp))
)
)
aLSO THE SERVICE NAME WAS CHANGED IN ORACLENETWORKADMINTNSNAMED.ORA TO
XYZ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = ABC)(PIPE = ABC1))
)
(CONNECT_DATA =
(SERVICE_NAME = XYZ)
)
)
ALSO FOR THE FORMS TO CONNECT THE CONNECTION STRING ADDED WAS IN ORANTNET80ADMINTNSNAMES.ORA:
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = nmp)
(server = 000.000.0.0)
(Pipe = ABC1)
)
)
(CONNECT_DATA = (SID = XYZ)
)
)
NOW ITS WORKING FINE .THE 000.000.0.0 IS THE MACHINES(SERVERS) IP ADDRESS.
ANY CLIENT THAT IS TO BE CONNECTED TO THIS DATABASE SHULD BE CONNECT WITH NMP PROTOCOL.
THANKS FOR THE HELP.
PLZ. MAIL ANYTHING RELATED ON THE SAME SITE.
|
|
|
|
latest solution : ORA-12571 TNS Packet Writer Failure [message #101082 is a reply to message #100846] |
Thu, 22 April 2004 22:33 |
dipti
Messages: 3 Registered: April 2004
|
Junior Member |
|
|
I was also facing the same problem
Ora-12571:TNS:packet writer failure with Microsoft 2000 professional oracle 9i 2 release
and forms 6i.
I couldnt connect from the oracle sqlplus with the instance.
The problem was....that the tcp/ip protocol was not working .
so we configured the listner.the listner.ora content is:
(startprgramsoracle9iconfiguration and migration toolsnet coniguration assistant
listener coniguration..nmp) or
(startprgramsoracle9iconfiguration and migration toolsnet managerlocallistener...)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.4)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(SERVER = 192.168.0.4)(PIPE = rameshp))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:ora9i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ace)
(ORACLE_HOME = D:ora9i)
(SID_NAME = ace)
)
)
aLSO THE SERVICE NAME WAS CHANGED IN ORACLENETWORKADMINTNSNAMED.ORA TO
(startprgramsoracle9iconfiguration and migration toolsnet coniguration assistant
local net serice name coniguration..nmp) or
(startprgramsoracle9iconfiguration and migration toolsnet managerlocalservice names...)
ace =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = RAMESH)(PIPE = rameshp))
)
(CONNECT_DATA =
(SERVICE_NAME = ace)
)
)
ALSO FOR THE FORMS TO CONNECT THE CONNECTION STRING ADDED WAS IN
ORANTNET80ADMINTNSNAMES.ORA:
ace =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = nmp)
(server = 192.168.0.4)
(Pipe = rameshp)
)
)
(CONNECT_DATA = (SID = ace)
)
)
and
# SQLNET.ORA Network Configuration File: D:ora9inetworkadminsqlnet.ora
# Generated by Oracle configuration tools.
# SQLNET.AUTHENTICATION_SERVICES= (nts)
NAMES.DIRECTORY_PATH= (TNSNAMES)
NOW ITS WORKING FINE .THE 000.000.0.0 IS THE MACHINES(SERVERS) IP ADDRESS.
ANY CLIENT THAT IS TO BE CONNECTED TO
THIS DATABASE SHULD BE CONNECT WITH NMP PROTOCOL.
THANKS FOR THE HELP.
PLZ. MAIL ANYTHING RELATED ON THE SAME SITE.
· Use lsnrctl in command prompt to get lsnrctl>. Use lsnrctl>help to start/stop… the listener.
· Use c>tnsping ‘service name’ to check working of any service name(Oracle service name/Forms service name)
|
|
|
ORA-12571 TNS Packet Writer Failure [message #101083 is a reply to message #101080] |
Thu, 22 April 2004 23:06 |
Yadagiri
Messages: 1 Registered: April 2004
|
Junior Member |
|
|
I am facing the same problem while compiling one of the procedure, not for all, with following message.
/*****************************/
ERROR at line 1:
ORA-12571: TNS:packet writer failure
ORA-24323: value not allowed
Error accessing package DBMS_APPLICATION_INFO
/*****************************/
What is the reason?
Please help.
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #101102 is a reply to message #100846] |
Mon, 03 May 2004 11:33 |
Jared Pickerell
Messages: 2 Registered: May 2004
|
Junior Member |
|
|
I had already used AdAware to fix remove a bunch of "junk" software that had gotten installed. I'm pretty sure that it was AdAware that broke the TCP/IP connectivity. I have had this happen once before on another XP machine. I downloaded WinsockXPFix and it took care of my problem. It does a TCP/IP reset (netsh) and rewrites some registry entryies and files.
Jared Pickerell
Co-Director/Network Admin
Information Systems
Highland Community College
|
|
|
|
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #101192 is a reply to message #100846] |
Sun, 13 June 2004 02:29 |
R.Kumar
Messages: 1 Registered: June 2004
|
Junior Member |
|
|
I have a D2K / Oracle application. D2K application and Oracle Database are hosted on separate servers.
Problem is with one of the PCs & laptop with Windows xp. I have installed Oracle Forms and Reports Runtime on this PC. Now when I try running the Application, I get an error something like this:
"ORA-12571 - TNS: Packet Writer Failure".
I tried uninstalling and re-installing Oracle (even removed all the registry entries). But this does not work.
Everything is perfect with the Network configuration. Also there are lot of other Windows 2000 Professional Systems & windows 98 that are running the same application properly without any error.
Can anyone out there, give me the solution for above stated problem?
|
|
|
|
Re: Try this ! [message #101212 is a reply to message #101211] |
Sun, 20 June 2004 21:49 |
Peter Leerson
Messages: 1 Registered: June 2004
|
Junior Member |
|
|
Finally, a solution that works. I had tried everything suggested by gurus everywhere in an attempt to fix this problem on a colleague's computer. I must add that I had already uninstalled all software packages that I believed were causing the conflict and run another winsock repair tool but to no avail. That is till now! Thankyou :)
|
|
|
|
|
|
|
Re: Forms Error : ORA-12571 TNS Packet Writer Failure [message #101276 is a reply to message #101102] |
Fri, 16 July 2004 13:44 |
Julie Gibson
Messages: 1 Registered: July 2004
|
Junior Member |
|
|
Much thanks, Jared. . .I also used AdAware to remove alot of spyware, as well as manually deleting some files & registry entries. I finally got rid of the spyware & popups, but it broke my Oracle-based application. I tried all the fixes mentioned previously, and this was the one that worked!! Much appreciation to you!
:-) julie
Julie Gibson
Information Technology Consultant
Cal Poly State University
jagibson@calpoly.edu
|
|
|