ORA-03113: end-of-file on communication channel

[Former Member]

Dear All,

Actually i have upgraded from SAP 4.7 to ECC 6 ondemo server with hostname "bssltests" but now i want to do a full system copy on a new server.

OS - Sun Solaris 10

Oracle - 10.2

But now after full system replica ....its giving me below error in Oracle startup.

SQL> connect /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 3355443200 bytes

Fixed Size 2029624 bytes

Variable Size 1792387016 bytes

Database Buffers 1546280960 bytes

Redo Buffers 14745600 bytes

Database mounted.

ORA-03113: end-of-file on communication channel

PLEASE HELP ME on how to resolve this error. everythinsg is ok on current demo server but error is coming on new system

If you need anymore details then pls tell me ...

Regards & Thanks,

Ankita.

[Former Member · Accepted solution]

have a look in to the database alert file under

/oracle/SID/saptrace/background

you may find more information there.

peter

[Former Member]

There is a DB corruption.

619172 - ORA-03113 on entering the NOMOUNT phase

370278 - ORA-3113 when starting SQLPLUS or SVRMGRL

The ora 3113 means,that the client process got disconnected from its

equivalent shadow process. It could be caused by:

-Network problems which lead the connection to break, which you've

already checked.

-The shadow process got killed for any reason.

-The statement that is executed is running into a resource problem when

being executed or when the optimal execution plan is found this might b

caused by a incorrect parameter setting.

-The table, on which you are having the problem is having corruptions.

-There is a bug in the oracle-release you are currently running on.335199 check this note as well.

Please post all ur trace files to look at the issue more deeply.

Thanks

Subbu