Home » RDBMS Server » Networking and Gateways » ORA-03113 after half hour of inactivity
ORA-03113 after half hour of inactivity [message #66611] Wed, 28 August 2002 22:09 Go to next message
Messages: 6
Registered: August 2002
Junior Member
Hi all,

The problem I'm having is that I get an ORA-03113 after not using SQL*Plus or T.O.A.D. for about half an hour or so. I'm using these programs to connect to an Oracle9i database ( 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!

PS: greetings from Belgium (always nice to know from which country someone is on these msgboards right ;-)
Re: ORA-03113 after half hour of inactivity [message #66693 is a reply to message #66611] Mon, 28 October 2002 09:05 Go to previous message
Messages: 1
Registered: October 2002
Junior Member
Check your sqlnet.ora parameter
sqlnet.expire_time = 10

Also if you using a firewall, contact the firewall admin to see if a there is network idle time_out setting.

Ramanarao Chamarty
Previous Topic: Re: Listener trivial question
Next Topic: accessing Oracle from a Sun machine
Goto Forum:

Current Time: Thu Feb 29 15:09:11 CST 2024