Re: Oracle on Windows Server - a lil' help?
Date: Wed, 8 Oct 2008 13:50:47 -0400
On Wed, Oct 8, 2008 at 1:25 PM, Taylor, Chris David < Chris.Taylor_at_ingrambarge.com> wrote:
> Doesn't seem to work on 10.2 on Windows 2003 either :) Supposedly
> EXPIRE_TIME=1 is supposed to work, but doesn't seem to.
> *Chris Taylor*
> *Sr. Oracle DBA*
> Ingram Barge Company
> Nashville, TN 37205
> Office: 615-517-3355
> Cell: 615-354-4799
> Email: chris.taylor_at_ingrambarge.com
Server OS MS Windows 2003 R2 SP2 32 bit
Oracle 10g R2 Standard Edition, 10.2.0.4 patchset, 32 bit. No one-off patches.
sqlnet.ora for the server:
This in fact does enable the timer functionality for dead connection
It does not work for values such as sqlnet.expire_time=10 that is referred to in the metalink documentation.
If you set the trc_level = support you will be able to observe the timer being set in the trace file.
Do you have the 10.2.0.4 patchset in place on the database server on the ORACLE_HOME of interest, including the ORACLE_HOME for the listener, if it runs out of a different home than the database instance of interest?
> *From:* Niall Litchfield [mailto:niall.litchfield_at_gmail.com]
> *Sent:* Wednesday, October 08, 2008 12:18 PM
> *To:* Taylor, Chris David
> *Cc:* ORACLE-L
> *Subject:* Re: Oracle on Windows Server - a lil' help?
> SQLNET.EXPIRE_TIME didn't work on older versions of Oracle on windows - I
> think 9.2 fixed it, but it may have been 10.1.
> On Wed, Oct 8, 2008 at 3:22 PM, Taylor, Chris David <
> Chris.Taylor_at_ingrambarge.com> wrote:
>> Guys & Gals,
>> I've got a situation where Oracle doesn't recognize disconnected apps on
>> Windows 2003 server. Every time a machine reboots or power goes out, or
>> users terminate an app, it leaves the session connected to the db, eating up
>> our available processes (500).
>> I've check the SQLNET.ORA EXPIRE_TIME parameter and that doesn't seem to
>> resolve the issue.
>> I think there are some TCP parameters on the db server itself that need to
>> be adjusted? Has anyone run into this and successfully corrected it?
>> Any good documents you would like to share? I think I have the Metalink
>> document on tuning windows servers for Oracle databases...going to try to
>> dig it back up.
>> *Chris Taylor*
>> *Sr. Oracle DBA*
>> Ingram Barge Company
>> Nashville, TN 37205
>> Office: 615-517-3355
>> Cell: 615-354-4799
>> Email: chris.taylor_at_ingrambarge.com
> Niall Litchfield
> Oracle DBA
-- http://www.completestreets.org/faq.html http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 08 2008 - 12:50:47 CDT