DSXchange

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.

Talk to your Oracle DBA. This error is being generated by Oracle, only reported by DataStage.

Try googling for ora-12571.

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