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
Pieter
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 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 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
R.Chamarty
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
rchamart@temple.edu
Previous Topic: Re: Listener trivial question
Next Topic: accessing Oracle from a Sun machine
Goto Forum:
  


Current Time: Fri Apr 19 05:39:33 CDT 2024