- Upgrading Business Intelligence Applications
- Out-of-Place Upgrade
- Move the JAZN File, Repository, and Presentation Catalog Customization Changes
- Case 4: Moving from Oracle BI Applications Release 11.1.1.10.3 (Oracle Analytics Server) to Oracle BI Applications Release 11.1.1.10.3 PS4 (Oracle Analytics Server) Having Target RCU Platform on Oracle ATP Database
- Case 4: Upgrade the Repository File
Case 4: Upgrade the Repository File
Use these instructions to upgrade the repository or data model file (RPD).
To upgrade the file, you generate and apply a repository patch.
- Generate a patch for the repository on the environment with Oracle BI Applications release 11.1.1.10.3.
- In the environment with Oracle Analytics Server, download the custom repository file using the
<DOMAIN_HOME>/bitools/bin
command path. For example,./datamodel.sh downloadrpd -O /scratch/ BIAPPS103Custom.rpd -SI biainstance -U <username> -P <password>
. - In the environment with Oracle Analytics Server, copy the Oracle BI Applications release 11.1.1.10.3 baseline repository file from the environment with Oracle Analytics Server using this command:
$cp/net/BIAPPS103.us.oracle.com/<ORACLE_HOME/biapps/admin/provisioning/OracleBIServerComponent/rpdbaseline/OracleBIApps.rpd/scratch/
- Compare the custom and release 11.1.1.10.3 baseline repository files using the
comparerpd
command and generate a patch:Commandpath: <DOMAIN_HOME>/bitools/bin/ Syntax: ./comparerpd.sh -P pwd_custom -C 11.1.1.10.3Custom.rpd -W pwd_GA -G 11.1.1.10.3GA.rpd -D patch.xml
For example,./comparerpd.sh -P Admin123 -C /scratch/BIAPPS103Custom.rpd -W Admin123 -G /scratch/OracleBIApps.rpd -D /scratch/103patch.xml
- In the environment with Oracle Analytics Server, download the custom repository file using the
- Apply the custom repository patch on the Oracle BI Applications release 11.1.1.10.3 PS4 repository file using these steps:
- In the environment with Oracle BI Applications release 11.1.1.10.3 PS4 setup, download the Oracle BI Applications release 11.1.1.10.3 PS4 general availability (GA) repository file from the location
<DOMAIN_HOME>/bitools/bin/
using this command:Command path: <DOMAIN_HOME>/bitools/bin./datamodel.sh downloadrpd -O <export_location> -SI<service_instancename > -U <username> -P <password>
For example,./datamodel.sh downloadrpd -O /scratch/103PS4 -SI biainstance -U<username> -P <password>
- Copy the downloaded Oracle BI Applications release 11.1.1.10.3 PS4 GA repository file to the environment with Oracle Analytics Server. Use the
patchrpd.sh
command to apply the patch on the Oracle BI Applications release 11.1.1.10.3 PS4 repository file:Command path: <DOMAIN_HOME>/bitools/bin ./patchrpd.sh -C <10.3PS4 RPD> -G <10.3 RPD> -I <Custom Patch file> -O Merged.rpd -V decision.csv -U-N -8 -A -S patchpassword
For example,./patchrpd.sh -C /scratch/103GA.rpd -G /scratch/103.rpd -I /scratch/103patch.xml -O /scratch/Merged.rpd -V /scratch/decision.csv -U -N -8 -A -S <password>
Provide passwords when prompted.
Note:
- U is an optional argument that applies default decisions for conflicts automatically so that
patchrpd
can finish successfully. If you don't include this parameter, thenpatchrpd
displays a warning and exits if a conflict is detected. - N is an optional argument that is used to ignore all non-fatal errors. Examples of non-fatal errors are unresolved objects, duplicated objects, and broken or incorrect expressions.
- 8 specifies the UTF-8 encoding.
- A is an optional argument used to skip subset patching and instead apply the patch using the input repository files.
- This example applies
103patch.xml
to the Oracle BI Applications release 11.1.1.10.3 PS4 GA repository, and then generates an output repository calledMerged.rpd
and an output decision file nameddecision.csv
. The "Merged" repository file is the "Upgraded" repository file that has the release 11.1.1.10.3 PS4 content and the customizations.
- U is an optional argument that applies default decisions for conflicts automatically so that
- In the environment with Oracle BI Applications release 11.1.1.10.3 PS4 setup, download the Oracle BI Applications release 11.1.1.10.3 PS4 general availability (GA) repository file from the location
- Upload the "Upgraded" repository file to the Oracle BI Applications release 11.1.1.10.3 PS4 setup:
- Copy the "Merged" repository file from the Oracle Analytics Server standalone machine to the Oracle BI Applications release 11.1.1.10.3 PS4 setup
- Upload the "Merged" repository file to the instance using the
<DOMAIN_HOME>/bitools/bin
command path. For example,./datamodel.sh uploadrpd -I /scratch/Merged.rpd -SI biainstance -U <username> -P <password>
- Restart the BI services.
- Verify the Oracle BI Applications release 11.1.1.10.3 PS4 repository file.
- Download the repository file from the environment with the Oracle BI Applications release 11.1.1.10.3 PS4 setup using the
<DOMAIN_HOME>/bitools/bin
command path. For example,./datamodel.sh downloadrpd -O /scratch/BIAPPS103PS4Upgraded.rpd -SI biainstance -U <username> -P <password>
- Using the Oracle Analytics Client Tool, open the downloaded repository file and verify that the custom changes are present.
For more information on Connecting the Oracle Analytics Server repository (Data model) to an Oracle ADB Data warehouse. See My Oracle Support note Doc ID 2808444.1.
- Download the repository file from the environment with the Oracle BI Applications release 11.1.1.10.3 PS4 setup using the