Documentations

How to monitor an Oracle database from an Ubuntu 16.04 ServiceNav Box?

On the page

Do you need help?

The Ubuntu 16.04 box embeds the Oracle 11.2 and 12.2 clients, so depending on the Oracle version to be monitored, the right client must be used.

To do this, we'll need to modify the nagios environment so that the correct client is called.

Modification of the nagios environment

Depending on the Oracle version to be monitored, modify the /home/nagios/.bashrc by commenting the lines that do not correspond to the Oracle version:

Edit the file /home/nagios/.bashrc and comment on the lines of the customer not to use (example for calling client 12.2):

# BEGIN ANSIBLE MANAGED BLOCK
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export PATH=$PATH:/usr/lib/oracle/12.2/client64/bin
export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib
# END ANSIBLE MANAGED BLOCKexport ORACLE_HOME=/usr/lib/oracle/11.2/client64
#export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/usr/games:/usr/local/games:/usr/lib/oracle/11.2/client64/bin
#export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

 

Do the same for the file /etc/sysconfig/nagios:

Edit the file  /etc/sysconfig/nagios and comment on the lines of the customer not to use (example for calling client 12.2):

# BEGIN ANSIBLE MANAGED BLOCK
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export PATH=$PATH:/usr/lib/oracle/12.2/client64/bin
export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib
# END ANSIBLE MANAGED BLOCK
#export ORACLE_HOME=/usr/lib/oracle/11.2/client64
#export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/usr/games:/usr/local/games:/usr/lib/oracle/11.2/client64/bin
#export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

Restarting nagios: /etc/init.d/nagios restart

Once you have made these changes, refer to the following procedure: https://coservit.com/servicenav/fr/documentation/comment-superviser-une-base-de-donnees-oracle/

You may also be interested in

How to monitor an Oracle database?

en_GB

Welcome to ServiceNav!

Do you need some help? More information about our products? Write to us!
You have taken note of our privacy policy.
We use cookies to ensure the best experience on our site. If you continue to use this site, we will assume that you are satisfied with it.

Reserve your place

You have taken note of our privacy policy.