Ora-3113 error during a commit

sabrewster · Post by **sabrewster** » 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.

ray.wurlod · Post by **ray.wurlod** » 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.

chulett · Post by **chulett** » 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:
$