Creating the project results database by using Oracle

You can create a project results database that uses Oracle.

For information about the supported versions of the database, see the Supported Software > Database section in Supported software

The database that you create for IBM® DevOps Test Integrations and APIs (Test Integrations and APIs) 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.

  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"