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
Oracle error during load.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.