-
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?
-
if session stays idle for 45 mins it drops exactally after 45 mins
-
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
I remember when this place was cool.
-
I'm betting this is a firewall issue, unless of course the Oracle profile says to kill the connection after 45 idle minutes.
-
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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.
-
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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?
I'm stmontgo and I approve of this message
-
Since when are Oracle errors and the exact cause of a problem an exact science?
MH
I remember when this place was cool.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|