Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12571: TNS:packet writer failure

gl32546848Jul 21 2010 — edited Jul 21 2010
Sqldeveloper : win xp
Version : 2.1.0.63

Oracle db: 10.2.0.4
OS : solaris

Issue : I am trying compile a plsql package which is of 54KB. when I am trying to compile to get the errors. I am getting

CREATE OR REPLACE PACKAGE BODY PACK_POR0575
*
ERROR at line 1:
ORA-12571: TNS:packet writer failure

Even I am trying to execute from sqlplus client from the xp machine.

SQL> @ c:\anir\pbpor0575.sql
1120 /
CREATE OR REPLACE PACKAGE BODY PACK_POR0575
*
ERROR at line 1:
ORA-12571: TNS:packet writer failure

However When I tried to run the same on the server, It was working fine. How to resolve this what could be the reason ? is there any size limit ?

if you have already faced such issue pl give the steps how to resolve this.

thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2010
Added on Jul 21 2010
5 comments
1,591 views