Documentations

How to monitor an Oracle database?

On the page

Need some help?

The Box ServiceNav embeds an Oracle client to provide Oracle supervision.

Prerequisite

Configure the ServiceNav Box to communicate with the Oracle database. To do this, either retrieve or create a tnsname.ora file or connect it to an Oracle directory with a sqlnet.ora and ldap.ora file (see with your DBA).

Using a tnsnames.ora file

The tnsname.ora file is used to tell the ServiceNav Box how to access the Oracle databases you want to monitor.

  1. Connecting via SSH on the Viadéis Services Box
  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 your box version
  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 the version of your box

File rights: readable for all users (755): chmod +r tnsnames.ora.

Using a directory sqlnet.ora and ldap.ora of Oracle database

The use of a ldap directory for Oracle makes it possible to dispense with the tnsname.ora file. This is very interesting when there is a number of Oracle databases to supervise.

  • Connecting via SSH on the Viadéis Services Box
  • 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 the version of your box
  • 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 the version of your box
  • This allows you to define the Oracle name servers it is 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 is to 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 "supervision" user or other via the Oracle console to give the supervision user rights on the databases. system.

Execute the following commands:

create user supervision identified by password;
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;

Deploy Oracle Unit Services

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

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

This may also be of interest to you

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

en_USEnglish
fr_FRFrench en_USEnglish

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.