Perform Demo Pre-Installation Steps for OUAW

This page provides the information necessary to plan and execute the demo data import, installation, and configuration required for Oracle Utilities Analytics Warehouse (OUAW).

Notes:

  • Before installing the prerequisite software, the user must perform a sequence of downloads and installations, as well as necessary validations on the database and application servers.
  • The person responsible to install OUAW must have database and middleware administrator knowledge.

On this page:

System Requirements and Supported Platforms

Before you begin the installation, note the following:

  • Both the hardware and the network requirements must be met. See System Requirements and Supported Platforms.

  • You must determine your installation target. The Oracle Utilities Analytics Warehouse can be installed on either the database or the application servers.

  • The OUAW deployment topology option is a multi-nodes topology that deploys the database and application components into separate dedicated servers, while a higher capacity server can have both OUAW database and application components on one single server. 

Back to Top

Demo Pre-Installation Requisites for OUAW Database Server

This section lists the prerequisite software required to install OUAW on the database server target, which is going to be used by the demo database component and the repositories created for the OUAW dashboards component.

The following table includes some directory structures examples.

Notes:

  • Customers can decide where to install this software. Make sure to note all the home directories on this list, as they will be used during OUAW installation.
  • Make sure to do every installation using a single OS user and replace all parameters enclosed in <> with the appropriate values.

Task

Description

Download and install the database

  1. Download Oracle Database Server Enterprise Edition 19c from Oracle Software Delivery Cloud  to a temporary directory.

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

  2. Installation can be done at the customized location.

    Example: </u01/ouaw/database> (referred to as ORACLE HOME).

Download and apply the database patch

  1. Download the database server patch 33806152 from My Oracle Support to a temporary directory.

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

  2. Set ORACLE_HOME, ORACLE_SID and PATH set to the database server installed path. 

  3. Unzip the patch and navigate to the patch top directory run the $ORACLE_HOME/OPatch/opatch apply

    Note: follow the readme file for applying patch which is under the patch top directory.

Create the database

Create the database for OUAW installation using the AL32UTF8 character set.

Download the OUAW database software.

  1. The OUAW media pack can be downloaded from Oracle Software Delivery Cloud  (Oracle Utilities Analytics Warehouse v2.8.0.1 Oracle Database Multiplatform.zip file).

  2. Unzip Oracle Utilities Analytics Warehouse v2.8.0.1 Oracle Database Multiplatform.zip to a temporary directory using any zip command utility.

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

  3. After unzip, find the OUAW Database Installers at the following location:

    </u01/ouaw/temp/database/BI2801> 

Download the OUAW demo data

  1. Download Oracle Utilities Analytics v2.8.0.1 Oracle Demo Data part from the Oracle_Utilities_Analytics_Warehouse_v2.8.0.1_Demo_Data.zip file. 

  2. Unzip Oracle_Utilities_Analytics_Warehouse_v2.8.0.1_Demo_Data.zip to a temporary directory.

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

  3. After unzip, find the Demo Data dump file and users.sql at the following location after unzip:

    </u01/ouaw/temp/demo/BI2801/Demo>

Back to Top

Demo Pre-Installation Requisites for OUAW Application Server

This section covers the downloads and install instructions that can be performed on the OUAW application server. 

The following table includes some directory structures examples.

Notes:

  • Customers can decide where to install this software. Make sure to note all the home directories on this list, as they will be used during OUAW installation.
  • Make sure to do every installation using a single OS user and replace all parameters enclosed in <> with the appropriate values.

Task

Description

Download and install the JDK 

  1. Download Oracle Java Development Kit (JDK) 1.8 from Oracle Technology Network to a temporary directory on the application server.

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

  2. Install the JDK on a customized location.

    Example: </u01/ouaw/java> (referred to as JAVA_HOME).

Download and install Database Client

Download the Oracle Database Client from Oracle Software Delivery Cloud and install it at a customized location.

Example: </u01/ouaw/clientBase>.

Note: This task is optional if both the OUAW application and database servers are installed on the same machine. See Install Oracle Database Client for more information.

Download and install Oracle Fusion Middleware Infrastructure

  1. Download the Oracle Fusion Middleware Infrastructure 12.2.1.4 Version from Oracle Software Delivery Cloud  into a temporary directory.
    Example:

    </u01/ouaw/temp/middleware>

  2. Install the software on a customized location.

    Example: </u01/ouaw/middleware>. This will be referred to as FMW Home. This installation path can be used for Oracle Data Integrator's ORACLE_HOME as well as for Oracle Analytics Server (OAS) installations.

See Install Oracle Fusion Middleware Infrastructure for more information.

Download and apply Oracle Fusion Middleware Infrastructure Patch

Download and apply the appropriate patch based on the version of Oracle Analytics Server (OAS) and ODI you used.

For OAS 6.4 and ODI FMW Home:

  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: Find the detailed patch installation steps in the README file that comes with each patch package.

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

  3. Run the following to install the patch 34065178:

    $ORACLE_HOME/OPatch/opatch apply

  4. Run the following to install the patch 34373563:

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

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

For OAS 7.0 ( OAS 2023 ) FMW Home:

  1. Download the Oracle Fusion Middleware Infrastructure patch 34065178 (Required FMW Compatibility Patch for JDK 8 u331 or later ) and 34974729 from My Oracle Support to a temporary directory.

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

    Note: Find the detailed patch installation steps in the README file that comes with each patch package.

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

  3. Run the following to install the patch 34065178:

    $ORACLE_HOME/OPatch/opatch apply

  4. Run the following to install the patch 34974729:

    $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 the latest Oracle Analytics Server (OAS) version 6.4.0 / 7.0 (OAS 2023) from Oracle Software Delivery Cloud into a temporary directory.

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

  2. Install the OAS software at the <FMW Home> location considering the ORACLE_HOME path. See Install Oracle Analytics Server for more information.

    Example: </u01/ouaw/middleware>. 

    Note: After installation, the "bi" directory will be located inside the FMW home as <FMW Home>/bi.
Download and apply Oracle Analytics Server (OAS) Patch

For OAS 6.4 Oracle Home:

  1. Download the Oracle Analytics Server (OAS) patch 34373446 and 33877829 from My Oracle Support to a temporary directory.
  2. Unzip the patches and navigate to the patch top folder.
  3. For each patch, run the following executable: $ORACLE_HOME/OPatch/opatch apply

For OAS 7.0 Oracle Home:

  1. Download the Oracle Analytics Server (OAS) patch 35024228 from My Oracle Support to a temporary directory.
  2. Unzip the patches and navigate to the patch top folder.
  3. For each patch, run the following executable: $ORACLE_HOME/OPatch/opatch apply

Configure OAS domain 

  1. Navigate to the OAS installed $ORACLE_HOME/bi/bin location.

    Example: <FMW Home>/bi/bin

  2. Run the ./config.sh file.

  3. Configure Oracle Analytics Server domain with a customized name on the customized location.

    Example: <oas_domain>

    Example: </u01/ouaw/domains/oas_domain> (referred to as OAS DOMAIN Home). See Configure the Oracle Analytics Server Domain with the Configuration Assistant for more information. 

  4. While running RCU as part of domain configuration:

    • Enter the connection string based on the type of database as 'Oracle'.

    • Enter a unique schema prefix.
      Example: '<OAS>' 

Download the OUAW application software.

  1. The OUAW media pack can be downloaded from Oracle Software Delivery Cloud (Oracle Utilities Analytics V2.8.0.1 Multiplatform.zip file).

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

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

  3. After unzip, find the application installer jar file.

    Example: OUA_2.8.0.1.0_generic.jar

Back to Top

OUAW Directory Structure and Other Required Information

The software installation directories can be used for OUAW installations and configurations. The locations specified on the following table will be respectively referred to as JAVA Home, Oracle Home, FMW Home, Domain Home and Dashboards Home.

Information Type

Description

JAVA_HOME

This is the Java installed location on the OUAW database and application servers.

Example: </u01/ouaw/java>

Database Home

The Oracle database installed path on the OUAW database server.

Example: </u01/ouaw/database>

Database Client

The Oracle database client installed path on the OUAW application server.

Example: </u01/ouaw/clientBase>

FMW Home

Oracle Fusion Middleware Infrastructure installation location on the OUAW application server.

Example: </u01/ouaw/middleware>

Domain Home

The WebLogic Domains (OAS Domain) will be configured in this directory on the OUAW application server.

Example: </u01/ouaw/domains/oas_domain>

Dashboards Home

The OUAW installation location where OUAW_DASHBOARD directory will be created after its installation on the application server.

Example: /u01/ouaw/deployment/OUAW_DASHBOARD>

Back to Top