RE: Oracle on Windows Server - a lil' help?
- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
- To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- Date: Wed, 8 Oct 2008 12:25:06 -0500
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@xxxxxxxxxxxxxxx
________________________________
From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx]
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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
