Documentation

How to monitor an Oracle database?

On the page

Need some help?

The ServiceNav box has an embedded Oracle client to support Oracle monitoring.

Pre-requisites

Configure the ServiceNav Box to communicate with the Oracle database. To do this, either obtain or create a tnsname.ora file, or connect it to an Oracle directory with a sqlnet.ora and ldap.ora file (ask 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. 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 your SNB version
  3. For older ServiceNav Box versions , 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/ again, depending on the version of your SNB

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

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

The use of an ldap directory for Oracle makes it possible to dispense with the tnsname.ora file. This is very useful when there is a large 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/ depending on the version of your SNB
  • 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 file lets you define Oracle name servers to be configured in 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 scope of the ldap domain to be configured according to your setup:

# 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", or other, user via the Oracle console to give the monitoring 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 Services

In ServiceNav you can use the host template "Oracle Database Services", or individually add services of your choice.

To accelerate deployment of monitoring you can use the monitoring account : Oracle

This may also be of interest to you

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

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.