Setting up an Oracle database

Set up an Oracle database to work with the Jazz™ Team Server, Design Management (DM), and Configuration Management (VVC) applications.

Before you begin

Procedure

  1. As a system administrator, create a database with UTF-8 encoding for the Jazz Team Server and all applications.
    1. Start the Database Configuration Assistant wizard and on the Welcome page click Next.
    2. On the Operations page, select Create a Database and then click Next.
    3. On the Templates page, select Custom Database and click Next.
    4. In both the Global Database Name and SID fields, enter a name for the content storage database, for example, DMDB. Click Next.
    5. To configure the database control, enter the required information for alert notification and optionally enable the daily disk backup schedule. To continue without database control configuration, clear the check box next to Configure Enterprise Manager and then click Next.
    6. On the Database Credentials page, choose an option for your user account, and then click Next.
      Note: Oracle password complexity policy requires that passwords should have minimum of 8 characters in length. In addition, the password must contain at least one upper case character, one lower case character, and one digit.
    7. On the next page, select a storage type and location for database files. Click Next.
    8. On the next page, choose a recovery option for the database, and then click Next.
    9. On the next page, specify whether or not to add the Sample Schemas to your database. Click Next.
    10. On the next page, click the Character Sets tab and select Use Unicode (AL32UTF8). Click Next.
      Note: Setting character set to Unicode (AL32UTF8) enables you to store multiple language groups.
    11. On the Database Storage page verify or change the database objects and click Next.
    12. On the next page click Finish to create the database.
    13. On the Confirmation window that opens, optionally save the page as an HTML file, and then click OK. A progress bar is displayed to show the database creation progress.
  2. 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 Server > Tablespaces 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.

  3. 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..
  4. 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) from www.oracle.com.
    1. Click Start > Control Panel > System.
    2. Click the Advanced tab, and then click Environment Variables.
    3. In the System variables list, click New.
    4. In the Variable name enter ORACLE_JDBC_DRIVER_FILE, and in the Variable value enter C:\Path_to_JDBC_dirver\ojdbc6.jar.
    1. On Unix systems, add the following environment variable declaration:
      ORACLE_JDBC_DRIVER_FILE =.:Path_to_JDBC_dirver/ojdbc6.jar
      Note: Design Management 4.0.x, no longer supports 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 Deploying the Design Management Server on WebSphere Application Server.

  5. To configure your database connection and create database tables complete one of these steps:
    1. If you are using Tomcat, start the server and continue with Setting up and configuring the Design Management Server.
    2. If you are deploying WebSphere Application Server, see Deploying the Design Management Server on WebSphere Application Server, and then continue with Setting up and configuring the Design Management Server.

Feedback