Tuesday, July 9, 2019

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

SHARE

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


Many Oracle admin or developers have many problems and issue when they work with oracle and one of the most problem is ORA-03113: end-of-file on communication channel.

This problem common and many admins need a solution for it ORA-03113: end-of-file on communication channel.

In this Article i will solve this issue and i success to fix ORA-03113: end-of-file on communication channel problem.




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


First of all you need to access you cmd and enter admin privilege to access sqlplus  with below command:
sqlplus / as sysdba

Then it will open and do the following as below:-

SQL> startup

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

Total System Global Area 2.6741E+10 bytes
Fixed Size 2277570 bytes
Variable Size 1.3570E+10 bytes
Database Buffers 1.30524E+10 bytes
Redo Buffers 13332520 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 10092736
Session ID: 571 Serial number: 3

Now the problem ORA-03113 end-of-file happened as above and now go to the fix as below:-


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.


Finally Database open as you see and the problem ORA-03113: end-of-file on communication channel is solved successfully.

If you need any help please don't hesitate to contact us and I'm happy to help you.
SHARE

Author: verified_user

0 comments: