IBM Performance Management

Running the krzgrant.sql script

Before you begin

If you do not run the krzgrant.sql script, an event is issued in the agent event workspace.
To complete the installation procedure, see Installing your agents.

After the installation, you can find the krzgrant.sql script in the following directory:

Windows x86 systems: install_dir\TMAITM6
Windows x64 systems: install_dir\TMAITM6_X64
UNIX and Linux systems: install_dir/arch/rz/bin

Where:

install_dir: Installation directory for the Oracle Database agent.
arch: IBM® Tivoli® Monitoring system architecture identifier. For example, lx8266 represents Linux Intel v2.6 (64 bit).

The krzgrant.sql script has the following usage: krzgrant.sql user_ID temporary_directory

Where:

user_ID: The ID of the Oracle user. This user ID must be created before running this sql file. Example value: tivoli.
temporary_directory: The name of the temporary directory that contains the krzagent.log output file of the krzgrant.sql script. This directory must exist before running this SQL script. Example value:install_dir/tmp.

You must have the Oracle database administrator (DBA) authorization role and write permission to the temporary directory to perform the following procedure.

Procedure

From the command line, run the commands to set environment variables.
- Windows systems:
```
SET ORACLE_SID= sid
SET ORACLE_HOME= home
```
- UNIX or Linux systems
```
ORACLE_SID = sid
export ORACLE_SID
ORACLE_HOME = home
export ORACLE_HOME
```
Where:
sid

Oracle system identifier, which is case-sensitive.

home

Home directory for the monitored Oracle instance.
From the same command-line window where you set environment variables, start the Oracle SQL Plus or an alternative tool that you use to issue SQL statements.
Log on to the Oracle database as a user that has Oracle DBA privileges.
Navigate to the directory that contains the krzgrant.sql script and run the following command to grant select privileges:
```
@krzgrant.sql user_ID temporary_directory
```
The output is logged in the krzagent.log file in the temporary directory. This log records the views and tables to which the Oracle Database agent is granted select privileges.

After the privileges are successfully granted, you can configure and start the Oracle Database agent.