Fix for ORA-03113 end-of-file on communication channel while starting Oracle database

Fix for ORA-03113 end-of-file on communication channel while starting Oracle database

While Starting database we are getting End-of-file error.

Error:

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Database mounted.

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

Process ID: 4903

Session ID: 237 Serial number: 26032

Solution:

Exit from previous SQLPLUS session and connect to new  session

[oracle@zeus ~]$ sqlplus / as sysdba

Connected to an idle instance.

SQL> startup nomount

ORACLE instance started.

SQL> alter database mount;

Database altered.

Clean unarchived logfiles.

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> alter database clear unarchived logfile group 2;

Database altered.

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Database mounted.

Database opened.

SQL>

If you like please follow and comment