Oracle configuration with CLM

Question

Procedure

As a system administrator, create a database with UTF8 encoding for the Jazz Team Server and all applications.

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;

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.
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).

Answer 1

0

permanent link

Ralph Schoon (62.7k●3●36●43) | 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.

All in case others find this topic in the forum, here is my work item:

https://jazz.net/jazz/web/projects/Jazz%20Collaborative%20ALM#action=com.ibm.team.workitem.viewWorkItem&id=242958

It's all about the answers!

Related questions

Oracle configuration with CLM

Procedure

One answer

Your answer