Creating the project results database by using Oracle

You can create a project results database that uses Oracle.

Before you begin

For information about the supported versions of the database, see the Supported Software > Database section in Software Product Capability Reports.

About this task

The database that you create for Rational® Integration Tester must be formatted to use UTF-8 as the character set. By default, Oracle does not create a database with the UTF-8 character set. When you create a new database, ensure that you select AL32UTF8 in the Oracle database setup.

Procedure

  1. Create a user within a suitably sized tablespace.
  2. Grant the following privileges to the new user: CONNECT, CREATE TRIGGER, CREATE PROCEDURE, CREATE TABLE, CREATE SEQUENCE, CREATE VIEW, and CREATE SYNONYM.
  3. Logged in as the newly created user, run the ghtester_oracle.sql script against your database.
    Note: There are various ways to run the script against the database. For example, by using Oracle SQL Command Line utility, run a command of the following format: @"<Installation Directory>/scripts/ghtester_oracle.sql"