[vksumanlal]

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

[acuartero]

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.

[chrisplough]

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

[vksumanlal]

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

[vksumanlal]

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

[vksumanlal]

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