EV Observe - Configure Oracle Monitoring Prerequisites
Oracle offers different products and services in the field of applications, databases, third-party software, virtualization, operating systems, etc. You can use the Box to collect information on Oracle databases using dedicated service templates.
To use control points based on Oracle, specific prerequisites must first be met.
- You configure these prerequisites once only.
- This is done in two steps:
- Configure the Box to access Oracle databases
- Create a dedicated user for monitoring system databases
Procedure: How to configure Oracle monitoring prerequisites
Step 1: Access Oracle databases
Use one of the methods below to configure the Box to access Oracle databases.
Step 1.a: Define the configuration using the tnsnames.ora configuration file
1. Log in via SSH to the Box.
2. Copy the tnsnames.ora file to the folder below based on the version of your Box.
Note: If the folder does not exist, you must first create it.
/usr/lib/oracle/11.2/client64/network/admin/
or
/usr/lib/oracle/12.2/client64/network/admin/
3. Run the command below to define read access to the file for all users (chmod 755).
- chmod +r tnsnames.ora
OR Step 1.b: Define the configuration using an LDAP directory for Oracle
We recommend you use this method if there are multiple Oracle databases to be monitored. You must specify the Oracle server names in a configuration file.
1. Log in via SSH to the Box.
2. Delete the files found in the folder below based on the version of your Box.
/usr/lib/oracle/11.2/client64/network/admin/
or
/usr/lib/oracle/12.2/client64/network/admin/
3. Copy the sqlnet.ora configuration file to the same folder and specify the Oracle server names in the file based on 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=fr "
DIRECTORY_SERVER_TYPE = OID
4. Copy the ldap.ora configuration file to the same folder and specify the LDAP properties in the file based on 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 = 2NAMES.DIRECTORY_PATH= (LDAP)
Step 2: Create a dedicated user for monitoring Oracle
1. Go to the Oracle console.
2. Run the commands below to create the dedicated user.
Replace the <User> and <Password> values with the login and password of the user.
create user <User> identified by <Password>;
grant create session to <User>;
grant select any dictionary to <User>;
grant select on SYS.V_$SYSSTAT to <User>;
grant select on SYS.V_$INSTANCE to <User>;
grant select on SYS.V_$LOG to <User>;
grant select on SYS.DBA_DATA_FILES to <User>;
grant select on SYS.DBA_FREE_SPACE to <User>;
Step 3: Set up monitoring in EV Observe using the service templates specific to Oracle
See the general procedure: How to deploy a service using a service template