DSXchange

Posted: **Thu Jul 19, 2007 1:27 pm**

I have been getting ORA-3113 connection errors which aborts my job and it seems to be happening during commits. I have increased the rows per transaction in hopes that more frequent commits would help me get out of this mode. However I am still getting the 3113's and wondering if there is a timeout / session parameter in datastage that could be set so that I don't loose my connection for long running commits. Or at least that is what I'm assuming is happening.

Thanks.

Posted: **Thu Jul 19, 2007 3:17 pm**

Type in oerr ORA 3113 to find out other possible remedies. Involve your Oracle DBA and network administrator. Increasing rows/transaction is not likely to make much difference if the problem is network dropouts.

Posted: **Thu Jul 19, 2007 6:24 pm**

Yah, I loves me that utility:

Code: Select all

$ oerr ORA 3113
03113, 00000, "end-of-file on communication channel"
// *Cause:
// *Action:
$

DSXchange

Ora-3113 error during a commit

Ora-3113 error during a commit