Open an SQL *Plus window and log in as SYSTEM or SYSDBA. To create a tablespace for Jazz Team Server, enter the following
command. Replace JTS with the tablespace name, ORACLE_BASE with
the absolute path where Oracle is installed, DMDB with
the database name you created in step 1, and JTS.DBF with
the datafile name that you want to create.
CREATE TABLESPACE JTS
DATAFILE 'ORACLE_BASE/oradata/CLMDB/JTS.DBF'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
To create a temporary tablespace for Jazz
Team Server, enter the following command. Replace JTS_TEMP with
the temporary tablespace name, ORACLE_BASE with
the absolute path where Oracle is installed, CLMDB with
the database name you created in step 1, and JTS_TEMP.DBF with
the temporary file name that you want to create.CREATE TEMPORARY TABLESPACE JTS_TEMP
TEMPFILE 'ORACLE_BASE/oradata/CLMDB/JTS_TEMP.DBF'
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
To create a tablespace for the Design Management application,
enter the following command. Replace DM with the
tablespace name, ORACLE_BASE with the absolute
path where Oracle is installed, DMDB with the database
name you created in step 1, and DM.DBF with the
datafile name that you want to create.
CREATE TABLESPACE DM
DATAFILE 'ORACLE_BASE/oradata/DMDB/DM.DBF'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
To create a temporary tablespace for the
Design Management application, enter the following command. Replace DM_TEMP with
the temporary tablespace name, ORACLE_BASE with
the absolute path where Oracle is installed, DMDB with
the database name you created in step 1, and DM_TEMP.DBF with
the temporary file name that you want to create.CREATE TEMPORARY TABLESPACE DM_TEMP
TEMPFILE 'ORACLE_BASE/oradata/DMDB/DM_TEMP.DBF'
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
To create a tablespace for the Configuration Management application,
enter the following command. Replace VVC with the
tablespace name, ORACLE_BASE with the absolute
path where Oracle is installed, DMDB with the database
name you created in step 1, and VVC.DBF with the
datafile name that you want to create.
CREATE TABLESPACE VVC
DATAFILE 'ORACLE_BASE/oradata/DMDB/VVC.DBF'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
To create a temporary tablespace for the
Configuration Management application, enter the following command.
Replace VVC_TEMP with the temporary tablespace
name, ORACLE_BASE with the absolute path where
Oracle is installed, DMDB with the database name
you created in step 1, and VVC_TEMP.DBF with the
temporary file name that you want to create.CREATE TEMPORARY TABLESPACE VVC_TEMP
TEMPFILE 'ORACLE_BASE/oradata/DMDB/VVC_TEMP.DBF'
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
To create a tablespace for the common data warehouse, enter
the following command. Replace DW with the tablespace
name, ORACLE_BASE with the absolute path where
Oracle is installed, CLMDB with the database name
you created in step 1, and DW.DBF with the datafile
name that you want to create.
CREATE TABLESPACE DW
DATAFILE 'ORACLE_BASE/oradata/DMDB/DW.DBF'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
To create a temporary tablespace for the
common data warehouse, enter the following command. Replace DW_TEMP with
the temporary tablespace name, ORACLE_BASE with
the absolute path where Oracle is installed, DMDB with
the database name you created in step 1, and DW_TEMP.DBF with
the temporary file name that you want to create.CREATE TEMPORARY TABLESPACE DW_TEMP
TEMPFILE 'ORACLE_BASE/oradata/CLMDB/DW_TEMP.DBF'
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
Note: In
the Oracle Enterprise Manager Database Control, click and verify that the tablespaces you created are displayed
and accessible. Also ensure that the default Oracle tablespace named
USERS already exist. If this tablespace does not exist in your Oracle
database, create it.
Create an Oracle database user for each
new tablespace. After the tablespaces 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.
To
create a user for Jazz Team Server tablespace and to grant the required
permissions, enter the following commands:
CREATE USER JTS_DB_USER IDENTIFIED BY Passw0rd DEFAULT TABLESPACE JTS QUOTA UNLIMITED ON JTS TEMPORARY TABLESPACE JTS_TEMP;
GRANT CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW TO JTS_DB_USER;
To
create a user for Design Management application tablespace and to
grant the required permissions, enter the following commands:
CREATE USER DM_DB_USER IDENTIFIED BY Passw0rd DEFAULT TABLESPACE DM QUOTA UNLIMITED ON DM TEMPORARY TABLESPACE DM_TEMP;
GRANT CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW TO DM_DB_USER;
To
create a user for Configuration Management application tablespace
and to grant the required permissions, enter the following commands:
CREATE USER VVC_DB_USER IDENTIFIED BY Passw0rd DEFAULT TABLESPACE VVC QUOTA UNLIMITED ON VVC TEMPORARY TABLESPACE VVC_TEMP;
GRANT CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW TO VVC_DB_USER;
To
create a user for common data warehouse tablespace and to grant the
required permissions, enter the following commands:
CREATE USER DW_USER IDENTIFIED BY Passw0rd DEFAULT TABLESPACE DW QUOTA UNLIMITED ON DW TEMPORARY TABLESPACE DW_TEMP;
GRANT DBA TO DW_USER;
Note: The
creation of the data 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. You can change this permission after the
data warehouse is created..