Perform Pre-Installation Steps for OUAW

This page will help you plan and execute the installation and configuration of the Oracle Utilities Analytics Warehouse (OUAW). Use the instructions and information below to download and install the prerequisite software, and then carry out the validations tasks on the database and application servers as described.

Note: This page assumes you have database and middleware administrator knowledge. 

On this page:

System Requirements and Supported Platforms

Before you begin installation, verify that the minimum system hardware and network requirements are met. See System Requirements and Supported Platforms.

Next, determine your installation target. One possible OUAW deployment topology option is a multi-nodes topology, which deploys the database and application components on separate dedicated servers. The other option is to deploy both the OUAW database and application components on a single high-capacity server.

Pre-Installation Requisites for OUAW Database Server

The prerequisite software for installing OUAW on a target database server is listed below. The target database server will be used by the OUAW database component, as well as the repositories created for the Oracle Data Integrator-based ETL, Dashboards, and Admin Tool components.

Note: While the table below includes some example directory structures, you can decide where the software will be installed. Make sure you keep track of all the home directories you create, as these will be used at the time of OUAW installation. Additionally, make sure the same OS user installs all software, and replace all parameters enclosed in <> with actual values.

Installation software and steps

Task

Description

Download and install the Java Development Kit

  1. Download the Oracle Java Development Kit (JDK) 1.8 version from My Oracle Support to a temporary directory. Example: </u01/ouaw/temp/java>.

  2. Install the JDK at a customized location. Example: </u01/ouaw/java>. This location will be referred to as JAVA_HOME.

Download and install Oracle Database Server Enterprise

  1. Download Oracle Database Server Enterprise Edition 19c from Oracle Software Delivery Cloud to a temporary directory. Example: </u01/ouaw/temp/database>.

  2. Install the database at a customized location. Example: </u01/ouaw/database>. This location will be referred to as ORACLE_HOME.

Download and apply Database Server Patch

  1. Download the Database Server Patch 35943157 from My Oracle Support to a temporary directory.

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

  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

Create database for installation

Create a database for OUAW installation. Use the AL32UTF8 character set.

Download and install GoldenGate Microservices

  1. Download Oracle GoldenGate Microservices 19.1 from Oracle Software Delivery Cloud to a temporary directory. See Installing Oracle GoldenGate Microservices for details.

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

  2. Install Oracle GoldenGate Microservices on the Target Database server(s) at a customized location.

    Example: </u01/ouaw/goldengate_MA>. This will be referred to as Oracle GoldenGate Microservices Installation Home.

Apply patch for GoldenGate Microservices

  1. Download and apply patch 36238786 (for Linux) or 36176781 (for Solaris and AIX) from My Oracle Support on top of the Oracle GoldenGate Microservices.

  2. Set the ORACLE_HOME to Oracle GoldenGate Microservices home installed location.

  3. Unzip the patch and navigate to the patch top folder, and then run the following:

    Copy 
    $ORACLE_HOME/OPatch/opatch apply

Create Oracle GoldenGate Microservices Deployment

Note: OUAW only supports GoldenGate Microservice Secure Deployments.

Prerequisites:

  • Ensure you have Root CA Certificates, Server Certificates, Client Certificates for Distribution (Source) and Receiver (Target) GoldenGate Microservices Servers and create the trust between the Certificates before Oracle GoldenGate Microservices Deployment. See more details for Self-Signed Certificates.
  • Ensure you have created respective wallets for Distribution (Source) and Receiver (Target) GoldenGate Microservices.

Add Oracle GoldenGate Microservices Deployment with the following command:

Copy
<Oracle GoldenGate Microservices Installation Home>/bin/oggca.sh

Refer to Setting Up Secure or Non-Secure Deployments for more information.

Examples:

  • </u01/ouaw/goldengate_SM> - This will be referred to as Oracle GoldenGate Microservices Service Manager Home.
  • </u01/ouaw/goldengate_Deploy> - This will be referred to as Oracle GoldenGate Microservices Deployment Home.

Note:

  1. Set the security options by selecting the SSL/TLS security checkbox and defining the respective wallets.

  2. Set the replication settings.
    • Set the Default Schema to MDADM for the Receiver (Target) GoldenGate Microservices.

    • Set the Default Schema to the Oracle GoldenGate Owner like C##GGOWNER for the Distribution (Source) GoldenGate Microservices. This user will be created during the configuration in Configure ETL Source for OUAW.

Download and extract Oracle APEX

  1. Download the latest version of Oracle APEX 23.2 from Oracle APEX to a local directory.

    Example: </u01/ouaw/apex>.

  2. Extract the APEX installer into customized location.

    Example: </u01/ouaw/apex>. This location will be referred to as the APEX Home directory.

Download the OUAW database software

  1. Download "Oracle Utilities Analytics Warehouse v2.9.0.0 Oracle Database Multiplatform.zip" from Oracle Software Delivery Cloud.

  2. Unzip the file to a temporary directory using any zip command. Example: </u01/ouaw/temp/database>.

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

Extract the Admin Tool

  1. Download "Oracle Utilities Analytics Warehouse v2.9.0.0 Multiplatform.zip" from Oracle Software Delivery Cloud.

  2. Extract "Oracle Utilities Analytics Warehouse v2.9.0.0 Multiplatform.zip" AdminTool folder to a temporary directory. Example: </u01/ouaw/temp/AdminTool>. This directory contains database SQL scripts.

Back to Top

Pre-Installation Requisites for OUAW Application Server

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

Note: While the table below includes some example directory structures, you can decide where the software will be installed. Make sure you keep track of all the home directories you create, as these will be used at the time of OUAW installation. Additionally, make sure the same OS user installs all software, and replace all parameters enclosed in <> with actual values.

Task

Description

Download and install the Java Development Kit

  1. Download Oracle Java Development Kit (JDK) 1.8 from My Oracle Support to a temporary directory on the application server. Example: </u01/ouaw/temp/java>

  2. Install the JDK at a customized location. Example: </u01/ouaw/java>. This will be 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 server and the database server 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 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>. 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

  1. Download the Oracle WebLogic Server 12.2.1.4 Patch 34065178 (Required FMW Compatibility Patch for JDK 8 u331 or later) and 36178496 from My Oracle Support to a temporary directory. Example: </u01/ouaw/temp/middleware>.

    Note: Find the detailed patch installation steps in the README file within each Patch Package.

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

  3. Run the following to install 34065178 patch:

    $ORACLE_HOME/OPatch/opatch apply

  4. Run the following to install 36178496 patch:

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

  5. Download the Oracle Fusion Middleware Infrastructure 12.2.1.4 Patches 36074941, 34809489, 36034300, 35868571, 34542329, and 33950717 from My Oracle Support to a temporary directory. Example: </u01/ouaw/temp/middleware>.

  6. Run the following to install the above patches:

    $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 version 7.0 (OAS 2023) or Oracle Analytics Server version 7.6 (OAS 2024) 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 considers 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

OAS 7.0 (2023)

  1. Download the Oracle Analytics Server (OAS 7.0) patch 36174464 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 Oracle Analytics Server domain 

  1. Navigate to the OAS installed $ORACLE_HOME/bi/bin location. Example: <FMW Home>/bi/bin.

  2. Run the following script: ./config.sh

  3. Configure the Oracle Analytics Server domain with a customized name. Example: <oas_domain> at a customized location, such as </u01/ouaw/domains>. This will be referred to as DOMAIN Home.

  4. While running the Oracle Repository Creation Utility as part of the domain configuration, do the following:

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

    • Enter a unique schema prefix, such as 'OAS'.

See Configuring the Oracle Analytics Server Domain with the Configuration Assistant for additional details.

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>. After installation, you can find the ODI directory under the FMW Home path. Example: <FMW Home>/odi.

    If necessary, see Install Oracle Data Integrator for detailed instructions.

Download and apply the ODI patch

  1. Download and apply the Oracle Data Integrator 12.2.1.4 patch 36114577 from My Oracle Support.

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

  3. Run the following executable:

    Copy 
    $ORACLE_HOME/OPatch/opatch apply

Configure repository 

  1. Ensure JAVA_HOME is defined.

  2. Ensure ODI is installed.

  3. Run the Repository Creation Utility (RCU) for ODI schema. Example execution:

    Copy 
    <FMW Home>/oracle_common/bin
    ./rcu

  4. Create a Schema repository for ODI and provide the database connection details.

  5. On the Select Components section, create a new prefix (for example, 'ODI'), select the Oracle Data Integrator checkbox, and then deselect the Oracle Data Integrator checkbox.

    Select Components section in Repository Creation Utility page.Select your components as detailed in step 5.

  6. Click Next and proceed through the rest of the screens to create the repository.

Note: Keep track of the password given. It will be required while creating the Oracle Data Integrator domain.

Download APEX

Download the Oracle APEX 23.2 from Oracle APEX 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 ORDS

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

Download the OUAW application software

  1. Download "Oracle Utilities Analytics Warehouse v2.9.0.0 Multiplatform.zip" and "Oracle Utilities Analytics Warehouse v2.9.0.0 Dashboard Component.zip" from Oracle Software Delivery Cloud.

  2. Extract "Oracle Utilities Analytics Warehouse v2.9.0.0 Multiplatform.zip" and "Oracle Utilities Analytics Warehouse v2.9.0.0 Dashboard Component.zip" to a temporary directory. Example: </u01/ouaw/temp/application>. The ETL component installer jar file is OUAW_2.9.0.0.0_ETL_generic.jar and Dashboard Components are <OAS Version>/rpd, catalog, and WriteBackTemplates.

Back to Top

OUAW Directory Structures and Other Required Information

The example software installation directories listed below can be used for OUAW installations and configurations. These locations will be referred to as the Java Home, Oracle Home, GoldenGate Home, Domain Home, Database, and Application Home.

Information Type

Example

JAVA_HOME

The Java installation path on the OUAW database and application servers.

<Java Home on Application Server>

Example: </u01/ouaw/java>

ORACLE_HOME

The Oracle database installation path on the OUAW database server.

<Database Home on Database Server>

Example: </u01/ouaw/database>

Database Client

The Oracle Database client installation path on the OUAW application server.

<Database Client Home on Application Server>

Example: </u01/ouaw/clientBase>

GoldenGate Microservices Installation Home

The Oracle GoldenGate Microservices installation path on the OUAW database server.

<GoldenGate Microservices Installation Home on Database Server>

Example: </u01/ouaw/goldengate_MA>

GoldenGate Microservices Service Manager Home

The Oracle GoldenGate Microservices Service Manager path on the OUAW database server.

<GoldenGate Microservices Service Manager Home on Database Server>

Example: </u01/ouaw/goldengate_SM>

GoldenGate Microservices Deployment Home

The Oracle GoldenGate Microservices Deployment Home on the OUAW database server.

<GoldenGate Microservices Deployment Home on Database Server>

Example: </u01/ouaw/goldengate_Deploy>

GoldenGate Microservices Client Wallet Location

Note: OGG client wallet location is under "<OGG Deploy Home>/ etc/ssl/" after OGG MS deployment.

 Example: </u01/ouaw/goldengate_Deploy/etc/ssl/distclient/client_wallet>

FMW Home

The Oracle Fusion Middleware Infrastructure installation path on the OUAW application server.

<FMW Home on Application Server Used for OAS/ODI>

Example: </u01/ouaw/middleware>

OAS Domain

The OAS Domain path. Keep track of this value, as it is referenced while Installing OUAW Dashboards.

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

Source & Target GoldenGate Microservice Service Manager Port

 

Example: <7860>

Source & Target GoldenGate Microservice Admin Service Port

Keep track of this value, as it is referenced while installing OUAW ETL and Source Configuration

Example: <7861>

Source & Target GoldenGate Microservice Distribution Service Port

Keep track of this value, as it is referenced while configuring Source

Example: <7862>

Source & Target GoldenGate Microservice Receiver Service Port

Keep track of this value, as it is referenced while installing OUAW ETL

Example: <7863>

Database Server Host Name

The database server where the database needs to be installed.

Example: <dbserver.hostname>

Source & Target GoldenGate Microservice Host Name

The server where GoldenGate Microservice is installed. Here, the Database Server Host is the same as the GoldenGate Microservice Host.

 Example: <ggms.hostname>

Application Server Host Name

The application server where Java, FMW, ODI, and OAS software components need to be installed.

Example: <appserver.hostname>

Back to Top