Blog

Today in this article, we will discuss how to resolve if you encounter ORA-03113 error. Let’s go through this in detail.

Problem :

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 80836
Session ID: 497 Serial number: 53931

Solution:

Below are cases that may arise :

1. Check from the alert log if the FRA got filled up, that is why can’t open the database. Then follow as below :

• startup mount;
• Increase the FRA and additional 2G so that it can’t be 100% filled otherwise, it will not start.
• alter database open.

2. Archive filesystem may got full. Move some arcs to another and then start up and then run crosscheck archive so that the backup may run smoothly.

Also, you can check out Oracle Doc for further reference.

Our Other Articles :

ORA-00020: maximum number of processes exceeded