ORA-03135: connection lost contact

dr.murthy · Post by **dr.murthy** » Sun Dec 27, 2009 8:33 pm

hi ,

i have a job which updates the surrogatkey value and loading into oracle oci table, when the loading time job is aborted and could not load data in to table, its saying error like
SurrKeyAgg: ORA-03135: connection lost contact
SurrKeyAgg: DBMS.CODE=ORA-03135
At row 1, link "LnKOtUpdtSurrkey"
Row Rejected

could you please let me know what is the problem in oracle, i have searched in this forums, i can't get any related information.

any one help out this issue

ray.wurlod · Post by **ray.wurlod** » Mon Dec 28, 2009 3:52 am

Learn how to decode Oracle error codes, for example using the oerr command or the (Oracle) error messages manual.

dr.murthy · Post by **dr.murthy** » Mon Dec 28, 2009 4:50 am

Thanks ray,

but my question is whether the problem is in oracle or in datastage job.

chulett · Post by **chulett** » Mon Dec 28, 2009 7:31 am

Assuming you can connect properly from the job, start the diagnostic work from the Oracle side.

Code: Select all

ORA-03135: connection lost contact 

Cause: 1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection.
 
Action: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora.

Work with your DBA and start with the 'actions' suggested.

dr.murthy · Post by **dr.murthy** » Mon Dec 28, 2009 9:30 am

its working for some other jobs,which are loaded data into oi tables succesfully

Abhijeet1980 · Post by **Abhijeet1980** » Thu Jan 07, 2010 2:41 pm

Dr. Murthy,

During a long drive, you find that one of the tyres has become flat. Is this a problem with the tyre, the motor or the road ?

How long does the DataStage job run before the ORA-03135 error is thrown ?

Analysis on your issue depends on the above question.

Many regards,