Setting up an Oracle database for Design
Management Server involves configuring the database system, creating the
database, and setting up tablespaces and users
Before you begin
Install Oracle on the database server and make sure that you
have the necessary permissions to access the database server and to
create and modify databases. Ensure that the database server is properly
configured; for example, you may need to set the following system
variables:
- Set ORACLE_HOME to the Oracle installation
directory.
- Set ORACLE_SID to the Oracle system ID for
the database server.
- Set ORACLE_JDBC_DRIVER_FILE to the location
of the Oracle JDBC JAR file, which is named ojdbc5.jar.
Important: The following
configuration parameters and tablespace options are examples. Your
environment might require different parameters and options.
Procedure
- Using the Oracle SQL*Plus command-line tool or the database
configuration assistant, create an Oracle database with UTF-8 encoding
for the Jazz™ Team Server (JTS), Design
Management Server (DM), Configuration Management Server (VVC), and another
database for the data warehouse (DW). Use Shared
Server Mode as the connection mode. For specifics, see
the Oracle database help.
- Using SQL*Plus, create two tablespaces in each database. The following code is an example:
CREATE TABLESPACE JTS
DATAFILE 'C:\oraclexe\app\oracle\oradata\jts01.dbf'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE TEMPORARY TABLESPACE JTS_TEMP
TEMPFILE'C:\oraclexe\app\oracle\oradata\jtstemp01.dbf'
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
CREATE TABLESPACE DM
DATAFILE 'C:\oraclexe\app\oracle\oradata\dm01.dbf'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE TEMPORARY TABLESPACE DM_TEMP
TEMPFILE'C:\oraclexe\app\oracle\oradata\dmtemp01.dbf'
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
CREATE TABLESPACE VVC
DATAFILE 'C:\oraclexe\app\oracle\oradata\vvc01.dbf'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE TEMPORARY TABLESPACE VVC_TEMP
TEMPFILE'C:\oraclexe\app\oracle\oradata\vvctemp01.dbf'
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
CREATE TABLESPACE DW
DATAFILE 'C:\oraclexe\app\oracle\oradata\dw01.dbf'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE TEMPORARY TABLESPACE DW_TEMP
TEMPFILE'C:\oraclexe\app\oracle\oradata\dwtemp01.dbf'
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
- Create a user for each tablespace and grant the users permissions
to work with the database. The following code is an example:
CREATE USER JTSUSER IDENTIFIED BY JTSUSER DEFAULT TABLESPACE JTS QUOTA UNLIMITED ON JTS TEMPORARY TABLESPACE JTS_TEMP;
CREATE USER DMUSER IDENTIFIED BY DMUSER DEFAULT TABLESPACE DM QUOTA UNLIMITED ON DM TEMPORARY TABLESPACE DM_TEMP;
CREATE USER VVCUSER IDENTIFIED BY VVCUSER DEFAULT TABLESPACE VVC QUOTA UNLIMITED ON VVC TEMPORARY TABLESPACE VVC_TEMP;
CREATE USER DWUSER IDENTIFIED BY DWUSER DEFAULT TABLESPACE DW QUOTA UNLIMITED ON DW TEMPORARY TABLESPACE DW_TEMP;
GRANT CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW TO JTSUSER;
GRANT CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW TO DMUSER;
GRANT CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW TO VVCUSER;
GRANT CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW TO DWUSER;