Upgrade Tech Stack for OUAW
This page details the tasks required to upgrade the services that are used to run Oracle Utilities Analytics Warehouse.
On this page:
Upgrade the Tech Stack for the Database Server
This section covers the instructions for the downloads, installations, and upgrades that can be performed on the Oracle Utilities Analytics Warehouse database server.
Notes:
- Before upgrading, back up the current environment and ensure you have a rollback plan.
- Make sure the same OS user installs all software, and that you replace all parameters enclosed in <> with valid values.
- While the table below includes some directory structures as examples, you can choose where to install the software. Make sure to keep track of all the home directories you create, as these will be used for OUAW installation.
Task |
Description |
---|---|
Download and apply Database Server Patch |
|
Download and extract Oracle APEX |
|
Download the OUAW database software |
|
Extract the Admin Tool |
|
Upgrade the Tech Stack for the Application Server
This section covers the instructions for the downloads, installations, and upgrades that can be performed on the Oracle Utilities Analytics Warehouse application server.
Notes:
- Before upgrading, back up the current environment and ensure you have a rollback plan.
- Make sure the same OS user installs all software, and that you replace all parameters enclosed in <> with valid values.
- While the table below includes some directory structures as examples, you can choose where to install the software. Make sure to keep track of all the home directories you create, as these will be used for OUAW installation.
Task |
Description |
---|---|
Download and Upgrade the Java Development Kit |
|
Download and install Oracle Fusion Middleware Infrastructure |
See Install Oracle Fusion Middleware Infrastructure for more information. |
Download and apply Oracle Fusion Middleware Infrastructure Patch |
Note: Apply these patches in both OAS and ODI ORACLE_HOME.
Note: ORACLE_HOME is referred to as <FMW Home location>. |
Download and install Oracle Analytics Server (OAS) |
After installation, you can find the "bi" directory inside the FMW Home. Example: <FMW Home>/bi See Install Oracle Analytics Server for more information. |
Download and apply Oracle Analytics Server (OAS) Patch |
|
Download and apply the ODI patch |
Post Patch Instructions:
|
Download and extract Oracle APEX |
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 and Extract ORDS |
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> |
Download the OUAW Application Software |
|
Upgrade the Existing Domains and Repository
This section details how to upgrade the existing domains and the repository in accordance with the in-place upgrade domain strategy.
Notes: Before upgrading a repository or domain activity, make sure you have a rollback plan in case it is necessary to revert your changes.
OAS Repository and Domain In-Place Upgrades
For OAS repository and domain in-place upgrades, follow the steps in Upgrading to the Latest Release of Oracle Analytics Server.