Upgrade Tech Stack for OUAW

This page details the tasks required to upgrade the services that are used to run Oracle Utilities Analytics Warehouse.

On this page:

Upgrade the Tech Stack for the Database Server

This section covers the instructions for the downloads, installations, and upgrades that can be performed on the Oracle Utilities Analytics Warehouse database server.

Notes:

  • Before upgrading, back up the current environment and ensure you have a rollback plan.
  • Make sure the same OS user installs all software, and that you replace all parameters enclosed in <> with valid values.
  • While the table below includes some directory structures as examples, you can choose where to install the software. Make sure to keep track of all the home directories you create, as these will be used for OUAW installation.

Task

Description

Download and apply Database Server Patch

  1. Download the Database Server Patch 35643107 from My Oracle Support to a temporary directory.
    Example: </u01/ouaw/temp/database>.

    Note: Download the patch that corresponds to your server operating system.

  2. Export the ORACLE_HOME set to the Database Server installed path. 
  3. Unzip the patch, navigate to the patch top directory, and run the following:

    Copy
    $ORACLE_HOME/OPatch/opatch apply

  4. Note: Follow the README while applying the database patches.

Apply patch for GoldenGate
  1. Download and apply patch 35580180 (for Solaris and Linux) or 35682480 (for AIX) from My Oracle Support on top of the Oracle GoldenGate.
  2. Set the ORACLE_HOME to the Oracle GoldenGate home installed location. 
  3. Unzip the patch, navigate to the patch top folder, and run the following:

    Copy
    $ORACLE_HOME/OPatch/opatch apply

  4. Note: Do not start the GoldenGate processes after applying the patch.

Apply patch for GoldenGate Monitor Agent
  1. Download and apply patch 34362913 from My Oracle Support on top of the Oracle GoldenGate Monitor Agent.
  2. Set the ORACLE_HOME to the Oracle GoldenGate Monitor Agent home installed location. 
  3. Unzip the patch, navigate to the patch top folder, and run the following:

    Copy
    $ORACLE_HOME/OPatch/opatch apply

Download and extract Oracle APEX

  1. Download the latest version of Oracle APEX 22.1 from Oracle Application Express to a local directory.

    Example: </u01/ouaw/temp>

  2. Extract the APEX installer into a customized location.

    Example: </u01/ouaw/apex>.

  3. Note: This location will be referred to as the New APEX Home directory.

Download the OUAW database software

  1. Download the Oracle Utilities Analytics Warehouse v2.8.0.2 Oracle Database Multiplatform.zip file from Oracle Software Delivery Cloud.
  2. Unzip the file to a temporary directory using any zip command.

    Example: </u01/ouaw/temp/database>.

  3. Note: You can find the OUAW Database Installers at the following location after unzipping the file: </u01/ouaw/temp/database/BI2802>

Extract the Admin Tool
  1. Download the Oracle Utilities Analytics Warehouse v2.8.0.2 Oracle Database Multiplatform.zip file from Oracle Software Delivery Cloud.

  2. Extract the Oracle Utilities Analytics Warehouse v2.8.0.2 Multiplatform.zip AdminTool folder to a temporary directory.

    Example: </u01/ouaw/temp/AdminTool>

    Note: This directory contains database SQL scripts.

Back to Top

Upgrade the Tech Stack for the Application Server

This section covers the instructions for the downloads, installations, and upgrades that can be performed on the Oracle Utilities Analytics Warehouse application server.

Notes:

  • Before upgrading, back up the current environment and ensure you have a rollback plan.
  • Make sure the same OS user installs all software, and that you replace all parameters enclosed in <> with valid values.
  • While the table below includes some directory structures as examples, you can choose where to install the software. Make sure to keep track of all the home directories you create, as these will be used for OUAW installation.

Task

Description

Download and Upgrade the Java Development Kit

  1. Download the Oracle Java Development Kit (JDK) 1.8 version (JDK 1.8.0.391) from Oracle Technology Network to a temporary directory.
  2. Upgrade the JDK to JDK 1.8.0 (391).
  3. Note: Rename the existing JDK path and upgrade/install the new JDK by creating the same JDK path so that JAVA_HOME is the same as the previous.

Download and install Oracle Fusion Middleware Infrastructure

  1. Download the Oracle Fusion Middleware Infrastructure 12.2.1.4 from Oracle Software Delivery Cloud to a temporary directory.
    Example: </u01/ouaw/temp/middleware>.

  2. Install the software in a customized location.

    Example: </u01/ouaw/middleware>.

    Note: This will be referred to as FMW Home. This installation path can be used for Oracle Analytics Server (OAS 2023) and Oracle Data Integrator 12.2.1.4 ORACLE_HOME during its installation.

  3. See Install Oracle Fusion Middleware Infrastructure for more information.

Download and apply Oracle Fusion Middleware Infrastructure Patch

  1. Download the Oracle WebLogic Server 12.2.1.4 Patch 34065178 (required FMW Compatibility Patch for JDK 8 u331 or later ) and 35899167 from My Oracle Support to a temporary directory.

    Example: </u01/ouaw/temp/middleware>

    Note: Detailed patch installation steps are in the README file in each patch package.

  2. Unzip the patch and navigate to the patch top folder.
  3. Run the following to install patch 34065178:

    Copy
    $ORACLE_HOME/OPatch/opatch apply

  4. Run the following to install patch 35899167:

    Copy
    $ORACLE_HOME/OPatch/opatch napply -oh <ORACLE_HOME> -phBaseFile generic_patchlist.txt

  5. Download the Oracle Fusion Middleware Infrastructure 12.2.1.4 35751917, 34809489, 35735469, 35868571, 34542329, and 33950717 patches from My Oracle Support to a temporary directory.

    Example: </u01/ouaw/temp/middleware>

  6. Run the following to install those patches:

    Copy
    $ORACLE_HOME/OPatch/opatch apply

  7. Note: ORACLE_HOME is referred to as <FMW Home location>.

Download and install Oracle Analytics Server (OAS)

  1. Download Oracle Analytics Server (OAS 2023) version 7.0 from Oracle Software Delivery Cloud to a temporary directory.
  2. Example: </u01/ouaw/temp/oas>.

  3. Install the OAS software at the <FMW Home> location. Here consider the ORACLE_HOME path.

    Example: </u01/ouaw/middleware>

    After installation, you can find the bi directory inside the FMW Home.

    Example: <FMW Home>/bi

    See Install Oracle Analytics Server for more information.

Download and apply Oracle Analytics Server (OAS) Patch

  1. Download the Oracle Analytics Server (OAS 7.0) patches 35860780 and 35084179 from My Oracle Support to a temporary directory.

  2. Unzip the patches and navigate to the patch top folder.

  3. Run the following for each patch:

    Copy
    $ORACLE_HOME/OPatch/opatch apply

Download and install Oracle Data Integrator (ODI)
  1. Download Oracle Data Integrator (ODI) 12.2.1.4 from Oracle Software Delivery Cloud to a temporary directory.

    Example: </u01/ouaw/temp/ODI>

  2. Extract and install ODI at the ORACLE_HOME location at same as FMW Home path.

    Example: </u01/ouaw/middleware>

    Note: After installation, you can find the ODI directory under the FMW Home path. Example: <FMW Home>/odi. See Install Oracle Data Integrator for details.

Download and apply ODI Patches
  1. Download and apply Oracle Data Integrator 12.2.1.4 patch 35861909 from My Oracle Support.
  2. Unzip the patch and navigate to the patch top folder.

  3. Run the following:

    Copy
    $ORACLE_HOME/OPatch/opatch apply

Post Patch Instructions:

If you are upgrading from an ODI release prior to 12.2.1.4.210321, make sure that all work and master repository schema users have been granted CREATE VIEW and CREATE PROCEDURE privileges. Execute the below queries in the target database:

Copy
grant create view to OUA_MASTER;
grant CREATE PROCEDURE to OUA_MASTER;
grant create view to OUA_WORK;
grant CREATE PROCEDURE to OUA_WORK;

Download and Extract APEX

Download Oracle APEX 22.1 from Oracle Application Express to a local directory.

Example: </u01/ouaw/apex>

After extraction, you can see the apex folder.

Example: </u01/ouaw/apex/apex>

Download and Extract ORDS

Download the Oracle REST Data source (ORDS) 21.1.3 version from Oracle REST Data Services Download  and extract it to a local directory.

Example: </u01/ouaw/ords>

After extraction you can see the ords folder.

Example: </u01/ouaw/ords>

Download the OUAW Application Software
  1. Download the Oracle Utilities Analytics Warehouse v2.8.0.2 Multiplatform.zip and Oracle Utilities Analytics Warehouse v2.8.0.2 Dashboard Component.zip files from Oracle Software Delivery Cloud.

  2. Extract Oracle Utilities Analytics Warehouse v2.8.0.2 Multiplatform.zip and Oracle Utilities Analytics Warehouse v2.8.0.2 Dashboard Component.zip files to a temporary directory.

    Example: </u01/ouaw/temp/application>.

    Note: The ETL Component installer jar file is OUAW_2.8.0.2.0_ETL_generic.jar and the Dashboard Components are <OAS Version>/rpd, catalog, WriteBackTemplates.

Back to Top

Upgrade the Existing Domains and Repository

This section details how to upgrade the existing domains and the repository in accordance with the in-place upgrade domain strategy.

Note: Before upgrading a repository or domain activity, make sure you have a rollback plan in case it is necessary to revert your changes.

OAS Repository and Domain In-Place Upgrades

For OAS repository and domain in-place upgrades, follow the steps in Upgrading to the Latest Release of Oracle Analytics Server.

Note: The ./reconfig.sh may fail while running it, generating the exception: " CFGFWK-60953: An error in reconfiguration template resulted in the following deployment being left in the original MW home: log4j.jar#1.3@1.2.15". To solve this, follow the steps in the document 2933574.1 available on My Oracle Support.

ODI Repository and Domain In-Place Upgrades

For ODI repository and domain in-place upgrades, follow the steps in Upgrading Oracle Data Integrator.

Note: The ./ua -readiness may fail while running it, generating the exception: "Failed to establish a connection to data source WLSSchemaDataSource" because of the error "UPGAST-00214: Unable to connect to database as the schema user DEV_WLS_RUNTIME". To solve this, follow the steps in the document 2751829 available on My Oracle Support.

The ./reconfig.sh may fail while running it, generating the exception: "CFGFWK-60953: An error in reconfiguration template resulted in the following deployment being left in the original MW home: log4j.jar#1.3@1.2.15". To solve this, follow the steps in the document 2933574.1 available on My Oracle Support.

Apex Domain In-Place Upgrade

The same steps that were used for upgrading the OAS domain will be used for the Apex domain in-place upgrade, apart from the step for Upgrading Product Schemas. Product schemas/RCU schema are not present in this Apex domain.

Back to Top