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.

System Requirements and Supported Platforms

Before you begin installation, verify that the minimum system hardware and network requirements are met. See System Requirements 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.
Task Description
Download and install the Java Development Kit

  1. Download the Oracle Java Development Kit (JDK) 17.0.16+ 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
Download and apply the Database Server Patch 37960098 from My Oracle Support.

Note:

Find the detailed patch installation steps in the README file within each Patch Package.
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 23ai 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
Download and apply patch 38139662 (for Linux) from My Oracle Support.

Note:

Find the detailed patch installation steps in the README file within each Patch Package.
Create Oracle GoldenGate Microservices Deployment

Note:

OUAW only supports GoldenGate Microservice Secure Deployments.

Prerequisite:

  • 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 Secure.

Add Oracle GoldenGate Microservices Deployment with the following command:

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

Refer to Deploy 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:

Set the Replication Schema settings.
  1. Set the Replication Schema to MDADM for the Receiver (Target) GoldenGate Microservices.


    Set the Replication Schema setting to the Oracle GoldenGate Owner.

  2. Set the Replication 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.


    Set the Replication Schema setting to Oracle GoldenGate Owner.
Download and extract Oracle APEX

  1. Download Oracle APEX 24.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 v25.10.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/BI251000> .
Extract the Admin Tool

  1. Download "Oracle Utilities Analytics Warehouse v25.10.0.0 Multiplatform.zip" from Oracle Software Delivery Cloud.

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

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
Java 8

  1. Download Oracle Java Development Kit (JDK) 17.0.16+ 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/java8>.

    Note:

    This will be referred to as JAVA_HOME for FMW 12c and OAS installation.
Java 17

  1. Download Oracle Java Development Kit (JDK) 17.0.16+ 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/java17>. This will be referred to as JAVA_HOME.

    Note:

    This will be referred to as JAVA_HOME for FMW 14c, ODI 14c, Apex 24.2, ORDS 25.1, and Oracle Utilities Analytics Warehouse installation.
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
FMW 12c

  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/middleware12c>.

    Note:

    This will be referred to as FMW 12c Home for OAS installation.

See Install Oracle Fusion Middleware Infrastructure for more information.

FMW 14c

  1. Download the Oracle Fusion Middleware Infrastructure 14.1.2.0 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/middleware14c>.

    Note:

    This will be referred to as FMW 14c Home for Apex Domain where i.war (Apex 24.2) and ords.war (ords 25.1.1) will be deployed and ODI 14c installation.

See Install Oracle Fusion Middleware Infrastructure for more information.

Download and apply Oracle Fusion Middleware Infrastructure Patch
FMW/WLS 12c Patches

Note:

FMW/WLS 12c are included in OAS STACK PATCH BUNDLE patch which will be applied after OAS Installation.
FMW/WLS 14c Patches

  1. Download the Oracle WebLogic Server 14.1.2 Patch 38166406 from My Oracle Support.

  2. Download and apply the Oracle Fusion Middleware Infrastructure 14.1.2 Patches 38015961, 38184117, and 38032126 from My Oracle Support.

    Note:

    Find the detailed patch installation steps in the README file within each Patch Package.
Download and install Oracle Analytics Server (OAS)

  1. Download the Oracle Analytics Server version 8.2 (2025) from Oracle Software Delivery Cloud to a temporary directory.

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

  2. Install the OAS software at the <FMW 12c Home> location, here considers ORACLE_HOME path.

    Example: </u01/ouaw/middleware12c>.

    After installation, you can find the "bi" directory inside the FMW Home. Example: <FMW 12c Home>/bi.

See Install Oracle Analytics Server for more information.

Download and apply Oracle Analytics Server (OAS) Patch
Download and apply the Oracle Analytics Server 8.2 patches 38161336 and 34809489 from My Oracle Support.

Note:

Find the detailed patch installation steps in the README file within each Patch Package.
Configure Oracle Analytics Server domain

  1. Navigate to the OAS installed $ORACLE_HOME/bi/bin location. Example: <FMW 12c 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) 14.1.2 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 14c Home path.

    Example: </u01/ouaw/middleware14c>.

    After installation, you can find the ODI directory under the FMW Home path. Example: <FMW 14c Home>/odi.

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

Download and apply the ODI patch
Download and apply the Oracle Data Integrator 14.1.2 patches 38172533 and 36668195 from My Oracle Support.

Note:

Find the detailed patch installation steps in the README file within each Patch Package.
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:
    <FMW 14c Home>/oracle_common/bin
./rcu

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

    On the Select Components section, create a new prefix (for example, 'ODI') and select the schema as per screenshot below.

    Note:

    Do not select the Oracle Data Integrator checkbox.


    Select Components section in Repository Creation Utility page. Select your components.

  5. 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 24.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) 25.1.1 version from Oracle REST Data Services and extract it to a local directory.
Download the OUAW application software

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

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

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/java8> or </u01/ouaw/java17>

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>

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/middleware12C> or </u01/ouaw/middleware14c>

OAS Domain

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

 Example: </u01/ouaw/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: <target.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

<target.ggms.server.host> = <target.dbserver.hostname>

<source.ggms.server.host> = <source.dbserver.hostname>

Application Server Host Name

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

 Example: <appserver.hostname>