// Oracle error reference

ORA-03135: connection lost contact

The client lost its connection to the database, typically after a firewall or timeout cut an idle session, or the server process ended.

Error code
ORA-03135
Category
Connection and login
Error message
connection lost contact

What it means

ORA-03135 is reported when the connection to the server is gone, often when the client next tries to use a session that a firewall, a timeout or the server silently ended while it was idle.

Common causes

  • A firewall or NAT device timing out an idle connection.
  • A profile limit such as IDLE_TIME or a server-side timeout ending the session.
  • The server process or instance stopping.

How to fix it

  1. Reconnect, and have long-lived applications validate pooled connections before use.

  2. Set SQLNET.EXPIRE_TIME (in minutes) in the server's sqlnet.ora so the database probes idle connections and firewalls see traffic.

  3. Check the user's profile for idle limits.

    SELECT p.resource_name, p.limit
    FROM dba_users u JOIN dba_profiles p ON p.profile = u.profile
    WHERE u.username = 'APP_USER' AND p.resource_name IN ('IDLE_TIME', 'CONNECT_TIME');

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.