Re: ORA-03113 after half hour of inactivity

Sybrand Bakker wrote:

> On Thu, 29 Aug 2002 13:19:41 +0200, Pieter <ravefiend_at_hotmail.com>
> wrote:
>
> >Hi all,
> >
> >The problem I'm having is that I get an ORA-03113 after not using
> >SQL*Plus 8.0.6.0.0 or T.O.A.D. 7.3.0.0. for about half an hour or so.
> >I'm using these programs to connect to an Oracle9i database (9.0.1.3.0)
> >which is part of an Oracle e-Bussiness Suite (11.5.7) installation. On
> >my PC (W2K) I've got serveral ORACLE_HOMES, but the Primary ORACLE_HOME
> >is set to an Oracle Developer 6i patchset 9 installation.
> >
> >This problem is really frustrating since I'm using these tools everyday
> >but I can't find the cause of this. This should have something to do
> >with SQL*Net right? I hope anyone knows where I should start looking for ...
> >
> >Thanks in advance!
> >Pieter
> >
> >PS: greetings from Belgium (always nice to know from which country
> >someone is on these newsgroups right ;-)
>
> You aren't using DHCP IP addresses by any chance?
> DHCP IP address will expire after a certain amount of inactivity.
> Other things too look at are sqlnet.expire_time in sqlnet.ora on the
> server, and problems in the eventlog using the Mickeysoft provided
> event viewer.
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

And even, perhaps, an expire time in the default, or other assigned, profile. Received on Thu Aug 29 2002 - 22:40:05 CEST