Setting up an Oracle database

Set up a supported Oracle database to work with the Rational Requirements Composer 2.0 Server.

Before you begin

Check for the following prerequisites before you set up your Oracle database to work with Rational Requirements Composer Server. Talk to your Oracle database administrator for additional help.
  1. Your system meets the minimum hardware and software requirements for Oracle.
  2. The user who is setting up the Oracle database has administrative privileges.
  3. Oracle is installed and running on the machine that will be used as the database server.
    Note: The machine that you wish to use as the database server can be different from the one on which the Rational® Requirements Composer 2.0 Server is running.
  4. A default database exists on the Oracle database server.
    Tip: When you install Oracle, you have the option to create a database automatically.

About this task

To setup an Oracle database, you must first create a tablespace to improve performance and then create an Oracle user linked to that tablespace. Note that UTF-8 encoding is essential to ensure proper handling of Unicode content.

Procedure

  1. Create a tablespace:
    Note: The tablespace can have any of these properties:
    • Name other than oracle_tbs
    • Location in another directory
    • Size greater than 1GB; however, you must allocate more space for large installations
    Use the following statement on a Windows machine:
    CREATE BIGFILE TABLESPACE oracle_tbs DATAFILE 'D:\oracle_tbs\oracle_tbs.dbf' SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    Important: The directory path (in this example, D:\oracle_tbs) must exist. You do not need to create a separate special tablespace. While you can use the Oracle default USERS tablespace, note that Oracle performs better with pre-allocated space on the disk that it manages.
  2. Create an Oracle user:
    After creating the tablespace, use the following statement to create a special Oracle user for Jazz to use the Oracle database.
    CREATE USER jazzDBuser IDENTIFIED BY jazzDBpswd DEFAULT TABLESPACE oracle_tbs
    Note: In this example, the user has the name jazzDBuser and password (IDENTIFIED BY in Oracle terms) jazzDBpswd and exists in the tablespace created in step 1.
  3. Assign permission to the Oracle user:
    The following SQL commands give necessary permissions to the Oracle user for initializing the Jazz database.
    GRANT CREATE SESSION TO jazzDBuser;
    GRANT CREATE TABLE, ALTER ANY TABLE, DROP ANY TABLE, CREATE ANY INDEX, ALTER ANY INDEX, DROP ANY INDEX TO jazzDBuser;
    GRANT INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO jazzDBuser;
    GRANT CREATE PROCEDURE TO jazzDBuser;
    GRANT CREATE VIEW TO jazzDBuser;
    Note: If a "case sensitivity" error appears when configuring an Oracle DB, you might need to grant the database user system administration authority. One way to do this is to issue the following commands:
    GRANT "DBA" TO "user" WITH ADMIN OPTION;
    ALTER USER "user" DEFAULT ROLE  ALL
  4. Copy the JDB driver:
    1. Locate the RRCS/server directory on the machine on which the Rational Requirements Composer 2.0 Server is installed, and create a directory called oracle.
    2. Locate the Oracle JDBC driver JAR file, ojdbc14.jar. The location of this file can vary depending on the Oracle product and operating system. Copy this file to the directory oracle created in the step above.
  5. (Optional step: Required ONLY if you are using WebSphere Application Server) Creating custom property in WebSphere: Configure the property ORACLE_JDBC and set the value of its absolute file path (not URL) to that of the Oracle JDBC driver; this path was set in step 4 above. If the path contains a space, use the short name (i.e.: a name that includes ~1)

    Return to the installation road map


Feedback