2 Replies Latest reply: Aug 11, 2011 7:46 PM by sb92075 RSS

    ORA-03135: connection lost contact

    868145
      Hi,

      I got a :


      SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 11 15:34:11 2011

      Copyright (c) 1982, 2010, Oracle. All rights reserved.

      ERROR:
      ORA-03135: connection lost contact
      Process ID: 0
      Session ID: 0 Serial number: 0


      Client Environment: Redhat Enterprise linux 5 (Not on same network as server)
      Server Environment: Redhat Enterprise linux 5 (On a separate network)

      *****I've run the windows client (Not on same network as server) as well and I didn't have any problems*****
      But I need this client to work on linux as well.
      I know the database is running because on machines within the same network as the server, I am able to access and use the database with no problems.

      I'm guessing there are some TCP parameters that I may need to set in linux? I've these timeout parameters on the server side:

      SQLNET.INBOUND.CONNECT_TIMEOUT = 300
      SQLNET.SEND_TIMEOUT = 300
      SQLNET.RECV_TIMEOUT = 300
      SQLNET.EXPIRE_TIME = 10
      ADR_BASE = /opt/app/oracle
      TRACE_LEVEL_SERVER = 16


      On the client I've tried:
      TRACE_DIRECTORY_CLIENT=/tmp/oracle
      TRACE_LEVEL_CLIENT=16
      TRACE_FILE_CLIENT=trace.out
      SQLNET.OUTBOUND_CONNECT_TIMEOUT=60
      TCP.CONNECT_TIMEOUT=60


      but get the same results.
      When I look at the server/client trace files, I can see the client actually has made a connection and the server rececieves some data
      (although I don't know what that data is) is then when the connection is lost.

      I don't think it's a firewall because as I said, my windows machine can do this.

      I'm my server is oracle 11g R2.

      Thanks,