Oracle startup error ORA-03113: end-of-file on communication channel

Oracle startup error ORA-03113: end-of-file on communication channel

Solution 1:

SQLplus connect as sysdba;

SQL> STARTUP MOUNT;

SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;

SQL> ALTER DATABASE OPEN RESETLOGS;

Solution 2:

SQLplus connect as sysdba;

sql > startup nomount;

sql> alter database mount;

sql> alter database clear unarchived logfile group 1;

sql> alter database clear unarchived logfile group 2;

sql> alter database clear unarchived logfile group 3;

try #4 until you dont have any more group

sql> shutdown immediate;

sql> startup;