Documentation

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

On the page

Need some help?

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

In order to do this, the nagios environment will have to be modified so that the right client is called.

Modification of the nagios environment

Depending on the Oracle version to be supervised, modify the file /home/nagios/.bashrc by commenting on 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 to call 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:/bin:/usr/games:/usr/local/games:/usr/lib/oracle/11.2/client64/bin
#export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

 

Perform the same operation for the file /etc/sysconfig/nagios:

Edit the file  /etc/sysconfig/nagios and comment on the lines of the customer not to use (example to call 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:/bin:/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 these changes have been made, refer to the following procedure: https://coservit.com/servicenav/fr/documentation/comment-superviser-une-base-de-donnees-oracle/

This may also be of interest to you

How to monitor an Oracle database?

en_US
fr_FR en_US

Welcome to ServiceNav!

Need help? More information about our products? Write to us!
You have taken note of our privacy policy.

[COVID - 19 ] - TELEWORKING, TARGET AVAILABILITY 100% !

While the epidemic lasts, ensure the availability and performance of your IT services for teleworking, with ServiceNav!

Following the government's call to mobilize to help businesses overcome the current health and economic context, we help you, free of charge, to ensure the complete monitoring of your teleworking environments: VPN, VDI, Teams, Skype Enterprise, Citrix... Objectives: collection, availability and usage indicators, dashboards to support your communication.
We use cookies to ensure that you have the best possible experience on our site, and 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.