check Oracle server stuck in the status of Checking

chimams · Post by **chimams** » Wed Sep 01, 2004 1:16 pm

We are having this issue; all 10 of our 'check Oracle server' test getting stuck in the status of Checking.

When this happens I have to stop and restart the HM. This will run usually for a day without problems but the next day they will be stuck again.

We are on version 4.52, I have reviewed the earlier reports of this issue in the earlier version where the fix was to insert "DoNotUse_SqlFetchAbsolute=1" in the hostmon.ini file. Our file already have this statement.

Please help to resolve this issue.

KS-Soft · Post by **KS-Soft** » Wed Sep 01, 2004 5:46 pm

What version of oci.dll (Oracle Client Library) is installed on your system?

Regards
Alex

chimams · Post by **chimams** » Thu Sep 02, 2004 10:10 am

The properties window for the oci.dll states 0.0.0.0

KS-Soft · Post by **KS-Soft** » Thu Sep 02, 2004 1:06 pm

What version of the Oracle client library you have installed?

chimams · Post by **chimams** » Thu Sep 02, 2004 2:24 pm

How do I find this information ?

KS-Soft · Post by **KS-Soft** » Thu Sep 02, 2004 5:59 pm

H'm, interesting question... There should be some readme file, configuration utility or manual, CD or floppy... How you installed the library? Or it was installed long long time ago?

I want to know version because I want to find some information about problems/solutions related to this version of the oracle library. Probably you have contacts and can ask Oracle support team about this problem directly?

Regards
Alex

eal · Post by **eal** » Fri Oct 01, 2004 12:11 pm

I'm having the exact same problem using HM 4.52. My oci.dll file is version 8.1.6.0.0 if that helps.

KS-Soft · Post by **KS-Soft** » Fri Oct 01, 2004 3:19 pm

You are using dedicated Oracle test method as well? Or you use "ODBC Query" test method?
Trying to find some comments about this version....

Regards
Alex

eal · Post by **eal** » Mon Oct 04, 2004 6:26 am

Yes, I'm using a dedicated Oracle test method as well.

KS-Soft · Post by **KS-Soft** » Mon Oct 04, 2004 12:58 pm

Did not find anything wrong in HostMonitor's code...
Could you try to use ODBC Query test method instead of Oracle test?

Regards
Alex

V Arun · Post by **V Arun** » Wed Oct 27, 2004 1:27 pm

Alex,

Am facing the same problem with ODBC query test method. Using HM ver 4.70.. Test just hangs with status 'checking'. I have to restart HM.

Oracle 8 client ver 8.0.4 and oci.dll 0.0.0.0 40,448 bytes

Regards,
Arun

KS-Soft · Post by **KS-Soft** » Fri Oct 29, 2004 2:48 pm

Both test methods (Oracle and ODBC Query) doesn't have any loops that can hung thread. Must be some error in oracle library...

Actually we found workaround for one bug in the oracle library:

Do not use SQLFetchAbsolute command option
Not every ODBC driver supports SQL_FETCH_ABSOLUTE command. HostMonitor tries to use this command and if driver returns error, HostMonitor use cycle with SQL_FETCH_NEXT command.
It works fine with most ODBC drivers. However ODBC driver which comes with Oracle client v.8 (and may be some other drivers) has bug in error handler. This bug can cause ODBC driver to crash.
That's why this option was implemented. Use it if you experience problem with ODBC driver.

Have you enabled this option? Option located on Miscellaneous page in the Options dialog
Of course there could be some other problem...

Regards
Alex