View previous topic :: View next topic |
Author |
Message |
y.beyet
Joined: 16 Apr 2002 Posts: 62 Location: France
|
Posted: Wed Jun 14, 2006 4:04 am Post subject: check Oracle Server |
|
|
Hello
I dont see timeout parameter under the test check Oracle Server. Could you add one ?
Regards,
Yannig |
|
Back to top |
|
|
KS-Soft Europe
Joined: 16 May 2006 Posts: 2832
|
Posted: Wed Jun 14, 2006 4:27 am Post subject: Re: check Oracle Server |
|
|
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 |
|
Back to top |
|
|
y.beyet
Joined: 16 Apr 2002 Posts: 62 Location: France
|
Posted: Wed Jun 14, 2006 6:41 am Post subject: |
|
|
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... |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Wed Jun 14, 2006 6:18 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
y.beyet
Joined: 16 Apr 2002 Posts: 62 Location: France
|
Posted: Thu Jun 15, 2006 1:56 am Post subject: |
|
|
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 ? |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Thu Jun 15, 2006 11:02 am Post subject: |
|
|
Quote: | 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...
Quote: | Maybe I should test my Oracle Databases in an other way |
Try ODBC Query test method
Regards
Alex |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Thu Jun 15, 2006 3:09 pm Post subject: |
|
|
People on http://www.dbforums.com say such problem was fixed in Oracle 9.2
Regards
Alex |
|
Back to top |
|
|
y.beyet
Joined: 16 Apr 2002 Posts: 62 Location: France
|
Posted: Fri Jun 16, 2006 3:46 am Post subject: |
|
|
I've tried with a 10g client, it's working now.
Thanks Alex ! |
|
Back to top |
|
|
|