Edit
Attach
P
rintable
r1 - 2017-07-19 - 18:28:17 - Main.ktessier
You are here:
TWiki
>
Deployment Web
>
DeploymentInstallingUpgradingAndMigrating
>
IBMQuickDeployer
>
IBMQuickDeployerSetupAndRunV20
>
IBMQuickDeployerChangeDefaultOracleParameters
<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! IBM Quick Deployer change default Oracle database parameters <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/uc.png" alt="uc.png" width="50" height="50" align="right"> %DKGRAY% %INCLUDE{"IBMQuickDeployerInsertAuthorBuildBasis"}% %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> The values contained in the default database parameters are used to configure the connections between the installed CLM applications and their individual databases. If you are going to use the Quick Deployer installed Oracle database then there is no need to change them prior to running the UCD application *Install Applications* process. However, you should have your database administrator review the configuration to make sure it conforms to internal security and reliability policies. <br/><br/> If you are going to use an existing Oracle database server, then you need to ensure that the *instance* is created and the default database parameters are updated to match the configuration used by your database instance. To do this follow the instructions in this topic. ---++Change default database parameters 1. Open application *Rational_QD_60x*, click *Environments*, then click the *Request Process* icon for the target environment. <br/><br/><img src="%ATTACHURLPATH%/change-db-parameters.png" alt="run process"><br/><br/> 1. In the Process field, select *Change Default Oracle Parameters*. <br/><br/><img src="%ATTACHURLPATH%/change-oracle-parameters1.png" alt="change parameters"><br/><br/> 1. If you fixed the component versions on the process you will not be prompted to choose versions. If offered to choose the component versions, then select Latest Available. <br/><br/><img src="%ATTACHURLPATH%/CDDP2.png" alt="choose version"><br/><br/> 1. Modify the process property default values to match your database. <br/><br/> The Oracle user table space are created using this command *CREATE BIGFILE TABLESPACE $TSName DATAFILE '${TS_path}/${appName}.dbf' $createTSOption* which is populated using these property values: <br/><br/> eg CREATE BIGFILE TABLESPACE *$oraclejtsTableSpace DATAFILE $oracleDBStorage_Home/jts.dbf $oraclejtsCreateTS* <br/><br/> The Oracle user temporary table space are created using this command *CREATE TEMPORARY TABLESPACE $TEMPTSName TEMPFILE '${TS_path}/${appName}temp.dbf' $createTEMPTSOption* which is populated using these property values: <br/><br/> eg CREATE TEMPORARY TABLESPACE *$oraclejtsTempTableSpace TEMPFILE $oracleDBStorage_Home/jtstemp.dbf $oraclejtsCreateTempTS* <br/><br/> The Oracle users are created using this command *CREATE USER $DBUser IDENTIFIED BY $DBUsersPassword DEFAULT TABLESPACE $TSName QUOTA UNLIMITED ON $TSName TEMPORARY TABLESPACE $TEMPTSName* which is populated using these property values: <br/><br/> eg CREATE USER $oraclejtsUser IDENTIFIED BY $oracleDBUsersPassword DEFAULT TABLESPACE $oraclejtsTableSpace QUOTA UNLIMITED ON $oraclejtsTableSpace TEMPORARY TABLESPACE $oraclejtsTempTableSpace* <br/><br/> Grant oracle user this command *GRANT $UserGrantOption TO $DBUser* which is populated using these property values: <br/><br/> eg GRANT $oraclejtsGrantOption TO *$UserGrantOption* <br/><br/> The properties are as follows * *oracleDBStorage_Home* : oracle database storage location <br/> Default on Linux: /IBMQD/dbstorage <br/> Default on Windows: c:\IBMQD\dbstorage * *oracleInstanceName* : oracle instance name, the instance must already existed <br/> Default:CLMINST * *oraclePort* : oracle port <br/> Default:1521 * *oraclejtsTableSpace* : jts table space name <br/> Default : jtsTS * *oraclejtsCreateTS* : command option for creating jts table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oraclejtsTempTableSpace* : jts temporary table space name <br/> Default : jtsTStemp * *oraclejtsCreateTempTS* : command option for creating jts temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oraclejtsUser* : jts user name <br/> Default : jtsUSER * *oraclejtsGrantOption* : command option for granting jts user option <br/> Default : "CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW" * *oracleccmTableSpace* : ccm table space name <br/> Default : ccmTS * *oracleccmCreateTS* : command option for creating ccm table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oracleccmTempTableSpace* : ccm temporary table space name <br/> Default : ccmTStemp * *oracleccmCreateTempTS* : command option for creating ccm temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oracleccmUser* : ccm user name <br/> Default : ccmUSER * *oracleccmGrantOption* : command option for granting ccm user option <br/> Default : "CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW" * *oracleqmTableSpace* : qm table space name <br/> Default : qmTS * *oracleqmCreateTS* : command option for creating qm table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oracleqmTempTableSpace* : qm temporary table space name <br/> Default : qmTStemp * *oracleqmCreateTempTS* : command option for creating qm temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oracleqmUser* : qm user name <br/> Default : qmUSER * *oracleqmGrantOption* : command option for granting qm user option <br/> Default : "CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW" * *oraclermTableSpace* : rm table space name <br/> Default : rmTS * *oraclermCreateTS* : command option for creating rm table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oraclermTempTableSpace* : rm temporary table space name <br/> Default : rmTStemp * *oraclermCreateTempTS* : command option for creating rm temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oraclermUser* : rm user name <br/> Default : rmUSER * *oraclermGrantOption* : command option for granting rm user option <br/> Default : "CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW" * *oraclegcTableSpace* : gc table space name <br/> Default : gcTS * *oraclegcCreateTS* : command option for creating gc table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oraclegcTempTableSpace* : gc temporary table space name <br/> Default : gcTStemp * *oraclegcCreateTempTS* : command option for creating gc temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oraclegcUser* : gc user name <br/> Default : gcUSER * *oraclegcGrantOption* : command option for granting gc user option <br/> Default : "CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW" * *oracledccTableSpace* : dcc table space name <br/> Default : dccTS * *oracledccCreateTS* : command option for creating dcc table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oracledccTempTableSpace* : dcc temporary table space name <br/> Default : dccTStemp * *oracledccCreateTempTS* : command option for creating dcc temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oracledccUser* : dcc user name <br/> Default : dccUSER * *oracledccGrantOption* : command option for granting dcc user option <br/> Default : "CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW" * *oraclerelmTableSpace* : relm table space name <br/> Default : relmTS * *oraclerelmCreateTS* : command option for creating relm table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oraclerelmTempTableSpace* : relm temporary table space name <br/> Default : relmTStemp * *oraclerelmCreateTempTS* : command option for creating relm temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oraclerelmUser* : relm user name <br/> Default : relmUSER * *oraclerelmGrantOption* : command option for granting relm user option <br/> Default : "CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW" * *oraclelqeTableSpace* : lqe table space name <br/> Default : lqeTS * *oraclelqeCreateTS* : command option for creating lqe table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oraclelqeTempTableSpace* : lqe temporary table space name <br/> Default : lqeTStemp * *oraclelqeCreateTempTS* : command option for creating lqe temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oraclelqeUser* : lqe user name <br/> Default : lqeUSER * *oraclelqeGrantOption* : command option for granting lqe user option <br/> Default : "CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW" * *oracleldxTableSpace* : ldx table space name <br/> Default : ldxTS * *oracleldxCreateTS* : command option for creating ldx table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oracleldxTempTableSpace* : ldx temporary table space name <br/> Default : ldxTStemp * *oracleldxCreateTempTS* : command option for creating ldx temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oracleldxUser* : ldx user name <br/> Default : ldxUSER * *oracleldxGrantOption* : command option for granting ldx user option <br/> Default : "CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW" * *oracledmTableSpace* : dmtable space name <br/> Default : dmTS * *oracledmCreateTS* : command option for creating dm table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oracledmTempTableSpace* : dm temporary table space name <br/> Default : dmTStemp * *oracledmCreateTempTS* : command option for creating dm temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oracledmUser* : dm user name <br/> Default : dmUSER * *oracledmGrantOption* : command option for granting dm user option <br/> Default : "CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW" * *oracledwTableSpace* : dwtable space name <br/> Default : dwTS * *oracledwCreateTS* : command option for creating dw table space <br/> Default : "SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE" * *oracledwTempTableSpace* : dw temporary table space name <br/> Default : dwTStemp * *oracledwCreateTempTS* : command option for creating dm temporary table space <br/> Default : "SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M" * *oracledmUser* : dw user name <br/> Default : dwUSER * *oracledwGrantOption* : command option for granting dm user option <br/> Default : "DBA" <br/><br/> 1. Click on *Submit* and wait for the process to run to completion <br/><br/><img src="%ATTACHURLPATH%/CDDP3.png" alt="wait for completion"><br/><br/> %INCLUDE{"IBMQuickDeployerInsertMiscellaneous"}% <sticky></div></sticky>
Edit
|
Attach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
:
r4
<
r3
<
r2
<
r1
|
More topic actions...
Deployment
Deployment web
Planning and design
Installing and upgrading
Migrating and evolving
Integrating
Administering
Monitoring
Troubleshooting
Community information and contribution guidelines
Create new topic
Topic list
Search
Advanced search
Notify
RSS
Atom
Changes
Statistics
Web preferences
NOTE: Please use the Sandbox web for testing
Status icon key:
To do
Under construction
New
Updated
Constant change
None - stable page
Smaller versions of status icons for inline text:
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our
Terms of Use.
Please read the following
disclaimer
.
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
.