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

  1. Database goes down abruptly
  2. Server goes down and there is no communication with server

Solutions

  1. Check the alert log file. reason can be anything and accordingly you need to act
  2. 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

Thanks for visiting this post. Please contact us if you are looking for training.
Subscribe to our channel for unlimited learning. Thank you!!!

Share and Enjoy !

0Shares
0 0 0

Recommended For You

ankushthavali

About the Author: ankushthavali

Leave a Reply

Your email address will not be published. Required fields are marked *