// Oracle error reference

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
Error message
end-of-file on communication channel

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

  1. Check the alert log and trace files on the server for errors at the time of the disconnect. The V$DIAG_INFO view shows where they are.

    SELECT name, value FROM v$diag_info;
  2. 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.

  3. For idle disconnects, enable dead connection detection with SQLNET.EXPIRE_TIME in the server's sqlnet.ora, or keep connections from sitting idle behind firewalls.

Related errors

More connection and login errors

The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.

// fewer errors, faster fixes

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.