Monitoring an Oracle database

image_pdfimage_print

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