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?

Kurt-Erich.Finger@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

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@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