If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

3113 is extremely hard to trace. Could be anything. Even if you open an iTar with Oracle, you might not get the answer to "Why?". But I suggest you open the iTar and upload the trace files and let them think :-)

ORA-3113 "end-of-file on communication channel" is a catch-all error message which simply means that the foreground oracle client process (svrmgrl, sqlplus, RMAN, Oracle Forms etc.) has lost contact with its background shadow process.

Unfortunately there are many causes of this. Network glitches were clearly the cause that the Oracle developers had in mind when they phrased the
error message, but anything which causes the shadow process to crash will cause this error to be reported.

This message may also be accompanied by other messages, either displayed on the screen or in log files. If the background process which has crashed
is one of the essential Oracle servers processes (PMON, SMON, DBWR etc.) you may also get an ORA-1034 ORACLE not available error
message. Looking in the alert log or looking through any trace files in your background_dump_dest may help diagnose the problem.

Common causes are:

Incompatible values of the init.ora parameter processes and the kernel shared memory and semaphore parameters

This is a very frequent cause because the default installation of Oracle sets up incompatible values!

Oracle executables need relinking

shared_pool_size too small.

timed_statistics=true.

This is probably version and path-level specific. But at least one version of Oracle benefits drom switching off timed_statistics.

a datafile extended over 2Gb in size.

Create table as select .... where there was an invalid procedure or function called from a trigger defined on the table we were selecting from.

Lot of time I have received this error,some times the network problem,some times shared pool size proble.So please check your environment everything is ok.