How to Resolve ORA-03113: end-of-file on communication channel

  • by

ORA-03113

Found ORA-03113 when we try to operate with the database. Let's see the case.

First of all, we perform a query, the database response is fine.

SQL> select first_name from employees where last_name = 'Chen';

FIRST_NAME
--------------------
John

But when we tried to update the row, it failed.

SQL> update employees set first_name = 'Ed' where last_name = 'Chen';
update employees set first_name = 'Ed' where last_name = 'Chen'
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 2283
Session ID: 1725 Serial number: 52573

ORA-03113 means that the connected database is no more accessible at this moment. You should check the status of the target database. Mostly, it's down.

The possible causes are:

If you're using a database link, you should check the remote database. However, I suggest that you should know why the target database is down before bringing it up.

Leave a Reply

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