RE: Database connections being disconnected

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Mon, 9 Feb 2015 20:09:59 -0600
Message-ID: <CAEueRAW+zB88T9-NB3WuDWDt7m7Ujo5cyAGz3eEqY9JSyvyzCg_at_mail.gmail.com>

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_at_uwsa.edu> 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_at_oracle.com]
> *Sent:* Friday, February 06, 2015 11:23 AM
> *To:* Leroy Kemnitz; oracle-l_at_freelists.org
> *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_at_uwsa.edu <lkemnitz_at_uwsa.edu>]
> *Sent:* Friday, February 06, 2015 12:21 PM
> *To:* oracle-l_at_freelists.org
> *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_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *Leroy Kemnitz
> *Sent:* Friday, February 06, 2015 11:09 AM
> *To:* oracle-l_at_freelists.org
> *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
>
>
>
>
>

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

Received on Tue Feb 10 2015 - 03:09:59 CET