installation manual oracle financial services operational ... · installation manual oracle...

Oracle Financial Services Software Confidential - Restricted

Installation Manual Oracle Financial Services Operational Risk Economic Capital

Release 2.1 April 2012


Document Control Author: Jaya Dash Group: OFSAA

Created on : 20-Sep-2010 Revision No : 1.1

Updated by : Meera Menon

and Sindhu K K

Reviewed by : Venkata

Subbaiah Bheemagoni

Approved by:

Updated on : 27-April-2012 Reviewed on : 27-April-2012 Approved on :


Table of Contents

1. About this Manual ....................................................................................................................... 1

1.1 Oracle Financial Services Analytical Application Infrastructure Overview ............................ 1

1.2 Analytical Applications Overview ........................................................................................... 1

1.3 Audience ................................................................................................................................ 1

1.4 Scope ..................................................................................................................................... 1

1.5 Organization of the Manual .................................................................................................... 1

1.6 Conventions Used in this Manual .......................................................................................... 2

2. Pre-Requisites ............................................................................................................................ 3

2.1 Environment ........................................................................................................................... 3

2.2 Front-End Access .................................................................................................................. 3

3. Installing the Analytical Applications ........................................................................................... 4

3.1 Preinstallation Activities ......................................................................................................... 4

3.1.1 New Installation of OREC Release 2.1 ..................................................................... 4

3.1.2 Upgrade from OREC Release 2.0 to OREC Release 2.1 ........................................ 5

3.2 Oracle Financial Services Operational Risk Economic Capital Release 2.1 Installation –

GUI Mode ............................................................................................................................... 6

3.2.1 Server A – App Layer ............................................................................................... 7

3.2.2 Server B – Database Layer .................................................................................... 16

3.2.3 Server C – Web Layer ............................................................................................ 26

3.2.4 Single Tier Installation ............................................................................................ 36

3.3 Oracle Financial Services Operational Risk Economic Capital Release 2.1 Installation –

SILENT Mode ...................................................................................................................... 39

4 Post Installation Activities ......................................................................................................... 40

Installation Manual


1. About this Manual

1.1 Oracle Financial Services Analytical Application Infrastructure Overview

Oracle Financial Services Analytical Application Infrastructure (OFSAAI) is an analytical

application platform which has been architected to be multi-tiered and open-systems compliant.

OFSAAI is fully web-enabled. It’s a 100% thin-client, browser-based interface with zero foot print

which dramatically reduces the cost of application deployment. All OFSAAI processes, including

those related to business, are metadata-driven, thereby providing a high degree of operational and

usage flexibility, and a single consistent view of information to all users.

OFSAAI product suite includes a rules-framework designer engine, Unified Metadata Manager

which has a semantic layer of metadata abstraction that is common over both relational and OLAP

repositories.

1.2 Analytical Applications Overview

The Oracle Financial Services Operational Risk Economic Capital v2.1 application provides

the bank with a complete view of the capital required for Operational Risks that it carries as

compared to the amount of accounting capital it actually has. The OREC application comes pre-

configured with Rules, Models, DTs, Runs and reports required for computing Operational Risk at

the individual exposure as well as the bank level.

1.3 Audience

This manual is meant for use by the OFSAAI Application System Administrator who plays an

integral part in installing the Oracle Financial Services Operational Risk Economic Capital Release

2.1 Application.

1.4 Scope

This manual provides step-wise instructions to install the Oracle Financial Services Operational

Risk Economic Capital Release 2.1 in an existing OFSAAI Release 7.2.1 Platform (base version)

hosted in Sun Solaris 5.10 Server – Oracle 11g R2 (11.2.0.2.0) – Weblogic 10.3.1.0/ Websphere

7.0.0.9/ Tomcat 6.0.29 – Essbase 9.3.1 – 64 bit environment.

1.5 Organization of the Manual

The Installation Manual is organized into the following chapters:

Pre Requisites section identifies the hardware and base software environment that is

required for a successful installation and functioning of the Oracle Financial Services

Operational Risk Economic Capital Release 2.1.

Installing the Application section details the pre-installation activities followed by step-by-

step instructions on the various installation options.

Post Installation Activities section details the steps that are required to be performed after

the successful installation of the Oracle Financial Services Operational Risk Economic

Capital Release 2.1.

Installation Manual


1.6 Conventions Used in this Manual

References to sections or chapters in the manual are displayed in Italics.

Oracle Financial Services Operational Risk Economic Capital Release 2.1 is also referred to as

OREC application in this User Guide.

Screen names are displayed in the following manner:

Introduction screen

Options and buttons are displayed in Bold.

Notes are displayed as follows:

NOTE:

It is important that the password should be 6 characters long. If you do not adhere to this pre-

requisite, you will see a system message that reads Password must be at least 6

characters long.

Installation Manual


2. Pre-Requisites

The installation process requires certain environmental variables to be set prior to starting the

installation. You must ensure that these requirements are met before starting the installation. For

more information refer to the Release Notes for the latest updates on hardware or software

requirements and the OFSAAI Installation Manual for the environment variables.

2.1 Environment

Installation of Oracle Financial Services Operational Risk Economic Capital Release 2.1 requires

the OFSAAI 7.2.1 Platform (base version) hosted on Sun Solaris 5.10 Server – Oracle 11g R2

(11.2.0.2.0) – Weblogic 10.3.1.0/ Websphere 7.0.0.9/ Tomcat 6.0.29 – Essbase 9.3.1 – 64 bit in

either a Single-tier or multitier environment.

It is implicit that all base software versions required by the Sun Solaris 5.10 version of Release

7.2.11 is available and adhered to.

The patch related to Bug 14017839 - OREC enhancement for 10 truncated distribution techniques

has to be applied on 7.2.11.

2.2 Front-End Access

Client Machines –Windows XP SP3

Microsoft Internet Explorer 7.0, 8.0

Java Plug-in 1.6.0_18

The screen resolutions supported are 1024*768 and 1280*1024

Microsoft Excel 2003

Adobe Reader 8.0

Installation Manual


3. Installing the Analytical Applications

3.1 Preinstallation Activities

The following is the preinstallation checklist to ensure the readiness to start installing Oracle

Financial Services Operational Risk Economic Capital, Release 2.1.

OFSAAI 7.2.11 must be successfully installed on Sun Solaris 5.10 Server – Oracle 11g R2

(11.2.0.2.0) – Weblogic 10.3.1.0/ Websphere 7.0.0.9/ Tomcat 6.0.29 – Hyperion Essbase

9.3.1 - 64 bit with the latest updated patch set for this OS version.

NOTE:

On base version 7.2.1, apply the latest updated patch set to upgrade to platform version

7.2.11.

3.1.1 New Installation of OREC Release 2.1

If you are installing Oracle Financial Services Operational Risk Economic Capital Release 2.1

for the first time, then follow the below pre-installation checklist:

The Config and atomic schema should be two distinct oracle database users.

The following grants must be given to atomic schema user (both Production and Sandbox):

grant create session to ATOMIC_USER;

grant alter session to ATOMIC_USER with admin option;

grant create user to ATOMIC_USER with admin option;

grant drop user to ATOMIC_USER with admin option;

grant create synonym to ATOMIC_USER with admin option;

grant create view to ATOMIC_USER with admin option;

grant create sequence to ATOMIC_USER with admin option;

grant create table to ATOMIC_USER with admin option;

grant create procedure to ATOMIC_USER with admin option;

grant create any index to ATOMIC_USER with admin option;

grant create trigger to ATOMIC_USER with admin option;

grant create any table to ATOMIC_USER with admin option;

grant create any sequence to ATOMIC_USER with admin option;

grant create any view to ATOMIC_USER with admin option;

grant alter user to ATOMIC_USER with admin option;

Two Infodoms (One Production and One Sandbox) has to be created. Each should have a

segment mapped to each of it.

The Infodom name and the ID should be the same. Similarly the segment code and the

segment name should be the same.

Installation Manual


Both the Infodoms should be mapped to an OFSAAI User group.

The OFS OREC v2.1 Sliced Data Model Oracle (Erwin 7.x)-V6.0 must be successfully

uploaded in both the Information Domains.

Create a table setupinfo in Config schema. The corresponding create table script is

mentioned as follows:

create table SETUPINFO

(

PARAMNAME VARCHAR2(100),

PARAMVALUE VARCHAR2(250),

APPNAME VARCHAR2(250),

DSNID VARCHAR2(250),

APPVERSION VARCHAR2(250),

PATCHVERSION VARCHAR2(250),

PATCHDATE DATE

)

NOTE:

The Data Model is available in the CD under <Data Model>.

Create Application –OREC

Create the following data sources: OREC & OR_OREC as RDBMS Sources – pointing to

the respective production infodom atomic databases to hold the T2T Definitions.

Map the data source OREC & OR_OREC to OREC application. Generate the source

model. For more information refer to the Data Integrator User Manual.

All OFSAAI Servers must be shut down.

Oracle 11G services must be running.

You must have the following information available and handy before you start the installation:

The FTP share path as configured in OFSAAI Release 7.2.11.

The name of the Information Domain in OFSAAI Release 7.2.11 into which the OFS

OREC v2.1 Sliced Data Model Oracle (Erwin 7.x)-V6.0 data model has been uploaded.

The OFSAAI User ID that has access to the above Information Domain.

NOTE:

The OFSAAI User ID must be assigned with a role that has a function to Add/Modify

business metadata.

3.1.2 Upgrade from OREC Release 2.0 to OREC Release 2.1

If a previous version of Oracle Financial Services Operational Risk Economic Capital (Release

2.0) is already installed, then follow the steps given below to upgrade the OREC application:

Create a table setupinfo in Config schema. The corresponding create table script is

mentioned as follows:

Installation Manual


create table SETUPINFO

(

PARAMNAME VARCHAR2(100),

PARAMVALUE VARCHAR2(250),

APPNAME VARCHAR2(250),

DSNID VARCHAR2(250),

APPVERSION VARCHAR2(250),

PATCHVERSION VARCHAR2(250),

PATCHDATE DATE

)

Insert a record in setupinfo table with the following values:

APPNAME = OREC

DSNID = the corresponding infodom id where the OREC application is already

installed.

APPVERSION = the version number of the OREC application already installed.

The new data model should be manually merged with the OFS OREC v2.0 Data Model and

then incremental upload of the data model should be performed.

NOTE:

The Data Model is available in the CD under <Data Model>.

Create Application –OREC

Create the following data sources: OREC & OR_OREC as RDBMS Sources – pointing to

the respective production infodom atomic databases to hold the T2T Definitions.

Map the data source OREC & OR_OREC to OREC application. Generate the source

model. For more information refer to the Data Integrator User Manual.

All OFSAAI Servers must be shut down.

Oracle 11G services must be running.

You must have the following information available and handy before you start the installation:

The FTP share path as configured in OFSAAI Release 7.2.11.

The name of the Information Domain in OFSAAI Release 7.2.11 into which the OFS

OREC Release 2.1 data model has been uploaded.

The OFSAAI User ID that has access to the above Information Domain.

3.2 Oracle Financial Services Operational Risk Economic Capital Release 2.1 Installation – GUI Mode

The Analytical Applications comprises of components that are installed on the OFSAAI

Application, Database and Web layers. Thus, if the OFSAAI Release 7.2.11 installation is on a

multi-tier architecture, then the Analytical Applications installer must be loaded on each of the

machines that host the various tiers of OFSAAI. The description of the installation process on multi

tier architecture with the components is as follows:

Installation Manual


Server A as the Application Layer

Server B as the Database Layer

Server C as the Web Layer

NOTE:

Single tier Installation

For a single-tier installation, the installer is required to be loaded only once on the machine

that hosts all the OFSAAI tiers, by selecting all the options as mentioned in Single Tier

Installation steps.

NOTE:

If ORA-00942 Oracle error appears during installation, please ignore and proceed.

3.2.1 Server A – App Layer

Step 1

Copy the Setup.sh and Setup.bin from the installation CD on to a folder on the machine that hosts

the OFSAAI application. To begin Oracle Financial Services Operational Risk Economic Capital

Release 2.1 installation, execute Setup.sh GUI. GUI is a command line argument.

Figure 1: Installation Splash Screen

Step 2

Installation Manual


Figure 2: Introduction Screen

Upon starting the installer, the Introduction screen displays the pre-requisites for installation.

Ensure that the pre-requisites are satisfied before you proceed.

NOTE:

At any point during the installation process, if you click Cancel, the installation process is

cancelled and you will exit this setup.

At any point during the installation process, if you click Previous, you will return to the

previous screen.

Step 3

Select log mode for this installer. If the Debug is selected, the Passwords will be printed in the Log

File ($FIC_HOME$\SolutionsLog_<INFODOM>_<DATE_TIME>.log).

Installation Manual


Figure 3: Log Mode Option Screen

Step 4

Enter the Customer ID that has been provided with OFSAAI Release 7.2.11.

Figure 4: Customer Identification Number Screen

Step 5

The Pre Setup Information screen requests for setup information.

Installation Manual


Select the appropriate OFSAAI layer that has been installed on the machine.

Example AppLayer

Figure 5: Pre Setup Information Screen – Choose Layer to Install

NOTE:

For a single-tier OFSAAI Release 7.2.11 installation, you must select App Layer, DB Layer

and Web Layer. For a multi-tier OFSAAI Release 7.2.11 installation, select the

corresponding layer installed on the machine.

Step 6

The Pre Setup Information screen requests for applications to be installed. Select the appropriate

application to be installed on the machine.

Example Oracle Financial Services Economic Risk Capital Release 2.1

Installation Manual


Figure 6: Select the product to be Installed

Step 7

Enter Information Domain details in which the OFS OREC v2.1 Sliced Data Model Oracle (Erwin

7.x)-V6.0 has been successfully uploaded.

Enter segment name which is mapped with the infodom.

Enter the valid path that has been configured as the FTP Share Path in OFSAAI Release 7.2.11.

You may click Choose to select the path. Click Restore Default to reset the path in case of

erroneous entry.

Installation Manual


Figure 7: Pre Setup Information Screen – Infodom Details

Click Next to continue.

Step 8

Enter Sandbox Information Domain name and segment name which is mapped with the Sandbox

infodom.

Figure 8: Pre Setup Information Screen – Sandbox Infodom Details

Installation Manual


NOTE:

If the setupinfo table is not present the following error message is displayed and the installation process is cancelled.

NOTE:

If the platform patch 7.2.11 is not applied then the following error message is displayed and the

installation process is cancelled.

Installation Manual


Step 9

The Pre Setup Information screen requests for the OFSAAI user ID.

Enter the OFSAAI user ID that has been mapped to the Information Domain provided earlier.

Enter the TNS name for the atomic schema (same as what you’ve given in Database Master while

creating the infodom).

Figure 9: Pre Setup Information screen – OFSAAI User Details

NOTE:

The OFSAAI user must have a role that is able to perform Add/Modify functions for business

metadata.


Step 10

The following screen indicates the start of the installation. If you have entered the right information

click Install to begin the installation process.

Installation Manual


Figure 10: Begin Installation

Step 11

The following screen displays the progress of the installation. Upon completion of the process, the

installation status is published on the screen. You must access the file

SolutionsLog_<INFODOM>_<DATE_TIME>.log in the path $FIC_HOME to check for errors if any.

Figure 11: Installation in Progress

Installation Manual


NOTE:

FIC_HOME is the environment variable set during the OFSAAI Installation; it refers to the

OFSAAI Installation directory.

Step 12

The following screen displays the successful installation of the Oracle Financial Services

Operational Risk Economic Capital Release 2.1 Setup.

Figure 12: Installation Complete

Click Done to quit the installer.

3.2.2 Server B – Database Layer

Step 1



Release 2.1 installation, execute Setup.sh GUI. GUI is a command line argument.

Installation Manual



Step 2


Upon starting the installer, the Introduction screen displays the pre-requisites for installation.


Installation Manual


NOTE:

At any point during the installation process, if you click Cancel, the installation process will

be cancelled and you will exit this setup.


previous screen.

Step 3

Choose the log mode for this installer. If the Debug is selected, the Passwords will be printed in

the Log File ($FIC_HOME$\SolutionsLog_<INFODOM>_<DATE_TIME>.log).


Step 4

Enter the Customer ID that has been provided with OFSAAI Platform.

Installation Manual



Step 5



Example DB Layer


Installation Manual


NOTE:

For a single-tier OFSAAI Release 7.2.11 installation, you must select App Layer, Web Layer,

DB Layer and Web Layer. For a multi-tier OFSAAI Release 7.2.11 installation, select the


Step 6

The Pre Setup Information screen requests for product to be installed.

Select the appropriate product to be installed on the machine.

Example Oracle Financial Services Operational Risk Economic Capital, Release 2.1


Step 7

Enter the Information Domain details in which the OFS OREC v2.1 Sliced Data Model Oracle

(Erwin 7.x)-V6.0 has been successfully uploaded and segment name which is mapped with the

infodom.


Click Choose to select the path or click Restore Default to reset the path in case of erroneous

entry.

Enter the IP address of the Server where the db layer is installed.

Enter the Config schema user ID. Also enter the Config schema db driver details and the

connection URL. DB driver and the connection URL can be taken from the Dynamic services.xml

in the $FIC_HOME/conf folder of the app layer.

Installation Manual


Figure 19: Pre Setup Information Screen – Database Details I

Step 8

Enter Sandbox Information Domain name and Segment name which is mapped with the Sandbox

infodom.

Figure 20: Pre Setup Information Screen – Sandbox Infodom

Details

Installation Manual


NOTE:


NOTE:

If the platform patch 7.2.11 is not applied the following error message is displayed and the


Installation Manual


Step 9



Enter the TNS alias name for infodom respectively as mentioned in Database master while

creating the infodom.

Figure 21: Pre Setup Information screen - OFSAAI User Details

NOTE:


metadata.


Step 10

The following screen cautions before starting the installation. If you have entered the right

information click Install to begin the installation process.

Installation Manual



NOTE:




previous screen.

Step 11




Installation Manual



NOTE:

FIC_HOME is the environment variable set during the OFSAAI Installation; it refers to the


Step 12

The following screen displays the completion of installation of the application setup:

Installation Manual




3.2.3 Server C – Web Layer

Step 1



Release 2.1 installation, execute Setup.sh GUI.

Installation Manual



Step 2


Upon invoking the installer, the Introduction screen will display the pre-requisites for installation.


Installation Manual


NOTE:

At any point during the installation process, if you click Cancel, the installation process will be

cancelled and you will exit this setup.


previous screen.

Step 3

Choose the log mode for this installer. If the Debug is selected, the Passwords will be printed in

the Log File ($FIC_HOME$\SolutionsLog_<INFODOM>_<DATE_TIME>.log).


Step 4

Enter the Customer ID that has been provided with OFSAAI Platform.

Installation Manual



Step 5



Example Web Layer


Installation Manual


NOTE:

For a single-tier OFSAAI Release 7.2.11 installation, you must select App Layer, DB Layer

and Web Layer. For a multi-tier OFSAAI Release 7.2.11 installation, select the


Step 6

The Pre Setup Information screen requests for the application to be installed.




Step 7

Enter the Information Domain details in which the OFS OREC v2.1 Sliced Data Model Oracle

(Erwin 7.x)-V6.0 has been successfully uploaded.

Enter the segment name which is mapped with the infodom.



erroneous entry.


Enter the Config schema user ID. Also enter the Config schema db driver details and the

connection url. (DB driver and the connection URL can be taken from the Dynamic services.xml in

the $FIC_HOME/conf folder of the app layer.

Installation Manual


Figure 31: Pre Setup Information Screen – Database Details

Step 8

Enter Sandbox Information Domain name and Segment name which is mapped with the Sandbox

infodom.

Figure 32: Pre Setup Information Screen – Sandbox Infodom

Details

Installation Manual


NOTE:


NOTE:

If the platform patch 7.2.11 is not applied the following error message is displayed and the


Installation Manual


Step 9



Enter the TNS alias name for infodom respectively as mentioned in Database master while

creating the infodom.

Figure 33: Pre Setup Information screen - OFSAAI User Details

NOTE:


metadata.


Step 10

The following screen cautions before starting the installation. If you have entered the right

information click Install to begin the installation process.

Installation Manual



NOTE:




previous screen.

Step 11




Installation Manual



NOTE:

FIC_HOME is the environment variable set during the OFSAAI Installation. It refers to the


Step 12

The following screen displays the completion of installation of the application setup.

Installation Manual




3.2.4 Single Tier Installation

Steps 1-4 and 8-12 would remain same as of any of multi tier installation layer.

Step 5


Select App, DB and Web layer that has been installed on the Server.

Installation Manual


Figure 37: Pre Setup Information Screen – Choose Layers to Install

Step 6

The Pre Setup Information screen requests for application to be installed.



Installation Manual


Figure 38: Select the application to be installed

Step 7

Enter Information Domain in which the OFS OREC v2.1 Sliced Data Model Oracle (Erwin 7.x)-

V6.0 has been successfully uploaded and Segment name which is mapped with the infodom.



erroneous entry.


Installation Manual


Figure 39: Pre Setup Information Screen – Infodom & Database

Details

3.3 Oracle Financial Services Operational Risk Economic Capital Release 2.1 Installation – SILENT Mode

If the installation is done on silent mode, then copy the setup.sh, setup.bin, silent.properties, and

silent.jar to the layer(s) in which the installation has to be done. Put the appropriate values in the

silent.properties. Give GL =1 and others as 0 in Enterprise Risk Management Products section

for this installation.

Execute Setup.sh with command line argument as SILENT, that is,Setup.sh SILENT, to start the

installer.

Installation Manual


4 Post Installation Activities

OFSAAI Server Memory Configuration

The OFSAAI Application Server is started using reveleusstartup.sh. This file can be edited for

setting customized memory settings, garbage collector settings depending on the available

hardware configuration. You are requested to contact OFSAAI Support at

https://flexsupp.iflexsolutions.com/ for guidance in altering the memory settings.

Once the installation of Oracle Financial Services Operational Risk Economic Capital Release 2.1

Application is completed, you must perform the following steps:

Create and deploy the war file into webserver. For more information, refer the OFSAAI

Release 7.2.11 Installation manual.

Start all OFSAAI Servers.

Start the Web Server (Weblogic 10.3.1.0/ Websphere 7.0.0.9/ Tomcat 6.0.29)

Refer Starting OFSAAI Servers in the OFSAAI Release 7.2.11 Installation Guide for

assistance in starting the servers.

Re-save all the Hierarchies, cubes and the other metadata in OFSAAI.

Recompile all the Functions, procedures and views in both Production and Sandbox

atomic schema.

The log for resaving hierarchies can be found under

$FIC_APP_HOME/common/FICServer/logs/ResaveLog.log

The Oracle Financial Services Operational Risk Economic Capital Release 2.1 Application

is now ready to be used. The data need to be loaded as per the attached Oracle Financial

Services Operational Risk Economic Capital Release 2.1 Run Chart. Refer: Oracle

Financial Services Operational Risk Economic Capital Release 2.1 Release Note.pdf and

the documents available in $FIC_HOME directory in each layer, for any additional

documentation.

If you are upgrading the application from Oracle Financial Services Operational Risk

Economic Capital Release 2.0 to Release 2.1 then the user will have to manually re-save

the Processes and Rules.

Copy the dynamic Services.xml, Dynamic services.dtd, Lookupservices.xml and

lookup.dtd from the $FIC_HOME/conf of app layer to ficdb/conf of the db layer.

If you encounter any problems during setup, please contact OFSAAI Support at

https://flexsupp.iflexsolutions.com/.

https://flexsupp.iflexsolutions.com/

https://flexsupp.iflexsolutions.com/

Installation Manual


Installation Manual

April 2012

Oracle Financial Services Operational Risk Economic Capital v2.1 Installation Manual

Oracle Corporation

World Headquarters

500 Oracle Parkway

Redwood Shores, CA 94065

U.S.A.

Worldwide Inquiries:

Phone: +1.650.506.7000

Fax: +1.650.506.7200

www.oracle.com/ financial_services/

Copyright © 2012 Oracle Financial Services Software Limited. All rights reserved.

No part of this work may be reproduced, stored in a retrieval system, adopted or transmitted in any form or by any means, electronic, mechanical, photographic, graphic, optic recording or otherwise, translated in any language or computer language, without the prior written permission of Oracle Financial Services Software Limited.

Due care has been taken to make this Installation Manual and accompanying software package as accurate as possible. However, Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this Installation Manual and the accompanying Software System. Furthermore, Oracle Financial Services Software Limited reserves the right to alter, modify or otherwise change in any manner the content hereof, without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes.

All company and product names are trademarks of the respective companies with which they are associated.

installation manual oracle financial services operational ... · installation manual oracle...

Documents