Re: Database resets user's connections

Hi Sybrand,

I checked up the resource_limit parameter. The parameter is not present in init.ora and when I checked v$parameter, it shows the value to be false.

The problem does not occur after 8-9 hours of idle time, it happens after every 8-9 hrs irrespective of user activity.

Any new ideas ?

Rgds,
Chetan

In article <929988367.23392.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> Hi Chetan
>
> Probably resource_limit = true in init<sid>.ora and profiles have been
set
> for your users with a idle_time of 8/9 hour. This is feature you would
like
> to use, but usually can't because people start complaining: Hey, I
have been
> away to a meeting for more than one hour, and now I have to reconnect.
> The only other option is sqlnet.expire_time in sqlnet.ora, but that
defaults
> to almost infinite (2 to the powe of 32 - 1) and the unit is minutes.
> That's from the Oracle perspective, of course it could equally be the
> network or anything.
> Do your people work more than 9 hours? :)
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> chetanw_at_my-deja.com wrote in message <7kl5lb$78v$1_at_nnrp1.deja.com>...
> >Help required desperately !!
> >
> >I have an Oracle 8.0.4 db on Solaris 2.6. Everything is working fine
> >except that intermittently (ie after 8-9 hrs), a user connected to
the
> >database from my application reports error in connecting to the db.
> >
> >This does not happen all at one time, it happens across the day. On
> >restarting the application, a fresh connection is created and no
probs
> >till after another 8-9 hrs.
> >
> >Any sugestions/ideas anyone ?? Probable areas : Listener parameters,
> >idle timeouts etc etc...
> >
> >Thanks in adv,
> >Chetan
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 22 1999 - 01:18:50 CDT