ora-03113 end-of-file on communication channel

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 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

  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