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]

Hi,

There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

Regards,

Ganesh

****Reward points if Helpful*****

[Former Member · Accepted solution]

Dear Ganesh,

Thanks for ur response. An extract of alert file is as below :

root@bssltests # pwd

/oracle/PRD/102_64/rdbms/log

root@bssltests # ls -l

total 62

-rw-r----- 1 oraprd dba 29887 Jul 30 13:00 alert_PRD.log

-rw-r----- 1 oraprd dba 116 May 21 19:34 dp.log

root@bssltests # more alert_PRD.log

*****

Adjusting the default value of parameter parallel_max_servers

from 640 to 75 due to the value of parameter processes (90)

Mon Jul 30 11:28:28 2007

Adjusting the default value of parameter parallel_max_servers

from 640 to 75 due to the value of parameter processes (90)

Mon Jul 30 11:29:50 2007

Adjusting the default value of parameter parallel_max_servers

from 640 to 75 due to the value of parameter processes (90)

Mon Jul 30 11:39:20 2007

Adjusting the default value of parameter parallel_max_servers

from 640 to 75 due to the value of parameter processes (90)

Mon Jul 30 11:59:33 2007

Adjusting the default value of parameter parallel_max_servers

from 640 to 75 due to the value of parameter processes (90)

Mon Jul 30 12:47:44 2007

Adjusting the default value of parameter parallel_max_servers

from 640 to 75 due to the value of parameter processes (90)

Mon Jul 30 13:00:42 2007

Adjusting the default value of parameter parallel_max_servers

from 640 to 75 due to the value of parameter processes (90)

***************

Wat shd i do now?

Regards,

Ankita

[Former Member · Accepted solution]

Hi Ankita,

Refere OSS Note 619172. This may solve your issue.

Regards,

Ganesh

****Reward points if Helpful*****

[Former Member · Accepted solution]

Hello,

Now i am geting below error .....wat shd i do?

******************************ORACLE START****************

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-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'

SQL> recover datafile '/oracle/PRD/sapdata1/system_1/system.data1'

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile until cancel;

ORA-00283: recovery session canceled due to errors

ORA-01201: file 4 header failed to write correctly

*************************

Regards,

Ankita.

[Former Member · Accepted solution]

Hi Ankita,

Refer thread below thread. May be useful.

Regards,

Ganesh

****Reward points if Helpful*****