Monitoring ORACLE Server with NAGIOS
Monitoring ORACLE Server with nagios
Environment: Oracle 10g
CentOS 5.2 x86_64
Install NRPE on the server where Oracle is located
The installation process refers to the Nagios NRPE documentation.
Note:
1. Because the nagios script needs to read oracle-related files. So the user running nagios needs to be defined as an oracle service user. And 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 = 192.168.100.62
}
two。 Give oracle users permission to execute under the ORACLE_HOME directory.
Chmod-Rf 740 $ORACLE_HOME/*
3. Modify the check_oracle script. Add $ORACLE_HOME and $PATH manually to avoid problems.
ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
PATH=$PATH: / u01/oracle/product/10.2.0/db_1/bin
2. Configure nrpe service
Modify the / usr/local/nagios/etc/nrpe.cfg file. Add the following:
# Check Oracle
Commanded [check _ oracle_tns] = / usr/local/nagios/libexec/check_oracle-- tns orcl
Commanded [check _ oracle_db] = / usr/local/nagios/libexec/check_oracle-- db orcl
Commanded [check _ oracle_login] = / usr/local/nagios/libexec/check_oracle-- login orcl
Commander [check _ oracle_cache] = / usr/local/nagios/libexec/check_oracle-- cache orcl system lkjsdf 80 90
Commander [check _ oracle_tablespace] = / usr/local/nagios/libexec/check_oracle-- tablespace orcl system lkjsdf tab 90 80
For specific parameter description, please refer to check_oracle-- help.
After the configuration is complete, restart the xinetd service.
3. Configure Nagios server
1. Install nrpe scripting support. -refer to the official documentation.
two。 Add nrpe command configuration. Modify the nagios/etc/objects/command.cfg file:
Define command {
Command_name check_nrpe
Command_line $USER1 $/ check_nrpe-H $HOSTADDRESS$-c $ARG1 $
}
3. Add the oracle host profile in nagios/etc/objects. Oracle.cfg .
Define host {
Use linux-server
Host_name oracle
Alias Oracle 10g
Address 192.168.100.63
}
Define service {
Use generic-service
Host_name oracle
Service_description TNS Check
Check_command check_nrpe!check_oracle_tns
}
Define service {
Use generic-service
Host_name oracle
Service_description DB Check
Check_command check_nrpe!check_oracle_db
}
Define service {
Use generic-service
Host_name oracle
Service_description Login Check
Check_command check_nrpe!check_oracle_login
}
Define service {
Use generic-service
Host_name oracle
Service_description Cache Check
Check_command check_nrpe!check_oracle_cache
}
Define service {
Use generic-service
Host_name oracle
Service_description Tablespace Check
Check_command check_nrpe!check_oracle_tablespace
}
NRPE and Nagios-Plugin installation files can be found in the attachment package. The official NRPE documentation is also included in the attachment package.
Note:
Tablespace check has not been fine-tuned and uses the wrong table name.
Temporary tablespaces can also be monitored by modifying the script.
