Did you set it on client side as well?
My apparent problem is that my server is not sending DCD probe packets to my client even though SQLNET.EXPIRE_TIME=1 in $OH/network/admin/sqlnet.ora.
Oracle server is 10.1.0.5.0 on Red Hat EL release 3 Oracle client is 10.2.0.1.0 on Fedora Core release 3
Between client and server is a router which is deliberately configured to close any connection which is idle for longer than a configured length of time (presently 70 seconds, although this is negotiable).
To keep the connection open by ensuring there was activity on the connection every 60 seconds I added the following lines to $OH/network/admin/sqlnet.ora:
SQLNET.EXPIRE_TIME=1 TRACE_LEVEL_SERVER=16 TRACE_DIRECTORY_SERVER=/home/oracle
Trace files started to appear in /home/oracle. Most, but not all, contained a line like:
[13-OCT-2006 21:29:44:296] niotns: Enabling dead connection detection (1 min)
and lines like
[13-OCT-2006 21:29:44:309] nstimini: entry [13-OCT-2006 21:29:44:309] nstimig: entry [13-OCT-2006 21:29:44:309] nstimig: normal exit [13-OCT-2006 21:29:44:309] nstimini: initializing LTM in asynchronous mode [13-OCT-2006 21:29:44:309] nstimini: normal exit [13-OCT-2006 21:29:44:309] nstimstart: entry
Which are described in Note 151972.1 "Dead Connection Detection (DCD) Explained" as evidence that DCD is enabled. The trace files without these lines were very short.
I opened a connection to the server from the client (which was otherwise idle) using a Oracle DBI script that did nothing but log in and sleep at the client. Our network admin monitoring the router could see the connection appear between the client host and port 1521 of the server host and the 70-second clock start to tick. It counted down to 0 without resetting, from which I infer that no DCD probe packets were sent from the server to the client. Is this inference reasonable? If it is, does anyone know why the DCD probe packets weren't sent?
Thanks in advance,
-- Best regards, Alex Gorbachev
The Pythian Group Sr. Oracle DBA
http://www.pythian.com/blogs/author/alex/ http://blog.oracloid.com -- http://www.freelists.org/webpage/oracle-l