seeing (null) under Status Information

[yescobar01]

Hello I am wondering why am i seeing a (null) under Status Information. In my attachment theres a screenshot of 2 hosts "cdtbigdata" is working and "cdtbd2" is not working i follow the same step as i had configure my "cdtbigdata", but this one is not working i tried connecting to my oracle in my XI box and it worked there. When I created the Oracle Table space i had to reconfigure it in the Service Management.

This was the argument i used for cdtbigdata and worked fine.
--connect "xxx.xxx.xxx.xxx:1521/cdtbigdata" --username usr --password "pwd" --name USERS --mode tablespace-can-allocate-next --warning 20 --critical 30

For the other tablespace that is not working "cdtbd2"
--connect "xxx.xxx.xxx.xxx:1522/cdtbd2" --username usr --password "pwd" --name USERS --mode tablespace-can-allocate-next --warning 20 --critical 30

xxx = ip address

thanks!
Yovan

[abrist]

Is port 1522 open and is the oracle db listening on the port?
From the XI cli:

Code: Select all

yum install nmap -y
nmap xxx.xxx.xxx.xxx -p 1522

What is the output?
Have you tried the check from the XI cli?

[slansing]

Also, have you verified that "cdtbd2" is an active service on the oracle server? This would be defined in the following file at the following location $ORACLE_HOME/network/admin/tnsnames.ora

[yescobar01]

I accidently deleted the post I have repost it

Code: Select all

[root@oravm2 /]# nmap 64.143.228.138 -p 1522

Starting Nmap 5.51 ( http://nmap.org ) at 2013-05-08 13:44 EDT
Nmap scan report for elastic-64-143-228-138.iad1.attcompute.com (64.143.228.138)
Host is up (0.0012s latency).
PORT     STATE SERVICE
1522/tcp open  rna-lm

Nmap done: 1 IP address (1 host up) scanned in 0.16 seconds
[root@oravm2 /]#

I will also check my $ORACLE_HOME/network/admin/tnsnames.ora <-- this will be in my XI box right?

[abrist]

I will also check my $ORACLE_HOME/network/admin/tnsnames.ora <-- this will be in my XI box right?

No. It will be on the Oracle server. You may need to talk to your DBA.

[nscott]

It could very well be on both, but the actual server should know what its tnsnames is, so for a start check on the Oracle server for tnsnames.ora. The tnsnames is only necessary on the Nagios XI box if the name you're using to connect with will not resolve to an IP through DNS.

Ensure that you have services that are connectable to by running

lsnrctl status

On your Oracle box, and please show us the output.

Can you verify that /usr/local/nagios/libexec/check_oracle_health on your Nagios XI server exists?

[yescobar01]

Here is the output screenshot i see the check oracle health in that dir.
Also doesn't this prove i am able to make a connection because i query the db in my xi box.?

Code: Select all

[root@oravm2 libexec]# cd $ORACLE_HOME/bin
[root@oravm2 bin]# ls
adrci  ^C  genezi  sqlplus
[root@oravm2 bin]# ./sqlplus "usr/pwd@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=64.143.xxx.xxx)(PORT=1522)))(CONNECT_DATA=(SID=cdtbd2)))"

SQL*Plus: Release 11.2.0.3.0 Production on Wed May 8 14:11:04 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from dim_dept;

  COUNT(*)
----------
       761

SQL>

[sreinhardt]

Since this hasn't been checked yet and it all seems to be run as root so far. Lets be sure the nagios user has $ORACLE_HOME env and that it has permissions to both that and the plugin.

Code: Select all

su nagios
echo  $ORACLE_HOME
ll  $ORACLE_HOME
ll /usr/local/nagios/libexec | grep -i oracle

[yescobar01]

Thanks for your reply here I enter the commands you asked.

Code: Select all

[root@oravm2 /]# su nagios
No packages needed for security; 71 packages available
[nagios@oravm2 /]$ echo $ORACLE_HOME
/usr/lib/oracle/11.2/client64
[nagios@oravm2 /]$ ll  $ORACLE_HOME
total 8 
drwxr-xr-x 2 root root 4096 May  7 16:04 bin
drwxr-xr-x 2 root root 4096 May  2 15:24 lib
[nagios@oravm2 /]$ ll /usr/local/nagios/libexec | grep -i oracle
-rwxr-xr-x 1 root   root     8366 May  1 13:19 check_oracle
-rwxr-xr-x 1 root   root   223077 May  7 14:46 check_oracle_health
[nagios@oravm2 /]$

[slansing]

Did you make sure to alter the three commands for a 64 architecture? This is important:

http://assets.nagios.com/downloads/nagi ... lation.pdf