6.5 Upgrading from 8.0.8.2.0 to 8.1.2.0.0

To upgrade from 8.0.8.2.0 to 8.1.2.0.0, do the following:

Note:

Before upgrade to Sanction pack 8.1.2.0.0 take backup of all STG tables. Use the list of the STG tables and create SQL truncate script for truncating STG tables from BD atomic schema. For the list of STG table, see CSA_Data_Map_812.xlsx in Components of Sanctions Pack (Doc ID 2329509.1) .

To upgrade from 8.0.8.2.x to 8.1.2.0.0, follow these steps before applying 8.1.2.0.0.
  1. Take backup of the kdd_centricity table and truncate it.
  2. Execute the following queries.
    • alter table fsi_rt_match_service drop CONSTRAINT UK_FSI_RT_MATCH_SERVICE1;
    • alter table fsi_rt_match_service drop column V_GOOD_SERVICE_UNIQ_ID;

Note:

Before you run the patch/installer, perform a backup of the Schemas (Atomic and Config), FIC_HOME, and ftpshare directories.
  1. Apply Sanctions 8.1.2.0.0.
  2. Go to <##INSTALLER KIT##>/OFS_SANC_PACK/OFS_TFLT/conf.
  3. Open the PatchConfig.xml file and configure the parameters as shown below:

    Table 6-5 PatchConfig.xml Parameters

    Tag Name/ Attribute Name Description Mandatory (Y/ N) Default Value/ Permissible Value Comments

    SCHEMA_OUT_XML_PATH

    		 Specifies the Schema XML path Y Unique Seeded Value -
    DATA_TABLE_S PACE Provides the tablespace data Y Unique Seeded Value -
    INDEX_TABLE_ SPACE Provides the tablespace index Y Unique Seeded Value -
    BIG_DATA_ENA BLE Flag to enable or disable big data N False DO NOT modify this value.

    EXECUTE_PRE_AND_POST_S CRIPTS

    		 Provides the pre and post scripts that need to be executed Y 1 -
    SWIFT_INFO Provides the SWIFT information Y Unique Seeded Value -

    SANC_ATOMIC_USER

    		 Provides the ATOMIC user name. Y Unique Seeded Value -
  4. Navigate to OFS_SANC_PACK/bin.
  5. Execute setup.sh file using the following command:

    ./setup.sh SILENT

  6. Verify the logs in installer.

    <Installer kit>OFS_SANC_PACK/logs/

    <Installer kit>OFS_SANC_PACK/schema_creator/logs/

    <Installer kit>/OFS_SANC_PACK/OFS_AAI/logs/

    <Installer kit>/OFS_SANC_PACK/OFS_CS/logs/

    <Installer kit>/OFS_SANC_PACK/OFS_TFLT/logs/

    Note:

    You can ignore ORA-00001, ORA-00955, ORA-02260, and ORA-01430 errors in the log file. In case of any other errors, contact Oracle Support.
  7. Apply the latest available AAI Patch (Contact Support).
  8. After you complete the upgrade, ensure that you run the following EDQinsert.sh script: refer the Post Installation steps.