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 33806152 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.

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.1 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/BI2801>
Extract the Admin Tool

  1. Download the Oracle Utilities Analytics Warehouse v2.8.0.1 Oracle Database Multiplatform.zip file from Oracle Software Delivery Cloud.

  2. Extract the Oracle Utilities Analytics Warehouse v2.8.0.1 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.341) from Oracle Technology Network to a temporary directory.
  2. Upgrade the JDK to JDK 1.8.0 (341).

    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) 6.4 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 Fusion Middleware Infrastructure Patch 34065178 (required FMW Compatibility Patch for JDK 8 u331 or later ) and 34373563 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 34373563:

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

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

Download and install Oracle Analytics Server (OAS)
  1. Download Oracle Analytics Server (OAS) version (6.4.0) from Oracle Software Delivery Cloud to a temporary directory.

    2. Example: </u01/ouaw/temp/oas>.

  2. 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) patches 34373446 and 33877829 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  34345040  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.1 Multiplatform.zip file from Oracle Software Delivery Cloud.

  2. Extract Oracle Utilities Analytics Warehouse v2.8.0.1 Multiplatform.zip file to a temporary directory.

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

    Note: The application installer jar file is OUA_2.8.0.1.0_generic.jar.

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.

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, it is necessary to follow the steps from the document 2751829, which is available through 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, with the exception of the step for Upgrading Product Schemas. Product schemas/RCU schema are not present in this Apex domain. See Upgrading to the Latest Release of Oracle Analytics Server for details.

Back to Top