DBAsupport.com Forums - Powered by vBulletin
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 43

Thread: drop connection

  1. 02-05-2004, 11:30 AM #1
    mehak
    mehak is offline Junior Member
    Join Date
    Dec 2000
    Posts
    62

    drop connection

    windows 2000.8.1.6.

    Our production database drops connection from 30minutes to 6 hours without any reason . One of our DBA
    already tested out the connection in DMZ area and found out connection drops
    periodically. We need to fix this issue as soon as possible. Following are the two error messages occurs when try to connect to the
    outside server.
    ORA-02068: following severe error from OPSWEB ORA-03113: end-of-file on
    communication channel
    Or
    ORA-02068: following severe error from OPSWEB ORA-03114: not connected to
    ORACLE
    Reply With Quote Reply With Quote
  2. 02-05-2004, 11:40 AM #2
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    disrupts in N/W can cause this err
    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"
    Reply With Quote Reply With Quote
  3. 02-05-2004, 12:09 PM #3
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You going through a firewall? Have you configured SQLNET.EXPIRE_TIME?
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE
    Reply With Quote Reply With Quote
  4. 02-05-2004, 12:24 PM #4
    mehak
    mehak is offline Junior Member
    Join Date
    Dec 2000
    Posts
    62
    yes i am . i already tried configuring the SQLNET.EXPIRE_TIME . conncetion still droped

    You going through a firewall? Have you configured SQLNET.EXPIRE_TIME?
    Reply With Quote Reply With Quote
  5. 02-05-2004, 12:40 PM #5
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Anything interesting in the alert log, or listener log? Any trace files being generated?
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE
    Reply With Quote Reply With Quote
  6. 02-05-2004, 12:42 PM #6
    Cookies
    Cookies is offline Member
    Join Date
    Oct 2002
    Posts
    182
    I found a similar situation when going through a firewall.
    The connection would disconnect only when idle for a certain amount of time. It was definitely not on the server or database side, but had to do with the firewall configs.

    Once we moved the server inside the firewall the disconnects dissapeared.
    - Cookies
    Reply With Quote Reply With Quote
  7. 02-05-2004, 12:59 PM #7
    mehak
    mehak is offline Junior Member
    Join Date
    Dec 2000
    Posts
    62
    No nothing at all. It's been going on for past several months now . I opened TAR with Oracle but they are insisting this is network issue and our net work team insisting oracle issue. I m figuring it out how should I resolve this.
    Reply With Quote Reply With Quote
  8. 02-05-2004, 01:20 PM #8
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    Open a SQL session locally (on the server) see if that gets disconnected. If it does than you have ruled out most networking possibilities. If it does not than you have some proof to support your networking theory.

    Also, if the times are random I doubt there is a procedure in place that causes this. Come to think of it I do not know of a way to terminate sessions after X time.

    MH
    Last edited by Mr.Hanky; 02-05-2004 at 01:22 PM.
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  9. 02-05-2004, 02:35 PM #9
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    who is your firewall vendor?
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
  10. 02-05-2004, 02:57 PM #10
    mehak
    mehak is offline Junior Member
    Join Date
    Dec 2000
    Posts
    62
    Mr.Hanky
    sql sessions drops after 45 mins.i checked that already
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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