Pre-requisites

  1. Database and IVS should be installed according to the OIPA Database Installation Instructions.

Upgrade Utility does not require IVS for upgrading OIPA Database. Non-IVS environment can be created and used to upgrade between versions. If this approach is used, IVS upgrade scripts has to be run after OIPA upgrade is performed. Non-IVS Environment approach is recommended.

  1. NON-IVS Environment Approach:
  1. (For Upgrades from 9.7.x to 11.X) Palette Web Application Utility version 11.x , deployed and configured (as described in the Rules Palette Set-Up Instructions).
  2. Hostname and port for the Palette Web Application Utility
  3. Upgrade Utility login credentials (this is same as Rules Palette Credentials).
  1. IVS Environment Approach:
  1. (For Upgrades from 9.7.x to 11.X) IVS scripts (given at the end of this document) should be run before using the upgrade Utility tool to upgrade the OIPA database.
  2. (For Upgrades from 9.7.x to 11.X) Palette Web Application Utility version 11.X , deployed and configured (as described in the Rules Palette Set-Up Instructions)
  3. Microsoft Windows 2000 or later.
  4. Hostname and port for the Palette Web Application Utility Upgrade Utility login credentials (this is same as Rules Palette Credentials).
  1. OIPA application database and IVS database user name and password
  1. The following scripts must be run in the OIPA database before running the upgrade utility if their is no entry in DATABASECHANGELOGLOCK table:
INSERT INTO DATABASECHANGELOGLOCK (ID,LOCKED,LOCKGRANTED,LOCKEDBY) VALUES (1,0,null,null);

If the DATABASECHANGELOGLOCK table doesn't exists in the database then following script should get run first to create the table :

Script for Oracle Database:

CREATE TABLE DATABASECHANGELOGLOCK ( ID NUMBER(38) NOT NULL, LOCKED  NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP(6), LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID) );

 

Script for Db2 Database:

CREATE TABLE DATABASECHANGELOGLOCK ( ID INT NOT NULL, LOCKED SMALLINT NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
 

Script for SqlServer Database:

CREATE TABLE DATABASECHANGELOGLOCK ( ID INT NOT NULL, LOCKED BIT NOT NULL, LOCKGRANTED DATETIME, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));

The script above may not be necessary in some cases. If a violation of the PK_DATABASECHANGELOGLOCK constraint is returned upon execution of the script, the violation can be disregarded.

 

 

 

 

 

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us