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 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 and copy the 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 apply Oracle Fusion Middleware Infrastructure Patch

Note: Apply these patches in both OAS and ODI ORACLE_HOME (FMW Home).

  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 apply Oracle Analytics Server (OAS) Patch

Note: Apply this patch in OAS ORACLE_HOME (FMW Home).

  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 apply ODI Patches

Note: Apply this patch in ODI ORACLE_HOME (FMW Home).

  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

Note: For post patch instructions, follow the README file in the patch package.
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