1. Upgrading Business Intelligence Applications
  2. Overview
  3. About In-Place and Out-of-Place Upgrades
  4. About In-Place Upgrade

About In-Place Upgrade

An in-place upgrade maintains your pre-upgrade Oracle home directory, but installs the new release binaries in a new Oracle home directory and upgrades the schemas in-place.

Oracle recommends in-place upgrade if you are upgrading from the Oracle BI Applications 11.1.1.10.3 release to the Oracle BI Applications 11.1.1.10.3 PS4 release (Oracle Fusion Middleware Infrastructure 12c to the latest update of Oracle Fusion Middleware Infrastructure 12c).

Note:

You must perform out-of-place upgrade if you want to upgrade from Oracle BI Applications 11.1.1.10.3 to Oracle BI Applications 11.1.1.10.3 PS4 having target RCU platform on the Oracle Autonomous Transaction Processing (ATP) Database.

Note:

  1. If you are upgrading from Oracle BI Applications 11.1.1.10.3PS3 to 11.1.1.10.3PS4, make sure you apply the PB4 (Patch Bundle 4) before you perform the in-place upgrade.
  2. If you are upgrading from Oracle BI Applications 11.1.1.10.3/11.1.1.10.3PS2 to 11.1.1.10.3PS4, make sure that you apply the PB2 (Patch Bundle 2) before you perform the in-place upgrade.
Complete these tasks to perform an in-place upgrade:
  1. Read the certification document.
  2. Prepare the machines for the application and database servers.
  3. Back up content and customizations.
    1. Back up the Oracle Data Integrator repository metadata schema and the customizations. See Back Up the ODI Repository.
    2. Back up the Business Intelligence content and customizations. See Back Up the Oracle Business Intelligence Content.
    3. Back up Oracle BI Applications Configuration Manager customizations.
  4. Upgrade infrastructure by installing the following prerequisite platforms in a new Oracle Home. Install in the same New_Oracle_Home location for all components. For example, /scratch/biapps104/Oracle/Middleware/New_Oracle_Home.
    1. Install Oracle Fusion Middleware Infrastructure 12.2.1.4. See Install Oracle Fusion Middleware Infrastructure (WebLogic Server).
    2. Install Oracle Analytics Server. See Install Oracle Analytics Server. See the Oracle BI Applications 11.1.1.10.3 PS4 certification matrix for the latest supported Oracle Analytics Server release.
    3. Install Oracle Data Integrator 12.2.1.4. See Install Oracle Data Integrator.
    4. Install the Oracle BI Applications PS4 install jar. See Install Oracle BI Applications.
    5. Apply mandatory patches on the NEW_ORACLE_HOME where you installed Oracle Fusion Middleware Infrastructure 12.2.1.4.
    6. Run the Pre-Upgrade readiness check. Navigate to New_Oracle_Home/oracle_common/upgrade/bin and run ./ua -readiness. See Run Pre-Upgrade Readiness Check.
    7. Upgrade the Business Intelligence platform schemas.
    8. Run the Domain Reconfiguration process.
    9. Upgrade the domain components and configurations.
    10. Update the Oracle Data Integrator Console and the Oracle Data Integrator J2EE Agent Deployment plan files.
  5. Upgrade the Business Intelligence content in:
    • Repository file
    • Web catalog
    • JAZN file
  6. Upgrade the Oracle Data Integrator repository.
  7. Import and apply the Oracle Data Integrator ETL customizations.
  8. Import the Oracle BI Applications Configuration Manager customizations.
  9. Review the upgrade changes to the warehouse schema and data.