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

Thread: drop connection

Hybrid View

  1. #1
    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

  2. #2
    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"

  3. #3
    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

  4. #4
    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?

  5. #5
    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

  6. #6
    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

  7. #7
    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.

  8. #8
    Join Date
    Jan 2001
    Posts
    3,131
    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 12:22 PM.
    I remember when this place was cool.

  9. #9
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    who is your firewall vendor?
    I'm stmontgo and I approve of this message

  10. #10
    Join Date
    Dec 2000
    Posts
    62
    Mr.Hanky
    sql sessions drops after 45 mins.i checked that already

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