Using nagios to monitor oracle 10g (1)

UseNagiosMonitoringOracleThe specific method of 10 Gb is as follows:

1. Install NRPE on the server where Oracle is located

 
 

  
  
#useradd nagios  
  
  
 
  
  
# wget http://nchc.dl.sourceforge.net/sourceforge/nagios/nrpe-2.12.tar.gz  
  
  
 
  
  
# tar xvfz nrpe-2.12.tar.gz  
  
  
 
  
  
# cd nrpe-2.12  
  
  
 
  
  
# ./configure --prefix=/usr/local/nagios  
  
  
 
  
  
# make all  
  
  
 
  
  
# make install-plugin  
  
  
 
  
  
# make install-daemon  
  
  
 
  
  
# make install-daemon-config  
  
  
 
  
  
# make install-xinetd  
  
  
 
 
 

Note:

1. The nagios script needs to read oracle-related files. Therefore, users running nagios must be defined as oracle service users. Modify the configuration in/etc/xinted. d/nrpe.

Service nrpe

 
 

  
  
{  
  
  
 
  
  
flags = REUSE  
  
  
 
  
  
socket_type = stream  
  
  
 
  
  
port = 5666  
  
  
 
  
  
wait = no  
  
  
 
  
  
user = oracle  
  
  
 
  
  
group = nagios  
  
  
 
  
  
server = /usr/local/nagios/bin/nrpe  
  
  
 
  
  
server_args = -c /usr/local/nagios/etc/nrpe.cfg --inetd  
  
  
 
  
  
log_on_failure += USERID  
  
  
 
  
  
disable = no  
  
  
 
  
  
only_from = 127.0.0.1 10.0.0.99  
  
  
 
  
  
}  
  
  
 
 
 

2. Copy check_oracle and utils. sh in the libexec directory on the nagios server to the libexec directory on the oracle server and modify the check_oracle script. Manually add $ ORACLE_HOME and $ PATH.

 
 

  
  
ORACLE_HOME=/home/oracle/OraHome_1  
  
  
 
  
  
PATH=$PATH:$ORACLE_HOME/bin