Oracle_Databasedown KS generates the following event: ORA-12571: TNS:packet writer failure (NETIQKB36325)

  • Document ID:7736325
  • Creation Date:02-Feb-2007
  • Modified Date:27-Apr-2011
    • Micro Focus Products:
      AppManager

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
Oracle_Databasedown Knowledge Script

Situation

ORA-12571: TNS:packet writer failure
Oracle_Databasedown KS generates the following event:
The database xxx is not running properly.
Reason: SQLSTATE=S1000, native error=12571, msg='[Oracle][ODBC][Ora]ORA-12571: TNS:packet writer failure

Resolution

This error is generated by the Oracle database itself. Unfortunately it is very vague in nature.
 
According to Oracle's Knowledge base, (http://metalink.oracle.com)   the ORA-12571 error is usually an indication of a connection timeout, caused by one of the following:
- network or network related equipment problems, such a bad router card.
- possibly a duplicate ip address in your configuration files, TNSNAMES.ORA and LISTENER.ORA
- instability of the Oracle database and the networking component. (The error is usually found in the alert / trace file)
- anti-virus software may be running on it causing a timeout
 
Users may be able to just edit the SQLNET.ORA file on the client and server. Remove the following entry from the SQLNET.ORA file on both the client and server:
SQLNET.EXPIRE_TIME=0
However, any changes should be done by a qualified Oracle dba or with guiidance from Oracle's Technical Support.

Additional Information

Formerly known as NETIQKB36325