Upgrade Process Overview
Explanations of the high level steps involved in the upgrade process are provided below.
High Level Steps In Upgrade Process
- Back up the target upgrade environment application database and IVS. This is very important. If any portion of the upgrade fails, then you will need to restore the current environment from this backup before re-running the upgrade utility.
- Database user should have Create, Drop and update privileges on Database Tables and Stored Procedures. Once the running of upgrade utility is completed the create and drop privileges have to be revoked from the user.
Grant: grant create view to <OIPA Username>; grant create trigger to <OIPA UsernameUsername>; grant create CREATE SYNONYM to <OIPA Username>; grant create CREATE TABLE to <OIPA Username>; grant create UNLIMITED TABLESPACE to <OIPA Username>; Revoke: REVOKE CREATE SYNONYM from <User>; REVOKE create view from <User>; REVOKE CREATE TABLE from <User>;REVOKE create trigger from <User>; |
- Install the Rules Palette Web Application Utility. The Installation guide for your application server is included in the Documentation Library for the 11.2.0.0 release on the Oracle Technology Network (OTN) website.
- Install the upgrade utility. The utility is located on the Oracle Software Delivery Cloud (https://edelivery.oracle.com/) in the Oracle Insurance Policy Administration 11.2.0.0 Media Pack. It is listed as a separate download.
- Configure the Palette Web Application Utility.
- Unzip the OIPA Version 11.2.0.0 Upgrade Utility.
- Create the upgrade environment in the upgrade utility and Upgrade Utility login credentials ( this is same as Rules Palette Credentials )
- Execute the upgrade utility.
- Review the results.
- Install a new version of the Rules Palette application. (The Installation guide for your platform is included in the Documentation Library for the 11.2.0.0 release on the Oracle Technology Network (OTN) website).
- Log in to the Rules Palette and run the Version Generator.
- Install a new version of the OIPA application. (The Installation guide for your application server is included in the Documentation Library for the 11.2.0.0 release on the Oracle Technology Network (OTN) website.
- Test the environment.
Note: Executing the upgrade utility will modify the rules and the database structure for the target environment only. Currently, the utility does not support release management, so it will have to be executed in all environments in your production pipeline.
