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>

Discover more from PlusDigit

Subscribe to get the latest posts sent to your email.

Discover more from PlusDigit

Subscribe now to keep reading and get access to the full archive.

Continue reading

AdBlock Detected!

Please disable your AdBlocker to access this website.

Once disabled, this message will disappear automatically.