It's all about the answers!

Ask a question

Oracle configuration with CLM


Sterling Ferguson-II (1.6k12288273) | 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 (63.5k33646) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.