ORA-12571 TNS Packet Writer Failure out of the blue
As of a month ago I have recieved two or three dozen complaints from a cross section of 30-40 clients, all of which are either running Oracle 18.104.22.168.1 or oracle 9.2 databases with oracle 8.1.6 and oracle 9.2 clients respectively. The complaints are always the same. Everything was working fine and I went to open the appliation and recieved a fatal error.
ORA-12571 TNS Packet Writer Failure
The application is a client/server records management program written in Delphi for Windows 98, 2k and XP clients and NT, 2000 and 2003 server environments.
Usually, out of 30-50 computers 1 or 2 may be affected by this problem. And on a seemingly random basis. Restarting the database or cycling the entire network doesn't resolve the problem, uninstalling all service packs and hotfixes and even reinstalling the oracle client software completely after deleting all directories and registry keys also does not resolve the problem. No other computers are affected and the ONLY way I have been able to resolve this error is by reformatting the computer and reinstalling the operating system. Any suggestions would be greatly appreciated.
A TNSPING SERVICENAME from the dos prompt results in the same error message, both before and after reinstalling oracle.
It is my understanding that the Operating System (windows) is not allowing the oracle client to communicate on port 1521 because it feels that this port is a security vulnerability. Can anyone else shed some additional light on this problem?