how to Fix ORA-03113 end-of-file on communication channel

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

This article explains how we can fix ORA-03113 end-of-file on communication channel:

Observation of Problem:
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2.6591E+10 bytes
Fixed Size 2233960 bytes
Variable Size 1.3489E+10 bytes
Database Buffers 1.3086E+10 bytes
Redo Buffers 13332480 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 10092736
Session ID: 571 Serial number: 3

SOLUTION : Follow below steps:

SQL> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 24 12:13:09 2016

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

Connected to an idle instance.

SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2.6591E+10 bytes
Fixed Size 2233960 bytes
Variable Size 1.3489E+10 bytes
Database Buffers 1.3086E+10 bytes
Redo Buffers 13332480 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
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2.6591E+10 bytes
Fixed Size 2233960 bytes
Variable Size 1.3489E+10 bytes
Database Buffers 1.3086E+10 bytes
Redo Buffers 13332480 bytes
Database mounted.
Database opened.
SQL>

Database opened !!!

Note: Don’t try in production and try only if you can clear Unarchived log files.

8 Comments

Leave a Reply

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