Skip to content

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 performed a query, meanwhile, the database response was fine.

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

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

But when we tried to update a row, it failed with ORA-03113.

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. Most likely, it's down.

Furthermore, the server process was gone or killed, which is a process that handles the requests of user in the database server.

The possible causes are:

Clients may have never known what's going on. No matter the database is down or session is lost, for external connections, the cause is that the server process is vanished.

For local database connections, if the symptom is the same, the error code become ORA-03135: connection lost contact.

Leave a Reply

Your email address will not be published.