Documentation

How to monitor an Oracle database?

On the page

Do you need help?

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

Prerequisites

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

Using a tnsnames.ora file

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

  1. Connect to the ServiceNav Box via SSH
  2. Copy the file tnsnames.ora to 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 ServiceNav Box
  3. On older ServiceNav boxes, 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 SNB version

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

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

The use of an ldap directory for Oracle lets you dispense with the tnsname.ora file. This is very useful when there is a number of Oracle databases to monitor.

  • Connect to the ServiceNav 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/ according to your SNB version
  • Then add the file sqlnet.ora to this directory: /usr/lib/oracle/11.2/client64/network/admin/
  • or /usr/lib/oracle/12.2/client64/network/admin/ depending on your SNB version
  • In this file you define the Oracle name servers to configure 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 lets you to define the context of the ldap domain and 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 "monitoring" user

Create a monitoring account using the below commands or via the Oracle console to give the user the necessary rights to 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 Services

In the ServiceNav interface you can use the host template "Service Oracle database", or select specific services of your choice.

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

You may also be interested in

Configure IBM AS/400 monitoring requirements

en_GB

Our next events

Our upcoming webinars

Our Previous Webinars

Welcome to ServiceNav!

Do you need some help? More information about our products? Write to us!
We will never sell or share your personal data with third parties. 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

We will never sell or share your personal data with third parties. You have taken note of our privacy policy.