Home

Oracle® Financial Services Analytical Applications Infrastructure

1. 4 8 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Create a data source Create a data source Step 1 Enter basic data source information Step 2 Select JDBC Select the authentication values for this resource provider Component managed authentication alias Step 3 Enter none v database specific properties for the Mapping configuration alias data source none Container managed authentication alias nene Step 5 Summary Note You can create a new J2C authentication alias by accessing one of the folloving links Clicking on a link will cancel the wizard and your current wizard selections vill be lost Global 32C tion ali Security domains L Previous Next Cancel 9 On clicking Next the Summary page is displayed Click Finish Create a data source Create a data source Step 1 Enter basic data source f information Summary of actions Step Select JOBC Options Values provider Scone cells GXS1 SOREV Zone2Node0SCell nodes GXSiSOREV Step 3 Enter Zone2Node0S servers serverl database specific properties for the data source JNDI name jdbc DRYMOCK Select an existing JDBC provider Data source name AtomT Oracle JDBC Driver ee class oracle jdbc pool OracleConnectionPoolDataSource URL jdbc oracle thin 10 184 108 91 1521 0rcl11gr2 Data store helper class name com ibm websphere rsadapter Oracle10
2. Create a New JDBC Data Source Back Finish Cancel Select Targets You can select one or more targets to deploy your new JDBC data source If you don t select a target the data source will be created but not deployed You will need to deploy the data source ata later time Finish Cancel Create GridLink Data Source If you have selected the option New GridLink Data Source while creating the Data Source you can directly specify the JDBC URL as indicated You also have the option to select Generic Data Source or Multi Data Source while creating a Data Source For more information refer Create Data Source page 4 12 or Configure Multi Data Sources page 4 18 Create a New JDBC GridLink Data Source Next Cancel JDBC GridLink Data Source Properties The following properties will be used to identify your new JOBC GridLink data source cates required fields What would you like to name your new JDBC GridLink data source aj Name xyz What JNDI name would you like to assign to your new JDBC GridLink data source 4 INDI Name jdbc xyz What database type would you like to select Database Type Oracle Is this XA driver C XA Driver Next Ensure that the JNDI Name field is specified in the format jdbc infodomname and XA Driver check box is selected Click Next Post Upgrade Configurations 4 17 Create a New JDBC GridLink Data Source Back Next Cancei Connection Properties Define Connect
3. approximately 1 5 GB of free hard disk space available in HOME which is required for Infrastructure upgrade e Ensure that you have approximately 1 5 GB of hard disk free space available in tmp folder e Ensure that no other activity is running in background which would consume the available disk space e Ensure that the total file descriptor value for the UNIX user account being used for upgrade must be set to a minimum of 9216 for RHEL OEL AIX and 5000 for Solaris which again depends on the size of the file system To check total file descriptor use the following command ulimit n e If the INFODOM_PATCHES table of Configuration Schema contains any duplicate entries for combination of V INFODOM and V PATCH NAME columns ensure to update these records excluding the record containing latest D APPLIED DATE value Execute the below query in Configuration schema to check if duplicate entries are present in INFODOM_PATCHES table You should manually remove the duplicate entries from the result fetched by the following query select v infodom v patch name count v patch name from infodom patches group by v infodom v patch name having count v patch name 1 e Database cursors need to be set to minimum value of 4000 for upgrade installation Login as DBA user or user having grant alter system privileges and use the following commands e To set the OPEN CURSORS value ALTER SYSTEM SET OPEN CURSORS 4000
4. 9 Select the checkbox adjacent to the deployment name 10 Click Stop menu button and select Force Stop Now from the pop down list Summary of Deployments Control Monitoring This page displays a ist of Java EE applications and stand alone application modules that have been installed to this domain Installed applications and modules can be started stopped updated redeployed or deleted from the domain by first selecting the application name and using the controls on this page To instal a new application or module for deployment to targets in this domain cick the Install button V Customize this table Deployments instal Update Delete San Showing 1to Lof 1 Previous Next E Cbuog7273 Ui PC NN install Update Delete Staty Stopy Showing 1to 1of1 Previous Next The deployment is stopped and the status is changed to Prepared To start the deployment 11 Select the check box adjacent to the deployment name 12 Click Start menu button and select Servicing all requests from the pop down list This page displays a ist of Java EE applications and stand alone application modules that have been installed to this domain Installed applications and modules can be started stopped updated redeployed or deleted from the domain by first selecting the application name and using the controls on this page To install a new application or module for deployment to targets in this domain cick the In
5. LJ GXS150REV upgssand upgssand ne2N UD AN o GXS150REV Zone2NodeOS VASTEST upgsconf upgsconf Total 8 2 Specify the list of User ID s and Passwords for Java 2 Connector Security 3 Enter the Alias User ID Password and Description Ensure the following e User ID is the Oracle user ID created for the respective Information Domain e Specify the config database user ID and password information for the jdbc FICMASTER data source and specify the atomic database user ID and password information for the atomic schema data source that you created earlier 4 10 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Data sources Data sources gt Default Datasource gt JAAS hentication gt New Specifies a list of user identities and passwords for Java TM 2 connector security to use General Properties Alias Atm User ID upgs73 Password c Description Atomic Instance ox Reset Cancel 4 Click Save and save the details JDBC Connection Pooling To define the JDBC connection pooling ensure that you have created JDBC Provider and Data source to access the data from the database 1 Click the newly created Data Source SDATA SOURCES and navigate to the path Data sources gt DATA_SOURCE gt Connection pools 2 Setthe values for Connection timeout to 0 seconds Maximum connections to 100 connections and Minimum connections to 10 connections
6. 5 Select the check box adjacent to the installed application which you want to update 6 Click Update The Preparing for the application update screen is displayed 4 28 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Preparing for the application update Specify the EAR WAR JAR or SAR module to upload and install Application to be updated upgs73 Application update options Replace the entire application Upload an enterprise archive ear to replace the entire installed application Specify the path to the replacement ear file o Local file system Full path 9 Remote file system Full path A Lares Replace or add a single module If the path to the new module matches an existing path to a module in the installed application the new module replaces the existing module If the path to the module does not exist in the installed application the new module is added to the application o Replace or add a single file If the path to the nev file matches an existing path to a file in the installed application the new file replaces the existing file If the path to the file does not exist in the installed application the new file is added to the application Replace add or delete multiple files Use a compressed file format such as zip or gzip The compressed file is unzipped into the installed application directory If the uploaded files exist in the application w
7. 64 bit with or without RAC WebSphere v7 0 0 9 64 bit WebLogic v10 3 1 0 10 3 4 0 64 bi Tomcat v6 0 29 64 bit OFSAAI Version 7 3 Red Hat Enterprise Linux Server release 5 3 5 5 Tikanga 64 bit Oracle Enterprise Linux Server release 5 3 5 5 Carthage 64 bit Oracle Database Enterprise Edition Release 11 2 0 2 0 64 bit with or without RAC WebSphere v7 0 0 17 64 bit WebLogic v10 3 5 0 64 bit Tomcat v7 0 19 64 bit 2 2 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Java Internet Explorer Java Plug in MS Office Client Machines Erwin Oracle Hyperion Essbase Oracle OLAP Sun Java 1 6 0 17 64 bit 7 amp 8 1 6 0 18 2003 Windows XP SP3 Windows 7 7 1 7 3 11 1 1 3 0 64 bit NA Sun Java 1 6 0_25 64 bit 8 amp 9 1 6 0_21 2003 2007 Windows XP SP3 Windows 7 7 1 7 3 11 1 2 1 0 64 bit Oracle OLAP v 11 2 0 2 0 Note For Oracle OLAP ensure that you have configured the Oracle Database server with OLAP option For Solaris operating system Software OFSAAI Version 7 2 10 OFSAAI Version 7 3 7 2 11 7 2 12 Operating System Solaris v5 10 Update 8 10 09 Oracle Solaris v5 10 Update 9 Database Server amp Client Web Server s10s u8wos 08a sparc SUNW Sun Fire V445 64 bit Oracle Database Enterprise Edition Release 11 2 0 1 0 64 bit WebSphere v7 0 0 9 64 bit WebLogic v10 3
8. Create and Deploy EAR WAR files in WebServers To create and deploy EAR WAR files refer to the following sections depending on the Webserver configured Note In case you have done a new WebServer installation depending on your WebServer configuration i e WebSphere WebLogic or Tomcat refer to the Configurations for new WebServer Installation page 4 42 For more information contact Oracle Support WebSphere This section is applicable only when the Web Application Server type is WebSphere Create WebSphere EAR File The EAR files is required to assemble servlets jsp files web pages and other static content into a deployable unit The EAR file is created to reflect the changes made to the web xml file Refer to the following steps 1 Onthe machine in which Infrastructure Web components have been installed navigate to the FIC_HOME ficweb directory At the prompt enter ant sh This triggers the creation of EAR file contextname ear The lt contextname gt is the name given during installation 2 Oncompletion of the EAR files creation the BUILD SUCCESSFUL and Time taken messages are displayed and you will be returned to the prompt The EAR file lt contextname gt ear is created on the machine on which Infrastructure Web components are installed under FIC HOME ficweb directory Note This process overwrites any existing version of EAR file that exists in the path Deploy WebSphere EAR Files To config
9. Select Data Store Helper Class Name from the drop down list and ensure that the checkbox Use this data source in container managed persistence CMD is selected Click Next Post Upgrade Configurations 4 7 Create a data source Create a data source Step 1 Enter basic Enter database specific properties for the data source data source information Set these database specific properties which are required by the database vendor Set bes JDBC driver to support the connections that are managed through the datasource provider Step 3 Enter Name Value database specific propertias forthe URL 10 184 108 91 1521 0rd11g data source Data store helper class name Step 4 Setup Orace 1g data store helper vi security aliases Step 5 Summary Use this data source in container managed persistence CMP Previous Next Cancel Note For RAC configuration provide the RAC url specified during installation Example jdbc oracle thin DESCRIPTION ADDRESS_LIST ADDRESS P ROTOCOL TCP HOST 10 184 108 91 port 1521 ADDRESS PR OTOCOL TCP HOST 10 184 108 92 PORT 1521 LOAD_BALA NCE no FAILOVER yes CONNECT_DATA SERVICE_NAME pqadb 8 Map the J2C authentication alias if already created If not you can create a new J2C authentication alias by accessing the link given Global J2C authentication alias or you can continue with the data source creation by clicking on Next and then Finish
10. What is the URL of the database to connect to The format of the URL varies by JDBC driver URL jdbc oracle thin 10 184 7 What database account user name do you want to use to create database connections Database User Name ssatom What is the database account password to use to create database connections Password 999090900909009009090 Confirm Password 99000000900 0990001 What are the properties to pass to the JDBC driver when creating database connections Properties user ssatom The set of driver properties whose values are derived at runtime from the named system property System Properties What table name or SQL statement would you like to use to test database connections Test Table Name SQL SELECT i FROM DUAL Test Configuration E Next Enion cancel Verify the details and click Test Configuration to test the configuration settings A confirmation message is displayed stating Connection test succeeded 9 Click Finish The created Data Source is displayed in the list of Data Sources e User ID is the Oracle user ID that is created for the respective Information Domain e User ID to be specified for Data Source with FICMASTER as JNDI name should be the Oracle user ID created for the 4 16 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX configuration schema Select the new Data Source and click Targets tab Verify AdminServer option and click Save
11. e To check the OPEN CURSORS value Select from v parameter where NAME open cursors Note The database cursors value can be reset to the previously defined value post successful upgrade e Ensure that each of the Default and Temporary table space used for Configuration and Atomic Database are allocated with a minimum of 50MB free space e For OFSAAI v7 3 the below settings are recommended for the Database However these settings are not mandatory and are required only if you want to have multiple 2 6 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX locales supported e NLS CHARACTERSET AL32UTF8 e NLS LENGTH SEMANTICS CHAR e NLS NCHAR CHARACTERSET ALI6UTF16 Execute grant olap user on Configuration and Atomic users using DBA user which is a pre requisite to create Oracle Cubes Execute grant select on SYS V PARAMETER to amp oracle user on Configuration and Atomic users using SYS user Prerequisites 2 7 3 Upgrade Process Upgrade Process Execute the below steps in the sequence 1 Stopall OFSAAI services including the WebServer services 2 Login to the system with the UNIX user on which OFSAAI 7 2 10 7 2 11 7 2 12 is installed 3 Navigate to the folder where you have unzipped the Upgrade Kit contents The directory consists of the following files i e Upgrade sh upgrade bin PreReqCheck jar and lib directory under which the following files j2ss
12. 6 Inthe Select Data Source Type screen select the type of data source which will be added to new JDBC Multi Data Source Create a New JDBC Hulti Data Source Cancel Select Data Source Type Please select type XA or Non XA of data source you would like to add to your new JDBC Multi Data Source XA Driver Non XA Driver 7 Mapthe required Data Source from the Available Data Sources Click Finish 4 20 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Create a New JDBC Multi Data Source Back Finish Cancel Add Data Sources What JDBC Data Sources would you like to add to your new JOBC Multi Data Source Data Sources Available FUSION1 FUSION2 FUSIONRH Create a New Data Source Back Finish Cancel The New JDBC Multi Data Source is created with added data sources Advanced Settings for Data Source 1 Select the new Data Source Settings for Data Source Name screen is displayed 2 Select Connection Pooling tab given under Configuration 3 Go to the Advanced option at the bottom of the page and check the Test Connection of Reserve checkbox Enables WebLogic Server to test a connection before giving it to a client To verify if the data source is valid select Data Source name Ex FICMASTER Post Upgrade Configurations 4 21 Summary of JDBC Data Sources Configuration Monitoring A JOBC data source is an object bound to the JNDI tree that provide
13. after starting the Infrastructure services 6 If you have ERM applications installed in OFSAAI 7 2 post upgrade to 7 3 you need to download and apply the one off patch 15915655 GENERIC available in the Bug 15915655 This facilitates the removal of old Data Quality links from LHS menu 7 To perform the necessary post upgrade configurations refer to Post Upgrade Configurations section page 4 1 8 Optional If you want to use the Object Migration feature of OFSAAI with WebLogic as application server perform the necessary configurations as mentioned in section Object Migration HttpsURLConnection configuration for WebLogic page 4 48 9 Generate the EAR WAR file and deploy on to your configured J2EE container Refer section Create and Deploy EAR WAR files page 4 26 for deploying the application on to J2EE container However if the Web Server type is Tomcat you have to perform cssparser configurations as mentioned in Create Tomcat WAR Files page 4 38 section 10 Ensure to clear the application cache prior to the deployment of Infrastructure or Application Service Packs One off patches For more information refer Clearing Application Cache page 4 43 section 11 Restart OFSAAI services For more information refer Start Infrastructure section in OFSAAI 7 3 Installation and Configuration Guide at OTN library at http docs oracle com cd E28070_01 homepage htm 3 2 Oracle Financial Services Analytical Applications Infras
14. console https if SSL is enabled The login screen is displayed Login with the User ID that has admin rights 2 In the LHS menu Domain Structure select Services gt JDBC gt Multi Data Sources The Summary of JDBC Multi Data Sources screen is displayed 4 18 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Summary of JDBC Multi Data Sources A JOBC multi data source is an abstraction around a group of data sources that provides load balancing and failover between data sources As with data sources multi data sources are also bound to the JNDI tree Applications can look up a multi data source on the JNDI tree and then reserve a database connection from a data source The multi data source determines from which data source to provide the connection Use this page to create or view multi data sources in your domain V Customize this table Multi Data Sources Filtered More Columns Exist New Showing 1to 20f 2 Previous Next aaa a CC Showing 1 to 20f 2 Previous Next Click New The New JDBC Multi Data Source screen is displayed Note Ensure that the Data Sources which needs to be added to new JDBC Multi Data Source has been created You also have the option to select Generic Data Source or Grid Link Data Source while creating a Data Source For more information refer Create Data Source page 4 12 or Create Grid Link Data Source page 4 17 reate a New JDBC Multi Data Sour
15. further information Stress Testing enhancements include e Creating multiple versions of Variable Shocks and Scenarios e Enhancement of Stress Testing with the capability to include Variable Shocks as tasks to add replace delete tasks and change their precedence in the Stress Run e Change in Scenario definition by removing Rule Shocks from Scenario definition e Forms Framework enhancements include Performance improvement in List Control to reduce the time taken to display multiple list controls when used in a container Performance improvement in Field Chooser to ensure that the DB query uses only the columns chosen for display and defined as mandatory excluding the other columns This in turn will fire the query whenever the field chooser selection changes There is no impact to the child grids display on selection de selection of columns in the parent grid as long as the parameters controls passed to the child are either marked as mandatory or selected in the grid Field Chooser works for the Read Only Grids Single Select Grids Multi Select Grids and Editable Grids Internationalization of History Table Action which facilitates the application to pick up the history action from the messages locale table based on the locale the user has currently logged in and not from the XML Support of Dynamic Breadcrumbs helping to users to navigate to the adjacent page s by clicking on the respective links Enhancements in Grid Pagin
16. server1 gt Process definition gt Java Virtual Machine Change the memory setting for Java Heap as indicated below Initial heap size 512 Maximum heap size 1024 Retrieve Patch Details For getting details on the patches that are installed in the OFSAAI environment query the table INFODOM_PATCHES in the Configuration Schema Select from infodom_patches The INFODOM PATCHES table in Configuration Schema gives the information of the patches which are already applied in OFSAAI environment Post Upgrade Configurations 4 47 Table Name Description V INFODOM Name of INFODOM N SERIAL NO Serial Number of patch V PATCH NAME Version of the patch applied V REMARKS Remarks D APPLIED DATE Patch application date OLAP Data Server Configuration This section is applicable if you are using the OLAP feature of OFSAAI The following parameters must be set to ensure that the system limitations are not exceeded at any stage The values for these OS parameters should be specified based on the expected load at each implementation site Example e Process Memory Limit e Max Thread Stack Size e Max Number of Threads per Process e Sort Buffer settings This must be set at the Essbase application level appropriate to the anticipated load Shutdown and Restart During shutdown of OFSAAI Server that has an instance of Data Services that is communicating with an OLAP Data Server it is imperative to ensure that the cleanup of
17. the following notice is applicable U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate fail safe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliat
18. the old instance is completed on the OLAP Data Server before restarting the OFSAAI Server Pause for a period of time based on the load the system was subjected to before restarting the Data Services subsystem Object Migration HttpsURLConnection configuration for WebLogic This section is applicable if you want to use the Object Migration feature of OFSAAI with WebLogic as application server The Object Migration feature of Infrastructure allows you to transfer data from a source database along with the schema objects triggers and stored procedures to the required database in an integrated environment 4 48 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX While making a HTTP s connection to external resource from WebLogic server the following exception is observed Caught Exception creating connection java lang ClassCastException weblogic net http SOAPHttpsURLConnection To avoid this problem add a java option entry DUseSunHttpHandler true in setDomainEnv sh file which resides in the WebLogic server Example oracle weblogic Oracle Middleware user_projects domains ofsaai7212 bin Restart WebLogic service Navigate to lt WebLogic Installation directory gt user_projects domains lt domain name gt bin and execute the command startWebLogic sh d64 Note If WebLogic is already running access the WebLogic Admin Console Stop amp start the application lt context name gt ear OF
19. uses to define your JDBC provider This vizard page displays the file names you supply only the directory locations of the files Use complete directory paths vhen you type the JDEC driver file locations For example C SQLLIB java on Windovs R or home db2insti sallib java on Linux TM Step 3 Summary If a value is specified for you you may click Next to accept the value Class path Directory location for ojdbc6 jar which is saved as WebSphere variable S ORACLE JDBC DRIVER PATH oracle orajdbc app orajdbc product 11 2 0 client i jdbc lib The Oracle JDBC driver Download ojdbc6 jar for Oracle 11g R2 file corresponding to the required version of Oracle Client can be downloaded from http www oracle com technetwork database enterprise edition jdbc 112010 09076 9 html Once downloaded you need to place the file in required folder in your system While creating the JDBC Provider ensure that the path to the jar file in the folder is specified in the Class path field in the Enter database class path information screen 6 Verify the details and click Finish to create the JDBC Provider Create a new JDBC Provider Create a new JDBC Provider Step 1 Create new JDBC provider Step 2 Enter database class path information cells GXS150REV Zone2NodeOSCell nodes GXS150REV Zone2Node05 servers serveri JDBC provider name Oracle JDBC Driver Description Oracle JDBC Driver Class path S ORACLE JDEC
20. 1 0 64 bit Tomcat v6 0 29 64 bit 9 10 s10s u9wos 14a SPARC sun4v 64 bit Oracle Database Enterprise Edition Release 11 2 0 2 0 64 bit with or without RAC WebSphere v7 0 0 17 64 bit WebLogic v10 3 5 0 64 bit Tomcat v7 0 19 64 bit Prerequisites 2 3 Java Internet Explorer Java Plug in MS Office Client Machines Erwin Oracle Hyperion Essbase Oracle OLAP Sun Java 1 6 0 17 64 bit 7 amp 8 1 6 0 18 2003 Windows XP SP3 Windows 7 7 1 7 3 9 3 1 64 bit NA Sun Java 1 6 0_25 64 bit 8 amp 9 1 6 0_21 2003 2007 Windows XP SP3 Windows 7 7 1 7 3 11 1 2 1 0 64 bit Oracle OLAP v 11 2 0 2 0 Note For Oracle OLAP ensure that you have configured the Oracle Database server with OLAP option For AIX 5 3 AIX 6 1 operating system Software OFSAAI Version 7 2 10 OFSAAI Version 7 3 7 2 11 7 2 12 Operating System AIX 5 3 ML 10 64 bit AIX 5 3 ML 12 64 bit Database Server amp Client Web Server AIX 6 1 ML 06 64 bit Oracle Database Enterprise Edition Release 11 2 0 1 0 64 bit WebSphere v7 0 0 9 64 bit WebLogic v10 3 1 0 64 bit Tomcat v6 0 29 64 bit AIX 6 1 ML 07 64 bit Oracle Database Enterprise Edition Release 11 2 0 2 0 64 bit with or without RAC WebSphere v7 0 0 17 64 bit WebLogic v10 3 5 0 64 bit Tomcat v7 0 19 64 bit 2 4 Oracle Financial Services Analytical Applications Infrastruct
21. DBC Provider The New JDBC Provider screen consists of the following options Enter the below mentioned details and click Next e Database Type Oracle e Provider Type Oracle JDBC Driver Implementation Type Connection pool data source e Name The required display name for the resource e Description The optional description for the resource Post Upgrade Configurations 4 3 Create a new JDBC Provider Create a new JDBC Provider E Set the basic configuration values of a JDBC provider which encapsulates the specific Step 2 Enter vendor JDEC driver implementation classes that are required to access the database database class path The wizard fills in the name and the description fields but you can type different information values Scope cells GXS150REV IZone2NodeOSCell nodes GXS150REV Zone2NodeO05 servers serverl Database au Provider type Oracle JDBC Driver vi Implementation type Connection pool data source v Name Oracle IDEC Driver Description 5 Specify the directory location for ojdbc6 jar file Ensure that you do not use the trailing slash file separators Click on Next 4 4 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Create a new JDBC Provider Create a new JDBC Provider Step 1 Create new JDBC provider Set the environment variables that represent the JDBC driver class files which WebSphere R Application Server
22. DRIVER PATHY ojdbc6 jar S ORACLE JDBC DRIVER PATH oracle orajdbe app orajdbc product 11 2 0 client_1 jdbe lib Implementation class name oracle jdbc pool OracleConnectionPoolDataSource 7 The options to Save and Review is displayed Click Save Post Upgrade Configurations 4 5 Create Data Source The steps given below are applicable for both config and atomic data source creation 1 Openthis URL in the browser window http lt ipaddress gt lt administrative console port gt ibm console https if SSL is enabled The login screen is displayed Login with the user id that has admin rights 2 Expand the Resources option in the LHS menu Click on JDBC gt Data sources option The Data sources page is displayed Data sources Data sources Use this page to edit the settings of a datasource that is associated with your selected JDBC provider The datasource object supplies your application with connections for accessing the database Learn more about this task in a guided activity A guided activity provides a list of task steps and more general information about the topic E Scope Cell GXS150REV Zone2NodeOScCell Node GXSISOREV Zone2Node05 Server serveri Scope specifies the level at which the resource definition is visible For detailed information on vhat scope is and how it works see the scope settings helo Nodes GXS1SOREV Zone2NodeO05 Serverzserverl IM Preferences New D
23. IP Host Address FIC_HOME conf Loo IP Update the OLD IP Host Addresses with kupServices xml the new WEB Server IP Host Address ficapp common FICSe SERVLET URL Update the OLD IP Host Addresses with rver conf FICWeb cfg the new WEB Server IP Host Address Post Upgrade Configurations 4 43 ficapp icc conf server conf properties ficdb conf FICDB cfg ficdb conf am conf FIC_WEB_HOME we broot conf ficweb cfg FIC_WEB_HOME we broot conf dynamicservices xml FIC_WEB_HOME we broot conf LookupServices xml FIC_WEB_HOME we broot WEB INF web x ml INSTALL HOME F OLDER gt profile FIC_SERVER_IP ICC_SERVER_HOST ICC_ROUTER_HOST MESSAGE_SERVER_ HOST REVELEUS_SERVER_ HOST FIC_SERVER_IP AM_HOST ICC_SERVER_HOST DEFAULT_CONNEC TION_URL ROUTER_HOST AM_HOST IP FIC_WEBSERVER_IP MESSAGE_SERVER_ HOST Update the OLD IP Host Addresses with the new WEB Server IP Host Address Update the Old APP IP Host Address with the new APP Server IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the Old IP Host Addresses with new APP Server IP Host Address Update the Old IP Host Addresses with new APP Server IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the Old IP Host Addresses with n
24. Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Release 7 3 Part No E38060 01 October 2012 ORACLE Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright O 2012 2013 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing If this is software or related documentation that is delivered to the U S Government or anyone licensing it on behalf of the U S Government
25. SAAI Setup Information Fetching Tool Executing the SetupInfo jar file available in the FIC HOME path will help you retrieve the related information about the OFSAAI Set up such as Operating System Name and version Database Type and Version OFSAAI architecture Log file locations and so on Execute Setuplnfo jar in Console To execute SetupInfo jar in console 1 Navigate to the path FIC HOME 2 Enter the command java jar SetupInfo jar After execution the output file location is displayed in the console Encryption Changer This utility helps you to regenerate the new AESCryptKey ext file and encrypt all the encrypted values of the OFSAAI setup according to the new key Execute EncryptC jar in Console To execute EncryptC jar in console 1 Navigate to the path FIC HOME 2 Enter the command java jar EncryptC jar A confirmation message is displayed after execution Post Upgrade Configurations 4 49 Once executed you need to create and deploy the EAR WAR file For more information refer Create and Deploy EAR WAR files in WebServers page 4 26 section Configure HTTPs Certificate information Update the following section from FICWeb cfg file with the HTTPs certificate related details File path is lt OFSAAI DeploymentPath gt lt ContextName ear gt lt ContextName war gt conf FICWeb cfg You need to change OFSAAI DeploymentPath in the staging area where you build the EAR file SFIC WEB HOME webroot conf FICWe
26. SSBASEPATH environment variables need to be updated in the user profile file where OFSAAI components are installed Clearing Application Cache This is applicable to all Web Servers that is WebSphere WebLogic and Tomcat Prior to the deployment of Infrastructure or Application Service Packs One off patches navigate to the following path depending on the WebServer configured and clear the cache e Tomcat Tomcat installation folder gt work Catalina localhost work Catalina localhost gt org apacheljsp e WebLogic lt WebLogic installation location gt domains lt Domain name gt servers lt Server name gt tmp _WL_user lt Application name gt qaelce jsp_servlet e WebSphere WebSphere installation directory gt AppServer profiles A ppServer profiles lt Profile name gt temp lt Node name gt server1 lt A pplication name gt lt war file name gt IP Host Address Related Changes If the IP Host Address of the machine on which OFSAAL is installed changes the following files and database column values need to be updated with the New Value for the uninterrupted performance of the application Related Files Place Holder Field Updated FIC HOME conf dyn DEFAULT CONNEC Update the Old DB IP Host Address with amicservices xml TION URL the new DB Server IP Host Address ROUTER HOST Update the Old DB IP Host Address with the new DB IP Host Address AM HOST Update the Old DB IP Host Address with the new DB
27. as shown in the following figure You can also define Reap Time Unused Timeout and Aged Timeout as required Post Upgrade Configurations 4 11 Data sources Data sources gt GAFUSION DATA SOURCE gt Connection pools Use this page to set properties that impact the timing of connection management tasks which can affect the performance of your application Consider the default values carefully your application requirements might warrant changing these values Configuration General Properties Additional Properties Scope cells ips26dorNode01Cell nodes ipaz6dorNodeO1 servers server1 Advanced connection pool Connection timeout properties lp seconds Connection pool custom properties Maximum connections 100 connections Minimum connections 10 connections Reap time i180 seconds Unused timeout 1800 seconds Aged timeout o seconds Purge policy E EntirePool iv ok Reset Cancel Configure Resource Reference in WebLogic Application Server This section is applicable only when the Web Application Server type is WebLogic WebLogic you can create Data Source in the following ways e For anormal Database instance Generic Data Source page 4 12 can be created e When Database is RAC configured Gridlink Data Source page 4 17 has to be created e When Load Balancing Fail over is required Multi Data Source page 4 18 has to be created Create Data Source The steps given below ar
28. atch Type Disabled Allow EJB reference targets to resolve automatically Application name Cell Node Server In the Summary screen you can click on the link provided in the Cell Node Server field to view or change the server details in the Map modules to servers screen 17 Click Finish and update the application with the specified details WebLogic This section is applicable only when the Web Application Server type is WebLogic Create EAR WAR file for WebLogic The EAR files is required to assemble servlets jsp files web pages and other static content into a deployable unit This EAR file creation is required to reflect the changes made to the web xml file Follow the steps outlined below 1 Onthe machine in which Infrastructure Web components have been installed navigate to the FIC_HOME ficweb directory At the prompt type ant sh This will 4 34 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX trigger the creation of EAR file contextname ear contextname is the context name given during installation On completion of the EAR files creation the BUILD SUCCESSFUL and Time Taken messages are displayed and you will be returned to the prompt The EAR file lt contextname gt ear is created on the machine on which Infrastructure Web components are installed under FIC WEB HOME directory Note This process overwrites any existing version of EAR
29. ation to record the history of all the actions such as Page navigation Check box Selection Record highlight Sort Order Group By Filed Record Level Rules Validations without a screen refresh Audit History for Multi select Hierarchies which facilitates an insert action into the history table on add delete from main table even when there are multiple New Modules and Features in OFSAAI 7 3 1 3 nodes with the same node description e Hierarchy Browser enhancements to include UI changes to Hierarchy Browser and Hierarchy Maintenance screens along with performance Improvements to handle highly structured and high volume hierarchies concurrent access to hierarchies and multiple dependant hierarchies in a container e naddition to the existing Essbase Cube the system also supports Oracle Cube e Support of MS Excel 2007 in Excel Upload which facilitates upload of Excel files along with all the embedded sheets defined within the Excel file e View Log enhancements in Operations module which include e UI changes to display As of date column Log Information corresponding to selected log tables and Status amp User Information pertaining to a particular process e Search options have been added for User and Batch Run ID e Depending on the selected Component Type the results in the Task ID grid may now include additional details such as current Process Step number of Records Processed Number of Errors Start amp End Dates an
30. ations 4 1 with Code 340 to entities on which Data Quality rules are to be defined e Save the Data Model changes e You would need to export the data model and perform an Incremental Model Upload For information on Incremental model upload refer Import Model section in v7 3 Infrastructure User Manual shared at http docs oracle com cd E28070_01 homepage htm Configure Resource Reference in WebServers The steps mentioned in the below section is to be performed if you have installed a new Webserver of the version specified in Prerequisite Software page 2 2 section Note For a new WebServer installation depending on your WebServer configuration i e WebSphere WebLogic or Tomcat refer to the Configurations for new WebServer Installation page 4 42 For more information contact Oracle Support Configure Resource Reference in WebSphere Application Server This section is applicable only when the Web Application Server type is WebSphere Create JDBC Provider 1 Open this URL in the browser window http lt ipaddress gt lt administrative console port gt ibm console https if SSL is enabled The login screen is displayed Login with the user id that has admin rights 2 Expand the Resources option in the LHS menu Click on JDBC gt JDBC Providers option The JDBC Providers page is displayed 4 2 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX JDBC providers JDBC providers Use th
31. b cfe When you deploy the EAR this will have the change The following properties are to be uncommented for a HTTPS setup and the provider for Websphere setup com ibm jsse IBMJSSEProvider MDD PROTOCOL PROTOCOL fMDD TRUSTSTORE TRUSTSTORE MDD TRUSTSTOREPASS TRUSTPASSWORD MDD KEYSTORE SKEYSTORE MDD KEYSTOREPASS S KEY PASSWORD PROVIDER PROVIDER DATE FORMAT MM dd yyyy 4 50 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX 5 Annexure Third Party Software OFSAAI makes use of the following software for various functionalities The Apache Software License Version 1 7 1 This product includes software developed by the Apache Software Foundation http www apache org Apache License Version 2 0 January 2004 Quadbase Systems Inc Copyright 2006 Quadbase Systems Inc All rights reserved NAG Limited NAG Limited 2005 Portions utilize NAG s C library All rights reserved Gnuplot Version 4 2 0 Copyright 1986 1993 1998 2004 www gnuplot info http www gnuplot info Annexure 5 1
32. ce Next Cancel Configure the Multi Data Source The following properties wil be used to identify your new JOBC multi data source What would you like to name your new JOBC multi data source GB tame JDBC Multi Data Source 0 What JNDI name would you like to assign to your new JOBC multi data source amp NOI Name jdbc infodomname What algorithm type for this JOBC Multi Data Source would you like to select amp Algorithm Type Load Balancing Next Cancel Enter the JDBC Source Name JNDI name and select the Algorithm Type from the drop down list Click Next e The JNDI Name has to be specified in the format jdbc infodomname e JNDI Name of the Data Sources that will be added to new Post Upgrade Configurations 4 19 JDBC Multi data source should be different from the JNDI name specified during Multi Data Source e Same steps needs to be followed to create a mandatory data source pointing to the configuration schema of infrastructure with jdbc FICMASTER as JNDI name for Data Source e JNDI Name provided in multi data source should be the same name that will be mentioned in the web xml file of OFSAAI Application e You can select the Algorithm Type as Load Balancing 5 Select the AdminServer check box and click Next reate a New JDBC Multi Data Source Back Next Cancel Select Targets You can select one or more targets to deploy your new JOBC Multi Data Source Back Next Cance
33. connection pooling do the following 1 Copy ORACLE HOM E jdbc lib ojdbc6 jar to the path TOMCAT DIRECTORY common lib Edit the server xml present under the path TOMCAT_DIRECTORY conf with the below changes which is required for connection pooling Context path SCONTEXTNAMES docBase APP DEPLOYED PATHS debug 0 reloadable true crossContext true gt lt Resource auth Container name jdbc INFODOM_ NAMES type javax sql DataSource driverClassName oracle jdbc driver OracleDriver username ATOMICSCHEMA USERNAMES password SATOMICSCHEMA PASSWORDS url JDBC_CONNECTION_URL maxActive 100 maxIdle 30 maxWait 10000 removeAbandoned true removeAbandonedTimeout 60 logAbandoned true Context e TOMCAT_DIRECTORY should be replaced by Tomcat application installed path e CONTEXTNAMES should be replaced by OFSAAI context name e APP DEPLOYED PATHS should be replaced by OFSAAI application deployed path e INFODOM NAMES should be replaced by Infodom Name e ATOMICSCHEMA USERNAMES should be replaced by Atomic schema database user name e ATOMICSCHEMA PASSWORDS should be replaced by Atomic schema database password Post Upgrade Configurations 4 25 e JDBC CONNECTION URL should be replaced by JDBC connection string jdbc Oracle thin lt IP gt lt PORT gt lt SID gt For example jdbc oracle thin 10 80 50 53 1521 soluint
34. d e All changes have been activated No restart is necessary e Settings updated successfully If not follow the steps given above to recreate the Data Source Settings for FICMASTER Configuration Targets Monitoring Control Security Notes Save This page allows you to select the servers or dusters on which you would like to deploy this JOBC data source Saye JDBC Connection Pooling To define the JDBC connection pooling ensure that you have created JDBC Provider and Data source to access the data from the database 1 Click the newly created Data Source DATA_SOURCE and navigate to the path Home gt Summary of Services JDBC gt Summary of JDBC Data Sources gt JDBC Data Source lt INFODDOM_NAME gt 2 Set the values for Initial Capacity to 10 Maximum Capacity to 100 Capacity Increment by 1 Statement Cache Type to LRU and Statement Cache Size to 10 as shown in the below figure Post Upgrade Configurations 4 23 intis C apacit y Moxie Capacity Capacity lecrement dC Statement Cache 5v x Type Statement Cache Sire P Advanced Swe 3 Save the details Configure Resource Reference in Tomcat Application Server Create Data Source This section is applicable only when the Web Application Server type is Tomcat Copy the JDBC driver file depending on your Oracle database version e For Oracle 11gR2 copy the Oracle JDBC driver file ojdbc6 jar from Oracle Home gt jdbc lib and place i
35. d Elapsed Time e Administration gt Security Management gt User Group Authorization feature facilitating System Authorizers to Approve Reject all the User Group changes which include Mapping Unmapping of a new user to a group or a role to a group or even a user domain to a group e Append Type feature in Model Upload has been introduced to eliminate the need for manual merging of data model with 7 x Erwin XMLs which are of huge size causing memory and Java heap issues during upload Append Type upload facilitates incremental upload of model with the true Incremental functionality so that each application can add their slice of model instead of uploading it as a fully merged entity e Object Migration functionality to helps users to select and migrate the various objects such as Unified Metadata objects Alias Business Processor Essbase Cube Data Sets Business Measures Business Hierarchy and Business Dimension and Financial Services Application objects Dimension Hierarchy Filter Expression Rule and SOL Rule along with their registered dependencies Migration may occur across information domains within the same or different OFSAAI Installations e Data Quality Framework for validation of data and optional assignment of new values Features include 1 4 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX e Nine Specific Check types to validate the selected column Check types can be base
36. d on Range Data Length Column Reference Specific Value List of Value Code Null Value Blank Value Referential Integrity Duplicity and Custom Check Business queries e Data may also be corrected by defining a Generic Check using one or more conditions based on values within the selected table e Optional value assignment data correction based on the above validation queries e Role based and rule level security e Execution of groups of rules through Data Quality Groups as well as through ICC Operations Batch e View Logs summarizing the processing results e Financial Services Applications Dimension Management Users can now add new dimension members through the Hierarchy Add and Edit flows e Sliced Model Upload feature in UMM gt Model Upload Features Not Available Information Delivery link consisting of Insight and Active Portal features e Pass Number Maintenance feature link in Operations module e Erwin Option in Generate Source Model dialog of Unified Metadata Manager gt Data Integrator gt Data Sources Rule Shocks feature links from Advanced Analytics Infrastructure gt Stress Testing e Parameter Modification feature links from Advanced Analytics Infrastructure gt Modeling e ISMEMORYLOAD property in Properties dialog of Database Extracts Table to File and File Extracts screens in Unified Metadata Manager gt Data Integrator gt Warehouse Designer File Sort Property in Properties d
37. dard infrastructure About this Manual This manual includes step by step instructions necessary to upgrade OFSAAI version from 7 2 10 7 2 11 7 2 12 to 7 3 The contents of this document detail the scope of OFSAAI version upgrade to 7 3 The information contained in the document is intended only for Infrastructure upgrade and is not specific to the applications installed and configured on existing OFSAAI installation The last section of this document consists of references and feedback information pertaining to any issues noticed within the document You can contact Oracle Support if you face any errors during the upgrade and also for applications specific upgrade queries Conventions and Acronyms Conventions AAI AES DBA EPM ERM LDAP LHS OFSAAI SA SOL UDP UMM XML Description Advanced Analytics Infrastructure Advanced Encryption Standard Database Administrator Enterprise Performance Management Enterprise Risk Management Lightweight Directory Access Protocol Left Hand Side Oracle Financial Services Analytical Applications Infrastructure System Administrator Structured Query Language User Defined Properties Unified Metadata Manager Extensible Markup Language vi TIER The terminology tier referenced in this document refers to the different components of AAI installed on any box For example DB tier would mean the box on which the ficdb components of AAI are installed a
38. e Kit 4 Uncompress the unzip utility file using the command uncompress unzip_ lt os gt Z Note Sometimes you may notice an error message uncompress not found No such file or directory when the package is not installed Contact your UNIX administrator to resolve this issue Prerequisites 2 1 5 Make sure that the file has execution permissions set If not run the command chmod 755 unzip os Example chmod 755 unzip linux 6 Tounzip a file using this utility run the command unzip_ lt os gt a lt name of the file to be unzipped gt Example unzip_linux a OFSAAI7 3_installer zip Prerequisite Software Refer the below table and ensure that you have upgraded all the prerequisite software listed in OFSAAI version 7 2 10 7 2 11 7 2 12 column to the versions as indicated in OFSAAI version 7 3 column However you can upgrade these software post upgrade to OFSAAT 7 3 Note OFSAAI v7 3 release is certified on Oracle 11g R2 11 2 0 2 0 and this Upgrade Installer is not compatible for OFSAAI 7 2 with Oracle 10g R2 For more information contact Oracle Support For Linux operating system Software Operating System Database Server amp Client Web Server OFSAAI Version 7 2 10 7 2 11 7 2 12 Red Hat Enterprise Linux Server release 5 3 5 5 Tikanga 64 bit Oracle Enterprise Linux Server release 5 3 5 5 Carthage 64 bit Oracle Database Enterprise Edition Release 11 2 0 1 0
39. e applicable for both config and atomic data source creation 1 Openthe following URL in the browser window http lt ipaddress gt lt administrative console port gt console https if SSL is enabled The login screen is displayed Login with the User ID that has admin rights 4 12 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX ORACLE WebLogic Server 11g Administration Console Log in to work with the WebLogic Server domain Password 2 Fromthe LHS menu Domain Structure click Services JDBC Data Sources The Summary of JDBC Data Sources screen is displayed ORACLE WebLogic Server Administration Console Home Log Out Preferences E Record Help Homa Summary of JDBC Dats Sources Change Center View changes and restarts Summary of OBC Data Sources changes wil automaticaly be modfy add or delete tems in this domain A J0 C data source is an object bound to the INDI tree that provides database connectivity through a pool of JDBC connections Applications can lock up a data source on the JNDI tree and then borrow a database connection from a data source This page summarizes the JDBC data source objects that have been created in this domain P Customize this table Data Sources Filtered More Columns Exist L New Delete 7 Nome Pe Foreign JNDI Providers v ssatoes Work Contexts Showing 1 to 1 of 1 Previous Next 1M Regetries New _ Dele
40. e basic configuration values of a datasource for association with your JDBC provider A datasource supplies the physical connections between the application server and the database Requirement Use the Datasources WebSphere R Application Server V4 console pages if your applications are based on the Enterprise JavaBeans TM EJB 1 0 specification or the Java TM Servlet 2 2 specification data source Scope cells GXS1SOREV Zone2NodeOSCell nodes GXS150REV iZone2NodeOS servers serverl Step 4 Setup security aliases Step 5 Summary Data source name T JNDI name idbe DRYMOCK 5 Select the option Select an Existing JDBC Provider and select the required JDBC provider from the drop down list Click Next Create a data source Create a data source Step 1 Enter basic data source information r Specify a JDBC provider to support the datasource If you choose to create a new JDEC provider it vill be created at the same scope as the datasource If you are selecting an existing JDBC provider only those providers at the current scope are available from the list Step 3 Enter database specific properties for the data source Step 4 Setup security aliases o Create new JDBC provider O Select an existing JOBC provider Oracle JDBC Driver VY Step 5 Summary 6 Specify the database connection URL URL format jdbc oracle thin lt DB_SEREVER_IP gt lt DB_SERVER_PORT gt lt SID gt 7
41. e of the tables from the Configuration Schema ensure to execute the below file from the Infrastructure Configuration Database user before creating a new Information Domain Infrastructure Database Layer Install Directory config table privileges for atomic user sgl Configure Infrastructure Server Memory The memory settings for Infrastructure Application Server Tomcat WebSphere and WebLogic can be edited for customizing memory settings and garbage collector settings depending on the available hardware configuration as explained below These settings are base minimum which needs to be incremented and these increments are usually handled in multiples of 128 mb for heap and 64 mb for stack Infrastructure Application Server Memory Settings You can configure the Infrastructure Application Memory settings as follows Locate reveleusstartup sh file which resides in the folder OFSAAI Installation Directory gt ficapp common FICServer bin Edit X_ARGS field in this file for customizing memory settings and garbage collector settings depends on the hardware configuration This has a default value X_ARGS Xms200m X ARGS X ARGS DELIM Xmx200m X_ARGS Xms1024m X ARGS X ARGS DELIM Xmx2048m Tomcat Memory Settings To configure the Tomcat Memory Settings locate the file catalina sh which resides in the folder lt CATALINA_HOME gt bin You can edit this file for customizing the memory settings and garbage collector set
42. e or add a single module If the path to the new module matches an existing path to a module in the installed application the new module replaces the existing module If the path to the module does not exist in the installed application the new module is added to the application o Replace or add a single file If the path to the new file matches an existing path to a file in the installed application the new file replaces the existing file If the path to the file does not exist in the installed application the new file is added to the application o Replace add or delete multiple files Use a compressed file format such as zip or gzip The compressed file is unzipped into the installed application directory If the uploaded files exist in the application with the same paths and file names the uploaded files replace the existing files If the uploaded files do not exist the files are added to the application You can remove existing files from the installed application by specifying metadata in the compressed file 10 Click Next Preparing for the application update How do you want to install the application Fast Path Prompt only when additional information is required Detailed Show all installation options and parameters em bindings to use a B Choose to generate default bindings and mappings 11 Select the Fast Path option 12 In the Specify bindings to use field select Merge new and ex
43. ect this option if you want to enable non XA JDBC connections from the data source to participate in global transactions using the one phase commit transaction processing With this option no other resources can participate in the global transaction One Phase Commit Back Next F cancel 7 Click Next The Connection Properties screen is displayed Create a New JDBC Data Source acis wens FEM canceu Connection Properties Define Connection Properties Whatis the name of the database you would like to connect to Database Name What is the name or IP address of the database server Hast ames 10 184 74 80 What is the port on the database server used to connect to the database Port 1521 What database account user name do you want to use to create database connections Database User Name ssatom What is the database account password to use to create database connections eccces 8 Enter the required details such as the Database Name Host Name Port Oracle User Name and Password Click Next The Test Database Connection screen is displayed Post Upgrade Configurations 4 15 Create a New JDBC Data Source Test Configuration Back Next Finish Cancel Test Database Connection Test the database availability and the connection properties you provided What is the full package name of JOBC driver dass used to create database connections in the connection pool Driver Class Name oracle jdbc OracleDriver
44. elete Test connection Manage state a Me amp E Select Name INDI name Scope gt Provider gt Description gt Category gt You can administer the following resources Default DefaultDatasource NodezGXS150REV Derby JDBC Datasource Datasource Zone2NodeOS Serverzserveri Provider for the WebSphere Default Application FICMASTER jdbc FICMASTER NodezGXS1SOREV FICMASTER New JDBC Zone2Node05 Server serveri Datasource RORFEW jdbc RORFFW Node GXS150REvV RORFFW New JDBC Zone2Node05 Server serverl Datasource jdbc RORPNC NodezGXS1i1SOREV RORPNC New JDEC Zone2Node05 Server serveri Datasource jdbc UPGSPFT NodezGXS150REV UPGSPFT New JDBC Zone2NodeOS Serverzserveri Datasource jdbc UPGSROR NodezGXS15O0REV UPGSROR New JDBC Zone2Node05 Server serveri Datasource Total 6 3 Select the Scope from the drop down list Scope specifies the level at which the resource definition is visible 4 Click New The Create a Data Source screen is displayed Specify the Data Source name and JNDI name for the new data source The JNDI and Data Source name are case sensitive and ensure that JNDI name is same as the Information Domain Click Next 4 6 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Create a data source Create a data source Step 2 Select JDBC provider Step 3 Enter database specific properties for the Set th
45. ensions Hierarchies and Measures The generated Rule and data files can be used to load data and build cubes e Object Migration This module facilitates to migrate all the registered objects along with their dependencies across information domains within the same or different database or server e SQL Rule This module facilitates to directly manipulate the database using SOL Statements and Procedures e Data Quality Framework This module facilitates to define rules and execute them to query validate and correct the transformed data existing in an information domain Note The existing Data Quality feature from LHS menu of Data Integrator Framework Data Quality has been removed and these Data Quality Rule definitions have to be re defined post upgrade using the new Data Quality Framework The existing DQ definitions created in ERM applications will be migrated and available in the new Data Quality section New Modules and Features in OFSAAI 7 3 1 1 New Features e AES Advanced Encryption Standard Encryption algorithm using JAVA has been implemented replacing the existing CPP implementation of the Triple DES algorithm e Enhancements in Data Integrator framework which include e SQL RULE enables users to directly manipulate the database using SOL statements and procedures e Create Edit Copy and Delete SOL Rules with support for both SOL statements and procedures e Validate the defined SOL statement procedu
46. es are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services Contents Preface 1 New Modules and Features in OFSAAI 7 3 WHat N AERE ETE E SES ENE TEN A SEEE E E EEEE 1 1 Limitations 2 Prerequisites Introduction C T 2 1 Guidelines to Unzip Infrastructure Upgrade Kit ssesessssssseeee 2 1 Prerequisite Software uei in itin nie t t Re Pd a i DTE be ER SELLE EE RE LATER ELE 2 2 Prerequisite Activities ient eie tieni ndi a bead et ER sae a n Re LI ERR Ee EE a eG 2 5 3 Upgrade Process Upgrade Process oce oie bae eee emet aa rE aA E EEEE A een 3 1 4 PostUpgrade Configurations Post Upgrade Configurations eem ee eem emen nennen 4 1 Configure Resource Reference in WebServers sssssssssssssee eee mee 4 2 Create and Deploy EAR WAR files in WebServers sssssssseeneeee 4 26 Additional Configurations iiaeia ie ie ii eene nee nre nnne nnne nnne nnn 4 42 5 Annexure Third Party Software 2 tee eee Ieri med Md e Pe EE ie Pn e EAR 5 1 Preface Intended Audience Welcome to Release 7 3 of the Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX This guide is intended for System Administra
47. ew APP Server IP Host Address Update the Old DB IP Host Address with the new DB Server IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the OLD IP Host Addresses with the new WEB Server IP Host Address Update the OLD IP Host Addresses with the new WEB Server IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address 4 44 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX FIC ROUTER HOST Update the Old DB IP Host Address with the new DB IP Host Address Below tabulated are the tables and corresponding column names that needs to be updated Table Name Column Name CONFIGURATION Update the PARAMVALUE for JICSHOST ETLSOURCEDETAILS V SRV IP ADDR DB MASTER DBIPADDRESS JDBCCONNSTR DSNMASTER DBSERVER OLAPIPADDRESS FICSYSMASTER WEBIPADDRESS APPIPADDRESS DBIPADDRESS SETUP SERVER INFO DB SERVER INFO SETUP PORTS OLAP MASTER WEB SERVER INFO BATCH PARAMETER BATCH PARAMETER M ASTER AM IP ADDRESS DBIPADDRESS V DBSERVERIP V APPSERVERIP V WEBSERVERIP OLAPIPADDRESS WEBIPADDRESS V PARAMETER VALUE V PARAMETER VALUE Post Upgrade Configurations 4 45 APP SERVER INFO APPIPADDRESS Configure Information Domain Schema Privileges As the Information Domain Schema accesses som
48. file in the path Deploy EAR WAR file for WebLogic To configure the WebLogic for OFSAAI v7 3 follow the below steps 1 Start WebLogic Domain by navigating to the path lt WEBLOGIC_INSTALL_DIR gt Bea user_projects domains lt DOMAIN_NAME gt bin and execute the command startWeblogic sh d64 Open the URL in the browser http lt ipaddress gt lt admin server port gt console https if SSL is enabled The Sign in screen of the WebLogic Server Administration Console is displayed Sign on with the WebLogic User Name and Password that has privileges to deploy the EAR file From the LHS menu select Deployments The Summary of Deployments screen is displayed Post Upgrade Configurations 4 35 ORACLE WebLogic Server Administration Console Change Center Home Log Out Preferences 5 Record Help Q Welcome upg7273 Connected to upg7273 View changes and restarts Configuration editing is enabled Future Home Summary of Deployments changes wil automatically be activated as you Deployment modify add or delete items in this domain gmane i Control Monitoring This page displays a ist of Java EE applications and stand alone application modules that have been installed to this domain Installed applications and modules can be started stopped updated redeployed or deleted from the domain by first selecting the application name and using the controls on this page To install a new application or module for deplo
49. gDataStoreHelper Use this data source in container managed true persistence CMP Component ma ed authentication alias Mapping configuration alias Container managed authentication alias You can also create and map J2C authentication alias after creating the data source 10 You must create another Data source by following the above procedure with jdbc FICMASTER as JNDI name pointing to the configuration schema of Infrastructure Post Upgrade Configurations 4 9 J2C Authentication Details The steps given below are applicable for both config and atomic data J2C Authentication To create J2C Authentication details 1 Select the newly created Data Source Click JAAS J2C authentication data link under Related Items and click New Data sources Data sources gt Default Datasource gt JAAS J2C authentication data Specifies a list of user identities and passwords for Java TM 2 connector security to use Prefix new alias names vith the node name of the cell for compatibility with earlier releases Apply E Preferences Nes Delete Select Alias gt User ID gt Description gt You can administer the following resources g GXS1S0REV upgsconf FICMASTER ne2n FICMASTER o GXS150REV Zone2Node05 RORFFW rorffw g XS150REV Zone2N RORPN rorpnc o x REV Zone2N i PFT upgspft upgspft oO GXS150REv upgsprod upgsprod Zone2Node05 UPGSPROD oO GXS150REV upgsror upgsror ne2N UPGSROR
50. h core 0 2 5 jar and commons logging 1 1 jar are present Note In a multi tier setup Upgrade Kit needs to be copied and unzipped in all the tiers You need to first upgrade the DB tier before upgrading other layers 4 Grant execute permission for Upgrade sh PreReqCheck jar lib and the files under the lib directory j2ssh core 0 2 5 jar and commons logging 1 1 jar using the command chmod 755 file name Example chmod R 755 PreReqCheck jar upgrade bin Upgrade sh lib 5 Execute Upgrade sh from the Installation directory where you have unzipped the files Note During upgrade ensure that you do not press Ctrl C or Ctrl Z This would interrupt the process and can corrupt the existing setup Upgrade Process 3 1 The upgrade process generates OFSA AIUpgrade log in the Infrastructure Installation Directory FIC HOME Note You can ignore the following errors ORA 00955 ORA 00904 ORA 01408 ORA 01418 ORA 02260 ORA 00997 ORA 02264 and ORA 02261 if reported in the OFSAAIUpgrade log Contact Oracle Support if you notice any issues in OFSAAIUpgrade log file on completing the upgrade process Verify if all the data is accessible by logging in to the application s It is highly recommended that you install the OFSAAI 7 3 2 0 0 IR patch to be on the latest patch set level to include all the fixes made in OFSAAI 7 2 11 7 2 12 post v7 3 release You can verify the success of 7 3 version upgrade by accessing the applications data
51. he application name Click OK in the confirmation dialog start Stop Reload Undeploy Expire sessions with idle 2 30 minutes Stet Stop Tomcat Manager Application Exe sessions Jwah ie 230 mints Stan Stop Reload Undeploy Expire sessions with idle 2 30 minutes Tomcat Host Manager Application OFSAAI Web Application Context Path required upgs73 XML Configuration file URL WAR or Directory URL oradatat appins appweb icweb upgs 3 Select WAR file to upload This diagnostic check will trigger a full garbage collection Use it with extreme caution on production systems Apache Tomcat 7 0 19 1 6 0 25 b06 Sun Microsystems Inc Linux 2 6 18 194 el5xen ICLV86DOR 10 184 134 146 Copyright 1999 2011 Apache Software Foundation Enter the context name given during the installation under Deploy Context Path field as lt context name gt Enter the Path where the lt context name gt war file resides in the WAR or Directory URL and click on Deploy Uncomment the Context path tag in the server xml file Restart the Tomcat services You can restart the tomcat service as follows Login to the Unix server through a terminal emulator e Navigate to catalina home bin directory e Stop the tomcat services using the command shutdown sh Post Upgrade Configurations 4 41 e Start the tomcat services using the command startup sh Additional Configurations Refer to the following sec
52. ialog of Database Extracts Table to File screen in Unified Metadata Manager gt Data Integrator gt Warehouse Designer e Authentication Type LDAP Authentication and Authorization in System Configuration gt Configuration screen New Modules and Features in OFSAAI 7 3 1 5 e Export to pdf option from Forms Framework module This has to be achieved through the use of BI Publisher with templates created in BIP attaching the same to Form and exporting based on the attached template e Replicating the existing Information Domain option during configuring of new Information Domain in System Configuration gt Information Domain e Phase out of earlier Data Quality feature link from Unified Metadata Manager gt Data Integrator to accommodate enhanced Data Quality Framework e OFSAAI Server Administrative Console utility to enable management of OFSAAI servers sh file The same is distributed over administrative interfaces of the core platform Limitations Following are the limitations of the OFSAAI v7 3 Upgrade e Existing Stress definitions in v7 2 of Advanced Analytics Infrastructure gt Stress Testing gt Stress Definition have to be re defined post v7 3 upgrade Bug 13700972 e Object Migration requires the Infrastructure version in your source to be the same as the version in your target Similarly the deployed OFSAA applications must be the same version in the source and target This ensures that the source and target data
53. ion Properties Enter Complete JOSC URL for GridLink database Complete JDBC URL What database account user name do you want to use to create database connections Database User Name What is the database account password to use to create database connections Password Confirm Password Cancel Specify Complete JDBC URL Database User Name and Password Click Finish The created Data Source is displayed in the list of Data Sources Configure Multi Data Sources A JDBC multi data source is an abstraction around a group of data sources that provides load balancing and fail over between data sources As with data sources multi data sources are also bound to the JNDI tree Applications can look up a multi data source on the JNDI tree and then reserve a database connection from a data source The multi data source determines from which data source to provide the connection When the database used is Oracle RAC Real Application Clusters which allows Oracle Database to run across a set of clustered servers then group of Data Sources can be created for instances running on a set of clustered servers and a JDBC multi data source can be created so that applications can look up a multi data source on the JNDI tree to reserve database connection If a clustered server fails Oracle continues running on the remaining servers 1 Open the following URL in the browser window http lt ipaddress gt lt administrative console port gt
54. is page to edit properties of a JDBC provider The JDBC provider object encapsulates the specific JDBC driver implementation class for access to the specific vendor database of your environment Learn more about this task in a i ivity A guided activity provides a list of task steps and more general information about the topic Scope Cell GXS150REV Zone2Node05Cell Node GXS150REV Zone2Node05 Server server1 Scope specifies the level at vhich the resource definition is visible For detailed information on vhat scope is and how it works see the scope settings help NodezGXSiS5OREV Zone2Node05 Serverzserveri v Preferences Bloe Select Name Scope gt Description gt You can administer the following resources ri Provider NodesGXS150REV Derby embedded non XA JDBC Zone2Node05 Server serveri Provider FICMASTER NodezGXS150REVv Oracle JDBC Driver Zone2Node05 Server server1 NodezGXS150REV Oracle JDBC Driver Zone2NodeOS Serverzserveri 1 T NodezGXS150REV RORFFW Zone2NodeOS Serverzserveri Node GXS150REV RORPNC Zone2Node05 Server serverl T T NodezGXS15OREV UPGSPFT Zone2NodeOS Serverzserverl t Node GXS150REV UPGSROR Zone2Node05 Server server1 NodezGXS150REV UPGSSAND Zone2NodeO05 Serverzserveri Select the Scope from the drop down list Scope specifies the level at which the resource definition is visible Click New to add new J
55. isting binds default option from the drop down list 13 Click Next The Select Installation options screen is displayed You can modify any of the details if required Once done click Next The Map module to servers screen is displayed Post Upgrade Configurations 4 31 Install New Application Specify options for installing enterprise applications and modules Specify targets such as application servers or clusters of application servers where you want to install the modules that are contained in your application Modules can be installed on the same application server or dispersed among several application servers Also specify the Web servers as targets that serve as routers for requests to this application The plug in configuration file plugin cfg xml for each Web server is generated based on the applications that are routed through Clusters and servers WebSphere cell GX5150REV Zone2Node05Cell node GX5150REV Zone2Node0S server serveri WebSphere cell2GXS150REV Zone2NodeOSCell nodez GXS150REV Zone2Node05 serverzserveri WebSphere cell GxSiSOREv Zone2NodeOSCall nodeeGXS150REV Zone2Node0S server server 14 Select the check boxes adjacent to the module names and click Next The Map resource references to resources screen is displayed 4 32 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Install New Application options for installing enterprise applications and m
56. ith the same paths and file names the uploaded files replace the existing files If the uploaded files do not exist the files are added to the application You can remove existing files from the installed application by specifying metadata in the compressed file 7 Select Remote file system and click Browse 8 Navigate to the FIC_HOME ficweb path to locate the ear file Post Upgrade Configurations 4 29 Browse Remote Filesystems E Select the radio button next to the archive that you wish to install or click on a directory name to view its contents Contents of webserver webs7 IBM WebSphere AppServer profiles upgs73 installedApps GXS150REV Zone2NodeOSCell E zac o D Build deployment sh o0 upgs7i3 ear O uus Cancel 9 Select the required ear file and click OK You are returned to Preparing for the application update screen with the path of the selected Remote file 4 30 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Preparing for the application update Specify the EAR WAR JAR or SAR module to upload and install Application to be updated upgs73 Application update options O Replace the entire application Upload an enterprise archive ear to replace the entire installed application Specify the path to the replacement ear file Oo Local file system Full path Remote file system Full path ps GXS1SOREV Zone2NodeOSCell upcs7 13 ear o Replac
57. nd does not mean the physical DB engine Similarly the WEB tier would mean the box on which the ficweb component resides and does not mean the physical web server J2EE engine APP tier would mean the box on which the ficapp components reside See Related Information Sources on page vii for more Oracle product information Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http www oracle com pls topic lookup ctx acc amp id docacc Access to Oracle Support Oracle customers have access to electronic support through My Oracle Support For information visit http www oracle com pls topic lookup ctx acc amp id info or visit http www oracle com pls topic lookup ctx acc amp id trs if you are hearing impaired Structure 1 New Modules and Features in OFSAAI 7 3 2 Prerequisites 3 Upgrade Process 4 Post Upgrade Configurations 5 Annexure Related Information Sources e Oracle Financial Services Analytical Applications Infrastructure User Guide Release 7 3 e Oracle Financial Services Analytical Applications Infrastructure Upgrade Kit Release Notes Release 7 3 vii 1 New Modules and Features in OFSAAI 7 3 What s New New Modules Following are the list of new modules features and limitations in 7 3 version of OFSAAIT e Oracle Cubes This module facilitates to define cubes using Business Metadata objects such as Dim
58. odules Each resource reference that is defined in your application must be mapped to a resource javax sql DataSource Mech Resource Aubanctn athe 15 Select the check boxes adjacent to the module names Ensure that the Target Resource JNDI Name fields for all the selected modules are provided with correct path You can click Browse button to add update these names 16 Click Next The Summary screen is displayed Post Upgrade Configurations 4 33 Install New Application Specify options for installing enterprise applications and modules Step 1 Select installation options Summary of installation options Step 2 Map modules to servers Options 1 Values e Precompile JavaServer Step3 Map Pages files resource references T to resources Directory to install S APP INSTALL ROOT GXS1SOREV application Zone2NodeOSCell Distribute application Yes No Use Binary Configuration No Deploy enterprise beans Yes Create MBeans for resources Yes Override class reloading settings for Web and EJB No modules Reload interval in seconds Deploy Web services No Validate Input off warn fail Process embedded configuration File Permission dll 7552 so 7552 a 7552 sl 755 Application Build ID Unknovn Allow dispatching includes to remote resources No No Allow servicing includes from remote resources No Asynchronous Request Disp
59. omcat Post Upgrade Configurations 4 39 Apache Software Foundation http www apache org Tomcat Web Application Manager Context Path required 3 Locate the server xml file in the Tomcat installation directory that is in CATALINA_HOME conf and comment the Context path tag path upgs73 docBase oradatal appins apache tomcat 7 0 19 webapps upgs73 debug 0 reloadablez false Resource auth Container namez jdbc FICMASTER type javax sql DataSource driverClassNomez oracle jdbc driver OracleDriver username penconf posswordz pen conf url jdbc oracle thin 10 184 134 124 1521 OFSAAI73 maxActive 100 maxIdle 30 maxWait 10000 gt Resource authz Container name jdbc ATOMS javax sql DataSource driverClassNomez oracle jdbc driver OrocleDriver usernamez atoms passwordz atoms url jdbc oracle thin 10 184 134 124 1521 OFSAAI73 maxActivez 100 maxIdle 30 maxWait 10000 gt 4 Restart the Tomcat service You can restart the tomcat service as follows 4 40 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Login to the Unix server through a terminal emulator e Navigate to catalina home bin directory e Stop the tomcat services using the command shutdown sh e Start the tomcat services using the command startup sh In the Commands column click Undeploy option against t
60. onfirmation message will be displayed and you will be returned to the prompt 4 The WAR file lt contextname gt war is created on the machine on which Infrastructure Web components are installed under FIC WEB HOME directory e This process will not overwrite any existing version of WAR file that exists in the path Rename delete any existing war file e Proceed with the following steps for Tomcat WAR Files Deployment page 4 38 e Log on to the server in which Tomcat is installed Deploy Tomcat WAR Files To configure the Tomcat for OFSAAI v7 3 follow the below steps 1 Open the URL in Browser window http lt IP address Tomcat server port https if SSL is enabled The Tomcat Home screen is displayed 4 38 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Home Documentation Configuration Wiki Mailing Lists Find Help Apache Tomcat 7 0 19 uir software Foundation If you re seeing this you ve successfully installed Tomcat Congratulations Developer Quick Start Tomcat Setup Eirst Web Application Other Downloads Other Documentation Get Involved Miscellaneous Apache Software Foundation Copyright 1999 2011 Apache Software Foundation All Rights Reserved Click Manager App The Connect to dialog is displayed Enter the User Id and Password that has admin rights and click OK The Tomcat Web Application Manager screen is displayed along with the deployed applications in T
61. re e Execute SQL Rules through OFSAAI ICC Framework Launch from SQL Rule summary page or Operations Batches e View the execution logs and status through LogViewer e Pagination functionality in Data grids e Configuration of DI Supported Data Source Locales e Populate Extraction functions from DATABASE ABSTRACT LAYER e Modified Expression Text to now represent as Derived Column e Enhancements in Advanced Analytics Infrastructure e Modeling Framework enhancements include Transition Matrix a new Statistical Technique with different types of methods such as EWMA Linear Regression Multi Factor Stepwise Regression and Time Series e Reuse and multipurpose Sandbox definitions e Allow Transformations to be defined for a Variable Definition e Model Execution and Stress Testing in Sandbox Information Domain e Regression Technique changes with the ability to predict multiple periods using iterative process e Variable instance name editing 1 2 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX e Output history and model deployment changes which includes nomenclature changes for Table column and configuration files e Optimizer and Pooling features from Advanced Analytics Infrastructure have been made available as a part of Analytical Applications for Enterprise Risk Management and are not part of this upgrade If these components are being used currently contact Oracle support for
62. s database connectivity through a pool of JDBC connections Applications can look up a data source on the JNDI tree and then borrow a database connection from a data source This page summarizes the JOBC data source objects that have been created in this domain V Customize this table Data Sources Filtered More Columns Exist New v pee Showing ito 9of9 Previous Next Showing 1to 9 of9 Previous Next 4 Select the server and click Test Data Source Settings for FICMASTER Configuration Targets Monitoring Control Security Notes Statistes Testing Use this page to test database connections in this JDBC data source V customize this table Test Data Source Filtered More Columns Exist Test Data Source Showing 1 to 1of 1 Previous Next Test Data Source Showing 1 to Lof 1 Previous Next A message is displayed indicating that the test was successful 4 22 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Messages Test of FICMASTER on server AdminServer was successful Settings for FICMASTER Configuration Targets Monitoring Control Security Notes Statstes Testing Use this page to test database connections in this JOBC data source Customize this table Test Data Source Filtered More Columns Exist Showing 1 to 10f1 Previous Next Showing 1 to 10f1 Previous Next 5 Once the Data Source is created successfully the following messages are displaye
63. stall button Customize this table Deployments instal Update Delete Seay Stopy Showing 1to 1of1 Previous Next Servicing all requests Servicing only administration requests amp Rupg7273 stai Update Delete Start Stop Showing ito Lof i Previous Next The selected deployment is started and the status is changed to Active Tomcat This section is applicable only when the Web Application Server type is Tomcat Post Upgrade Configurations 4 37 Create Tomcat WAR Files The WAR files is required to assemble servlets jsp files web pages and other static content into a deployable unit Note that if you need to access Advanced Analytics Infrastructure module using Tomcat as the WebServer you need to do the following e Delete cssparser 0 9 4 fs jar from FIC_WEB_HOME webroot WEB INEF lib e Copy cssparser 0 9 5 jar file from FIC WEB HOME CSSPARSER to FIC WEB HOME webroot WEB INF lib Note If the OS is AIX you need to copy xerces jar file from FIC WEB HOME XERCES to FIC WEB HOMEN webroot WEB INF lib The steps given below will guide you through the WAR files creation process 1 Onthe machine in which Infrastructure Web components have been installed navigate to the path FIC_HOME ficweb 2 Atthe prompt execute ant sh This will trigger the creation of WAR file contextname war The lt contextname gt is the name given during installation 3 Oncompletion of the WAR files creation a c
64. structures are compatible for objects you wish to migrate Refer to OFSAAI 7 3 User Manual Administration gt Utilities gt Object Migration section for additional prerequisites on Object Migration e When you have an Information Domain created in existing 7 2 Infrastructure setup and the same has been deleted post the upgrade the associated tables are retained and the same need to be manually dropped from Atomic User Bug 13639948 1 6 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX 2 Prerequisites Introduction The list of pre configurations required for OFSAAI v7 3 upgrade is stated in this section Ensure the following requirements before upgrade e Guidelines to Unzip Infrastructure Upgrade Kit page 2 1 e Prerequisite Software page 2 2 Guidelines to Unzip Infrastructure Upgrade Kit Once you have downloaded the Infrastructure Upgrade Kit from https support oracle com refer to the following instructions to Unzip the downloaded contents 1 Copy the OFSAAI Upgrade Kit to your server in Binary mode 2 Download the Unzip utility with respect to specific OS from the location https updates oracle com unzips unzips html and transfer it to the UNIX machine in Binary mode where OFSAAI needs to be upgraded 3 Copy the unzip_ lt os gt Z file into the directory that is included in your PATH variable typically HOME path or Directory in which you have copied OFSAAI Upgrad
65. t in lt Tomcat Home gt lib To create data source for Infrastructure application navigate to lt Tomcat Home gt conf and edit the following block of text by replacing the actual values in server xml lt Context path lt context name gt docBase lt Tomcat Installation Directory gt webapps webapps gt debug 0 reloadable true crossContext true Resource auth Container name jdbc FICMASTER type javax sql DataSource driverClassName oracle jdbc driver OracleDriver username lt user id for the configuration schema database gt password lt password for the above user id gt url jdbc oracle thin lt DB engine IP address gt lt DB Port gt lt SID gt maxActive 100 maxIdle 30 maxWait 10000 gt lt Resource auth Container name jdbc INFORMATION DOMAIN NAME gt type jJavax sql DataSource driverClassName oracle jdbc driver OracleDriver username lt user id for the database gt password lt password for the above user id gt url jdbc oracle thin lt DB engine IP address gt lt DB Port gt lt SID gt maxActive 100 maxIdle 30 maxWait 10000 gt lt Context gt 4 24 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX e The Resource tag must be repeated for each Information Domain created e After the above configuration the WAR file has to be created and deployed in Tomcat JDBC Connection Pooling To define the JDBC
66. te Create TOC data sources Delete 206C data sources System Status Health of Running Servers Fated 0 3 Click New and select Generic Data Source option The Create a New JDBC Data Source screen is displayed You can also select GridLink Data Source or Multi Data Source while creating a ata Source For more information refer Create GridLink Data Source page 4 17 or Configure Multi Data Sources page 4 18 Post Upgrade Configurations 4 13 Create a New JDBC Data Source Next Cancel JDBC Data Source Properties The following properties wil be used to identify your new JOBC data source What would you like to name your new JOBC data source eE Name ATOMSTSOL What JNDI name would you like to assign to your new JDBC Data Source amp NOI Name jdbc ATOMSTSOL What database type would you like to select Database Type Oracle Next 4 Enter JDBC data source Name JNDI Name and select the Database type from the drop down list Click Next Ensure the following e The JNDI Name field should be in the format jdbc informationdomain e Same steps needs to be followed to create a mandatory data source pointing to the configuration schema of infrastructure with jdbc FICMASTER as JNDI name JNDI Name is the same as mentioned in web xmlfile of OFSAAI Application e Required Database Type and Database Driver should be selected Create a New JDBC Data Source Back Next Cancel JDBC Data Source Proper
67. ties The following properties will be used to identify your new JOBC data source Database Type Orade What database driver would you like to use to create database connections Note indicates that the driver is explicitly supported by Oracle WebLogic Server Database Driver Oracle s Driver Thin XA for Instance connections Versions 9 0 1 and later v Back Next Cancel 5 Select the Database driver from the drop down list Click Next 6 Select Supports Global Transactions check box and One Phase Commit option 4 14 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Create a New JDBC Data Source Back ess Fish cancnt Transaction Options You have selected non XA JDBC driver to create database connection in your new data source Does this data source support global transactions If yes please choose the transaction protocol for this data source V Supports Global Transactions Select this option if you want to enable non XA JDBC connections from the data source to participate in global transactions using the Logging Last Resource LLR transaction optimization in place of Emulate Two Phase Commit Logging Last Resource Select this option if you want to enable non XA JDBC connections from the data source to emulate particpation in global transactions using JTA Select this option only if your application can tolerate heuristic conditons Emulate Two Phase Commit Sel
68. tings depending on the available hardware configuration Add the memory setting for Java Heap to Xms512m Xmx1024m 4 46 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX Example if z SLOGGING MANAGER then JAVA OPTS JAVA OPTS Xms512m Xmx1024m Djava util logging manager org apache juli ClassLoaderLogManager else JAVA OPTS SJAVA OPTS Xms512m Xmx1024m LOGGING MANAGER fi WebLogic Memory Settings To configure the WebLogic Memory Settings change the memory setting for Java Heap to Xms512m Xmx1024m in setDomainEnv sh file which resides in the folder DOMAIN HOME bin and in CommEnv sh file which resides in the folder common bin You can edit this file for customizing memory settings and garbage collector settings depending on the available hardware configuration Example e if S JAVA VENDOR Sun then WLS MEM ARGS 64BIT Xms512m Xmx1024m export WLS MEM ARGS 64BIT WLS MEM ARGS 32BIT Xms512m Xmx1024m export WLS MEM ARGS 32BIT else WLS MEM ARGS 64BIT Xms512m Xmx1024m export WLS MEM ARGS 64BIT WLS MEM ARGS 32BIT Xms512m Xmx1024m export WLS MEM ARGS 32BIT e JAVA VM MEM_ARGS Xms256m Xmx1024m WebSphere Memory Settings To configure the WebSphere Memory Settings navigate to the following path Websphere applications server gt Application servers gt
69. tions for detailed module specific post installation configurations Configurations for new WebServer Installation This section is applicable for a new WebServer installation When you have installed a new Webserver during the v7 3 OFSAAI upgrade you need to do the following Manually replace the existing WebServer path with the new path in the below listed files e FIC HOME EXEWebService Configured Webserver gt ROOT conf RevLog4jConfig xml e FIC HOME UninstallerData installvariables properties e FIC WEB HOME webroot WEB INF web xml e FIC WEB HOME webroot conf ExportLog4jConfig xml And update the following parameters in the Configuration table of Configuration Schema with the new path e REV IMG PATH e DeFiHome e EMBEDDED JSP JS PATH Note that this parameter will be available only if Forms Framework feature has been enabled Note You may have to refer Configure Infrastructure Ports and Webserver Configuration for Infrastructure Application sections in OFSAAI v7 3 Installation and Configuration Guide for additional details profile Changes This section is applicable for a new Java Oracle ESSBASE installation When you have installed a new version of the above software during the v7 3 OFSAAI upgrade you need to update the profile with the new path 4 42 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX The JAVA BIN ORACLE HOME PATH HYPERION HOME ARBORPATH and E
70. tors SA who are instrumental in upgrading the Infrastructure version and configuring the same to make it operational Getting Started Oracle Financial Services Analytical Applications Infrastructure OFSAAT is a general purpose Analytics Applications infrastructure that provides the tooling platform necessary to rapidly configure and develop analytic applications for the financial services domain It is built with Open Systems Compliant architecture providing interfaces to support business definitions at various levels of granularity Applications are built using OFSAAI by assembling business definitions or business metadata starting from data model to lower grain objects like Dimensions Metrics Security Maps and User Profile to higher order objects like Rules Models and Analytic Query Templates which are assembled using the lower grain ones In addition to application definition tools it provides the entire gamut of services required for Application Management including Security Service Workflow Service Metadata Management Operations Life cycle Management public API s and Web Services that are exposed to extend and enrich the tooling capabilities within the applications OFSAAI provides the framework for building running and managing applications along with out of the box support for various Deployment Models Compliance to Technology standards and supporting a host of OS Middleware Database and Integration with enterprise stan
71. tructure Upgrade Manual UNIX 4 Post Upgrade Configurations Post Upgrade Configurations The Post Upgrade configurations that need to be performed are as indicated below 1 To access the new modules i e Oracle Cubes SOL Rule Object Migration and Data Quality Framework in the LHS menu the following function roles have to be mapped to the respective application user groups e Oracle Cube Administrator to access Oracle Cubes e Object Migration Admin to access Object Migration e SOL Rule Admin to access SOL Rule e ETL Analyst to access Data Quality Framework Note You can refer to Administration gt Security Management gt User Administrator gt UserGroup Role Map section in OFSAAI v7 3 User Manual to know more about mapping required roles to user groups You need to Create Data Source and Connection Pool by configuring the Resource References depending on the WebServer installed to access the new modules i e Oracle Cubes SOL Rule Object Migration and Data Quality Framework For more information refer Configure Resource Reference in WebServers page 4 2 section Data source and connection pool configurations have to be performed for all the Information Domains which are to be used on the above modules This configuration is applicable only for OFSAAI upgrades which use OFSAAI v7 2 ERM Data Quality Framework e Open and edit the data model and add the UDP Data Quality correction rules Post Upgrade Configur
72. ure Upgrade Manual UNIX Java Internet Explorer Java Plug in MS Office Client Machines Erwin Oracle Hyperion Essbase Oracle OLAP IBM AIX Runtime Java Technology JRE JDK 1 6 0 SR7 SR9 64 bit 7 amp 8 1 6 0 18 2003 Windows XP SP3 Windows 7 7 1 7 3 11 1 1 3 0 64 bit NA IBM AIX Runtime Java Technology JRE JDK 1 6 0 SR10 64 bit 8 amp 9 1 6 0_21 2003 2007 Windows XP SP3 Windows 7 7 1 7 3 11 1 2 1 0 64 bit Oracle OLAP v 11 2 0 2 0 Note For Oracle OLAP ensure that you have configured the Oracle Database server with OLAP option Prerequisite Activities e The upgrade process assumes that a working environment is available on which OFSAAI v7 2 10 7 2 11 7 2 12 is already running and required APPS are configured e Itis important to take a backup of the file system Installation folder profile file and ftpshare folder contents on all the tiers Application Web and Database along with the Configuration and Atomic DB users configured in the current OFSAAI v7 2 10 7 2 11 7 2 12 environment e OFSAAI upgrade process requires a total free disc space of 2 5 GB in addition to the size of SFIC HOME directory where OFSAAL is installed For example if FIC HOME size is 2 GB then OFSAAI upgrade process requires about 4 5 GB of free disc space e Incase the HOME and FIC HOME are in different mount ensure that you have Prerequisites 2 5
73. ure the WebSphere for OFSAAI v7 3 follow the below steps 4 26 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX 3 Start WebSphere Profile by navigating to the path Websphere Installation Directory IBM WebSpherel AppServerlprofiles Profile Name bin and execute the command startServer sh server1 Open the following URL in the browser http lt ipaddress gt lt Administrative Console Port gt ibm console https if SSL is enabled The login screen is displayed Integrated Solutions Console Log in to the console User 10 Enter the User ID and Password that has admin rights Click Login The Welcome screen is displayed In the LHS menu select Applications gt Application Types gt WebSphere enterprise applications All the installed applications are listed in the Enterprise Applications section and which facilitates you to manage the installed applications Post Upgrade Configurations 4 27 Enterprise Applications a Enterprise Applications Use this page to manage installed applications A single application can be deployed onto multiple servers Bl Preferences Start Stop Install Uninstall Update Rollout Update Remove File Export Export DDL Export File amp I EET 1 1 Select Name Application Status _ You can administer the following resources o GafaultAcclication p go 2 x g z22273
74. yment to targets in this domain dick the Install button V Customize this table Deployments instan Y Y Showing 110 Lof 1 Previous Next eme 0000 fmm RM Order x F Showing 1to 1of1 Previous Next 4 Delete the previously deployed folder lt context gt ear from lt WEBLOGIC_INSTALL_DIR gt Bea user_projects domains lt DOMAIN_NAME gt applicati ons 5 Create lt context gt ear folder under applications folder 6 Copy the lt context gt ear file from FIC HOME ficweb to lt WEBLOGIC_INSTALL_DIR gt Bea user_projects domains lt DOMAIN_NAME gt applicati ons lt context_name gt ear folder 7 Select the checkbox adjacent to the deployment name you want to update 8 Click Update The Update Application Assistant screen is displayed Update Application Assistant Next Finish Cancel Locate new deployment files You have elected to update the upg7273 application Source path foradate2 wl 1035 Orade Middleware user_projects domains jupg7273 epplications upg7273 esr Change Path is otiia plan No value specified Change Path path Next Faan Cancel Verify the provided Source path and click Next The Update Application Assistant screen displays the defined options Once done click Finish The Summary of Deployments screen is displayed with state as Active 4 36 Oracle Financial Services Analytical Applications Infrastructure Upgrade Manual UNIX To Stop the WebLogic deployment services

Oracle® Financial Services Analytical Applications Infrastructure

Contents

Download Pdf Manuals

Related Search

Related Contents

Oracle&reg; Financial Services Analytical Applications Infrastructure

Contents

Download Pdf Manuals

Related Search

Related Contents

Oracle® Financial Services Analytical Applications Infrastructure