Re: ORA-03113 after half hour of inactivity

[Quoted] 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 Received on Thu Aug 29 2002 - 21:18:36 CEST