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 = 'Rowe';
FIRST_NAME
--------------------
John
But when we tried to update a row, it failed with ORA-03113.
SQL> update employees set first_name = 'Scott' where last_name = 'Rowe';
update employees set first_name = 'Scott' where last_name = 'Rowe'
*
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:
- Someone killed your session, therefore, your server process disappeared from the database server.
- Someone accidentally shutdown the database, all server processes were gone.
- The database shuts itself down due to severe issues.
- A blackout or hardware incident makes the database server down.
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.