Systemwalker Service Quality Coordinator User's Guide

9.1 How to Set up Oracle Database Server

To make Oracle a management target, define the following keys for the [ORA] section:

Item	Description	Definition example
[ORA]	The section name. Do not change this item.	ORA
DCAID	A specific ID for monitoring Oracle. Do not change this item.	"ORA"
INTERVAL	The collection interval in minutes.	5
SID	Set the Oracle instance name. Point The name that is specified here is attached to the beginning of the resource ID.	ORCL
USERNAME	Enter the ID for the user that will access Oracle and obtain information from the dynamic performance view (an administrator user that has been granted a DBA role). The Oracle default is usually "system". If the default is to be changed, refer to "9.1.1 How to create a new user that can access the Oracle dynamic performance view".	System
PASS	Enter the password for the user that will access Oracle and obtain information from the dynamic performance view (an administrator user that has been granted a DBA role). The Oracle default is usually "manager". If the default is to be changed, refer to "9.1.1 How to create a new user that can access the Oracle dynamic performance view"	manager
VER	Specify the version of the Oracle instance to be monitored. Use the format "X.X.X".	9.2.0
ORAHOME	Set the value of ORACLE_HOME for the Oracle database to be monitored.	/opt/app/9iee/product/9.2.0

Definition example

:

#########################################

# Oracle Information

[ORA]
DCAID="ORA"
INTERVAL = 5
SID = ORCL
USERNAME = system
PASS = manager
VER = 9.2.0
ORAHOME="/opt/app/9iee/product/9.2.0"

:

Point

To monitor more than one instance of Oracle, perform the following steps:

1. Add the relevant section and set its parameters.

   • The section can be freely defined within a template, but the user should ensure that the section name is not duplicated. In the following example, the section name "ORA2" will be added.

   • Even when monitoring multiple Oracle instances, the value of the DCAID key must remain as "ORA".

   Definition example

   :

   #########################################

   # Oracle Information

   [ORA]
   DCAID="ORA"
   INTERVAL = 5
   SID = ORCL
   USERNAME = system
   PASS = manager
   VER = 9.2.0
   ORAHOME="/opt/app/9iee/product/9.2.0"

   [ORA2]

   DCAID="ORA"

   INTERVAL = 5

   SID = ORCL2

   USERNAME = system

   PASS = manager

   VER = 9.2.0

   ORAHOME="/opt/app/9iee/product/9.2.0"

   :

   
   

2. Add the section added in step 1 above to the GROUP key of the ATTR::DB section. If the definition is as shown in the above example, amend as follows:

   Before change

   :

   [ATTR::DB]

   GROUP="SYMSAR,SYMPS,ORA"

   :

   After change

   :

   [ATTR::DB]

   GROUP="SYMSAR,SYMPS,ORA,ORA2"

   :