KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

check Oracle server stuck in the status of Checking

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting
View previous topic :: View next topic  
Author Message
chimams



Joined: 22 Jun 2004
Posts: 3
PostPosted: Wed Sep 01, 2004 1:16 pm    Post subject: check Oracle server stuck in the status of Checking Reply with quote
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.
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12795
Location: USA
PostPosted: Wed Sep 01, 2004 5:46 pm    Post subject: Reply with quote
What version of oci.dll (Oracle Client Library) is installed on your system?

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
chimams



Joined: 22 Jun 2004
Posts: 3
PostPosted: Thu Sep 02, 2004 10:10 am    Post subject: Reply with quote
The properties window for the oci.dll states 0.0.0.0
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12795
Location: USA
PostPosted: Thu Sep 02, 2004 1:06 pm    Post subject: Reply with quote
What version of the Oracle client library you have installed?
Back to top
View user's profile Send private message Visit poster's website
chimams



Joined: 22 Jun 2004
Posts: 3
PostPosted: Thu Sep 02, 2004 2:24 pm    Post subject: Reply with quote
How do I find this information ?
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12795
Location: USA
PostPosted: Thu Sep 02, 2004 5:59 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message Visit poster's website
eal



Joined: 05 May 2004
Posts: 8
Location: Canada
PostPosted: Fri Oct 01, 2004 12:11 pm    Post subject: Reply with quote
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.
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12795
Location: USA
PostPosted: Fri Oct 01, 2004 3:19 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message Visit poster's website
eal



Joined: 05 May 2004
Posts: 8
Location: Canada
PostPosted: Mon Oct 04, 2004 6:26 am    Post subject: Reply with quote
Yes, I'm using a dedicated Oracle test method as well.
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12795
Location: USA
PostPosted: Mon Oct 04, 2004 12:58 pm    Post subject: Reply with quote
Did not find anything wrong in HostMonitor's code...
Could you try to use ODBC Query test method instead of Oracle test?

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
V Arun



Joined: 11 Apr 2004
Posts: 52
PostPosted: Wed Oct 27, 2004 1:27 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12795
Location: USA
PostPosted: Fri Oct 29, 2004 2:48 pm    Post subject: Reply with quote
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:
Quote:

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
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group
KS-Soft Forum Index