Re: Database resets user's connections

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.
Received on Mon Jun 21 1999 - 13:07:13 CDT