Re: Connection timeout

The timeout occurs when I don't use the connection for a longer time. (one or two hours). TOAD then kicks me out reporting an ORA-03113. Connecting to the database is not the problem. If the connection is idle for some hours I am kicked out.
According to our guy responsible for the network nothing was changed in the last months.

I think the problem occured after I followed some security advices from Oracle. I forgot which. I only know that together with some other updates Oracle supplied the program "checkpwd" together with a 17mbyte file of passwords to be checked.
I tried to find that document on metalink, but was not successfull.

sybrandb schrieb:

> Kurt-Erich.Finger_at_hte-company.de wrote:
> > 10.1.0.4.0 Standard version on Debian
> > patched 'til CUPJuly2006
> >
> > I get a connection timeouts when I am connected to the database via
> > TOAD and also using Putty and SQLPlus (the operating system on the
> > client is XP) after some hours.
> > I think this occurred after checking the system for vulnarabilities
> > according to the Oracle warning this spring. I don't recall the
> > document anymore.
> > Before I was connected to the database undefinitely.
> >
> > I checked the profiles on the database and the sqlnet.ora file on the
> > server.
> > I found no entries that would set timeout, idle_time or somthing like
> > that.
> >
> > Somebody has clue what could lead to my timeouts?
>
>
> 'Connection timeout' is vague, as it can mean multiple error messages.
> Does your 'connection timeout' has an error message?
> Before assuming it is 'naturally'Oracle, did you verify any network
> related problems, by running traceroute and/or ping commands, or
> netstat?
> Was anything changed in the network the last few months?
> I remember I couldn't connect to the network once, because the cleaners
> pulled the network cable from my system during vacuum cleaning my room.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Wed Oct 04 2006 - 03:08:10 CDT