ORA-03113: end-of-file on communication channel
The connection to the database ended unexpectedly: the server process died, the instance went down, or the network dropped the connection.
- Error code
ORA-03113- Category
- Connection and login
What it means
ORA-03113 means the client was talking to its server process and the connection closed without warning. It is a symptom; the cause is on the server or the network. If the server process crashed, the database alert log and trace files usually show an ORA-00600 or ORA-07445 at the same moment.
Common causes
- The server process serving the session crashed, often logged as ORA-00600 or ORA-07445.
- The instance was shut down or crashed.
- A firewall or load balancer dropped an idle connection.
- The session was killed by an administrator or resource limit.
How to fix it
-
Check the alert log and trace files on the server for errors at the time of the disconnect. The
V$DIAG_INFOview shows where they are.SELECT name, value FROM v$diag_info;
-
Reconnect. If the same statement kills the connection each time, it has hit a server bug; search My Oracle Support for the ORA-00600 arguments.
-
For idle disconnects, enable dead connection detection with
SQLNET.EXPIRE_TIMEin the server'ssqlnet.ora, or keep connections from sitting idle behind firewalls.
Related errors
ORA-03135connection lost contactORA-12170TNS: connect timeout occurred2013MySQL: Lost connection to MySQL server during query2006MySQL: MySQL server has gone away08006PostgreSQL: connection failure
More connection and login errors
ORA-01017invalid username/password; logon deniedORA-12154TNS: could not resolve the connect identifierORA-12514TNS: listener doesn't know the requested serviceORA-12505TNS: listener doesn't know the SIDORA-12541TNS: no listenerORA-28000the account is lockedORA-28001the password has expiredORA-01034ORACLE not available
The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.
Work on Oracle in SQLly
A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.