Upgrade Tech Stack for OUAW

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

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

   Note: Make sure to 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: $ORACLE_HOME/OPatch/opatch apply

Note: Follow the README while applying the database patches.

1. Download the latest version of Oracle APEX 22.1 from Oracle Technology Network 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.1 Oracle Database Multiplatform.zip file from Oracle Software Delivery Cloud.
2. Unzip the file to a temporary directory using any zip command.

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

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

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) 6.4 ORACLE_HOME during its installation.

See Install Oracle Fusion Middleware Infrastructure for more information.

Note: Apply these patches in both OAS and ODI ORACLE_HOME, since OAS and ODI FMW Homes are different.

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

   Copy

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

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

1. Download Oracle Analytics Server (OAS) version (6.4.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.

1. Download the Oracle Analytics Server (OAS) patches 34373446 and 33877829 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

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

Note: Before applying the patch, set the ORACLE_HOME where ODI is installed, since OAS and ODI ORACLE_HOME are different.

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

3. Run the following:
   Copy

   $ORACLE_HOME/OPatch/opatch apply

Post Patch Instructions:

1. Clear the ODI cache after having applied the patch for ODI Studio, and 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. Execute the queries below in the target database.

Copy

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