RE: Database connections being disconnected
- From: Seth Miller <sethmiller.sm@xxxxxxxxx>
- To: lkemnitz@xxxxxxxx
- Date: Mon, 9 Feb 2015 20:09:59 -0600
You should also check the profile assigned to that user. There is an idle
timeout there as well.
Seth Miller
On Feb 6, 2015 11:32 AM, "Leroy Kemnitz" <lkemnitz@xxxxxxxx> wrote:
> 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 <lkemnitz@xxxxxxxx>]
> *Sent:* Friday, February 06, 2015 12:21 PM
> *To:* 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 <oracle-l-bounce@xxxxxxxxxxxxx>] *On
> Behalf Of *Leroy Kemnitz
> *Sent:* Friday, February 06, 2015 11:09 AM
> *To:* 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:
