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 extract Oracle APEX
  1. Download the latest version of Oracle APEX 21.1 from Oracle Application Express to a local directory.
    Example: </u01/ouaw/temp>.
  2. Extract the APEX installer into customized location.
    Example: </u01/ouaw/apex>.

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

Download the OUAW database software
  1. Download the Oracle Utilities Analytics Warehouse v2.8.0.0 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/BI2800>

Extract the Admin Tool
  1. Download the Oracle Utilities Analytics Warehouse v2.8.0.0 Multiplatform.zip file from Oracle Software Delivery Cloud.
  2. Extract "Oracle Utilities Analytics Warehouse v2.8.0.0 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 (Example: JDK 1.8.0.291) from Oracle Technology Network to a temporary directory.
  2. Upgrade the JDK to JDK 1.8.0 (291).

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 at 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 5.9)'s 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 30657796 from Oracle Software Delivery Cloud to a temporary directory. (Patch 30657796 is available inside the Oracle Analytics Server 5.9 package from the website.)

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

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

    Copy
    $ORACLE_HOME/OPatch/opatch apply

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

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

    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 Extract APEX

Download the Oracle APEX 21.1 from Oracle Technology Network and extract it 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 Technology Network 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.0 Multiplatform.zip file from Oracle Software Delivery Cloud.

  2. Extract Oracle Utilities Analytics Warehouse v2.8.0.0 Multiplatform.zip file to a temporary directory.
    Example: </u01/ouaw/temp/application>.
    The application installer jar file is OUA_2.8.0.0.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.

Notes:

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

  • ODI & Apex Domain, and Repository Upgrade are not required in this upgrade path.

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.

Back to Top