User's lost connection with our Oracle Server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: User's lost connection with our Oracle Server

  1. #1
    Join Date
    Jun 2002
    Posts
    11

    Question

    Hi,several times a day, user's lost contact with the "Oracle SERVER" for a while when they are accessing the DB. Sometimes the connection returns quickly, but sometimes "affect the connection with the DB".
    * I think, the problem is with the " SERVER or NETWORKING ", because when you try to access it through Win Explorer you can't, and after a while, it's possible. The same thing happens with mappings to this server, sometimes are accessible and then not, and so on.
    A handicap, is that we don't have our Communication's Personnel (outsourcing), just in the moment when the problems come, to make a network's monitoring with a sniffer.The last time, they made it, said that nothing wrong was happening with the network. They aren't tracking the issue correctly, i think. The same thing with the Server's performance monitoring, is not tracked as it must.
    As result:
    " Every body point that the problem is the DATABASE ".

    *** The point is, that the database always is UP, have an acceptable performance,never hangs and the log and trace files, don't show nothing outstanding.
    The SPECS are:
    - SERVER: Compaq Proliant 2000, WinNT 4 (SP 6), 785 MB, (2)Pentium II/450Mhz, (4) Disks 9.1GB (Raid 5).
    - ORACLE: Oracle Server 8i(8.1.5), 400 MB (SGA), Shared Pool=250M (22% used of this),
    Hits Cache %: Diction.= 98%, Buffer=93%, Library Pin= 96%, Library Get=91%.

    So i'd like you can tell me, what do you think about it (it's Oracle causing the problem ?), if you know tools with options to monitor Oracle packages on the network, what server's components to monitor? , and so on.
    I hope you can help me, best regards.
    Mauro


  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    If I were you, I will question myself how stable is my network.
    When user lost connection does he see any oracle error. I guess user should get end of communication channel ora-3113 etc...

    ANy specifics on what kinda messages does user see while they are experiencing these problems. I can't give you more details on looking at Server Side OS processes/ networking stats etc., as its not UNiX.

    If you think network is stable look at Oracle Net8 specifics and parmeters and net8 tracing and see the connection is consistant or not...
    Reddy,Sam

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    if ur connection terminates,try to ping to the server.If you get "request time out" message then its with network and not with ur database.

    regards
    anandkl
    anandkl

  4. #4
    Join Date
    Jun 2002
    Posts
    11
    Exactly, if i try to make a ping to the server, the answer is: a "request time out". Even, if you try to access it by Win Explorer, you can't.

    I think the problem is with the network or maybe with the Server, but the communication's people don't think so, because they are making the check for a little period of time (minutes). They don't recollect enough information with the sniffer, for a long period (3 or 4 hours) to then analize it, as it must be.
    Maybe the server can have a problem, don't think so ?

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    If the ping is being timed out how the n/w guys can say that there is nothing wrong with the n/w???

    Sanjay

  6. #6
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Database never make you to get out...it may not let you in depending on the processes value.
    like most of the problem solved by env setup...
    most of the connection problem by network...
    Thanks.
    Thanigaivasan.

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