It's all about the answers!

Ask a question

Oracle configuration with CLM


Sterling Ferguson-II (1.6k7247254) | asked Nov 28 '12, 3:36 p.m.
edited Nov 28 '12, 4:19 p.m.

Procedure

  1. As a system administrator, create a database with UTF8 encoding for the Jazz Team Server and all applications.
  2. Open an SQL *Plus window, and create the database tablespaces:
    CREATE TABLESPACE <jts user tablespace> 
    DATAFILE '<path and name of .dbf file>' 
    SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;		
    		
    		
    CREATE TEMPORARY TABLESPACE <jts user temp tablespace> 
    TEMPFILE '<path and name of the temp .dbf file>' 
    SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
  3. If you are installing all CLM applications, you must repeat the previous step 3 times to create a separate tablespace for JTS, CCM, and QM. In the Oracle Enterprise Manager Database Control, verify the tablespaces you created are displayed and accessible.
  4. Note: Do not create the data warehouse tablespace at this stage. The data warehouse tablespace is created during the server setup process.
???

Step 3 states JTS again. Is this an error? Was this Also, step 4 states that the data warehouse will be created later...We don't have consistent access to this Oracle admin, do we tell him to create a DB "space" now?
With DB2, we setup 4 DBs (JTS/DW/CCM/QM). The above instructions seem to state creation of JTS, then JTS (again), CCM and QM...and the datawarehouse to be created later...(which makes 5).

One answer



permanent link
Ralph Schoon (56.3k23642) | answered Nov 29 '12, 3:26 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Sterling, you have to do the steps for JTS, CCM and QM - that means you do it three times. You have 3 databases (RM currently stores its data in the JTS DB). You will need an additional database for the data warehouse. Please see https://jazz.net/library/article/831 . It uses DB2 but essentially there is no difference in the concept.

Comments
Sterling Ferguson-II commented Nov 29 '12, 8:30 a.m.

Thanks Ralph,

It looks like the documentation for Oracle needs to be revisited. It also tells you to not create a database for the warehouse, that part will be done during setup. Then, it tells you before starting setup, you need to have created the database for the warehouse.

I'll create a WI.


Sterling Ferguson-II commented Nov 29 '12, 6:07 p.m.

Your answer


Register or to post your answer.