This discussion is archived
2 Replies Latest reply: Aug 11, 2011 5:46 PM by sb92075 RSS

ORA-03135: connection lost contact

868145 Newbie
Currently Being Moderated
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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points