- 18 Jan, 2020
- 0 Comments
- 28 Secs Read
ora-03113 end-of-file on communication channel
This is common error which will occur on oracle database.
ora-03113 end-of-file on communication channel
Following are the reason to get the error
- Database goes down abruptly
- Server goes down and there is no communication with server
Solutions
- Check the alert log file. reason can be anything and accordingly you need to act
- If you forcefully shutdwn the database and not able to start then follow the below steps.
- sqlplus / as sysdba
- startup nomount
- alter database clear unarchived logfile group 1;
- alter database clear unarchived logfile group 2;
- alter database clear unarchived logfile group 3;
- shutdown immediate
- startup
#ora-03113