Documentations

How to monitor an Oracle database?

On the page

Do you need help?

The ServiceNav box includes an Oracle client to ensure Oracle monitoring.

Prerequisites

Configure the ServiceNav box to communicate with the Oracle database. To do so, you have to either retrieve or create a tnsname.ora file or connect it to an Oracle directory with a sqlnet.ora and ldap.ora file (check with your DBA).

Using a tnsnames.ora file

The tnsname.ora file allows you to tell the ServiceNav box how to access the Oracle database you want to monitor.

  1. Connecting to the Viadéis Services Box via SSH
  2. Copy the file tnsnames.ora in the directory : /usr/lib/oracle/11.2/client64/network/admin/ or /usr/lib/oracle/12.2/client64/network/admin/ depending on the version of your box
  3. For older versions of Viadéis Services Box, the directory above does not exist, so you must copy the tnsnames.ora file here: /usr/lib/oracle/11.2/client/network/admin or /usr/lib/oracle/12.2/client64/network/admin/ depending on your box version

File permissions: read for all users (755): chmod +r tnsnames.ora.

Using an Oracle database sqlnet.ora and ldap.ora directory

The use of a ldap directory for Oracle allows to do without the tnsname.ora file. This is very interesting when there is a number of Oracle databases to supervise.

  • Connecting to the Viadéis Services Box via SSH
  • Delete the files in the directory: /usr/lib/oracle/11.2/client64/network/admin/ or /usr/lib/oracle/12.2/client64/network/admin/ depending on your box version
  • Then add the file sqlnet.ora in this directory: /usr/lib/oracle/11.2/client64/network/admin/
  • or /usr/lib/oracle/12.2/client64/network/admin/ depending on your box version
  • This allows you to define the Oracle name servers to be configured according to your infrastructure:

# sqlnet.ora Network Configuration File:
#C:oracleora10gnetworkadminsqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = coservit.local

#SQLNET.AUTHENTICATION_SERVICES= (NTS)
sqlnet.expire_time = 2

NAMES.DIRECTORY_PATH= (LDAP)

  • Now add the file ldap.ora in the same directory: /usr/lib/oracle/11.2/client64/network/admin/ This allows you to define the context of the ldap domain, it must be configured according to your infrastructure:

# ldap.ora Network Configuration File:
#C:oracleora10gnetworkadminldap.ora
# Generated by Oracle configuration tools.

DIRECTORY_SERVERS= (oranames1:389:636, oranames2:389:636)

DEFAULT_ADMIN_CONTEXT = " dc=chroracle,dc=en "
DIRECTORY_SERVER_TYPE = OID

 

Create a "supervision" user

Create a user "supervision" or other via the Oracle console to give the rights to the supervision user on the databases system.

Run the following commands:

create user supervision identified by ;
grant create session to supervision;
grant select any dictionary to supervision;
grant select on SYS.V_$SYSSTAT to supervision;
grant select on SYS.V_$INSTANCE to supervision;
grant select on SYS.V_$LOG to supervision;
grant select on SYS.DBA_DATA_FILES to supervision;
grant select on SYS.DBA_FREE_SPACE to supervision;

Deploying Oracle Unitary Services

In the supervision website you can use the equipment template "Oracle Database Services", or directly the unit service of your choice.

To facilitate the deployment of the supervision you can use the supervision account : Oracle

You may also be interested in

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

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.