Monitoring an Oracle database

ServiceNav has an embedded Oracle client. For successful monitoring of Oracle…

Prerequisites

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)

 

Facebook
Google+
Google+
http://servicenav.coservit.com/documentation/monitoring-an-oracle-database/
Youtube
Youtube
LinkedIn