Wednesday 12 April 2017

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

Error:

SQL> startup;
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  2932632 bytes
Variable Size             335544424 bytes
Database Buffers          729808896 bytes
Redo Buffers                5455872 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 7900
Session ID: 1 Serial number: 63172

Cause:

The connection between Client and Server process was broken

Solution:

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  2932632 bytes
Variable Size             335544424 bytes
Database Buffers          729808896 bytes
Redo Buffers                5455872 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 1073741824 bytes
Fixed Size                  2932632 bytes
Variable Size             335544424 bytes
Database Buffers          729808896 bytes
Redo Buffers                5455872 bytes
Database mounted.
Database opened.


**************Database Opened****************

No comments: