9.2 Prepare for Upgrade

Before you plan to install or upgrade any of your application packs to Release 8.1.2.0.0, ensure that all the application packs in your current OFSAA instance are available in the Release 8.1.2.0.0 version. For more information about the release version details, contact My Oracle Support.

Note:

Ensure to revert any customized data model changes done without performing data model upload before upgrading.

The minimum supported version is 8.0.6.1.0. If upgrading from a release before 8.0.6.1.0, then first upgrade to 8.0.6.1.0 or later. After this step, you can upgrade to 8.1.2.0.0 or later.

  1. Backup the following environment files from their respective directories:
    • Database schema
    • OFS_HM_PACK.xml
    • OFS_HM_SCHEMA_IN.xml
    • OFSAAI_InstallConfig.xml
  2. See the OFS Analytical Applications Technology Matrix for the hardware and software required to upgrade to OFS HM Release 8.1.2.0.0.
  3. Enable unlimited cryptographic policy for Java. For more information, see the Enabling Unlimited Cryptographic Policy section in the OFS Analytical Applications Infrastructure Administration Guide.
  4. Clone your environment. There is a consistent need for a faster and effective approach of replicating an existing OFSAA instance for further project developments, that is, setting up OFSAA instances that are exact copies of the current OFSAA instance. For more information, see the Clone your Existing Environment section.
  5. Execute the following SQL query on the Atomic Schema:

    update rev_tables_b set version=0 where version is null; commit;

  6. You must apply the OFS AAI patch 32530173 in case of Pack-on-Pack v8.1.2.0.0 installation. Do not apply this patch, if you have already applied it as part of another application pack’s installation.