7        Upgrade

This section includes the procedures for the various upgrade scenarios supported by OFS DI Release 8.1.1.0.0.

Topics:

·        Upgrade Scenarios

·        Prepare for Upgrade

·        Download the OFSAAAI Applications Pack Installer and Mandatory Patches

·        Upgrade from OFSDI v8.0.6.0.0 or a later version to OFSDI v8.1.1.0

·        Clone Your Existing Environment

·        Update the OFS_DI_PACK.xml File

·        Update the Silent.props File in Release 8.1.1.0.0 Pack

·        Trigger the Upgrade Installation

·        Verify the Log File Information

·        Post-installation Steps

Upgrade Scenarios

This section includes the procedures for the various upgrade scenarios supported by OFS DI Release 8.1.1.0.0.

ATTENTION:   

Always ensure that you run the upgrade installer only on the cloned environment.

 

Table 17: OFSDI Release 8.1.1.0.0 Upgrade Scenarios

Scenario

Upgrade Instructions

Upgrade from Release v8.0.x of OFSDI or OFSDI on AIX or Solaris x86 Operating System

 

Release v8.1.1.0.0 of OFSDI is not certified for AIX and Solaris x86 Operating Systems. If you are currently running OFSAA v8.0.x on AIX or Solaris x86 Operating Systems and plan to upgrade to Release v8.1.1.0.0, then you must migrate from AIX or Solaris x86 to Linux or Solaris SPARC. See the MOS Doc ID 2700084.1 for details.

Upgrade from OFSDI v8.0.6.0.0 or a later version to OFSDI v8.1.1.0.0

In this scenario, you are upgrading the OFSDI application pack from the Release v8.0.6.1.0 or a later version to the Release v8.1.1.0.0.

Example: You are on the OFSDI v8.0.7.0.0 and now want to upgrade it to the OFSDI v8.1.1.0.0.  

1.     Clone your existing environment to the v8.1.0.0.0 of OFS Analytical Applications Technology Matrix .

2.     Run the Environment Check Utility tool and ensure that the hardware and software requirements are installed as per the OFS Analytical Applications Technology Matrix . See the OFSAA Environment Check Utility Guide for detailed steps.

3.     Update the OFS_DI_PACK.xml file to enable ONLY the existing installed applications.

4.     Update the Silent.props file present in the OFSDI v8.1.0.0.0 installer pack.

5.     Trigger the upgrade installation. 

Install OFSDI Application Pack v8.1.0.0.0 on an Existing OFSAA Instance

In this scenario, you have already installed an application pack versioned v8.1.0.0.0 and now you want to install the OFSDI application pack versioned v8.1.0.0.0.

Example: OFS ALM Pack is already installed and now you want to install OFSDI Pack. 

1.     Update the OFS_DI_PACK.xml file to enable ONLY the existing installed applications.

2.     Update the Silent.props file present in the OFSDI v8.1.0.0.0 installer pack.

3.     Trigger the upgrade installation.

 

Prepare for Upgrade

Before you plan to install or upgrade any of your application packs to Release 8.1.0.0.0, ensure that all the application packs in your current OFSAA instance are available for download and installation in the Release 8.1.0.0.0 version. Contact My Oracle Support for more information about the 8.1 release details for the required applications.

NOTE:   

·        The user profile executing the installation must have the permission on /tmp before installation.

·        Enough space must be available in /tmp before installation, else the installation terminates, without log files.

 

1.     Download and Extract the OFSDI Application Pack installer kit.

2.     See the OFS Analytical Applications Technology Matrix  for the hardware and software required to upgrade to the OFSDI Application Pack Release 8.1.0.0.0.

3.     Enable unlimited cryptographic policy for Java. For more information, see the Enabling Unlimited Cryptographic Policy section in the OFS Analytical Applications Infrastructure Administration Guide.

4.     Clone your environment. For more information, see the Clone your Existing Environment section.

5.     Execute the following SQL query on the Atomic Schema:

6.     update rev_tables_b set version=0 where version is null;

7.     commit;

Upgrade from OFSDI v8.0.6.0.0 or a later version to OFSDI v8.1.1.0.0

You are upgrading OFSDI Application Pack from the Release v8.0.6.0.0 or later versions to the Release v8.1.1.0.0.

For example, you are using OFSDI v8.0.7.0.0 and now want to upgrade to the OFSDI v8.1.1.0.0 or you want to upgrade from OFSDI v8.1.0.0.0 to OFSDI v8.1.1.0.0.

NOTE:   

If upgrading OFSDI Application Pack from a version before OFSDI v8.0.6.0.0, then first upgrade to OFSDI v8.0.6.0.0 or later versions. To upgrade to OFSDI v8.0.6.0.0 or later versions, see the corresponding version-specific OFS Data Integration Installation and Configuration Guide.

 

NOTE:   

Ensure to log in to OFSAA Infrastructure Config Schema and execute the following SQL query:

ALTER TABLE CONFIGURATION MODIFY PARAMNAME VARCHAR2 (100 CHAR);

 

Clone Your Existing Environment

Clone your existing environment to the v8.1.1.0.0 OFS Analytical Applications Technology Matrix . For more information, see the OFSAA Cloning Reference Guide for:

·        Release 8.0.x: If you are upgrading from a version before OFS DI Release 8.0.6.0.0 to version OFS DI 8.0.6.0.2.

·        Release 8.1.x: If you are upgrading from OFS DI Release 8.0.6.0.0 or later to OFS DI version 8.1.1.0.0.

Update the OFS_DI_PACK.xml File

Update the OFS_DI_PACK.xml file and enable only the existing installed Application Packs.

To configure the OFS_DI_PACK.xml file, follow these steps:

1.     Navigate to the <INSTALLER_DIRECTORY>/OFS_DI_PACK/conf directory.

2.     Open the OFS_DI_PACK.xml file in a text editor.

3.     Configure the OFS_DI_PACK.xml file as mentioned in the following table.

Figure 33: Sample OFS_DI_PACK.xml File

Description of Sample OFS_DI_PACK.xml File follows This illustration shows a sample of the OFS_DI_PACK.xml file.Description of Sample OFS_DI_PACK.xml File follows This illustration shows a sample of the OFS_DI_PACK.xml file.

Table 18: OFS_DI_PACK.xml file Parameters

Tag Name

Attribute Name

Description

Mandatory (Y/ N)

Comments

APP_ID

ENABLE

Enable Application or Product

YES if installing in the SILENT mode.

The default value is YES for Infrastructure.

The default value is NO for Others.

Permissible values are YES and NO.

Set this attribute- value to YES against every APP_ID which is licensed and must be enabled for use.

NOTE: Application or Product once enabled cannot be disabled. However, Application or Product not enabled during installation can be enabled later through the Administration UI.

 

4.     Save the file.

Update the Silent.props File in Release 8.1.1.0.0 Pack

Update the Silent.props file present in the Release 8.1.1.0.0 pack. Most parameters in the Silent.props file for 8.1.1.0.0 have default values. Before triggering the installation, ensure that you review them thoroughly and update as required.

1.     Navigate to the OFS_DI/appsLibConfig/conf directory.

2.     From Release 8.1.1 onwards, DI supports a single Silent.template file available in the OFS_DI_PACK/appsLibConfig/conf directory. The Silent.template is populated with default values.

3.     Ensure to modify the template in the directory. Create a copy of this file and rename the copy as Silent.props.

4.     Edit the Silent.props file and specify the parameters as per the requirements.

SILENT installation is achieved through a properties file (Silent.props) that must be updated with proper values, before attempting to install using the silent mode. The following table lists all the properties that need to be specified.

5.     Configure the Silent.props file as mentioned in the table in the Install the OFS DI Application Pack section.

6.     Open the Silent.props file and edit only the following parameters:

Table 19: Parameters for the Silent.props File

Property Name

Description of Property

Permissible Values

Comments

APFTP P_LOG_PATH=

Infodom Maintenance log path (to be created) for the new Infodom for the app layer.

Not applicable

# Mandatory if this an App Layer Installation and if you want to create a new infodom.

DBFTP_LOG_PATH

Infodom Maintenance log path (to be created) for the new Infodom for the DB layer.

Not applicable

# Mandatory if this a DB Layer Installation and if you want to create a new infodom.

 

Trigger the Upgrade Installation

You are upgrading the OFSDI Application Pack from Release 8.0.6.0.0 or later to Release 8.1.1.0.0.

For example, you are using OFSDI v8.0.7.0.0 and now want to upgrade to the OFSDI v8.1.1.0.0 or you want to upgrade from OFSDI v8.1.0.0.0 to OFSDI v8.1.1.0.0.

To install the OFSDI Application Pack, follow these steps:

1.     Enter the following command in the console to execute the OFSDI Application Pack installer with the Silent option:

./setup.sh SILENT

2.     The installer proceeds with the Pre-installation Checks.

3.     Enter the OFSAA Processing Tier FTP/SFTP password value and proceed, when prompted in the command prompt.

Figure 34: OFSAA Processing Tier FTP/SFTP Password Prompt

Description of OFSAA Processing Tier FTP/SFTP Password Prompt follows This illustration shows OFSAA Processing Tier FTP/SFTP password prompt during the installation. 

NOTE:   

Enter the password to access the Product Staging/Metadata repository directory FTPSHARE in the application server.

 

 

4.     If you are performing the Big Data installation, then enter the Hive Server SFTP/FTP password value, when prompted at the command prompt.

NOTE:   

Enter the password to access the OFSDI Hive directory FTPSHAREH in the application server.

5.     The process displays the OFSAA License. Enter Y and proceed.

Figure 35: Accept the OFSAA License Agreement

Description of Accept the OFSAA License Agreement follows This illustration shows the OFSAA License Agreement prompt during the installation. 

6.     The installer installs the OFSAAAI application.

Figure 36: OFS AAAI Silent Mode Installation

Description of OFSAA Silent Mode Installation follows This illustration shows the OFSAA silent mode installation. 

7.     After OFSAAAI is installed, the OFSDI Application Pack installation begins.

Figure 37: OFSDI Application Pack Installation

Description of DI Silent Mode Installation follows This illustration shows the OFS DI installation.

 

Figure 38: OFSDI Application Pack Installation Complete

Description of Silent Mode Installation Build Complete follows This illustration shows the OFS DI installation - Installation Complete message.

8.     The following message is displayed in the console:

Installation completed…

9.     The OFSAA Infrastructure installation performs a post-install health check automatically on the successful installation of the product.

10.  To verify if the release is applied successfully, check the log files mentioned in the Verify the Log File Information for Upgrade section.

11.  For more information on securing your OFSAA Infrastructure, see the OFSAA Security Guide.

NOTE:   

The DMT screens are no more managed with a generic function since OFSAAI v8.1.0.0.0. Starting from OFSAAI v8.0.6.0.0, each action performed in the DMT screens require specific user roles and functions for various operations. Therefore, OFSDI has up taken the user roles and functions available for the OFSAAI v8.1.0.0.0 DMT screens. From v8.1.0.0.0, OFSDI and OFSAAI support only new functions and the new user roles mapped to the user groups.

 

Verify the Log File Information

See the following logs files for more information:

·        The Pack_Log.log file in the OFS_DI_PACK/logs/ directory.

·        The OFS_DI_installation.log file and the OFS_DI_installation.err file in the OFS_DI_PACK/OFS_DIH/logs directory.

NOTE:   

If you have enabled applications other than DIH during installation, verify the logs in the respective application path.

For example, If OFS_DIH and OFS_INTF_FCUBS are enabled for installation, see the OFS_DI_PACK/OFS_DIH/logs and OFS_DI_PACK/OFS_INTF_FCUBS/logs directories.

 

·        The Infrastructure installation log files in the OFS_DI_PACK/OFS_AAI/logs/ directory.

·        The OFSAAInfrastucture_Install.log file in the $FIC_HOME directory.

·        Ignore the following error messages in the log files:

For 8.1.0.0.0 to 8.1.1.0.0 upgrade path:

§       [ERROR] Query:-- Create table...

Error:Object already exists

§       [ERROR] Query:-- Create/Recreate primary, unique and foreign key constraints...

Error:Table already has a primary key

For other paths:

§       Error:ORA-00001: unique constraint

§       Query:-- Create table...

Error:Object already exists

Post-installation Steps

Follow the steps mentioned in the Post-installation Steps section.