Configuring an Oracle database for use with Rational Quality Manager

Follow these instructions to configure an Oracle 10g database for use with Rational® Quality Manager.

Points to consider:

Note: IBM® Rational Team Concert provides additional information on configuring an Oracle database. To view this information, see Setting up an Oracle database.

To configure Oracle for use with Rational Quality Manager:

  1. If necessary, install Oracle, following the instructions in the Oracle installation guide.
  2. Create an Oracle database.

    On the Oracle server machine, start the Database Configuration Assistant and create a new database. Work with your Database Administrator if you are unsure how to do this task.

  3. To improve database performance, create an Oracle tablespace of at least 1 GB at an appropriate location on the Oracle server.
    The example below shows a create statement executed on a Windows® machine:
    CREATE BIGFILE TABLESPACE oracle_tbs DATAFILE 'c:\oracle_tbs\oracle_tbs.dbf' SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    Note: The directory path (in this example c:\oracle_tbs) must already exist. It is not necessary to create a separate special tablespace. You can use the Oracle default USERS tablespace, but Oracle performs better with a pre-allocated space on the disk that it manages.
  4. Create a special Oracle user for Rational Quality Manager.
    CREATE USER RQMDBuser IDENTIFIED BY RQMDBpswd DEFAULT TABLESPACE oracle_tbs

    In the previous example, the user name is RQMDBUser and the password (IDENTIFIED BY in Oracle terms), is RQMDBpswd.

  5. After you create RQMDBUser, grant the user the system permissions necessary to perform the following actions:
    • Create a session.
    • Create, alter, and drop tables and indexes.
    • Insert, update, and delete from the tables created.
  6. Copy the Oracle ojdbc14.jar file from the machine where Oracle is installed to the Rational Quality Manager server machine.
    1. Navigate to <installation_dir>/RQM/server and create a directory called oracle.
    2. Copy the ojdbc14.jar file into the oracle directory.
  7. Configure Rational Quality Manager database properties.
    1. Navigate to <installation_dir>/RQM/server and find the teamserver.oracle.properties file.
    2. In the teamserver.oracle.properties file, change the database host name (or IP), database name, and the Oracle user name and password as shown below:

      Default teamserver.oracle.properties file:

      com.ibm.team.repository.db.vendor = ORACLE
      com.ibm.team.repository.db.jdbc.location=thin:jazzDBuser/{password}@//oracleserver.example.com:1521/ORCL
      com.ibm.team.repository.db.jdbc.password=jazzDBpswd

      The teamserver.oracle.properties file after being modified for Rational Quality Manager:

      com.ibm.team.repository.db.vendor = ORACLE
      com.ibm.team.repository.db.jdbc.location=thin:RQMuser/{password}@//9.34.23.81:1521/RQMDB
      com.ibm.team.repository.db.jdbc.password=password

      where

      RQMuser is a user with appropriate DB access rights.

      RQMDB is the name of the Oracle database.

      9.34.23.81:1521 is the IP address and port number of the Oracle server.

      password is the password of the Oracle user.

      Note: The // in front of the IP address above is needed when the RQM server and Oracle are installed on different machines.

      Also, do not change the password={password} text in the property: com.ibm.team.repository.db.jdbc.location.

    3. Add the following lines to the “teamserver.oracle.properties” file.
      #websphere port configuration
      com.ibm.team.repository.server.repourl.port.http=9080
      com.ibm.team.repository.server.repourl.port.https=9443 
      Note: These are the default port numbers. If you have not installed WAS and you use other port numbers, you will need to make these port numbers match the port numbers assigned in WAS.
    4. Save the teamserver.oracle.properties file.
    5. Rename the teamserver.properties file, also located in <installation_dir>/RQM/server, to teamserver.properties.BAK.
    6. Rename the teamserver.oracle.properties file to teamserver.properties and save.
  8. Create database tables.

    Now that the teamserver.properties file has been modified, you must run a Jazz™ utility called repotools to create the database tables. The repotools.bat utility file is located in <installation_dir>/RQM/server.

    Open a command prompt window and run repotools with the following arguments:

    repotools -createTables logFile=c:/tmp/repotools.log

Feedback