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';
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:
- Someone accidentally shutdown the database.
- The database shuts itself down due to severe issues.
- A blackout or hardware incident makes the database server down.
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.