oracle Test fail randomly

karpe · Post by **karpe** » Mon Sep 14, 2009 9:49 am

Hi,

I appreciate in my hostmonitor that sometimes every oracle test fail.

I have aproximately 50 test of oracle server. (i use the test method: Check Oracle server)

Every error return this message:

Access violation at address 7C81BD02 in module 'ntdll.dll'. Read of address FFEC8B55

I repair this problem restarting the HostMontor. (it is installed as service, using local system account).

After restart the HM Service, every test change to ok.

Mi HostMonitor version is: Version 7.50
Mi HostMonitor machine is: Win 2003 Server Enterprise Edition SP2.
The Oracle client is:oracle 10.2.0

Thanks and regards

KS-Soft · Post by **KS-Soft** » Tue Sep 15, 2009 5:37 pm

We rechecked our code, do not see any errors. According to google other software had problems with Oracle client 10.2.0 as well, so probably there is bug in client library.
Could you try to update Oracle software?

Regards
Alex

karpe · Post by **karpe** » Wed Sep 16, 2009 12:58 am

Hi Alex,

I´m waiting to fail again. Them i want to test if the sqlplus can connect to the BBDD, and the tnsping reply.

Thanks and regards,
Carlos

KS-Soft · Post by **KS-Soft** » Wed Sep 16, 2009 10:38 am

I don't think such test will help because you said "I repair this problem restarting the HostMontor".
It looks like some error (data corruption) appears in Oracle library DLL used by HostMonitor. Yes, sqlplus and tnsping probably uses the same DLL but each process has its own copy (DLL works in address space of "parent" application). So, when DLL fails/corrupt in HostMonitor process it still works fine for other processes and vice versa - you may use sqlplus for a while then it fails but HostMonitor may work fine at the same time.

I think its better to check resource usage when error appears
Could you check resource usage for each process, especially for hostmon.exe? You may use standard Windows Task Manager to check Handles, GDI and USER objects. What is the total resource usage on the system? How many handles/threads/GDI objects used by hostmon.exe process?

Regards
Alex

karpe · Post by **karpe** » Thu Sep 24, 2009 2:12 am

Hi Alex,

Now, I see in the HM every oracle test failing. I checked the resourse usage by the hostmon.exe process:

hostmon.exe User: System CPU: 2%+- Mem Usage: 193.960 K Handles: 706 Threads: 21 USER Objects: 203 GDI Objects: 293

I will send you by mail the screenshots.

Thanks and regards
German Carlos Martinez

karpe · Post by **karpe** » Thu Sep 24, 2009 2:14 am

Hi

I restarted the HM Service and i copy the same information:

hostmon.exe User: System CPU: 5%+- Mem Usage: 32.404 K Handles: 352 Threads: 17 USER Objects: 165 GDI Objects: 230

Regards

KS-Soft · Post by **KS-Soft** » Thu Sep 24, 2009 7:11 pm

Probably HostMonitor uses too much memory: 193MB... How many test items do you have? What about Virtual Memory usage?
However this should not be a problem.

>hostmon.exe User: System CPU: 5%+- Mem Usage: 32.404 K Handles: 352 Threads: 17 USER Objects: 165 GDI Objects: 230
That looks absolutely normal.

While 29,232 total allocated handles by all applications... that can be a problem.
I assume you cannot stop DNS server that uses over 5,000 handles? Then may be you can stop some other applications that use too much system resources?

Regards
Alex

karpe · Post by **karpe** » Fri Sep 25, 2009 2:40 am

HI Alex,

I checked that the machine have installed the DNS server, but this aplication is not used. I proceed to stop the service.

I think that the resources in this machine are some limited. THis have a sql 2000.
Hardware specification:
computer: Pentiun III 997Mhz and 2.0 Gb of RAM.

I have 668 test. Performed tests 172065.

Regards
Carlos

karpe · Post by **karpe** » Wed Oct 07, 2009 8:35 am

Hi Alex

The error appear now again. I copy the hostmon.exe resources:
hostmon.exe User: System CPU: 1%+- Mem Usage: 138.272 K Handles: 434 Threads: 20 USER Objects: 225 GDI Objects: 287

Perhaps the HM was taking a lot of memory, now, after restart the service, only use 40MB, during the error was taking 129 MB

Thanks and regards
Carlos

KS-Soft · Post by **KS-Soft** » Wed Oct 07, 2009 12:33 pm

Perhaps the HM was taking a lot of memory, now, after restart the service, only use 40MB, during the error was taking 129 MB

It depends on what exactly kind of memory you are checking.
E.g. Windows Task Manager shows "Mem usage" field. This field provides information about "Working Set"
Quote from Microsoft manual
====================
Working Set is the current size, in bytes, of the Working Set of this process. The Working Set is the set of memory pages touched recently by the threads in the process. If free memory in the computer is above a threshold, pages are left in the Working Set of a process even if they are not in use. When free memory falls below a threshold, pages are trimmed from Working Sets. If they are needed they will then be soft-faulted back into the Working Set before leaving main memory.
====================
In other words, if Task Manager show hostmon.exe mem usage = 200000K, this does not mean anything. HostMonitor could use just 5000K while other memory pages were released by HostMonitor but not released by Windows because Windows still have enough free memory to manage.

Could you try to update Oracle software?

Regards
Alex

karpe · Post by **karpe** » Tue Oct 13, 2009 4:21 am

Hi Alex, i´m cheking the event viewer now, in the application event log appeared repeatly this error before restart the HM.

The description for Event ID ( 0 ) in Source ( hostmon.exe ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Thread creation error: Not enough storage is available to process this command.

After restart the HM service, the error not appear again.

Thanks and regards
Carlos

KS-Soft · Post by **KS-Soft** » Tue Oct 13, 2009 2:34 pm

Could you try to update Oracle software?

Regards
Alex