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.
- Your system meets the minimum hardware and software requirements
for Oracle.
- The user who is setting up the Oracle database has administrative
privileges.
- 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.
- 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
- 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.
- 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.
- 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
- Copy the JDB driver:
- 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.
- 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.
- (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