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

Check Oracle server test question

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



Joined: 25 Apr 2009
Posts: 51
Location: Ukraine

PostPosted: Fri Jul 16, 2010 2:33 am    Post subject: Check Oracle server test question Reply with quote

What timeout for Check Oracle server test and how change it?
How can I set max reply value which set ALARM status?
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12791
Location: USA

PostPosted: Fri Jul 16, 2010 8:24 am    Post subject: Reply with quote

Oracle client allows to setup timeout.
Also we recommend to use ODBC Query test, it allows you to specify timeout as well. We keep old Oracle, Interbase, MS SQL tests for compatibility.

On the other hand... its better to not check that Oracle at all. Oracle client software (especially ODBC drivers) often has bugs that leads to various problems.
As we know the most stable Oracle client - version 9

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



Joined: 25 Apr 2009
Posts: 51
Location: Ukraine

PostPosted: Thu Oct 21, 2010 1:17 am    Post subject: Reply with quote

I use Oracle client 8.x. Test method - ODBC query test. Timeout in HM ODBC query test - 10sec. But I have situation when all my Oracle ODBC query test in status "Checking" for big time and nothing help - Only restart HM service help me.
I can't change my oracle client because I test Oracle server v.7.3.4.
Q:Why timeout in ODBC query test don't work when my test in status checking over 10 sec?
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12791
Location: USA

PostPosted: Thu Oct 21, 2010 10:54 am    Post subject: Reply with quote

As we know Oracle clients version 8.x have a lot of bugs. Timeout related problem is not the worst problem it can make. It may lead to application crash
Oracle client version 10.x has bugs as well...
As we know the most stable Oracle client - version 9g

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