RE: Database connections being disconnected

  • From: Leroy Kemnitz <lkemnitz@xxxxxxxx>
  • To: Jeff Smith <jeff.d.smith@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 6 Feb 2015 17:31:58 +0000

The RESOURCE_MANAGER_PLAN parm in the database is not set to any value.  I 
didn't setup any resource plans, unless some are created by default at install.



LeRoy

From: Jeff Smith [mailto:jeff.d.smith@xxxxxxxxxx]
Sent: Friday, February 06, 2015 11:23 AM
To: Leroy Kemnitz; oracle-l@xxxxxxxxxxxxx
Subject: RE: Database connections being disconnected

Make sure it's not the database kicking you out based on a resource consumer 
group plan

From: Leroy Kemnitz [mailto:lkemnitz@xxxxxxxx]
Sent: Friday, February 06, 2015 12:21 PM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: RE: Database connections being disconnected

Oops - missed a word.

My firewall guys tell me that the firewall is open and time outs are not set.


LeRoy

From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Leroy Kemnitz
Sent: Friday, February 06, 2015 11:09 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Database connections being disconnected

All -

I have been having problems with database connections being 'reset'.  I am 
using SQL Dev 4.0 to connect to Oracle 11.2.0.3.

I have the SQLNET.EXPIRE_TIME = 0 in the sqlnet.ora.  My firewall guys tell me 
that the firewall is open and time outs are set.  This is occurring in dev but 
not in prod - so apparently I set something wrong in dev - but I can't find it.

I have been searching thru Oracle support but no answers yet.  Anyone else have 
the same issue?  I am running out of ideas of what to check.


LeRoy


Other related posts: