job aborting with error ORA-12571: TNS:packet writer failure

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kirankota79
Premium Member
Premium Member
Posts: 315
Joined: Tue Oct 31, 2006 3:38 pm

job aborting with error ORA-12571: TNS:packet writer failure

Post by kirankota79 »

I am doing an insert into oracle table from dataset using upsert. I am getting this error many times and job is aborting. Each time this is happening on different nodes.

sqlcode is: -12571esql complaint: ORA-12571: TNS:packet writer failure

Unable to insert record into table.

Records Inserted: 0 Records Used for Update: 0 Records Rejected: 0 Total Records: 0

Operator's runLocally() failed.


Can someone let me know the reason?....this happened 3 times continously and it is happening for all the jobs i am inserting.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Talk to your Oracle DBA. This error is being generated by Oracle, only reported by DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
John Smith
Charter Member
Charter Member
Posts: 193
Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia

Post by John Smith »

Try googling for ora-12571.

Ray's advice is good unless YOU happen to be the DBA.
Post Reply