drop connection - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 5 FirstFirst 1234 ... LastLast
Results 11 to 20 of 43

Thread: drop connection

  1. #11
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  2. #12
    Join Date
    Dec 2000
    Posts
    62
    if session stays idle for 45 mins it drops exactally after 45 mins

  3. #13
    Join Date
    Jan 2001
    Posts
    3,131
    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.

  4. #14
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I'm betting this is a firewall issue, unless of course the Oracle profile says to kill the connection after 45 idle minutes.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #15
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  6. #16
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #17
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  8. #18
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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

  9. #19
    Join Date
    Jan 2001
    Posts
    3,131
    Since when are Oracle errors and the exact cause of a problem an exact science?



    MH
    I remember when this place was cool.

  10. #20
    Join Date
    Dec 2000
    Posts
    62
    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
  •  



Click Here to Expand Forum to Full Width