How to generate Oracle data warehouse upgrade scripts without upgrading the CLM server
I want to upgrade an IBM Rational Collaborative Lifecycle Management Solution (CLM) to a new version.
The Oracle Database user who connects to the Data Warehouse does not have full administrative privileges.
Because of that, the Data Warehouse was created using the steps from the below link:
Create Oracle data warehouse without DBA permissions
I want to to generate the upgrade scripts, but I don't want to do it manually during the upgrade, as I need my upgrade to be done silently.
How can I generate the Oracle DW upgrade scripts without already starting an upgrade of CLM?
The Oracle Database user who connects to the Data Warehouse does not have full administrative privileges.
Because of that, the Data Warehouse was created using the steps from the below link:
Create Oracle data warehouse without DBA permissions
I want to to generate the upgrade scripts, but I don't want to do it manually during the upgrade, as I need my upgrade to be done silently.
How can I generate the Oracle DW upgrade scripts without already starting an upgrade of CLM?
One answer
You can do that by installing an additional CLM installation.
To generate the upgrade scripts:
The scripts will be generated and the existing CLM installation will not be affected.
To generate the upgrade scripts:
- Install the target CLM version.
-
Copy the teamserver.properties file from
Old CLM Version Installation Directory/jts/conftoNew CLM Version Installation Directory/jts/conf. -
Run the
repotools-jts generateWarehouseUpgradeScriptscommand as instructed in the link below.
Create Oracle data warehouse without DBA permissions
The scripts will be generated and the existing CLM installation will not be affected.