How To Handle ORA-12571: TNS Packet Writer Failure Error In A Valid Sqlplus Session (Doc ID 1127583.1)

Last updated on APRIL 21, 2017

Applies to:

Oracle Communications Order and Service Management - Version 6.3.1 to 7.2.0 [Release 6.3 to 7.2]
Information in this document applies to any platform.
Review relevance June 19, 2014
Review relevance Nov 20, 2015
Review relevance April 21, 2017

Symptoms

Very often you have a valid working SQLPLUS session and you are able to send commands to the database server, for example:

SQL> select username,machine,count(*) from v$session group by username,machine;
USERNAME MACHINE COUNT(*)
------------------------------ ------------------------------ ----------
OSM01TORONTO 33
SYS CA-ORACLE\bniu-lap 1
OSM631_53_TT CA-ORACLE\bniu-lap 2
OSM631_B53_W OSM01TORONTO 1
PROVISIONING_POL_TM labdb2.ch.oracle.com 2


Then all of a sudden it is not working anymore

SQL> /
select username,machine,count(*) from v$session group by username,machine
*
ERROR at line 1:
ORA-12571: TNS:packet writer failure

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms