NetXMS Support Forum

English Support => General Support => Topic started by: Thor2029 on March 15, 2012, 09:53:07 AM

Title: ORACLE DB TEST
Post by: Thor2029 on March 15, 2012, 09:53:07 AM
Hi Victor,

Can you tel me if it's possible to test (with DCI) connexion to an ORACLE database (diférent than the netxms oracle database) with specific user account (like username/password) or simply test if my ORACLE DATABASE is UP or DOWN

Thanks for your reply,

Best regards,

Thor
Title: Re: ORACLE DB TEST
Post by: macro on March 17, 2012, 01:40:30 AM
Hi,

Strangely enough, now NetXMS can monitor quite a few Oracle DB parameters (such as number of open cursors, sessions, etc) but hasn't got a DCI just to tell whether an Oracle database is on or off. But this is planned for the next release though.

If this is an urgent matter for you please tell me which version and platform do you use and we can work something out.
Title: Re: ORACLE DB TEST
Post by: Thor2029 on April 05, 2012, 04:13:02 PM
Hi Victor,
So what can i do to test connexion login/password (i have the oracle client installed)

Best regards

Title: Re: ORACLE DB TEST
Post by: macro on April 09, 2012, 06:26:27 PM
There is a new parameter in the Oracle subagent - Oracle.DBInfo.IsReachable. The new code is in the svn already and scheduled for 1.2.0 release later this month. Should you need this sooner please give me your agent platform details (OS, current agent version) I'll see if I can build the binary off the svn trunk for you.