Re: Oracle on Windows Server - a lil' help?

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
>

Chris,

Environment:
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:
sqlnet.expire_time=1

This in fact does enable the timer functionality for dead connection detection.
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?

hth.

Paul

> <chris.taylor_at_ingrambarge.com>
>
>
> ------------------------------
> *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.
>>
>> Thanks!!
>>
>> *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.orawin.info
>

-- 
http://www.completestreets.org/faq.html
http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf

--
http://www.freelists.org/webpage/oracle-l