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.
- Connect to the ServiceNav Box via SSH
- 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
- 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 = 2NAMES.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