Back Up the Oracle BI Applications Repository Customizations

Generate a patch for the repository of the Oracle BI Applications 11.1.1.10.3 environment.

1. Back up the baseline Oracle BI Applications 11.1.1.10.3 repository.

   The baseline Oracle BI Applications 11.1.1.10.3 BAR file is present in the following location:

   <ORACLE_HOME>/bi/biapps/admin/provisioning/OracleBIPresentationServicesComponent/OracleBIApps.bar

   1. Use the expandarchive command to extract the baseline Oracle BI Applications 11.1.1.10.3 repository from the BAR file.

      Note:

      The expandarchive command is available on the system where you have installed Oracle Analytics Server or the Oracle Analytics Client tool (Windows). Set the DOMAIN_HOME before you run the expandarchive command.

      • If you are using the expandarchive, copy the baseline Oracle BI Applications 11.1.1.10.3 BAR file to the Windows system where you have installed the Oracle Analytics Client tool:

        <OracleAnalyticsClienttool Install location>\bi\modules\oracle.bi.metadatalcm\scripts\expandarchive.cmd <BAR file path> <target folder where BAR file to be expanded> encryptionpassword= <password>

      • On Oracle Analytics Server:
        • Linux:

          $ORACLE_HOME/bi/modules/oracle.bi.metadatalcm/scripts/expandarchive.sh <BAR file path> <target folder where BAR file to be expanded> encryptionpassword=<encryption password>

        • Windows:

          $ORACLE_HOME\bi\modules\oracle.bi.metadatalcm\scripts\expandarchive.cmd <BAR file path> <target folder where BAR file to be expanded> encryptionpassword= <encryption password>

   2. Copy the baseline Oracle BI Applications 11.1.1.10.3 repository (default.rpd) to the Oracle BI Applications 11.1.1.10.3 system for comparison.
      In the target folder where the BAR file is expanded, the baseline Oracle BI Applications repository is available in /datamodel/rpd/default.rpd.
2. Back up the custom Oracle BI Applications 11.1.1.10.3 repository.
   In the Oracle BI Applications11.1.1.10.3 system, download the custom repository.
   1. Navigate to <DOMAIN_HOME>/bitools/bin.
   2. Run the following command:

      ./datamodel.sh downloadrpd -O <Location> -si <service_instance> -u <username> -p <password>

      For example,

      ./datamodel.sh downloadrpd -O /u01/BIAPPS103_Custom.rpd -si biainstance -u weblogic -p password

3. Compare the Baseline Oracle BI Applications 11.1.1.10.3 repository and the Custom Oracle BI Applications 11.1.1.10.3 repository. Generate a patch file to contain the differences between the baseline repository and the custom repository.
   1. In the Oracle BI Applications 11.1.1.10.3 environment, navigate to <DOMAIN_HOME>/bitools/bin.
   2. Run the following command:

      ./comparerpd.sh -P custom_pwd -C <CustomOracleBIApplications 11.1.1.10.3 repository> -W Baseline_pwd -G <Baseline Oracle BI Applications 11.1.1.10.3 repository> -D patch.xml

      For example,

      ./comparerpd.sh -P Admin123 -C BIAPPS103_Custom.rpd -W Admin123 -G BIAPPS103_Baseline.rpd -D patch.xml