Perform Pre-Installation Steps for OUAW

1. Download the Oracle Java Development Kit (JDK) 1.8 version from Oracle Technology Network 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.

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.

1. Download the Database Server Patch 33806152 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 a database for OUAW installation. Use the AL32UTF8 character set.

1. Download Oracle GoldenGate 19.1 from Oracle Software Delivery Cloud to a temporary directory. See Install GoldenGate for details. Example: </u01/ouaw/temp/goldengate>.

2. Install Oracle GoldenGate on the Target Database server(s) at a customized location. Example: </u01/ouaw/goldengate>. This will be referred to as Oracle GoldenGate Home.

1. Download Oracle GoldenGate Monitor Agent 12.2.1.2 from Oracle Software Delivery Cloud to a temporary directory. Example: </u01/ouaw/temp/oggagent>.

2. Choose the installation type Oracle GoldenGate Monitor Agent while installing at a customized location. Example: </u01/ouaw/oggagent>. This location will be referred to as Oracle GoldenGate Monitor home.

1. Download and apply patch 26982776 from My Oracle Support on top of the Oracle GoldenGate Monitor agent.

2. Set the ORACLE_HOME to Oracle GoldenGate Monitor agent 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

1. Go to <Oracle GoldenGate Monitor Agent home>/oggmon/ogg_agent/cfg_templates directory and open the template "Config.properties" file.

2. Modify the parameters below.

   Copy

   ACTUAL: jagent.host=localhost
   CHANGE TO: jagent.host=<<actual hostname on which Oracle GoldenGate is installed>>
   
   ACTUAL: monitor.jmx.username=oggmsjmxusr
   CHANGE TO: monitor.jmx.username=jmx_src
   
   ACTUAL: jagent.username=oggmajmxusr
   CHANGE TO: jagent.username=<<Oracle GoldenGate software installed OS user>>
   
   ACTUAL: jagent.rmi.port=5559
   CHANGE TO: jagent.rmi.port=5557 or any free port other than the one on which the rmiregistry is started
   
   ACTUAL: agent. type.enabled=OGGMON
   CHANGE TO: agent.type.enabled=OEM

1. Navigate to <Oracle GoldenGate Monitor home>/oggmon/ogg_agent.

2. Run the following script: createMonitorAgentInstance.sh. Example execution:

   Copy

   cd <Oracle GoldenGate Monitor home>/oggmon/ogg_agent
   ./createMonitorAgentInstance.sh

3. When prompted, enter the following information:

• Oracle GoldenGate home directory: <GoldenGate Home location>
• Path to use for Oracle GoldenGate Monitor Agent instance. Example: </u01/ouaw/ogginstance>. This will be referred to as the Oracle GoldenGate Monitor Instance home.
• A unique name to replace the timestamp in the name of the file used to start the Oracle GoldenGate Monitor agent instance. 

1. Navigate to <Oracle GoldenGate Monitor Agent instance Home>/bin.

2. Add JAVA_HOME/bin to the PATH variable.

   Copy

   export JAVA_HOME=<JAVA HOME PATH>
   export PATH=$JAVA_HOME/bin:$PATH

3. Run the following script: pw_agent_util.sh. Example execution:

   Copy

   cd  < Oracle GoldenGate Monitor Instance>/bin
   ./pw_agent_util.sh -jagentonly

4. Enter the Oracle wallet password. This password must be entered as the password for the JAgent while running the OUAW installer.

5. Store the password for future reference.

1. Download the latest version of Oracle APEX 22.1 from Oracle Technology Network 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.

1. Download "Oracle Utilities Analytics Warehouse v2.8.0.1 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/BI2801>

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 at a customized location. Example: </u01/ouaw/java>. This will be referred to as JAVA_HOME.

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.

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 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 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 34373563 patch:

   $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 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 34974729 patch:

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

For OAS 7.6 (OAS 2024) 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 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 patches mentioned in Step 5:

   $ORACLE_HOME/OPatch/opatch apply

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

1. Download the latest Oracle Analytics Server (OAS) version 6.4.0 / 7.0 (OAS 2023) / 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.

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

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.

1. Download Oracle Data Integrator (ODI) 12.2.1.4 from Oracle Technology Network 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.

1. Download and apply the Oracle Data Integrator 12.2.1.4 patch 34345040 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

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.

   

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 the Oracle APEX 22.1 from Oracle Technology Network 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 the Oracle REST Data source (ORDS) 21.1.3 version from Oracle Technology Network and extract it to a local directory. Example: </u01/ouaw/ords>. After extraction you can see the ords folder. Example: </u01/ouaw/ords>.

<Java Home on Application Server>

Example: </u01/ouaw/java>

<Database Home on Database Server>

Example: </u01/ouaw/database>

<Database Client Home on Application Server>

Example: </u01/ouaw/clientBase>

<GoldenGate Home on Database Server>

Example: </u01/ouaw/goldengate>

<GoldenGate Monitor Agent Home on Database Server>

Example: </u01/ouaw/oggagent>

<GoldenGate Monitor Agent Instance Home on Database Server>

Example: </u01/ouaw/ogginstance>

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

Example: </u01/ouaw/middleware>

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

This is mentioned in the "Edit configuration template" task in Pre-Installation Requisites for OUAW Database Server above.

This is mentioned in the "Create JAgent Wallet" task in Pre-Installation Requisites for OUAW Database Server above.

Example: <7830>

Example: <dbserver.hostname>