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
- 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
Thanks for visiting this post. Please contact us if you are looking for training.
Subscribe to our channel for unlimited learning. Thank you!!!