Re: ORA-03113: end-of-file on communication channel --- what causes it??

In general:

ora-3113 indicates an unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Oracle Networking components. This message could occur if the shadow two-task process associated with an Oracle Networking connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.

There are numerous causes of this error. It is a 'catch all' type error which means 'I cannot communicate with the oracle shadow process'. This usually occurs when the Oracle server process has died for some reason. A lot of factors can result in an ora-3113. It all comes down to the fact that the client went out to read some information from the server and suddenly found out the connection was no longer there.

Ensure that there is space in the USER_DUMP_DEST and the BACKGROUND_DUMP_DEST. Disable the Oracle Parallel Server if that is running. Disable the MTS if that is being used.
Relink 'oracle' executable and try again.

If problem still persist, try turning on tracing to level 16 to get more information and possible cause of error.

If you couldn't get the resolution better contact Oracle Tech Support and get it fixed.

Thanks and Regards
Varatha.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!