Nagios Support Forum

Well, there is an improvement now after adding the .com to the instance name. This is the error: CRITICAL - cannot connect to xx.xx.xx.xx:1521/SGRC.XX.COM. ORA-01017: invalid username/password: logon denied (DBD ERROR: OCISessionBegin) But I am not sure if this is username and password issue as our ...

Hi SSAX, Are you sure is it at line 104? in my code its at line 326. Anyways I have updated the code which you have advised and please find the output from CLI: libexec]# ./check_mssql -H xx.xx.xx.xx --username sa --password "xxxx" --database master --port 1433 --query "SELECT+name+%2...

oh sorry, i have provided you another output. Here it is: xxxxxxxxxxx*SGRC-/home/oracle >lsnrctl status LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 05-APR-2016 12:26:48 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of...

Please find attached the screen shot from Studio Express. Studio express is not a problem. When I run the same query in Nagios XI then its an issue

Please find the output below: testhost:/home/oracle:TALTAM> lsnrctl services LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 05-APR-2016 12:42:34 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testhost)(PORT=1521))) Services Summa...

Hi hsmith, Yes, I have tried from command line, same output :cry: ./check_mssql -H xx.xx.xx.xx --username sa --password "ptest" --database master --port 1433 --query "SELECT+name+%2B+%27%2C+%27+AS+%5Btext%28%29%5D+FROM+sys.databases+WHERE+state+%21%3D+0+FOR+XML+PATH%28%27%27%29%3B&quo...

Hi rkennedy,

Do you mean the service command? Here it is:
check_xi_oracletablespace!--connect 'xxx.xx.xx.xxx:1521/SGRC' --username 'test' --password 'ptest' --mode tablespace-usage --warning 90 --critical 98

Thank you!

Thank you ssax, Sorry for taking a long time to respond. This works absolutely fine in MSSQL Studio express and gives the desired result. But in Nagios its not able to execute. I am getting an error as - CRITICAL: Could not execute the query . This is the query: check_xi_mssql_query!--username sa --...

Hi ssax, You are star! I could complete the installation successfully. Now I am encountering another error: CRITICAL - cannot connect to xx.xx.xxx.xx:1521/SGRC. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach) Please share your t...

Hi tmcdonald,

Could you post any example for wrapper script which i can use?