Setting up an Oracle database

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:
Important: The following configuration parameters and tablespace options are examples. Your environment might require different parameters and options.

Procedure

  1. 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.
  2. 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;
  3. 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;

Feedback