Announcement

Collapse
No announcement yet.

Oracle application running slow when a pc disconnected from network

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Oracle application running slow when a pc disconnected from network

    Sir,

    Now I am going through a critical situation that has no answer for me , but I believe that you can help me in this

    We have an ERP solution running in my network. Oracle E business.

    Server – HP prolient G5 2 GB ram with 2 partitions

    Partition c = 72 GB .. Mirrored (2 x 72 GB sas 15 K rpm HDD)

    Partition d= RAID5 (3 x 72 GB sas 15 K rpm HDD + 1 x 72 GB sas 15 K rpm HDD as stand by)
    OS .. windows 2000 Advanced server. SP- 4 Upto date in patching

    IIS version = 5.0.
    ERP
    Oracle 9i DB

    Forms 6i as frond end

    It was running smoothly. Our working time is GMT 8 am to 5 pm. Some of the top level managers are doing their checking after 5 pm everyday up to 9 pm

    Around 50 employees are accessing the ERP daily from their desktop through Web based interface (http:apps:13000)
    It was very surpricing that While i was working with the oracle application, at 5.34 PM, every thing was fine .. I got slowness all on a sudden and I saw One of my employee is clossing his door to leave home. I took his key and switch on his machine ... i didnt log on to network / windows... i came and checked the application... working smooth and fast.. I shut down that PC again and saw real time the application is getting slower.

    when an Xp desktop is removed from the network, My Oracle application is showing slow responce.

    I switch on the desktop, and the application was running very fast. I removed the network cable to another switch port, another new switch, and tested... there is no change in behaviour of application.
    I changed the NIC card .. No change
    I removed the IP and re assign the IT from DHCP pool. No change
    I removed all the installed Programs... No change
    I removed Symantec from Client and server
    No change
    I removed the client from the Domain and added to defauly work group.. No change
    I changed the machine name .. Then EVEN THE SPECIFIC DESKTOP IS ON IN THE NETWORK, THE APPLICATION IS SLOW.
    WHAT DOES THIS MEANS
    IS ANY MACHINE NAME CAN INFLUENCE AN APPLICATION'S PERFORMANCE.
    I DID THIS TEST WITH DIFFERENT MACHINE NAME ADDING TO THE SPECIFIC MACHINE. THE APPLICATION WAS SLOW TILL I RENAMED WITH ITS PREVIOUS NAME IN THE NETWORK

    pls help me to solve this issue

    regards

    sumanlal

  • #2
    Re: Oracle application running slow when a pc disconnected from network

    It sounds like a network issue. Try taking OTM out of the picture. When your connection is slow (with the other PC turned off) try copying a large file over the network and time it. Then try the same test when OTM is running normally. If the file copy is slow when the connection to OTM is slow then I think you can safely assume that the network is the issue not the OTM application.

    Comment


    • #3
      Re: Oracle application running slow when a pc disconnected from network

      Sumanlal,

      It sounds like you're having issues with Oracle's EBS suite, rather than OTM. This community is built around supporting OTM (Oracle Transportation Management or G-Log) and many of us don't have deep experience with EBS.

      I'd try Alan's suggestion around network performance - otherwise, you will find more experts on EBS over at Welcome to The Oracle FAQ | Oracle FAQ

      --Chris
      Chris Plough
      twitter.com/chrisplough
      MavenWire

      Comment


      • #4
        Re: Oracle application running slow when a pc disconnected from network

        hello friends
        Thx for your reply

        Yesterday we did some tests to point out what is the problem exactly for the slowness
        During that specific PC is off application (only running report, saving data) is slow. all the other network resources can access fast as normal. even we can browse through the menus fast in the application . the reports even though it is small/ large it is taking 30 sec instad of 3 sec normal.

        My server IP is 192.168.135.5. and I removed the network connection from the server and access the application through local host. (instad of http:apps:13000, i used http:127.0.0.1:13000. then i found the application is fast as normal.
        what doed it means
        can anybody help me


        suman

        Comment


        • #5
          Re: Oracle application running slow when a pc disconnected from network

          Yesterday we did some tests to point out what is the problem exactly for the slowness
          During that specific PC is off application (only running report, saving data) is slow. all the other network resources can access fast as normal. even we can browse through the menus fast in the application . the reports even though it is small/ large it is taking 30 sec instad of 3 sec normal.

          My server IP is 192.168.135.5. and I removed the network connection from the server and access the application through local host. (instad of http:apps:13000, i used http:127.0.0.1:13000. then i found the application is fast as normal.
          what doed it means
          can anybody help me


          suman

          regards
          sumanlal

          Comment


          • #6
            Re: Oracle application running slow when a pc disconnected from network

            Hello
            I did more experiment on the issue and found the following things
            I changed the machine name MISManager to Test (The machine which is found to cause the slowness is MISManager)
            Then the application turns suddenly slow..
            I changed my laptops name to MISManager and bring my laptop active in the network.
            Then the application turned behaving fast. When i removed the network connection of laptop which i renamed to MISManager, the application suddenly turned slow.
            As i said earlier, my application is an Oracle based application, the following services are needed smooth running of Oracle application.
            Oracle Forms server "forms 60 server-D2k" Started Automatic
            Oracle report server "rep server" Started Automatic
            Oracle Mts recovery service Started Automatic
            Oracle ORA home 92 agent Started Automatic
            Oracle ORA Home 92 HTTP server Started Automatic
            Oracle ORA Home 92 TNS listner Started Automatic
            Oracle service Ebiz Started Automatic

            Some times Oracle form server in the task manager (ifweb60.exe) is hanging and it was taking 50% of the CPU time .. Our ERP is in the implimentation stage .. Oracle forms server service is made to start under local system account, we are not able to kill the task. so we changed the option to start the service as domain Admin's account. so we can kill the process with out restarting the server.
            now i changed the machine name of the specific Pc and rename my laptop with the name. and found that the application is some how related to application performance
            when i change the form server service to local system account, this behaviour stopped and even though MISManager named pc is not in the network, the application is running fast.
            Can anybody tell me why and how this happens
            regards
            sumanlal

            Comment

            Working...
            X