Set up an Oracle database to work with the Rational® Engineering Lifecycle
Manager Jazz™ Team Server,
the Rational Engineering Lifecycle
Manager,
and the Configuration Management application.
Before you begin
To create and set up an Oracle database, it is assumed that
the user who is preparing the database must have database administration
authority over the database and that the database, tablespace storage,
and appropriate storage configuration is created by a user with system
administration authority. Also one of the following supported Oracle
editions must be installed on a computer to be used as the database
server. This computer can be different from the one that the
Jazz Team Server runs
on:
- Oracle Database 11g Standard or Enterprise Edition Release 2
- Oracle Database 10g Standard or Enterprise Edition Release 2
Note: The required Java™ Database
Connectivity (JDBC) driver for both Oracle 10g and 11g is ojdbc6.jar
11.2.0.3 or higher. Also always update the database to the latest
database version. For example, if the database server is 11.2, then
you should be running 11.2.0.3 or later.
Important: The
following configuration parameters and tablespace options are examples
and might not entirely apply to your environment. For example, if
you cannot use the AUTOEXTEND setting, then the files must be large
enough to allow for growth. Or if you cannot use the UNLIMITED size
quota for the Jazz Team Server database
user, then make sure to allow enough space for rapid growth.
Important: If you install the
Rational Engineering Lifecycle
Manager applications
on the same computer or distributed platforms, you can either create
separate databases for each application or you can use the same database
for all applications. However, you must create a separate tablespace
and a database user who is associated with that tablespace for each
application.
The examples in this topic are for one Oracle database
with separate database users who are dedicated to each application.
Note: The
database that you create for the Jazz Team Server and
all Rational Engineering Lifecycle
Manager applications
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 DB setup.
Procedure
- As a system administrator, create a database
with UTF8 encoding for the Jazz Team Server and
all applications.
- Open an SQL *Plus window, and create the database tablespaces:
CREATE TABLESPACE <relmjts user tablespace>
DATAFILE '<path and name of .dbf file>'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE TEMPORARY TABLESPACE <relmjts user temp tablespace>
TEMPFILE '<path and name of the temp .dbf file>'
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
- If you are installing all Rational Engineering Lifecycle
Manager applications,
you must repeat the previous step 2 times to create a separate tablespace
for Rational Engineering Lifecycle
Manager JTS
(relmjts), Rational Engineering Lifecycle
Manager (relm),
and Configuration Management application (vvc). In the Oracle Enterprise
Manager Database Control, verify the tablespaces you created are displayed
and accessible.
- Create an Oracle database user for each
new tablespace.
After the table spaces are created,
a special Oracle user must be created for each application to use
the Oracle database. For multiple Jazz servers
that run on one Oracle database, an Oracle database user must be created
for each application. The Oracle database user must be able to create
database objects in its tablespace (either unlimited or with a space
quota) with privileges to create session, table, procedure, and views.
In these examples replace the phrases in the angle brackets.CREATE USER <relmjts db user> IDENTIFIED BY <password> DEFAULT TABLESPACE <relmjts user tablespace> QUOTA UNLIMITED ON <relmjts user tablespace> TEMPORARY TABLESPACE <relmjts user temp tablespace>;
After
the user is created, give the user the necessary permissions needed
to initialize the Jazz database.
The following SQL command can be used to grant the appropriate permissions:GRANT CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW TO <relmjts db user>;
Note: The
creation of the warehouse on Oracle requires more permissions as compared
to other databases. When you specify the database user in the connection
spec for data warehouse, ensure that the database user has DBA permissions.
For more information, see
Completing the installation. Also, it is assumed
that a tablespace named "USERS" already exists. This is a default
Oracle tablespace. If this tablespace does not exist in your Oracle
database, use the following command to create it.
CREATE TABLESPACE USERS
DATAFILE '<path and name of .dbf file>'
SIZE <tablespace size> AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
- Create an environment variable named ORACLE_JDBC_DRIVER_FILE and
point to the ojdbc6.jar JDBC driver. The location
can vary depending on the Oracle product and operating system. You
can download the supported Oracle JDBC driver (ojdbc6.jar 11.2.0.3)
from www.oracle.com.
- Click .
- Click the Advanced tab, and then
click Environment Variables.
- In the System variables list,
click New.
- In the Variable name enter ORACLE_JDBC_DRIVER_FILE,
and in the Variable value enter C:\Path_to_JDBC_dirver\ojdbc6.jar.
- On Linux systems,
add the following environment variable declaration:
ORACLE_JDBC_DRIVER_FILE =.;Path_to_JDBC_dirver/ojdbc6.jar
Note: Rational Engineering Lifecycle
Manager does
not support JRE 5.0. The version of supported JREs are 6.0 and 7.0.
The
ojdbc5.jar class library requires JRE 5.0
and the
ojdbc6.jar class library requires JRE
6.0 or later. You must use
ojdbc6.jar.
If you
are using WebSphere® Application
Server, you must also add a custom property that points to the ojdbc6.jar JDBC
driver. For more information, see Setting up WebSphere Application Server for Rational Engineering Lifecycle Manager.
- To configure your database connection and create database
tables complete one of these steps:
- If you are using Tomcat, start the server and continue
with Running the Jazz Team Server setup wizard for Rational Engineering Lifecycle Manager applications.
- If you are deploying WebSphere Application
Server, see Running the Jazz Team Server setup wizard for Rational Engineering Lifecycle Manager applications.