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.
5*
Excellent Job
Good solution worked for me
This solution worked!!
Thank You.
Thanks a lot worked for me
same error is coming after follow these steps
I Try several time but not db opened, now trying to restart server machine.
Thanks, worked for me.
Thank you!! it worked for me