This document is intended for system administrators or application developers who are upgrading Oracle Financial Services Lending and Leasing Application.
Term |
Refers to |
Home Directory/$OFSLL_HOME |
Oracle Financial Services Lending and Leasing Home Directory |
Application |
Oracle Financial Services Lending and Leasing |
An upgrade is a process of updating an existing version to its higher version. For example, upgrading Oracle Financial Services Lending and Leasing from 14.6.0.0.0 to 14.7.0.0.0.
Before upgrade, you need to stop the queues to prevent object locks. Hence, copy ‘stopqueues.sql’ file available under \ofslldb.zip\sql folder to $OFSLL_HOME\sql. This is executed during the subsequent steps of upgrade process.
Before you start with the upgrade process, execute the following grants as sys user:
Choose ‘2’ as the installer option at the ‘Selecting the Install Type’ stage, then the script runs the upgrade installer.
During the upgrade process directory objects are to be created and installer prompts for the same as indicated below:
Respond to the prompts and continue. For more details, refer to ‘Installing Upgrade’ section in Database Installation Guide.
While installing the upgrade, the installer performs the following tasks:
Post upgrade, install the database object of web services by referring to the instructions detailed in chapter 2 ‘Installing WebServices Database Objects’ of WebServices Installation Guide.
Grant java file permissions for the directory objects created by executing the script ‘set_java_perms.sql’ available in dba_utils folder. For more information, refer to the process detailed in section 2.5 of Database installation guide.
Note
Post upgrade, if there are any invalid java stored procedures noticed, please recompile the respective units manually.