drop connection

[slimdave]

Originally posted by mehak
Mr.Hanky
sql sessions drops after 45 mins.i checked that already

Is it always after exactly 45 minutes? Is that 45 minutes since connection established, or 45 minutes after connection goes idle?

[mehak]

if session stays idle for 45 mins it drops exactally after 45 mins

[Mr.Hanky]

Originally posted by mehak
if session stays idle for 45 mins it drops exactally after 45 mins

That rules out a network problem. You did this locally, correct?

What algorhythms are out there that will kill idle sessions after XX minutes?

MH

[slimdave]

I'm betting this is a firewall issue, unless of course the Oracle profile says to kill the connection after 45 idle minutes.

[abhaysk]

Originally posted by Mr.Hanky
You did this locally, correct?

What algorhythms are out there that will kill idle sessions after XX minutes?

MH

Might ther be any algorithm developed to kill idle seession after 45 mins, but this reasoning for the above ora - err seems no relevence..

If Session is killed u get an Error "ORA-00028: your session has been killed"..but hez getting "ORA-02068"...so its suerly related to N/W issues..

Abhay.

[slimdave]

Originally posted by abhaysk
If Session is killed u get an Error "ORA-00028: your session has been killed"..but hez getting "ORA-02068"...so its suerly related to N/W issues..

It's not that simple, I think. The 2068 error refers to losing a connection needed for a database link.

[abhaysk]

Originally posted by slimdave
It's not that simple, I think. The 2068 error refers to losing a connection needed for a database link.

I really meant the error ORA-03113 end-of-file on communication channel
and 2068 was jus in a hurry to copy paste from above/original post...

Well 03113 also states if any session being killed/disconnected immediate this error can be seen, but to my notice i never had Ora 03113 when session is even killed immediate..

Most likely cause is the N/W..for this kinda errors..

Abhay.

[stmontgo]

have you thought to involve the network admin and have them check the logs/events on the firewall and or the switch in front of the firewall?

[Mr.Hanky]

Since when are Oracle errors and the exact cause of a problem an exact science?



MH

[mehak]

yeah i checked with Network team according to them problem is without question revolving around the Oracle software or its interaction with the Windows Operating System.