check Oracle Server

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
y.beyet
Posts: 62
Joined: Tue Apr 16, 2002 6:00 pm
Location: France
Contact:

check Oracle Server

Post by y.beyet »

Hello

I dont see timeout parameter under the test check Oracle Server. Could you add one ?

Regards,
Yannig
KS-Soft Europe
Posts: 2832
Joined: Tue May 16, 2006 4:41 am
Contact:

Re: check Oracle Server

Post by KS-Soft Europe »

y.beyet wrote:I dont see timeout parameter under the test check Oracle Server. Could you add one ?
What timeout do you mean? HostMonitor is just trying to connect to Oracle server using Oracle Call Interface (OCI.DLL). It does not perform any SQL queries. Have you instaled Oracle Client on the server, where HostMonitor is running? Do you see any error? What exact error do you see?

Regards,
Max
y.beyet
Posts: 62
Joined: Tue Apr 16, 2002 6:00 pm
Location: France
Contact:

Post by y.beyet »

I lose my oracle connection last week (oracle down), and I check my oracle connection with this test.
I have no answer form the test, just checking for about 5 hours...
KS-Soft
Posts: 12821
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

What version of HostMonitor do you use? Version 5.20 or higher should terminate test and return "Unknown" status if OCI.DLL does not respond within 15 min.
Also what version of Oracle Call Interface have you installed? Normally it should not hung if server does not respond...

Regards
Alex
y.beyet
Posts: 62
Joined: Tue Apr 16, 2002 6:00 pm
Location: France
Contact:

Post by y.beyet »

I run the test with HM6.00, oci.dll is 9.0.1.1.1.
I think 15 minutes is a little bit long when an oracle database does not answer...
Maybe I should test my Oracle Databases in an other way ?
KS-Soft
Posts: 12821
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

I think 15 minutes is a little bit long when an oracle database does not answer...
15 minutes is not regular timeout, this is emergency timeout in case DLL hangs. Normally DLL should respond within minute or so. Will try to find information about this problem, may be Oracle has a patch...
Maybe I should test my Oracle Databases in an other way
Try ODBC Query test method

Regards
Alex
KS-Soft
Posts: 12821
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

People on http://www.dbforums.com say such problem was fixed in Oracle 9.2

Regards
Alex
y.beyet
Posts: 62
Joined: Tue Apr 16, 2002 6:00 pm
Location: France
Contact:

Post by y.beyet »

I've tried with a 10g client, it's working now.
Thanks Alex !
Post Reply