How to fix for ORA-03113: end-of-file on communication channel

How to fix the issue ORA-03113: end-of-file on communication channel for Oracle Database Server 12c
When I shutdown immediate command in a running database instance. The database was busy and it took time to shut it down. So I kill the process for virtual machine server. After virtual machine restart, the database did not start any more, throwing ORA-03113 error.

[oracle@host ~]$ sqlplus / as sysdba
...
...
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2147483648 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 4323
Session ID: 2232 Serial number: 26232

Solution

[oracle@zeus ~]$ sqlplus / as sysdba
...
...
Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 2147483648 bytes

SQL> alter database mount;

Database altered.

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.

Total System Global Area 2147483648 bytes

Database mounted.
Database opened.
SQL>

Leave a Reply

Your email address will not be published. Required fields are marked *