Oracle error during load.

seanc217 · Post by **seanc217** » Fri Jul 21, 2006 11:53 am

I am loading data into an Oracle database. When I get to the end of the load I get an error as such...

Ciramst_to_Oracle,0: GenericQuery:esqlErrorHandler
Prepare failed for: GenericStmt_7
query is: SELECT banner FROM V$VERSION
sqlcode is: -3135
esql complaint: ORA-03135: connection lost contact

I am trying to determine if this is because of DataStage or is this a network issue. I think I know the answer, I just wanted to see if anyone else has dealt with this.

TIA

splayer · Post by **splayer** » Fri Jul 21, 2006 2:10 pm

Looks very much like an Oracle error to me. Please let us know what you find out.

DSguru2B · Post by **DSguru2B** » Fri Jul 21, 2006 8:24 pm

Its a database error. Google 'ORA-03135' and you will get to the core of the problem.
Regards,

ray.wurlod · Post by **ray.wurlod** » Sat Jul 22, 2006 12:35 am

This can be really simple - bumped into one yesterday, failing to connect to Oracle in a different time zone, where they were doing the database backups, so had quiesced the database. Or it can be complex. Ultimately you have to discern why something is timing out.