Upgrade Tech Stack for OUAW

1. Download the Database Server Patch 35643107 from My Oracle Support to a temporary directory.
   Example: </u01/ouaw/temp/database>.

   Note: Download the patch that corresponds to your server operating system.

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

Note: Follow the README while applying the database patches.

1. Download and apply patch 35580180 (for Solaris and Linux) or 35682480 (for AIX) from My Oracle Support on top of the Oracle GoldenGate.
2. Set the ORACLE_HOME to the Oracle GoldenGate home installed location. 
3. Unzip the patch, navigate to the patch top folder, and run the following:
   Copy

   $ORACLE_HOME/OPatch/opatch apply

Note: Do not start the GoldenGate processes after applying the patch.

1. Download and apply patch 34362913 from My Oracle Support on top of the Oracle GoldenGate Monitor Agent.
2. Set the ORACLE_HOME to the Oracle GoldenGate Monitor Agent home installed location. 
3. Unzip the patch, navigate to the patch top folder, and run the following:
   Copy

   $ORACLE_HOME/OPatch/opatch apply

1. Download the latest version of Oracle APEX 22.1 from Oracle Application Express to a local directory.

   Example: </u01/ouaw/temp>

2. Extract the APEX installer into a customized location.

   Example: </u01/ouaw/apex>.

Note: This location will be referred to as the New APEX Home directory.

1. Download the Oracle Utilities Analytics Warehouse v2.8.0.2 Oracle Database Multiplatform.zip file 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/BI2802>

1. Download the Oracle Java Development Kit (JDK) 1.8 version (JDK 1.8.0.391) from Oracle Technology Network to a temporary directory.
2. Upgrade the JDK to JDK 1.8.0 (391).

Note: Rename the existing JDK path and upgrade/install the new JDK by creating the same JDK path so that JAVA_HOME is the same as the previous.

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 in a customized location.

   Example: </u01/ouaw/middleware>.

   Note: This will be referred to as FMW Home. This installation path can be used for Oracle Analytics Server (OAS 7/2023).

See Install Oracle Fusion Middleware Infrastructure for more information.

Note: Apply these patches in both OAS and ODI ORACLE_HOME (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 35899167 from My Oracle Support to a temporary directory.

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

   Note: Detailed patch installation steps are in the README file in each patch package.

2. Unzip the patch and navigate to the patch top folder.
3. Run the following to install patch 34065178:
   Copy

   $ORACLE_HOME/OPatch/opatch apply

4. Run the following to install patch 35899167:

   Copy

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

5. Download the Oracle Fusion Middleware Infrastructure 12.2.1.4 35751917, 34809489, 35735469, 35868571, 34542329, and 33950717 patches from My Oracle Support to a temporary directory.

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

6. Run the following to install those patches:

   Copy

   $ORACLE_HOME/OPatch/opatch apply

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

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

Note: Apply this patch in OAS ORACLE_HOME (FMW Home).

1. Download the Oracle Analytics Server (OAS 7.0) patches 35860780 and 35084179 from My Oracle Support to a temporary directory.
   

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

3. Run the following for each patch:

   Copy

   $ORACLE_HOME/OPatch/opatch apply

Note: Apply this patch in ODI ORACLE_HOME (FMW Home).

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

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

3. Run the following:
   Copy

   $ORACLE_HOME/OPatch/opatch apply

Post Patch Instructions:

Note: For more details, follow the README file in patch package.

1. Clear the ODI cache after having applied the patch.

   For ODI Studio, run the odi command with -clean -initialize parameters. See Document 1943854.1 in My Oracle Support for details.

   For ODI J2EE Agent, clear the cache of the WebLogic Managed Server hosting the application, as explained in Document 2171537.1 in My Oracle Support.

2. Make a backup of your ODI repository schema. Ensure a proper backup of the ODI repository exists prior to upgrade. If the patch needs to be rolled back, the repository will need to be restored from the backup. Repository restoration is also required in case the upgrade assistant fails.

3. If you are upgrading from an ODI release prior to 12.2.1.4.210321, then use the Upgrade Assistant (UA) to upgrade all ODI repositories associated with the installation.

Note: Before performing this upgrade, make sure that all work and master repository schema users have been granted CREATE VIEW and CREATE PROCEDURE privileges.

grant create view to OUA_MASTER;
grant CREATE PROCEDURE to OUA_MASTER;
grant create view to OUA_WORK;
grant CREATE PROCEDURE to OUA_WORK;

Download Oracle APEX 22.1 from Oracle Application Express 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 REST Data Services and extract it to a local directory.

Example: </u01/ouaw/ords>

After extraction, you can see the ords folder.

Example: <u01/ouaw/ords>