11.5.2 Initializing the Upgrade

To initialize the upgrade, follow these steps:

  1. Download the OFS LRS Application Pack Release 8.1.0.0.0 installer from Oracle Software Delivery Cloud.
  2. Copy the archive file to your OFSAA server in Binary mode.

    NOTE The archive files are different for every operating system such as Solaris, and RHEL or Oracle Linux.

  3. Log in to the OFSAA Server with user credentials that were used to install OFSAA.
  4. Shut down all the OFSAAI Services. See the Stop the Infrastructure Services and Start the Infrastructure Services section in the OFS AAI Release 8.1.0.0.0 Installation and Configuration Guide for details.
  5. Execute the command:

    chmod -R 750 $FIC_HOME

  6. If you have Unzip utility, skip to the next step. Download the Unzip utility (OS-specific) and copy it in Binary mode to the directory that is included in your PATH variable, typically $HOME path or directory in which you have copied the 8.1.0.0.0 installer.

    Uncompress the unzip installer file using the command:

    uncompress unzip_<os>.Z

    NOTE If you receive an error message: uncompress: not found [No such file or directory] when the package is not installed, contact your UNIX administrator.

  7. Give execute permission to the file using the command:

    chmod 751 OFS_LRS_81000_<OperatingSystem>.zip

  8. Extract the contents of the Oracle Financial Services Liquidity Risk Solution Application Pack 8.1.0.0.0 in the Download Directory installer archive file using the command:

    Unzip <name of the file to be unzipped>

    Note:

    For Solaris OS, download, extract and apply the one-off patch 31509494 from My Oracle Support. See the Readme packaged with the patch for further instructions on how to install the patch.
  9. Log in to OFSAA Infrastructure Config Schema and execute the following SQL query:

    ALTER TABLE CONFIGURATION MODIFY PARAMNAME VARCHAR2 (100 CHAR);

  10. Give execute permission to the archive file. Navigate to the path where the directory OFS_LRS_PACK exists and execute the command:

    chmod –R 755 OFS_LRS_PACK

  11. Execute the user .profile file.
  12. Navigate to the /OFS_LRS_PACK/schema_creator/conf directory and modify the OFS_LRS_SCHEMA_IN.xml file by providing the existing values to the parameters JDBC_URL, JDBC_DRIVER, Host, Setupinfo name, schema names (config and atomic), password, default tablespace, Infodom, Quota as per the previous version.
  13. Navigate to the /OFS_LRS_PACK/schema_creator/bin directory and execute the osc.sh file using the following command:

./osc.sh -s

NOTE

Step 11 and 12 are required to generate the

OFS_LRS_SCHEMA_OUTPUT.xml

file.