These are the instructions for creating databases for lifecycle
management in Oracle for IBM® Rational® Asset Manager. These databases are used by the included version of IBM Rational Team Concert.
Before you begin
If
you are using an existing Rational Team Concert server,
you can skip this task because Rational Team Concert already
have the databases.
Oracle
must already be installed and running.
You must create the databases
for asset lifecycles on the same host as the database for assets.
Procedure
To set up the Oracle databases for asset lifecycles:
- Using the Oracle Database Configuration Assistant,
follow the steps in the wizard to create a new database.
- The database must be on the same host as the database
that you created for assets.
- Use global database name ccmdb,
and a system identifier (SID) ccmdb. The
global database name and the system identifier must be the same.
- On the Character Sets page, select Use Unicode
(AL32UTF8).
- Also on the Character Sets page, for National Character
Set, select UTF8 - Unicode 3.0 UTF-8.
- Complete the other pages in the wizard, accepting the
default values.
- Create a tablespace. The tablespace
must have the following properties:
- A name other than oracle_tbs;
- A location in a different directory than the oracle_tbs tablespace;
- A size of at least 1 GB; for larger installations, you might need
more space.
The following command for a Windows computer shows a sample create statement:
CREATE BIGFILE TABLESPACE jazz_tbs DATAFILE 'D:\jazz_tbs\jazz_tbs.dbf' SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE
Note: In
the above command, the directory D:\jazz_tbs\ must
exist.
- Create a database user:
- Open Database Control.
- Navigate to the Users page.
(In Oracle 10.2(g), click Administration, then Users;
in Oracle 11(g), click Server, then in the
Security section click Users.)
- Create a user that meets the following qualifications:
- You can use any valid user name. Unlike the database for assets,
a specific user name is not required.
- The user has the RESOURCE and CONNECT roles.
- The user's quota setting is unlimited.
- The default tablespace for the user is the tablespace that you
created in step 2.
- The user must have the following permissions:
- ALTER ANY INDEX
- ALTER ANY TABLE
- CREATE ANY INDEX
- CREATE DATABASE LINK
- CREATE MATERIALIZED VIEW
- CREATE PROCEDURE
- CREATE PUBLIC SYNONYM
- CREATE ROLE
- CREATE SEQUENCE
- CREATE SESSION
- CREATE SYNONYM
- CREATE TABLE
- CREATE TRIGGER
- CREATE TYPE
- CREATE VIEW
- DELETE ANY TABLE
- DROP ANY INDEX
- DROP ANY TABLE
- INSERT ANY TABLE
- UNLIMITED TABLESPACE
- UPDATE ANY TABLE
Tip: Oracle provides a default
user named "Scott" that has many of the appropriate permissions. You
can use this default user as the basis for your new user account.
- Repeat the above steps to create a database named jtsdb.