ETERNUS SF Disk Space Monitor User's Guide - Microsoft(R) Windows Server(TM) 2003/Solaris(TM) Operating System/Linux - 13.0

15.3 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"
SID	Set the Oracle instance name. 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 Section 15.3.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 Section 15.3.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.0.2
ORAHOME	Set the value of ORACLE_HOME for the Oracle database to be monitored.	/opt/app/9iee/product/9.2.0

The following is a sample definition:

:

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

# Oracle Information

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

:

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"

   SID = ORCL

   USERNAME = system

   PASS = manager

   VER = 9.0.2

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

   [ORA2]

   DCAID="ORA"

   SID = ORCL2

   USERNAME = system

   PASS = manager

   VER = 9.0.2

   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 definition:

   :

   [ATTR::DB]

   GROUP="SYMSAR,SYMPS,ORA"

   :

   After definition:

   :

   [ATTR::DB]

   GROUP="SYMSAR,SYMPS,ORA,ORA2"

   :

15.3.1 How to create a new user that can access the Oracle dynamic performance view

This operation is not required if the default ID and PASSWORD for Oracle are used.

To create a new user that can access the Oracle dynamic performance view, enter the following SQL command from svrmgr1 using an Oracle administrator ID (usually "system").

In the following example, the necessary privileges are given to a user with ID "id1" and password "pass1".

create user id1 identified by pass1;

grant dba to id1;

grant connect to id1;