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.
Task |
Description |
---|---|
Download and install the Java Development Kit |
|
Download and install Oracle Database Server Enterprise |
|
Download and apply Database Server Patch |
|
Create database for installation |
Create a database for OUAW installation. Use the AL32UTF8 character set. |
Download and install GoldenGate Microservices |
|
Apply patch for GoldenGate Microservices |
|
Create Oracle GoldenGate Microservices Deployment |
Note: OUAW only supports GoldenGate Microservice Secure Deployments. Prerequisites:
Add Oracle GoldenGate Microservices Deployment with the following command: Copy
Refer to Setting Up Secure or Non-Secure Deployments for more information. Examples:
Note:
|
Download and extract Oracle APEX |
|
Download the OUAW database software |
Note: You can find the OUAW Database Installers at the following location after unzipping the file: |
Extract the Admin Tool |
|
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 |
|
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 |
See Install Oracle Fusion Middleware Infrastructure for more information. |
Download and apply Oracle Fusion Middleware Infrastructure Patch |
|
Download and install Oracle Analytics Server (OAS) |
See Install Oracle Analytics Server for more information. |
Download and apply Oracle Analytics Server (OAS) Patch |
OAS 7.0 (2023)
|
Configure Oracle Analytics Server domain |
See Configuring the Oracle Analytics Server Domain with the Configuration Assistant for additional details. |
Download and install Oracle Data Integrator (ODI) |
|
Download and apply the ODI patch |
|
Configure 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 |
|
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> |