Monitoring Oracle Databases
ServiceNav has an embedded Oracle client. For successful monitoring of Oracle…
Configure the ServiceNav Box to communicate with the Oracle database. For this you either edit/ create a file tnsname.ora or connect to a directory with Oracle sqlnet.ora and ldap.ora (see your DBA).
Using a tnsnames.ora file
The tnsname.ora file informs the Box ServiceNav how to access the Oracle database you want to monitor.
- Login using SSH on the ServiceNav Box
- Copy the tnsnames.ora file in the directory: /usr/lib/oracle/11.2/client64/network/admin/
- For older version of Box Viadéis Services, the directory above does not exist, so you have to copy the tnsnames.ora file here: /usr/lib/oracle/11.2/client/network/admin
File rights: reading for all users (755): chmod + r tnsnames.ora.
Using a directory and sqlnet.ora Oracle database ldap.ora
Using ldap for Oracle allows you to bypass the tnsname.ora file; useful when there are many Oracle databases to monitor.
- Login SSH on Viadéis Services Box
- Delete the files in the directory: /usr/lib/oracle/11.2/client64/network/admin/
- Then add the sqlnet.ora file in this directory: /usr/lib/oracle/11.2/client64/network/admin/ This defines the Oracle name servers is to configure based on your infrastructure:
# Sqlnet.ora Network Configuration File:
#C: \ Oracle \ ora10g \ network \ admin \ sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = coservit.local
# SQLNET.AUTHENTICATION_SERVICES = (NTS)
sqlnet.expire_time = 2
NAMES.DIRECTORY_PATH = (LDAP)