Nagios and Oracle db

[slansing]

This is to assist in setting up the oracle instant client so that the check_oracle_health plugin can be used to communicate with your remote oracle DBs:

http://exchange.nagios.org/directory/Pl ... th/details

[JanePisk]

Code: Select all

./check_oracle_dual.sh: line 98: /home/oracle/product/10.2/db_2/bin/sqlplus: Permission denied

any other ideas?

[tmcdonald]

Check the permissions on the directory:

ls -l /home/oracle
ls -l /home/oracle/product/10.2/db_2/bin/sqlplus

Chances are the nagios user does not have permission to access that file/directory.

[JanePisk]

Code: Select all

[oracle@fox ~]$ ls -l /home/oracle/
total 440
drwxr-xr-x  3 oracle oinstall   4096 Nov 12  2007 admin
-rw-rw-rw-  1 oracle oinstall    151 Sep 18 10:53 afiedt.buf
drwxr-xr-x  2 oracle oinstall   4096 Aug  7  2008 bfu
-rwxr-xr-x  1 oracle oinstall   1079 May 22  2006 copia_dbfiles
-rw-rw-rw-  1 oracle oinstall      1 Oct 29  2007 dead.letter
-rw-r--r--  1 oracle oinstall    639 Mar 23  2009 gino
-rw-rw-rw-  1 oracle oinstall    315 Mar 23  2009 gino.out
-rw-rw-rw-  1 oracle oinstall  12745 Jan 23  2009 gino.sql
drwxr-xr-x  4 oracle oinstall   4096 Jun  8  2012 libextprocsh
-rw-rw-rw-  1 oracle oinstall 143360 May  6  2008 libextprocsh.tar
-rw-rw-rw-  1 oracle oinstall    350 Mar 11  2009 nohup.out
-rw-rw-rw-  1 oracle oinstall   1292 Jul  2  2009 OLA01_CheckRename_0207090745.log
-rw-rw-rw-  1 oracle oinstall   1292 Jul  2  2009 OLA01_CheckRename_0207090807.log
-rw-rw-rw-  1 oracle oinstall      0 Apr 19  2008 open-iscsi-2.0-869.tar.gz
drwxrwxr-x  7 oracle oinstall   4096 Sep  6  2006 oraInventory
drwxrwxr-x  3 oracle oinstall   4096 Apr 24  2007 product
-rw-rw-rw-  1 oracle oinstall   1431 Nov 20 07:00 report_tbs.out
drwxr-xr-x  2 oracle oinstall   4096 Jul 15  2008 sample
drwxr-xr-x  5 oracle oinstall  69632 Nov 20 07:00 scripts
-rw-rw-rw-  1 oracle oinstall    901 Aug  9  2006 settaEXISSVIL.sh
-rw-rw-rw-  1 oracle oinstall    894 Aug  9  2006 settaSVILDB.sh
drwxr-xr-x  2 oracle oinstall   4096 Feb  9  2009 siebel
-rw-rw-rw-  1 oracle oinstall   1347 Jan 25  2007 sqlnet.log
drwxr-xr-x  2 oracle oinstall   4096 Sep 29  2006 stage
drwxr-xr-x  2 oracle oinstall   4096 Mar 18  2009 test
drwxr-xr-x  2 oracle oinstall   4096 Sep 30  2010 TEST

Code: Select all

[oracle@fox ~]$ ls -l /home/oracle/product/10.2/db_2/bin/sqlplus
-rwxr-xr-x  1 oracle oinstall 8868 Aug 10  2006 /home/oracle/product/10.2/db_2/bin/sqlplus

[oracle@fox ~]$ id nagios
uid=517(nagios) gid=517(nagios) groups=517(nagios),502(dba),501(oinstall)

[oracle@fox ~]$ id oracle
uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)

[slansing]

On a side note, did you try:

http://exchange.nagios.org/directory/Pl ... th/details