Page 1 of 2
seeing (null) under Status Information
Posted: Wed May 08, 2013 10:42 am
by 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
Re: seeing (null) under Status Information
Posted: Wed May 08, 2013 11:09 am
by 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?
Re: seeing (null) under Status Information
Posted: Wed May 08, 2013 11:15 am
by 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
Re: seeing (null) under Status Information
Posted: Wed May 08, 2013 12:45 pm
by 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?
Re: seeing (null) under Status Information
Posted: Wed May 08, 2013 12:57 pm
by abrist
yescobar01 wrote: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.
Re: seeing (null) under Status Information
Posted: Wed May 08, 2013 1:03 pm
by 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?
Re: seeing (null) under Status Information
Posted: Wed May 08, 2013 1:09 pm
by 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>
Re: seeing (null) under Status Information
Posted: Wed May 08, 2013 4:54 pm
by 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
Re: seeing (null) under Status Information
Posted: Thu May 09, 2013 9:40 am
by 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 /]$
Re: seeing (null) under Status Information
Posted: Thu May 09, 2013 9:58 am
by 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