Running the krzgrant.sql script

Before you begin

If you do not run the krzgrant.sql script, an event is raised 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:

install_dir\TMAITM6_X64
install_dir/architecture/rz/bin

where:

install_dir: Installation directory for the Oracle Database agent.
architecture: The IBM Application Performance Management or Cloud APM system architecture identifier. For example, lx8266 represents Linux Intel v2.6 (64-bit). For a complete list of the architecture codes, see the install_dir/registry/archdsc.tbl file.

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 you run 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 you run 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.
- ```
SET ORACLE_SID= sid
SET ORACLE_HOME= home
```
- ```
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.
Go 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.