Home

Oracle® Financial Services Analytical Applications Infrastructure

1. Aged timeout o seconds Purge policy EntirePool v ok Reset Cancel 2 Setthe values for Connection timeout to 0 seconds Maximum connections to 100 connections and Minimum connections to 10 connections as shown in the following figure You can also define Reap Time Unused Timeout and Aged Timeout as required 5 1 3 Configure Resource Reference in Weblogic Application Server This section is applicable only when the Web Application Server type is WebLogic In Weblogic you can create Data Source in the following ways a For a normal Database instance Generic Data Source can be created See Create Data Source a When Database is RAC configured Gridlink Data Source has to be created See Create GridLink Data Source When Load Balancing Fail over is required Multi Data Source has to be created See Configure Multi Data Sources 5 10 OFSAA Infrastructure Installation and Configuration Guide Configuring Resource Reference 5 1 3 1 Create Data Source The steps given below are applicable for both config and atomic data source creation 1 Open the following URL in the browser window http lt ipaddress gt lt administrative console port gt console https if SSL is enabled The Welcome window is displayed 2 Login with the Administrator Username and Password Figure 5 13 Welcome ORACLE WebLogic Server 11g Administration Console Welcome Log to work with the Weblog Server dom
2. OPERATION CODE SCODE NAME NAME SOAPACTION SOAPACTION STYLE SSTYLE PACKAGENAME S PACKAGENAME lt INPUT ORDER SORDER B 28 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations PARAMNAME SPARAMNAME ARGTYPE SARGTYPI qn CLASSNAME CLASSNAME gt lt OUTPUT PARAMNAME SPARAMNAME RETURNTYPE SRETURNTYPE EL CLASSNAME SCLASSNAME gt lt OPERATION gt lt WEBSERVICE gt lt WEBSERVICES gt XML The DynamicWSConfig xml has the placeholders as tabulated below These have to be updated depending on the web service chosen and the mode of accessing it For each Web service to be accessed the entire webservice tag in the DynamicWSConfig xml file must be repeated The placeholders tabulated below should be set in accordance to the parameters published in the third party wsdl files webservices to be accessed The stub class specified must implement the com iflex Oracle Reveleus execution webservice EXEWebIF interface Attributes for WEBSERVICE tag Table B 11 WEBSERVICE tag Placeholder Description CODE Unique number within the xml file and cannot be 999 or 0 SENDPOINT soap address location in the wsdl service name tag of the wsdl
3. sess eene nennen nnne nennen ranas 5 1 5 1 1 Configure Resource Reference in Infrastructure Web Application 5 1 5 1 1 1 Configure web xml er USER enne eie entente rei e en 5 1 5 1 2 Configure Resource Reference in WebSphere Application Server 5 2 5 1 2 1 Create JDBC Provider eb e boe ERE ERE DIR aiiis 5 2 5 1 2 2 Create Data Source sion as 5 5 5 1 2 3 J2C Authentication Detallada di 5 8 5 1 2 4 JDBC Connection Pooling sse eene nnns 5 10 5 1 8 Configure Resource Reference in Weblogic Application Server ccoo 5 10 5 1 3 1 Create Data SOUPCE iii a odds dee Te E Ee eere aet enne 5 11 5 1 3 2 Create GridLink Data Source eerte nennen nenne 5 15 5 1 3 3 Configure Multi Data Sources chatten tere cas 5 16 5 1 3 4 Advanced Settings for Data Source sss eee nene 5 19 5 1 3 5 JDBC Connection Pooling iisisti iritisa eene enne 5 19 5 1 4 Configure Resource Reference in Tomcat Application Server sss 5 20 5 1 4 1 Create Data Source e eee Te pr ab 5 20 5 1 4 2 JDBC Connection Pooling 5 eee n ete e edente 5 21 5 2 Configuring Web Application Servers sse ee eene enne 5 22 5 2 1 Configuring IBM WebSphere Application Server ssssssssseeeeeeee 5 22 5 2 1 1 Create WebSphere EAR File sss enne 5 22 5 2 1 2 Deploy WebSphere EAR Files sse nnne 5 22 5 2 1 3 WebSphere HTTPS Configura
4. Uninstalling WAR Files in Tomcat 8 1 Uninstalling OFSAA Infrastructure This section will guide you through the necessary steps to uninstall the OFSAA Infrastructure product Before you start the uninstallation process ensure that no open connections exist to the OFSAA Infrastructure Config and Atomic Schemas and Infrastructure services are brought down To uninstall OFSAA Infrastructure 1 Login to the system as non root user 2 Navigate to the FIC_HOME directory and execute the command Uninstall sh 3 Enter the password for OFSAAI Configuration Schema when prompted as shown in the following figure Figure 8 1 Uninstalling OFSAA Infrastructure scratch ofsaadb OFSAAI gt Uninstall sh Uninstallation Started time Tue Jun 10 14 20 27 IST 2014 1 RR RR RR RR RR RRR ORR ROR RR RR Driver loaded with Driver oracle jdbc driver OracleDriver Please enter Configuration schema Password Connected to Config Schema Cleaning config schema config schema cleaned Cleaning up Infrastructure Home Dir Please wait Uninstallation Completed Thank You time Tue Jun 10 14 21 59 IST 2014 1 RR RR RR RR RR RR RR RR RRR RAR RR RR RR RR RR scratch ofsaadb OFSAAI gt A Note the following a Uninstallation does not remove the Infrastructure application from the Web Application Server This has to be done manually Uninstalling OFSAA Infrastructure 8 1 Uninstalling EAR Files in WebSphere a The
5. Database Settings Database Instance Settings NLS CHARACTERSET to be AL32UTF8 a NLS LENGTH SEMANTICS to be CHAR a OPEN CURSORS limit to be greater than 1000 Minimum 500MB quota on DEFAULT TABLESPACE for CONFIG user Database User Schema One DB User identified for holding configuration and metadata repository Usually referred to as CONFIG user schema Optionally two DB Users identified for holding the Sample App data model data referred as ATOMIC user schema and Sandbox schema if you decide to install the Sample App Note The required privileges need to be granted to these DB schemas by executing privileges atomic user sql and privileges config user sql files appropriately present inside the OFSAAI 73300 OS folder Web Server WebSphere WebLogic WebSphere profile or WebLogic domain should have been created You will be prompted to enter the WebSphere installation path or WebLogic domain home directory during OFSAAI installation For more information see Creation of New Profile in WebSphere and Creating Domain in WebLogic Server sections 3 2 Obtaining the software This release of OFSAA Infrastructure v7 3 3 0 0 can be downloaded from the Oracle Software Delivery Cloud https edelivery oracle com You need to have a valid Oracle account in order to download the software 3 3 Common Installation Tasks 3 3 1 Identifying the Installation Directory This would
6. O Base this domain on an existing template eose Appendix Webserver Configuration for Infrastructure Application B 5 Webserver Configuration for Infrastructure Application 3 Select the Generate a domain configured automatically to support the following products option and click Next The Specify Domain Name and Location window is displayed Figure 8 11 Specify Domain Name and Location E Fusion Middleware Configuration Wizard x Specify Domain Name and Location ORACLE Enter the name and location for the domain Domainname MockSol Domain location weblogic webl1013 bealuser_projectsidomains Browse 4 Enter the Domain Name and Location Click Browse to navigate and specify the location Click Next The Configure Administrator Username and Password window is displayed Figure 8 12 Configure Administrator Username and Password F Fusion Middleware Configuration Wizard Configure Administrator User Name and Password This user is the defaut administrator bs ra 5 Enter the User name and User password to be assigned to the Administrator Ensure that the password is of minimum 8 characters in length 6 Re enter the password for confirmation and add a brief Description Click Next The Configure Server Start Mode and JDK window is displayed B 6 OFSAA Infrastructure Installation and Configuration Guide Webserver Configuration for Infrastructure
7. See the Table 3 1 Prerequisite Information section in this document Installation of OFSAAI was completed successfully What next Post the successful completion of OFSAAI installation one has to perform the Post Installation steps See Chapter 5 Post Installation Configuration What is to be done when OFSAAI Installation is unsuccessful OFSAAL installer generates log file OFSAAInfrastructure Install login the Infrastructure Installation Directory There is also another log file created in the path configured in Log47 xm1 The logs of any of these reported Warnings Non Fatal Errors Fatal Errors Exceptions should be brought to the notice of the OFSAAI Customer Support It is recommended not to proceed until the reported problems are adequately addressed How do I completely uninstall OFSAAI OFSAAI can be completely uninstalled by performing the steps provided in Chapter 8 Uninstalling OFSAA Infrastructure How to grant privileges if a new information domain is created If you are creating a new information domain provide a set of privileges database permissions to the new Atomic schema 2 Log into the database as sys and connect as sysdba user 2 Execute the file privileges config user sql available under FIC HOME directory 2 Enter the database schema for which you want to grant privileges When should I run the MLS utility See the Multiple Language Support MLS Utility section in OFSAAI Administrati
8. What happens when the OFSAAI Application Server does not proceed even after providing the system password Ensure that the System Password provided when prompted should match with the Oracle Configuration password provided during installation Also check whether the connection to the configuration schema can be established through sqlplus Although the OFSAAI installation has completed successfully when OFSAAI servers are started and the application URL is accessed it gives an error message the page cannot be found or displayed or Could not retrieve list of languages from Server Please contact the system administrator What should one do Ensure OFSAAI servers have been started and are running successfully On the server start up parameters options see Starting Infrastructure section For more details on the issue refer on to the Revappserver log in FIC APP HOME common FICServer logs directory or the Web Server log files Is it necessary to provide the specified grants to the Oracle schema user before installation If yes can it be revoked after completion of installation The Oracle schema user requires the necessary grants specified before during and after the installation process Grants provided should never be revoked as the application makes use of these grants all the time Can we have distributed OFSAAI Application Server for load balancing OFSAAI Application server can be scaled out distributed ac
9. B 2 19 1 Configure DynamicWSConfig xml File For each third party web service that needs to be accessed using the OFSAAI Web services framework and the operations to be invoked corresponding entries are to be made in the DynamicWSConfig xml template file The variable WebServer denotes any one of the application server that is WebSphere WebLogic or Tomcat The DynamicWSConfig xml file will be available in the lt OFSAAI Installation Directory EXEWebService WebServer ROOT conf directory This file can be placed in any directory that is accessible by the application and this location must be specified in the web xml file as WSCONFIGFILE parameter The DynamicWSConfig xml template file will be in WebServer Deployment Path EXEWebService ear EXEWebService war conf directory This template is given below XML lt WEBSERVICES gt lt WEBSERVICE CODE CODE ENDPOINT SENDPOINT TARGETNAMESPACE STARGETNAMESPACE XMLNS_XSD SXMLNS_XSD E NCODINGSTYLE SENCODINGSTYLE wn ERVICENAME SSERVICENAME PORTTYP ies NAME SPORTTYPENAME SESSION MAINTAIN PROPERTY SSESSION MAINTAIN PROPERTY USERNAME SUSERNAME PASSWORD SPASSWORD STYLE SWEBSERVICESTYLE STUBIMPLEMENTATION SSTUBIMPLEMENTATION gt E
10. Configuring Web Application Servers Figure 5 31 Preparing for the application installation Preparing for the application installation Specify the EAR WAR JAR or SAR module to upload and install Path to the new application Local file system Full path O Remote file system Next Cancel 6 Select Remote File System and click Browse Select the EAR file generated for OFSAAI to upload and install Click Next Figure 5 32 Installation Options Preparing for the application installation How do you want to install the application Fast Path Prompt only vhen additional information is required O Detailed Show all installation options and parameters B Choose to generate default bindings and mappings Previous Next Cancel 7 Select the Fast Path option and click Next The Install New Application window is displayed 5 24 OFSAA Infrastructure Installation and Configuration Guide Configuring Web Application Servers Figure 5 33 Install New Application Install New Application Specify options for installing enterprise applications and modules Specify the various options that are available to prepare and install your application o Precompile JavaServer Pages files Directory to install application a Distribute application O Use Binary Configuration Y Deploy enterprise beans lication name upgs73 V Create MBeans for resources O Override class rel
11. The Enterprise Applications screen is displayed Figure 8 8 Enterprise Applications Enterprise Applications Enterprise Applications Use this page to manage installed applications A single application can be deployed onto multiple servers E Preferences Start Stop Install Uninstall Update Rollout Update Remove File Export Export DOL Export File Select Name Application Status 9 You can administer the following resources Psfaultapolication o imape O query gt o seam gt Total 4 This Enterprise Applications screen helps you to 2 Install new application 2 Uninstall existing applications Appendix Webserver Configuration for Infrastructure Application B 3 Webserver Configuration for Infrastructure Application 2 Start or Stop the installed applications B 1 1 3 Delete WebSphere Profiles To delete a WebSphere profile do the following 1 2 3 Select the checkbox adjacent to the required application and click Stop Stop the WebSphere profile to be deleted Navigate to WebSphere directory lt WebSphere_Installation_Directory gt AppServer bin Execute the command manageprofiles sh delete profileName lt profile_name gt Delete profile folder Example lt WebSphere_Installation_ Directory gt AppServer profiles lt profile_name gt Execute the command manageprofiles sh validateAndUpdateRegistry B 1 2 Configurating WebLogic for Infrastructure Applicat
12. 9 Install Complete OFSAAI Server IP Hostname Database Server IP Hostname ORACLE FINANCIAL SERVICES InstallAn re ME NETSUNN 10 Enter the IP address or hostname of the OFSA Al server and Database server 11 Click Next The Web Application Server window is displayed Figure 4 12 Web Application Server Web Application Server License Choose the Web Application Server type Prelnstall Setup Installation Install Complete O Tomcat WebSphere O Weblogic ORACLE FINANCIAL SERVICES InstallAnywhere 12 Select the appropriate Web Application server type The options are Tomcat WebSphere and WebLogic 13 Click Next Based on the selection corresponding screens are displayed For WebSphere The WebSphere Setup Details window is displayed 4 10 OFSAA Infrastructure Installation and Configuration Guide GUI Mode Installation Figure 4 13 WebSphere Setup Details WebSphere Setup Details License Enter WebSphere installation Path up to the Host name directory Prelnstall Setup For Ex data2 test WebSphere AppServer profiles Profile Na Installation me installedApps cellName gt 9 Install Complete scratch was IBM WebSphere AppServer profiles Profsa73 3 ORACLE FINANCIAL SERVICES InstallAn a Enter the installation path up to the host name directory of the WebSphere The format is WebSphere path lt WebSphere profile directory gt installedAp
13. For example InteractionVariable name FILE TRANSFER PORT gt 21 lt InteractionVariable gt Yes LOCALE Identifies the locale information to be used during the installation This release of the OFSAA Infrastructure supports only US English For example lt InteractionVariable name LOCALE gt en_US lt InteractionVariable gt Yes A 4 OFSAA Infrastructure Installation and Configuration Guide OFSAAI InstallConfig xml and OFSAAI_PostinstallConfig xml Parameters Table A 2 Cont OFSAA Infrastructure Installation Tasks and Descriptions InteractionVariable Name Significance and Expected Value Mandatory Layer name OFSAAI APP LAYER POST INSTALL Identifies if the Post Install Configuration Yes required for the OFSAA Infrastructure installation needs to be completed by the installer The default value specified is 0 The below numeric value should be set depending on the choice 2 YES 1 NO 0 For example InteractionVariable name POST INSTALL gt 1 lt InteractionVariable gt Note 1 If you have specified the value as 1 refer OFSAAI PostInstallConfig xml for information on configuring the parameters 2 If you have specified the value as 0 see Chapter 5 Post Installation Configuration INSTALL SAMPLEAPP Identifies if the Sample Application packaged Yes with this release of the OFSAA Infrastructure should be installed The default value specified is 0 Th
14. Once you have logged into the Infrastructure system you need to perform the following additional configurations to setup the OFSAAI environment DefineServer Details for Database Application and Web servers For information see System Configuration Server Details section in OFSAAI 7 3 3 0 0 User Manual listed in the Related Documents section Add Database Details For information see System Configuration gt Database Details section in OFSAAI 7 3 3 0 0 User Manual listed in the Related Documents section Start Stop Infrastructure Services 6 3 Stopping Infrastructure Create an Information Domain For information see System Configuration gt Information Domain section in OFSAAI 7 3 3 0 0 User Manual listed in the Related Documents section Create a Segment For information see Administration gt Security Management gt System Administrator gt Segment Maintenance section in OFSAAI 7 3 3 0 0 User Manual listed in the Related Documents section Create Add User with access to all permissions For information see Administration gt Security Management gt User Administrator section in OFSAAI 7 3 3 0 0 User Manual listed in the Related Documents section Note Each new file that is created in the ftpshare folder of any installation layer should be granted specific explicit permission If you encounter any problems during setup please contact Infrastructure Support 6 2 Stopping
15. a Installation Overview Hardware and Software Requirements and Specifications a Verifying the System Environment Understanding Installation Modes xiii xiv Chapter 3 Preparing for Installation Installer and Installation Prerequisites a Obtaining the software Common Installation Tasks Part II Installation and Configuration Chapter 4 Installing OFSAA Infrastructure v 7 3 3 0 0 Silent Mode Installation GUI Mode Installation Chapter 5 Post Installation Configuration Configuring Resource Reference Configuring Web Application Servers Chapter 6 Start Stop Infrastructure Services Starting Infrastructure Stopping Infrastructure Chapter 7 Verifying the Installation Chapter 8 Uninstalling OFSAA Infrastructure Uninstalling OFSAA Infrastructure Uninstalling EAR Files in WebSphere Uninstalling EAR Files in WebLogic Uninstalling WAR Files in Tomcat Part I Introduction and Preparation Part I introduces OFSAAI version 7 3 3 0 0 installation and describes how to perform preparatory and common installation tasks Part I contains the following chapters Chapter 1 Understanding OFSAA Infrastructure Chapter 2 Understanding OFSAA Infrastructure Installation Chapter 3 Preparing for Installation 1 Understanding OFSAA Infrastructure This chapter provides a brief overview of OFSAA Infrastructure version 7 3 3 0 0 This chapter includes the following
16. Ba Ne Cancel Select Targets You can select one or more targets to depioy your new 208 Multi Data Source Back Next ance 6 Select the AdminServer check box and click Next Figure 5 26 Select Data Source Type Create a New JDBC Multi Data Source Back Next Cance Select Data Source Type Please select type XA or Non XA of data source you would lke to add to your new JOSC Mult Data Source O XA Driver Non XA Driver Back Next Cancel 7 Select the type of data source which will be added to new JDBC Multi Data Source Click Next Figure 5 27 Add Data Sources Create a New JD8C Multi Data Source Data Sources Available Choser Create a New Data Source Back Fish Cancel 8 Map the required Data Source from the Available Data Sources Click Finish The New JDBC Multi Data Source is created with added data sources 5 18 OFSAA Infrastructure Installation and Configuration Guide Configuring Resource Reference 5 1 3 4 Advanced Settings for Data Source 1 Click the new Data Source fromt the Summary of JDBC Data Sources window The Settings for Data Source Name window is displayed 2 Select the Connection Pooling tab given under Configuration 3 Goto 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 For e
17. J2C J2EE Connector J2EE Java 2 Enterprise Edition JDBC Java Database Connectivity JDK Java Development Kit JNDI Java Naming and Directory Interface JRE Java Runtime Environment Convention Meaning JVM LDAP LHS MOS OFSAAI OLAP OS RDMS SFTP SID SSL URL VM Web Archive XML Java Virtual Machine Lightweight Directory Access Protocol Left Hand Side My Oracle Support Oracle Financial Services Analytical Application Infrastructure On Line Analytical Processing Operating System Random Access Memory Relational Database Management System Secure File Transfer Protocol System Identifier Secure Sockets Layer Transparent Network Substrate Uniform Resource Locator Virtual Machine WAR Extensible Markup Language Organization of the Guide Every manual or guide of the OFSAA Infrastructure has specific purpose built content The specific purpose of this guide is to explain how to 1 Install Single Instance of OFSAA Infrastructure components 2 Verify the installation was successful 3 Getting started with the OFSAA Infrastructure Keeping in mind the above purpose this Installation guide is organized in below parts Part I Introduction and Preparation Chapter 1 Understanding OFSAA Infrastructure a What is OFSAA a What is OFSAA Infrastructure a OFSAA Infrastructure Components a OFSAA Infrastructure High Availability Chapter 2 Understanding OFSAA Infrastructure Installation
18. 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 and has to be incremented considering the deployment metrics into account The increments are usually handled in multiples of 128mb for heap and 64mb for stack B 2 7 1 Infrastructure Application Server Memory Settings You can configure the Infrastructure Application Memory settings as follows Appendix Webserver Configuration for Infrastructure Application B 15 Additional Configurations Locate profile file 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 SDELIM Xmx2048m Note This parameter is modified in 7 3 2 IR and you need to modify X ARGS APP variable in the profile file to customize Java Memory Settings for Model Upload based on the Data Model size B 2 7 2 Tomcat Memory Settings To configure the Tomcat Memory Settings 1 Locate the file catalina sh which resides in the folder CATALINA HOME bin 2 Edit this file for customizing the memory settings and garbage collector settings depending on the available hardware configuration 3 Add the memory setting for Java Heap to Xms512m Xmx1024m Example if z S LOGGING MANAGER then J
19. for the application installation Note This block of text must be repeated for any new Information Domains created Also the sample bundled with web xml has ORDEMO entered in the lt INFODOM NAME gt tag This needs to be replaced with the Information Domain created for the application installation 5 1 2 Configure Resource Reference in WebSphere Application Server This section is applicable only when the Web Application Server type is WebSphere 5 1 2 1 Create JDBC Provider 1 Open this URL in the browser window http ipaddress administrative console port ibm console https if SSL is enabled The Login window is displayed 2 Login with the user id that has admin rights 3 Expand the Resources option in the LHS menu and click JDBC JDBC Providers The JDBC Providers window is displayed Figure 5 1 JDBC Providers JDBC providers JDBC providers gt Use this page to edit properties of a JDBC provider The JDEC provider object encapsulates the specific JOBC driver implementation class for access to the specific vendor database of your environment 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 Zone2NodeOSCell Node GXS1ISOREV Zone2Node05 Server serverl Scope specifies the level at which the resource definition is visible For detailed information on what sco
20. sub elements Under no circumstances should any of these be removed or tampered The different layers and its significance are mentioned in Table Table A 1 OFSAA Infrastructure Installation Tasks and Descriptions Layer Name Significance GENERAL This layer contains Interaction Groups that capture general installation details such as the installation directory the system IP hostname the database details and so on OFSAAI APP LAYER This layer contains the Interaction Groups that capture information on post installation configuration and sample app installation OFSAAI DB LAYER This layer contains the Interaction Group that captures information on the ports that need to be enabled for the various internal OFSAA Infrastructure services that run on the system Appendix OFSAAI InstallConfig xml A 1 OFSAAI InstallConfig xml and OFSAAI PostlnstallConfig xml Parameters Table A 1 Cont OFSAA Infrastructure Installation Tasks and Descriptions Layer Name Significance OFSAAI WEB LAYER This layer contains the Interaction Groups that capture the Web Server and Web Application Server details You need to manually set the InteractionVariable parameter values as mentioned in Table If a value is not applicable enter NA and ensure that the value is not entered as NULL Table A 2 OFSAA Infrastructure Installation Tasks and Descriptions InteractionVariable Name Significance and Ex
21. 1 Starting Infrastructure the command prompt without having to wait till the process completes However this command cannot be used when you are starting the server for the first time or starting after changing user password in the configuration database schema 2 Select the required webserver start up option from the table below Table 6 1 Webserver start up options Start up Option Description Starting WebSphere profile On the machine in which Web sphere is installed navigate to Webshpere Install Directory AppServer lt profiles gt lt profile name gt bin and execute the command startServer sh serverl Starting WebLogic Domain On the machine in which WebLogic is installed navigate to WebLogic Installation directory gt user_ projects domains domain name bin and execute the command startWebLogic sh d64 Note If WebLogic is already running access the WebLogic Admin Console Stop and start the application context name gt ear Starting Tomcat On the machine in which Tomcat is installed navigate to Application lt Tomcat_Install_ Directory gt bin and execute the command catalina sh run 3 Start ICC server a Onthe machine in which Infrastructure default Application components have been installed navigate to FIC_HOME ficapp icc bin and execute the command iccserver sh Note Only Infrastructure Default Application Server would hold ICC component
22. 1 Configuring jaxrpc jar Copy the jaxrpc jar from the OFSAA nstallation Directory gt axis 1_4 webapps axis WEB INF 1ib and place it in under Tomcat Installation Directory gt lib 5 2 3 2 Tomcat User Administration The Tomcat administration and manager application does not provide a default login You are required to edit SCATALINA HOME conf tomcat users xml as instructed below This file contains an XML user for each individual user which will display the username and password used by admin to log on to Tomcat and the role names to which the admin user is associated with For example user name admin password admin roles standard manager gt 1 Add the manager role to any one of the existing username password combination as shown in the example above 2 Usethe same username password to which the manager role has been assigned to access the Tomcat Application Manager 3 If the Tomcat server is already running it requires a re start after the above configuration is done 5 2 3 3 Configure Tomcat to use JAVA 64 bit Executables 1 Navigate to the SCATALINA_HOME bin folder 2 Edit the setclasspath sh as explained below 3 Under Set standard commands for invoking Java change JAVA HOME bin to SUAVA BIN Example Edit the following block of text Set standard commands for invoking Java RUNJAVA SJAVA HOME bin java if os400 true t
23. Application Figure 8 13 Configure Server Start Mode and JDK F Fusion Middleware Configuration Wizard Configure Server Start Mode and JDK ORACLE Before putting your domain into production make sure that the production environment is secure For more information see the topic Securing a Production Environment in the WebLogic Server documentation To use WebLogic JRockit in production Oracle recommends developing and testing your applications with WebLogic JRockit early in the project cycle For information about WebLogic Rockt see the WebLogic Rockt documentation WebLogic Domain Startup Mode Development Mode Utilize boot properties for username and password and poll for applications ta deploy Sun JDK recommended for better startup performance during iterative development O Production Mode Require the entry of a username and password and do not poll for applications to deploy Other WebLogic Rockt JDK recommended for better o QUE runtime performance and management Location se Ea te Previous Next 7 Select the following options In the WebLogic Domain Startup Mode section select the required mode Development Mode or Production Mode In the JDK Selection section select Other JDK Click Browse and navigate to the JDK location Click Next The Select Optional Configuration window is displayed Appendix Webserver Configuration for Infrastructure Application
24. Application Level Users can perform an operation only if mapped to appropriate role and functions Does OFSAAI have the ability to enforce periodic password change OFSAAI provides configurable parameters to define number of days after which the user password would expire and then the user is forced to change the password after expiration period What is the password policy followed in OFSAAI OFSAAI enforces a minimum password length with a combination of Upper and Lower case characters and alpha numeric strings Which version of Erwin Data Modeller does OFSAAI support OFSAAI now supports ERwin version 9 2 and 9 5 generated xmls in addition to ERwin 4 1 ERwin 7 1 ERwin 7 3 and ERwin 9 0 formats Does OFSAAI provide the mechanism to upload Business Data model OFSAAI provides two mechanisms for business data model upload 2 Easy to use GUI based Model upload mechanism to upload the Business Data Model through Unified Metadata Manager gt Import Model 2 OFSAAI also provides a model upload utility upload sh for uploading the business data model through the command line parameter by executing this shell script file under the path FIC HOME ficapp common FICServer bin See Run the Model Upload Utility section for details The Business Data model undergoes changes how does this incremental change get applied to the existing model Modified data model can be uploaded into the system and OFSAAI has the ability to compar
25. Configure the Administration Server sse eee nennen B 8 Configure Server Start Mode and JDK esses B 9 Configure Server Start Mode and JDK o ococonococinconononononnrnnnnecnnnonrnnarorannnnncnnnnnrnnrararanannnnnraros B 10 OFSAAT Lovin DIdOU x ite ad eer E etre erre ee een B 18 Internet ODIO usse tette tierce te er e ete e Cep obstet eee diet ree Abs B 19 OFSAA Infrastructure Port Changer eese eee nennen B 22 Select Source amp Destination for Migration B 27 Select Entities to Migrates 5 5 eed eene nete m ee reete eret TEE B 27 Error DICO a cote eroe E Eileen LR Pe E PER cau Stade Enea ea eem d odds D 14 List of Tables 2 1 2 2 2 3 3 1 4 1 4 2 OFSAA Infrastructure Installation Tasks and Descriptions esses 2 2 Configurations Supported ette at e nite dare tied rage cett da ge roe EE ERA aee og ode 2 2 Recommended Software Combinations ccccccccsscescessesscesseescesceeeecsceseesaecssesaecaecaseeseseeesees 2 4 Prerequisite Information it a A nene n dt ad AAA 3 2 Silent Mode Installation 1 coocncoccnocnnoncconnconnnonanonnnonnonnnnonnnnonnnonnnc cano ronnnonn non nn non nn errare rn ettet te nen 4 2 dina Sous Pals A e o e e la cos 4 3 Teo M no 4 3 Webserver start Up Optom ciaci n citada ere Terre hehehe nee rie i es 6 2 OFSAA Infrastructure Installation Tasks and Descriptions A 1 OFSAA Infrastructure Installation Tasks and Descriptions A 2 L
26. Domain at least one database details would need to exist The message ConnectToDatabase FatalError could not connect to the DB server appears during startup of backend engine message server What does one need to do Verify whether connection to the configuration schema can be established through sqlplus 2 Verify configuration schema password is modified post installation 2 Ensure oracle database alias name created for oracle instance and oracle service name are same 2 Onamwulti tier Installation mode ensure TNSNAME and SID are the same in both the Application and Database Layers The message Fatal Error failed to get user ID from LibSmsConnect appears during the startup of backend engine message server What has to be done Ensure Reveleus sec file exist under the FIC_HOME conf directory where the Database components are installed Does OFSAAI Application support LDAP authentication OFSAAI supports LDAP configuration and authentication Does OFSAAI support multiple languages Yes OFSAAI supports multiple languages Appendix Frequently Asked Questions D 9 Frequently Asked Questions Does OFSAAI provide any data back up features OFSAAI does not have built in back up facility External Storage Infrastructure is recommended for back up What kind of security features does the OFSAAI provides OFSAAI provides security at 2 Segment Level Users can access only the segment they are mapped to 2
27. Domains Table B 4 Members Reverse population Value Code Example Members Reverse MEMBER REVERSE MEMBER REVERSE population VALUE Y N POP 8INFODOMS DIME POP ORAFUSION 1 Y NSION_ID VALUES B 2 4 4 Configure Hierarchy Reverse Population This property should be set for reverse population of Hierarchies for the Dimensions in required Information Domains Table B 5 Hierarchy Reverse population Value Code Example Hierarchy Reverse HIERARCHY REVERSE HIERARCHY REVERSE population VALUE Y N POP INFODOM DIME POP ORAFUSION 1 Y NSION_ID VALUES B 2 4 5 Configure Maximum Levels allowed in Hierarchies This property is required to set the maximum levels allowed to build the Hierarchies tree structure Table B 6 Hierarchy Maximum level allowed Value Code Example Hierarchy Maximum level MAX_ MAX_DEPTH FUSION 15 allowed for the hierarchy in DEPTH INFODOM VA particular Information LUE Domain VALUE Integer number B 14 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations The Maximum Levels allowed in the hierarchies is less than or equal to 15 If the Hierarchy Reverse population is set as Y and more than 15 levels are created Then an alert is displayed as The number of levels exceeding the limit If the maximum level allowed is set as more than 15 and hierarchy reverse population
28. ID To get authenticated by proxy server gt lt context param gt lt context param gt lt description gt http proxy Password lt description gt lt param name gt http proxyPassword lt param name gt lt param value gt PROXYPASSWORD lt param value gt lt User Password To get authenticated by proxy server gt lt context param gt context param description http non ProxyHosts lt description gt lt param name gt http nonProxyHosts lt param name gt param value NONPROXYHOST param value Appendix Webserver Configuration for Infrastructure Application B 31 Additional Configurations lt Hosts for which the proxy settings should get by passed Note Separate them by symbol gt lt context param gt OFSAAI Home Entry This entry should point to the Application layer Web layer of the OFSAAI installation and should be accessible Replace FIC HOMES in the following block of text in web xml with lt WebServer Deployment Path gt EXEWebService ear EXEWebService war lt context param gt lt description gt OFSAAI Web Home lt description gt lt param name gt FIC_HOME lt param name gt lt param value gt FIC_HOME lt param value gt 1 OFSAAI Installation Folder gt context param context param lt description gt OFSAAI Web Home lt description gt param name FIC PHYSICAL HOME param name param value FIC HOMES param value 1 OFSAAI In
29. If you have installed more than one category of components on the current machine the corresponding checkboxes for the respective components you have installed will be enabled To edit the port value enter the new port value User has the option to change the required ports and leave the other ports unchanged Only the ports for which values are modified will change and the ports that are unchanged will retain its default value Note All ports on a machine must be unique The range of port numbers that are given should preferably be between 1025 and 65535 The Servlet port can have 80 or 443 as port numbers if Default HTTP HTTPS ports are being used 2 Select the Database Type as Oracle from the drop down list 2 The IP Host Address of the machine on which the corresponding database is installed will be populated 2 The Port Number on which the database is listening is displayed B 22 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations The SID details are displayed 2 The Configuration Schema username is displayed Enter the Configuration schema password 2 Click Change to initiate the port changes To execute PortC jar in CMD mode 1 Navigate to the path FIC HOME 2 Enter the command java jar PortC jar CMD Then enter the requested information to change the ports Once the port numbers are changed in the Infrastructure configuration a message will be displayed confirming
30. Installation Configuration Infrastructure Verify Installation See Verifying the Installation 2 2 Hardware and Software Requirements and Specifications This section describes the various Operating System Database Web Server and Web Application Server version and other variant details on which this release of the OFSAA Infrastructure has been qualified Note OFSAAI installation can be performed on both Virtual and Physical servers OFSAA Infrastructure components are qualified on the hardware and software variants given in Table 2 2 Other generic software specific version and variant details are also mentioned in the table Table 2 2 Configurations Supported Operating System Oracle Linux Red Hat OracleLinux Server release 5 3 up to 5 10 64 bit Enterprise Linux Oracle Linux Server release 6 0 and above 64 bit Note Same versions of RHEL is supported Linux6is not supported for 6 x versions of EPM applications That is for the 6 x versions of ALM FTP PFT PM TPC and HM IFRS Oracle Solaris Oracle Solaris v5 10 Update 9 9 10 s10s u9wos 14a SPARC sun4v 64 bit Oracle Solaris v5 11 IBM AIX a AIX 5 3 ML 127 64 bit AIX 6 1 ML 07 64 bit Java Runtime Environment Oracle Linux Red Hat Oracle Java Runtime Environment JRE 1 6 0 25 64 bit Enterprise Linux Oracle Solaris 2 2 OFSAA Infrastructure Installation and Configurati
31. LDAP or vice versa Figure 8 21 Select Source amp Destination for Migration Select Source amp Destination for Migration LDAP To SMS SMS To LDAP Ok Close 2 Select the SMS to LDAP option and click OK The Select Entities to Migrate window is displayed Figure 8 22 Select Entities to Migrate Select Entities To Migrate y User y User Group Function Role Segment Profile Holiday Function Role Map User User Group Map User Group Role Map User Group Domain Map Migrate Close You can select the data that you wish to migrate such as Users User Groups Functions Roles Segment Profiles Holiday Master Function Role Maps User User Group Maps User Group Role Map and User Group Domain Map Appendix Webserver Configuration for Infrastructure Application B 27 Additional Configurations 3 Select the entities that you wish to migrate and click Migrate The data is migrated and a confirmation dialog is displayed You can verify the data migrated to LDAP server through the LDAP Browser Note You should also enter the passwords for all the users as passwords are not migrated in migration process B 2 19 Configure OFSAAI Web Services Web Services in OFSAAI is meant for exposing a web service to asynchronously or synchronously execute requested tasks offered by OFSAAI The configuration steps given below are to be done only if you are using the Web Services feature of OFSAAI
32. None specified OFSAA Web Application true Context Path required upgs73 XML Configuration file URL WAR or Directory URL oradatat appins appweb ficweb upgs73 war Select WAR file to upload Browse jJ Ospioy Find leaks This diagnostic check will tngger a full garbage collection Use with extreme caution on production systems Apache Tomcat 0 19 160 2506 Sun M crosystems Inc Linux 26 18 194 elSxen amass ICLVBEDOR 10 164 134 146 4 Inthe Deploy section enter the Context Path provided during the installation as lt context name gt 5 Enter the path where the context name war file resides by default FIC_WEB_ HOME lt context name war gt in the WAR or Directory URL field and click Deploy On successful application deployment a confirmation message is displayed For information on starting the Tomcat server see Section 6 1 Starting Infrastructure 5 2 3 7 Non SSL Port Configuration Ensure that the following connect tag under Define a non SSL HTTP 1 1 Connector on port 8080 in Tomcat installation folder conf server xml file is uncommented for Non SSL Configuration By default it is uncommented Connector port 8080 protocol HTTP 1 1 connectionTimeout 20000 redirectPort 8443 gt Note To disable connection timeouts set connectionTimeout value to 1 The port mentioned as connector port is the Web Application Server port or Servlet port in Infrastructure 5 2
33. OFSAA Infrastructure components will be installed Note You must be logged in to the UNIX operating system as a non root user Download the unzip utility OS specific unzip_ lt os gt Z from the location https updates oracle com unzips unzips html and copy it in Binary mode to the directory that is included in your PATH variable typically SHOME path on the system on which the OFSAA Infrastructure components will be installed If you already have the unzip utility to extract the contents of the downloaded archive skip to the next step Uncompress the unzip installer file using the command uncompress unzip_ lt os gt Z Note In case you notice an error message uncompress not found No such file or directory when the package is not installed contact your UNIX administrator Give EXECUTE permission to the file using the command chmod 751 unzip 0S For example chmod 751 unzip sparc Extract the contents of the OFSAAI 7 3 3 0 0 installer file using the following command unzip OFSAAI 73300 OS zip 3 4 OFSAA Infrastructure Installation and Configuration Guide Common Installation Tasks 5 Give EXECUTE permission to the installer script Navigate to the path OFSAAT_ 73300_ lt 08 gt and execute the command chmod 755 setup sh Preparing for Installation 3 5 Common Installation Tasks 3 6 OFSAA Infrastructure Installation and Configuration Guide Part Il Installatio
34. Servers Figure 5 47 Tomcat home Home Documentation Configuration Wiki Mailing Lists Find Help Apache Tomcat 7 0 19 eee eee If you re seeing this you ve successfully installed Tomcat Congratulations Other Downloads Other Documentation Get Involved Miscellaneous Apache Software Foundation Tomcat Connectors Tomcat Connectors Qamea Contact Tomsathatve mod ik Documentation SYM Repositories Legal aestum lagena Tomcat Nate Matna Lists Sponsorship Hsrtaoe Osolores Deptoyer yan Thanks nace Heme Resources Copynght 1999 2011 Apache Software Foundation All Rights Reserved 2 Click Manager App The Connect to dialog is displayed 3 Enter the User Id and Password that has admin rights and click OK For user creation in tomcat see Tomcat User Administration The Tomcat Web Application Manager window is displayed with the list of all the applications deployed 5 38 OFSAA Infrastructure Installation and Configuration Guide Configuring Web Application Servers Figure 5 48 Tomcat Web Application Manager A ose o a Cs seasons uth ies 30 ton stan Stop Reload _Undeploy Expe sessions wan idie 2 30 minutes Star Stop Reload Undeploy Imanagor None specified Tomcat Manager Application we Expire sessions with idle 2 30 minutes stan Stop Reload Undeploy __Expre sessions wath idle 2 30 minutes lo fhost manager None specified Tomcat Host Manager Application true lofsaT3st
35. The context name can be identified from a URL as below scheme lt host gt lt port gt lt context name gt lo gin jsp Sample URL https myweb 443 ofsaadev login jsp For example InteractionVariable name CONTEXT NAME gt ofsaadev lt InteractionVariable gt Yes A 6 OFSAA Infrastructure Installation and Configuration Guide OFSAAI InstallConfig xml and OFSAAI_PostinstallConfig xml Parameters Table A 2 Cont OFSAA Infrastructure Installation Tasks and Descriptions InteractionVariable Name Significance and Expected Value Mandatory WEBAPP CONTEXT PATH Identifies the absolute path of the exploded ear Yes file on the web application server For Tomcat specify the Tomcat directory path till webapps such as oradata6 revwb tomcat webapps For WebSphere enter the WebSphere path as WebSphere profile directory installed Apps lt NodeCellName gt For example data2 test WebSphere AppServer profiles lt Profile_ Name installedApps aix imfNode01Cell Where aix imf is Host name For WebLogic provide the WebLogic home directory path as WebLogic home directory path bea wlserver 10 3 WEB LOCAL PATH Identifies the absolute path to any directory on Yes the web application server that can hold temporary files being uploaded as part of the applications usage Note In case of a clustered deployment ensure this path and directory is same on all the nodes
36. User ID is the Oracle user ID created for the respective Information Domain 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 Click Apply and save the details Post Installation Configuration 5 9 Configuring Resource Reference 5 1 2 4 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 SOURCES and navigate to the path Data sources gt DATA_SOURCE gt Connection pools Figure 5 12 Connection Pools Data sources AC Data sources 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 LL Additional Properties Sco PRS Node01C 1 Advanced ce ipa dorNodeO1Cellinodesiipa26dorNodeO1 server serveri nn jon 1 Connection timeout properties b seconds Connection pool m r eT Maximum connections 100 connections Minimum connections 10 connections Reap time iso seconds Unused timeout 1900 seconds
37. applications folder 3 Copy the FIC WEB HOME context name ear file to WEBLOGIC INSTALL DIR Bea user projects domains DOMAIN NAME applications 4 Explode the context name ear file by executing the command jar xvf context name ear 5 Delete the context ear and context war file recently created 6 Create a directory context name war under WEBLOGIC INSTALL DIR Bea user projects domains DOMAIN NAME applications 7 Copy FIC WEB HOME context name war file to WEBLOGIC INSTALL DIR Bea user projects domains DOMAIN NAME applications context name ear 8 Explode the context name war file by executing the following command to get the directory structure jar xvf context name war 5 30 OFSAA Infrastructure Installation and Configuration Guide Configuring Web Application Servers Install Application To install Application 1 Open the Install Application Assistant Figure 5 40 Install Application Assistant Install Application Assistant Next Cancel Locate deployment to install and prepare for deployment Select the fie path that represents the appicaton root directory archive fie exploded archive drectory or appicaton module descriptor that you want to install You can also enter the path of the applicaton directory or file in the Path feld Note Only valid fie paths are displayed below If you cannot find your deployment fies upload y
38. be executed in two modes GUI 2 CMD To execute PortC jar in GUI mode ensure that the Hummingbird Exceed to be running and do the following 1 Navigate to the path FIC HOME in each machine 2 Enter the command java jar PortC jar GUI The OFSAA Infrastructure Port Changer window is displayed Appendix Webserver Configuration for Infrastructure Application B 21 Additional Configurations Figure 8 20 OFSAA Infrastructure Port Changer OFSAA Infrastructure Port Changer n x Configure port numbers used by OFSAAInfrastructure OFSAAInfrastructure install directory Application Layer Database Layer Web Layer Infrastructure Java Port 3425 ICC Server Port 9815 ICC Native Port 9817 Infrastructure Native Port 8721 Infrastructure Agent Port 9812 OLAP Data Server Port 10101 Message Server Port 4376 Router Port 4379 AM Port Web Server Port 12123 Enter Database Details Select your Database Oracie lv IP Address Port Number SID Config schema username Config schema password Cancel Change The OFSAA Infrastructure Port Changer window displays the following gt The path in which Infrastructure components have been installed 2 The check boxes corresponding to Application Layer Database Layer or Web Layer are enabled based on 2 Inthe event you have performed a single tier installation on the current machine the check boxes for all three components will be enabled
39. eere ee tind er a Sven cates devs ae e Tene T 5 5 5 6 Created data SOWFCE sillas pista ursa es A asa 5 6 5 7 Select JDBC provider siii 5 6 5 8 Enter database specific properties enne 5 7 5 9 Setup security aliases nee Ia ite ote ma bere obe edo eres 5 7 5 10 SUTIN AL Ys osse snae deiecti b qe EOD ERU I GR TOU RR NAT 5 8 5 11 JAAS J2C authentication data New eese teen eterne eee nenne nennen 5 9 5 12 Connection Pools cusco ee eee iet de OB anie a eed ee ivt ies 5 10 5 13 Welcom esr tin eere ate oti ee PER eie tem eta eene deeds 5 11 5 14 Summary of JDBC Data Sources nth eeensenoe eere idee toten Eb rere Regen 5 11 5 15 Create a New JDBC Data SoutCe ite tier ree e diet 5 12 5 16 JDBC Data Source Properties iniaiaiai e enne nnne nennen 5 12 5 17 Transaction Options sssssssssssseeeeeeeeeen nete E ete nennt ana tn cana teen tenente cnn 5 13 5 18 Conn ction Properties ts oie GR ecd oe d mui eem ei e dp idus 5 13 5 19 Test Database Connection ovocitos 5 14 5 20 Select argelina ii cre Seb eee rte e haie eL RIO IR Rudd 5 15 5 21 Create a New JDBC GridLinkData Source essere entente 5 15 vii viii 5 22 5 23 5 24 5 25 5 26 5 27 5 28 5 29 5 30 5 31 5 32 5 33 5 34 5 35 5 36 5 37 5 38 5 39 5 40 5 41 5 42 5 43 5 44 5 45 5 46 5 47 5 48 Qo Qo Qo Qo Qo HO Qo Qo Qo Qo Qo COO al Lol l l QOO O0 Y 0 001A 0 0 JDBC GridLinkData Source Connec
40. file generate the application EAR WAR file and redeploy the application onto your configured web application server For more information on generating and deploying EAR WAR file see Configuring Web Application Servers D 12 OFSAA Infrastructure Installation and Configuration Guide Frequently Asked Questions What should I do if my Hierarchy filter is not reflecting correctly after I make changes to the underlying Hierarchy In some cases the Hierarchy Filters do not save the edits correctly if the underlying Hierarchy has been changed This can occur in hierarchy maintenance where you have moved a member to another hierarchy branch and that member was explicitly selected in the Filter and is now a child of a node which is already selected in the Filter Please refer to Support Note for the workaround What should I do to change context name for a cloned environment Refer to Support Note How do you turn off unused information domains infodoms from cache Follow the below steps to turn off unused infodoms from cache Navigate to FIC_HOME conf in the APP layer of your OFSAAI installation 1 2 3 In the DynamicServices xml file identify the section for Service code 20 gt Modify the value of parameter CACHE ON STARTUP to 0 default is 1 Repeat the same in the WEB layer too Generate the application EAR WAR file and redeploy the application onto your configured web application server For more inform
41. on Yes the directory identified under parameter DB_ FTPSHARE_PATH above Note This value should be the same as mentioned in parameter APP_SFTP_USER_ID above A 8 OFSAA Infrastructure Installation and Configuration Guide Appendix Webserver Configuration for Infrastructure Application This appendix includes the following sections 2 Webserver Configuration for Infrastructure Application 2 Additional Configurations B 1 Webserver Configuration for Infrastructure Application You can configure the web server in the following ways as required Click on the links to view the section in detail Configurating WebSphere for Infrastructure Application Deployment 2 Configurating WebLogic for Infrastructure Application Deployment B 1 1 Configurating WebSphere for Infrastructure Application Deployment Applicable only if the web container is WebSphere You can deploy multiple Infrastructure applications on different profiles of a stand alone WebSphere application server To create multiple WebSphere Profiles in a stand alone server use the command line option as explained below A profile is the set of files that define the runtime environment At least one profile must exist to run WebSphere Application Server B 1 1 1 Creation of New Profile in WebSphere The Profile is created in WebSphere through command line using the manageprofiles sh which resides in WebSphere Install directory gt AppServer bi
42. server xml file in CATALINA_HOME conf directory to avoid conflict during undeploy and re deploy of the WAR file Place comment in between the context path section For example I Context path pr2test docBase home perfuser tomcat 7 0 19 webapps pr2test debug 0 reloadable true crossContext true gt lt Resource auth Container name jdbc PR2ATM type javax sql DataSource driverClassName oracle jdbc driver OracleDriver username pr2atm password pr2atm url jdbc oracle thin 8010 184 74 99 1521 PERFTEST maxActive 100 maxIdle 30 maxWait 10000 gt lt Context gt gt Restart the Tomcat service by doing the following b Login to the Unix server through a terminal emulator c Navigate to catalina home bin directory d Stop the tomcat services using the command shutdown sh e Start the tomcat services using the command startup sh Open the URL in a browser window http lt IP address gt lt Tomcat server port gt https if SSL is enabled The Tomcat home window is displayed Click the Manager App The Connect to window is displayed Login with the user credentials having admin rights The Tomcat Web Application Manager window is displayed with the list of all applications deployed in Tomcat 8 4 OFSAA Infrastructure Installation and Configuration Guide Uninstalling WAR Files in Tomcat Figure 8 6 Tomcat Web Application Manager te Apache So
43. 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 ipaddress administrative console port console https if SSL is enabled The Login window is displayed 2 Login with the User ID that has admin rights 3 In the LHS menu Domain Structure select Services gt JDBC gt Multi Data Sources The Summary of JDBC Multi Data Sources window is displayed 5 16 OFSAA Infrastructure Installation and Configuration Guide Configuring Resource Reference Figure 5 23 Summary of JDBC Multi Data Sources Summary of JDBC Multi Data Sources Use this page to create or view mus your doman P Customize this table Multi Data Sources Filtered More Columns Exist 4 Click New The New JDBC Multi Data Source screen is displayed N
44. the changes The log Portchanger 1og in the Infrastructure installation path provides the status of port changes performed For above port changes to take effect a re start of all Infrastructure servers is required Note Do not execute the PortC jar with CMD option in the nohup mode The port changes are done only on Infrastructure web components where EAR WAR files are deployed After the port changes are done you need to re create the EAR WAR files and re deploy these files B 2 14 Modify Web Server Port The Web Server Port is the same as the Servlet Port In the event you wish to change the Servlet port after the installation process you must follow the same process as above in the Port Changes section This will change the Servlet port of the Infrastructure application Follow the steps explained in the Starting Infrastructure section to restart Infrastructure Servers After restarting check the connectivity from Servlet URL http lt IPaddress gt lt PortNumber gt lt context name gt servlet com iflex fic ficml FICMaster gt The status should be successful for all the services B 2 15 OFSAAI 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 To execute SetupInfo
45. the latest copy of this document in OTN library which includes all the recent additions revisions if any done till date Before you begin the installation ensure that you have an access to the Oracle Support Portal with the required login credentials to quickly notify us of any issues at any stage You can obtain the login credentials by contacting Oracle Support The Oracle Financial Services Analytical Applications Infrastructure OFSAAT Installation and Configuration Guide is intended for administrators that are responsible for installing and maintaining OFSAA Infrastructure components The document assumes you have experience in installing Enterprise components Basic knowledge about the OFSAA Infrastructure components UNIX commands Database concepts and Web Server Web Application Server is recommended 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 xi Related Documents This section identifies additional documents related to OFSAA Infrastructure You can access Oracle documentation online fr
46. time perform the following steps 1 Navigate to the path FIC HOME Product Installation Directory 2 Execute the command piverify sh What should one do if the installation in GUI mode is not invoked There are set of configuration steps required to be performed during the installation in GUI mode Verify whether the steps mentioned under Configuration for GUI Mode Installation section are done correctly What should one do if there are any exceptions or errors in installation and how to proceed 1 Please backup the installation logs 2 Sharethe backup logs with Oracle support On Solaris 11 system if one gets the following error message during OFSAAI installation what should be done Error OFSAAI 1108 ORA 00604 error occurred at recursive SQL level 1 ORA 01882 timezone region not found Or Time zone cannot be set as null or localtime This happens if the time zone is not set that is NULL or it is set as localtime Set the environment variable TZ to a valid time zone region in the profile file For example Appendix Frequently Asked Questions D 5 Frequently Asked Questions TZ Asia Calcutta export TZ What happens if the installation process is abruptly terminated or aborted What should one do If the installation is abruptly terminated then the installation process will be incomplete To recover from this follow the below steps 1 Drop the DB objects in the config schema created by OFS
47. to start the LDAP server B 2 18 1 Configure Infrastructure Configuration Schema In the Infrastructure configuration schema ensure the following entries in Configuration Table Table B 10 Configuration Schema PARAMNAME Description PARAM Value Example AUTHENTICATIONTYPE Authentication type 2 AUTHENTICATIONTYPE value must be 2 for LDAP ROOTCONTEXT The Root Context for the dc lt Reveleus gt dc lt com gt LDAP Directory ROOTDN The Root dn for LDAP cn lt Manager gt dc lt Reveleus gt directory dc com ROOTPASS Password for the Root secret LDAPURL LDAP URL 1dap 10 80 193 35 389 LDAP SSL MODE LDAP in SSL Mode N for non SSL and Y for SSL HASHPASS Should the user FALSE or TRUE password be Hashed When HASSPASS is set as FALSE we need to have the ROOTDN value as uid ORCLADMIN ou Users dc OFSAAI de com ORCLADMIN is a dummy user it will be replaced dynamically with the logged in user When HASSPASS is set as TRUE we need to have the ROOTDN value as cn orcladmin cn Users dc i flex dc com and proper oracladmin LDAP password as ROOTPASS First OFSAAI connects to LDAP directory using orcladmin user and fetches the login user details and verifies the entered password Note ROOTCONTEXT ROOTDN and ROOTPASS entries should be same as in the slapd conf file B 2 18 2 Configure OpenLDAP Files 1 Copy the reveleusSchema schema from Infrastruc
48. topics a What is OFSAA a What is OFSAA Infrastructure a OFSAA Infrastructure Components a OFSAA Infrastructure High Availability 1 1 What is OFSAA In today s turbulent markets financial institutions require a better understanding of their risk return while strengthening competitive advantage and enhancing long term customer value Oracle Financial Services Analytical Applications enable financial institutions to measure and meet risk adjusted performance objectives cultivate a risk management culture through transparency lower the costs of compliance and regulation and improve insight into customer behavior Oracle delivers a comprehensive integrated suite of financial services analytical applications for Enterprise Performance Management Enterprise Risk Management Financial Crime and Compliance Management Customer Insight and Integrated Business Intelligence 1 2 What is OFSAA Infrastructure Oracle Financial Services Analytical Applications Infrastructure powers the Oracle Financial Services Analytical Applications family of products to perform the processing categorizing selection and manipulation of data and information needed to analyze understand and report on specific performance risk compliance and customer insight issues by providing a strong foundation for the entire family of Oracle Financial Services Analytical Applications across the domains of Risk Performance Compliance and Customer Insight The I
49. with locale name does not exist Resolution Copy MyResources_en_US properties to the setup kit directory and keep en_US in LOCALE tag of OFSAAI_InstallConfig xml Error code OFSAAI 1013 Cause File OFSAAI InstallConfig xml OFSAAI PostInstallConfig xml not found Resolution Copy OFSAAI InstallConfig xml OFSAAI PostInstallConfig xml to the setup kit directory Error code OFSAAI 1014 Cause XML node value is blank Resolution Make sure all node values except SMTPSERVER PROXYHOST PROXYPORT PROXYUSERNAME PROXYPASSWORD NONPROXYHOST or RAC URL are not blank Error code OFSAAI 1015 Cause XML is not well formed Resolution Execute the command dos2unix OFSAAI_InstallConfig xml to convert plain text file from DOS MAC format to UNIX format OR Make sure that OFSAAI_InstallConfig xml is valid Try to open the file through Internet Explorer for a quick way to check validity If it is not getting opened create new OFSAAI InstallConfig xml using the XML Utility jar Error code OFSAAI 1016 Cause User installation directory contain blank spaces Resolution Provide an installation path that does not contain spaces Check the tag USER INSTALL DIRin OFSAAI InstallConfig xml file This path should not contain any spaces D 16 OFSAA Infrastructure Installation and Configuration Guide Error Dictionary Error code OFSAAI 1017 Cause User installation directory is invalid Res
50. 00 PARAMETER NAME CUBE CACHE SIZE VALUE 1000 2 lt PARAMETER NAME RDM_CACHE_SIZE VALUE 1000 gt 2 lt PARAMETER NAME BUSINESSPROCESSOR_CACHE_SIZE VALUE 2000 gt 2 lt PARAMETER NAME DERIVEDENTITY_CACHE_SIZE VALUE 1000 gt lt PARAMETER NAME LOG_GET_METADATA VALUE false gt lt PARAMETER NAME METADATA_PARALLEL_CACHING VALUE 0 gt lt PARAMETERS gt lt SERVICE gt D 2 Error Dictionary This contents of this section has been created with the interest to help you resolve the installation issues if any There is a compilation of all the possible errors that might arise during the installation process with the possible cause and the resolution to quickly fix the issue and proceed further with the installation D 2 1 Accessing Error Dictionary Instead of scrolling through the document to find the error code you can use the pdf search functionality In the Find dialog available in any of the Adobe Acrobat version that you are using to view the pdf document follow the below instructions to quickly find the error resolution 1 With the Installation pdf open press Ctrl F or select Edit gt Find 2 The Find dialog is displayed as indicated 3 Enter the error code that is displayed on screen during Infrastructure installation 4 Press Enter The search results are displayed and hig
51. 1 Enabled 0 Disabled Installation If value is 1 then ARBORPATH HYPERION HOME amp ESSBASEPATH sins variables should be set in profile before installation Install Complete gt OFSAAI OLAP FEATURE 0 ORACLE FINANCIAL SERVICES InstallAn ME Bose 14 Enter 1 if you want to configure OFSAAI OLAP feature By default 0 is displayed 15 Click Next The Web Server Details window is displayed Figure 4 18 Web Server Details Web Server Details License Note Context name will be used in your Application URL Prelnstall Setup http lt WebServerlP gt Servlet port contextname gt lagin jsp C Installation Example http 10 80 50 206 9080 mvapp login jsp stall C 9 Install Complete C ENABLE HTTPS WEB SERVER PORT 9061 WEB APP SERVER IP 10 184 134 88 Context name for deployment Profsa733 ORACLE WEB LOCAL PATH FINANCIAL SERVICES scratcnywebsphere fipshare 16 Select the Enable HTTPS checkbox to configure HTTPS 17 Enter Web Server HTTP Server Port Web App Server HTTP Server IP address context name for deployment and the local path to any folder on the Web Application Server Tomcat Websphere Weblogic 18 Click Next The Database Details window is displayed Installing OFSAA Infrastructure v 7 3 3 0 0 4 13 GUI Mode Installation Figure 4 19 Database Details License Prelnstall Setup S Installation Install Complete
52. 1004 Cause File profile is not present in HOME Resolution Create profile in HOME i e in the home directory of user Error code OFSAAI 1005 Cause File OFSAAInfrastructure bin is not present in current folder Resolution Copy OFSAAInfrastructure bin into installation kit directory Error code OFSAAI 1006 Cause File CustReg DAT is not present in current folder Resolution Copy CustReg DAT into installation kit directory Error code OFSAAI 1007 Cause File OFSAAI InstallConfig xml is not present in current folder Resolution Copy OFSAAI InstallConfig xml into installation kit directory Error code OFSAAI 1008 Cause File validateXMLInputs jar is not present in current folder Resolution Copy validateXMLInputs jar into installation kit directory Error code OFSAAI 1009 Cause File 10947 xml is not present in current folder Resolution Copy 10g4j xml into installation kit directory Appendix Frequently Asked Questions D 15 Error Dictionary Error code OFSAAI 1010 Cause Unknown error occurred Resolution Make sure to provide proper argument SILENT or GUI to the Setup sh file Error code OFSAAI 1011 Cause XML validation failed Resolution Check InfrastructurePreValidations Log for more details Error code OFSAAI 1012 Cause Property file
53. 3 8 SSL Port Configuration Ensure that the following connect tag under Define a SSL HTTP 1 1 Connector on port 8443 in lt Tomcat_installation_folder gt conf server xml file is uncommented for SSL Configuration By default it is commented lt Connector port 8443 protocol HTTP 1 1 SSLEnabled true maxThreads 150 scheme https secure true Post Installation Configuration 5 39 Configuring Web Application Servers clientAuth false sslProtocol TLS Note The port mentioned as connector port is the Web Application Server port or servlet port in Infrastructure For more information related to SSL Configuration on Tomcat refer to http tomcat apache org 5 40 OFSAA Infrastructure Installation and Configuration Guide 6 Start Stop Infrastructure Services This chapter details about how to start and stop Infrastructure services This chapter includes the following topics Starting Infrastructure Stopping Infrastructure 6 1 Starting Infrastructure Once the installation of Infrastructure has been completed successfully and the post installation steps are completed the servers must be started Log on to each machine and run the profile file All servers mentioned must be started from the same shell encoding The servers mentioned below are dependent on each other It is mandatory to maintain the order in which the servers are started Allow each of the servers to initialize complet
54. 4 To start Back end Services a Onthe machine on which Infrastructure Database components have been installed navigate to FIC_DB_HOME bin and execute the command to start Agent server agentstartup sh Or Start Back end services using the command nohup agentstartup sh amp Note This agent internally starts the Router Message Server OLAP data server and AM services 5 Froma client workstation open the client browser and provide the URL as http or https IP address gt lt servlet port context name login jsp For example http 11 111 111 111 1111 0fsaai login jsp 6 2 OFSAA Infrastructure Installation and Configuration Guide Starting Infrastructure Note If https configuration is enabled the client browser will need to disable the proxy servers through the client browser s internet options The OFSAAI login screen is displayed Figure 6 1 OFSAAI Login window Financial Services Analytical Applications Infrastructure ORACLE Language US English X User ID Password 2014 Oracle and or its affiliates All rights reserve There are two in built system administration users profiles configured in the system a SYSADMN SYSAUTH You can login to the system using the S YSADMN User ID Note that there is no I in the SYSADMN login USER ID Enter the password that was provided during installation On the first login you will be prompted to change the password
55. 9esososcsseoseseet Confirm Password setososoososostond What are the properbes to pass to the JDBC driver when creating database connections The set of driver propertes whose values are derived at runtime from the named system property System Properties hat table name or SQL statement would you like to use to test database comectons Test Table Name Test Configuration Back Next Finan Cancel 11 Verify the details and click Test Configuration and test the configuration settings A confirmation message is displayed stating Connection test succeeded 12 Click Finish The created Data Source is displayed in the list of Data Sources Note the following a User ID is the Oracle user ID that is created for the respective Information Domain User ID to be specified for data source with FICMASTER as JNDI name should be the Oracle user ID created for the configuration schema 13 Select the new Data Source and click the Targets tab 5 14 OFSAA Infrastructure Installation and Configuration Guide Configuring Resource Reference Figure 5 20 Select Targets Create a New JDBC Data Source Back Finish Cancel Select Targets ou can select one or more targets to deploy your new JOBC data source If you don t select a target the data source wil be created but not deployed You wil need to deploy the data source ata later Sme 7 AdminServer Back Finan Cancel 14 Select the AdminServer option and click Fi
56. AAI installation 2 Openthe profile and remove the entries made by the OFSAAI installation which are made between the comment statements Beginning of entries by OFSAA Infrastructure installation and End of entries by OFSAA Infrastructure installation 3 Delete the OFSAA install directory created by the OFSAAL installer 4 Perform the OFSAAI installation again Would OFSAA support any other web server types other than the ones stated in tech matrix and installation guide No all the supported software and versions are stated in the OFSAA Technology Stack Matrices What should one do if the database connection from connection pool throws an error java sql SQLRecoverableException IO Error Connection reset This happens while running several database intensive tasks in parallel To correct this error add the line securerandom source file dev urandom in the java security configuration file available in 7AVA HOME jre lib security path Note This needs to be configured on all the machines or VMs where the OFSAAI components are installed If the issue is not resolved even with the above settings check the MTU Maximum Transmission Unit settings on the linux box For details on MTU settings and updating them contact your system Administrator When I invoke setup sh file from my install archive it throws syntax errors file not found error messages what should I do This could mostly happen 2 When ins
57. AI The following files are required 2 setup sh envCheck sh 2 preinstallcheck sh Verlnfo txt 2 OFSAAInfrastructure bin 2 validatedXMLinputs jar MyResources en US properties 2 log4j xml 2 OFSAAT PostlnstallConfig xml 2 OFSAAIT InstallConfig xml 2 privileges config usersql 2 privileges atomic user sql 2 XML Ulilityjar Is OFSAAI license specific to Applications No OFSAAI license is not specific to any application Where can I reach out for the license key for installations OFSAAT 7 3 3 0 0 installer does not need a license code or a license file With the license agreement acceptance one could proceed with the installation During installation when one gets an error message Execute Permission denied what is to be done Please check whether all the files provided for OFSAAT installation has execute permissions To give execute permissions D 2 OFSAA Infrastructure Installation and Configuration Guide Frequently Asked Questions 2 Navigate to the path OFSAAI_73300 and execute the command chmod 755 Graphical installers are not If error resembles Graphical installers are not supported by the VM The console mode will be used instead then check whether any of the X windows software has been installed Example Hummingbird Exceed is started and configured to Graphical mode installation Note Type xclock from prompt and this should display clock in graphical mode No Java
58. AI installer performs all the pre requisite validation check during installation Any errors encountered in the process is displayed with an appropriate Error Code You can refer to the Error Dictionary to find the exact cause and resolution to rectify the error D 1 Frequently Asked Questions You can refer to the Frequently Asked Questions which has been developed with the interest to help you resolve some of the OFSAAI Installation and configuration issues This intends to share the knowledge of problem resolution to a few of the known issues This is not an official support document and just attempts to share the knowledge of problem resolution to a few of the known issues OFSAAI FAQs What are the different components that get installed during OFSAAI The different components of OFSAAI are illustrated in Figure 1 1 OFSAA Infrastructure Framework If OFS AAI AAAI needs to be installed on different versions of an Operating System which installer needs to be downloaded OFS AAI AAAT installer downloaded for a specific Operating System can be used to install on all its supported versions For Solaris OS only one installer OFSAAI 73300 Solaris is available and it can be used to install OFSAAI on both versions of Solaris that is v5 10 or v5 11 Similarly the installer OFSAAI 73300 Linux can be used to install OFSAAI on all supported versions of Oracle Linux that is v 5 3 up to 5 10 and v6 0 and above The installer OFSAAI 73300 A
59. AVA OPTS SJAVA OPTS Xms512m Xmx1024m Djava util logging manager org apache juli ClassLoaderLogManager else JAVA OPTS SJAVA OPTS Xms512m Xmx1024m LOGGING MANAGER fi B 2 7 3 WebLogic Memory Settings To configure the WebLogic Memory Settings 1 Change the memory setting for Java Heap to Xms512m Xmx1024min setDomainEnv sh file which resides in the folder DOMAIN HOME bin and in CommEnv sh file which resides in the folder common bin 2 Edit this file for customizing memory settings and garbage collector settings depending on the available hardware configuration Example 1 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 B 16 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations WLS MEM ARGS 32BIT Xms512m Xmx1024m export WLS MEM ARGS 32BIT Example 2 JAVA VM MEM ARGS Xms256m Xmx1024m B 2 7 4 WebSphere Memory Settings To configure the WebSphere Memory Settings 1 Navigate to Websphere applications server Application servers serverl gt Process definition gt Java Virtual Machine 2 Change the memory setting for Java Heap Initial heap size 512 Maximum heap size 1024 B 2 8 Internet Explorer Setting
60. Administrator and System Authorizer users 26 Click Next The SFTP Details window is displayed Installing OFSAA Infrastructure v 7 3 3 0 0 4 15 GUI Mode Installation Figure 4 23 SFTP Details SFTP Details License Note Prelnstall Setup For enable SFTP If value is 1 then SFTP will be enabled If value is inst llation O then FTP will be enabled Install Complete ENABLE SFTP 1 FILE TRANSFER PORT 22 ORACLE FINANCIAL SERVICES Previous Next 27 Enter 1 to enable SFTP or 0 to enable FTP Note Ensure the system on which the OFSAA Infrastructure is being installed has either FTP SFTP enabled 28 Enter the port to be used for file transfer 29 Click Next The Post Install window is displayed Figure 4 24 Post Install POST INSTALL License CONFIGURE POST INSTALLATION DETAILS Prelnstall Setup S Installation Y Install Complete ORACLE FINANCIAL SERVICES 30 Select Yes if you want to do the post installation configuration after installing OFSAA Infrastructure 4 16 OFSAA Infrastructure Installation and Configuration Guide GUI Mode Installation 31 Click Next The OFSAAI Post Install Details window is displayed Figure 4 25 OFSAAI Post Install Details OFSAAI Post Install Details License FTPSHARE PATH 3 Prelnstall Setup scratch ofsaadb ftpshare Installation Restore Default Install Complete FTP SFTP USER ID ofsaadb Please enter In
61. B 7 Webserver Configuration for Infrastructure Application Figure 8 14 Select Optional Configuration F Fusion Middleware Configuration Wizard Select Optional Configuration 7 Administration Server Modify Settings C Managed Servers Clusters and Machines Add or Delete Modify Settings C RDBMS Security Store Modify Settings 8 Select Administration Server A WebLogic Server domain must have an Administration Server You can also select Manages Servers Clusters and Machines and RDBMS Security Store if required Click Next The Configure the Administration Server window is displayed Figure 8 15 Configure the Administration Server F Fusion Middleware Configuration Wizard Configure the Administration Server AdminServer All Local Addresses Too7 o B 8 OFSAA Infrastructure Installation and Configuration Guide Webserver Configuration for Infrastructure Application 9 Enter Administration Server details such as the Name Listen address Listen Port SSL listen port and SSL enabled for secure login using https check box Click Next The Configuration Summary window is displayed Note Make a note of the Listen Port or SSL Listen Port value ex 7007 since the same has to be re entered in the Servlet port field during Infrastructure installation Figure 8 16 Configure Server Start Mode and JDK F Fusion Middleware Configuration Wizard
62. Cell Node Server 14 Click Finish and deploy the Infrastructure Application on WebSphere Post Installation Configuration 5 27 Configuring Web Application Servers 15 On successful installation a message is displayed Click Save and save the master file configuration The details are displayed in the Master File Configuration window To start the application 1 Expand Applications gt Application Type gt WebSphere enterprise applications The Enterprise Applications window is displayed Figure 5 38 Enterprise Applications Enterprise Applications Use this page to manage installed appicabons A single appicabon can be deployed onto mulbole servers Preferences Step Install Uninstal Update RoloutUpdate Removef e Export ExportDDL Export fie 077 Select Name gt Application Status Q You can adenrester the folowing resources E Alxcasr s C Defaubhookcation O uten gt O men gt Total 4 2 Select the installed application and click Start Note profile name gt is the profile name given while creating the WebSphere profile a cell name gt is the cell name given during profile creation a contextname is the context name given during installation 5 2 1 3 WebSphere HTTPS Configuration Following are the steps for configuring an HTTPS Transport on WebSphere 1 Create a profile using the Profile Creation Wizard in WebSphere 2 Note down
63. Configuration Summary Domain Summary Click on an tem in the Domain Summary pane on the left to inspect its attributes in the Detais pane below You can make limited adjustments by clicking Previous to return to a prior panel If everything is satisfactory click Next Details Attribute Value Name Basic WebLogic Server Domain Description Create a basic WebLogic Server domain without installing sample application Author Oracle Corporation Location weblogic webltO13 bealwlserver 10 3 commontemoplates domains wis jar 10 Verify the configuration details of the WebLogic domain and click Create The Creating Domain window is displayed with the status indication of the domain creation process Appendix Webserver Configuration for Infrastructure Application B 9 Additional Configurations Figure 8 17 Configure Server Start Mode and JDK F Fusion Middleware Configuration Wizard Creating Domain ORACLE Progress Preparing Extracting Domain Contents Creating Domain Security Information Saving the Domain information Storing Domain Information String Substituting Domain Files Performing OS Specific Tasks Performing Post Domain Creation Tasks Domain Created Successfully Domain Location weblogic weblt013 bealuser projects domainsMockSol Admin Server URL http Aps88rev 7007 ORACLE 11 Click Done when complete The domain server is created enabling the deployment of multiple
64. Connection configuration for WebLogic This section is applicable if you are using 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 visual environment While making a HTTP s connection to external resource from WebLogic server the following exception comes because of underlying API uses WebLogic implementation 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 Ensure that Sun Implementation is required to support Object Migration for HTTPS protocol using self signed certification B 20 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations B 2 12 Configure User Attributes Screen The User Attributes feature of Infrastructure allows you to enter additional attributes for a user The CSSMS_ATTRIB_MAST table in the configuration schema should be loaded with data based on the additional attributes that are required to be captured for a user The field labels in the User Attributes screen of Infrastructure will be dependent on the values that are entered in this table An exampl
65. Console Prompts User Inputs Are you accepting the terms and conditions mentioned above Y N Enter Y if you accept the license agreement and want to proceed with installation Please enter password for default Infrastructure administrator user SYSADMN Enter the password for the System Administrator Please re enter password for default Infrastructure administrator user SYSADMN Enter the same password again to confirm its validity Please enter password for default Infrastructure authorizer user SYSAUTH Enter the password for the System Authorizer Please enter password for default Infrastructure authorizer user SYSAUTH Enter the same password again to confirm its validity Note SYSADMN and SYSAUTH are the two default OFSAAI administrative users created Installing OFSAA Infrastructure v 7 3 3 0 0 4 3 Silent Mode Installation Figure 4 3 Silent Mode Installation Installing 4 4 OFSAA Infrastructure Installation and Configuration Guide Silent Mode Installation Figure 4 4 Silent Mode Installation Post Install Health Check Installing OFSAA Infrastructure v 7 3 3 0 0 4 5 Silent Mode Installation Figure 4 5 Silent Mode Installation Sample Application installation 4 6 OFSAA Infrastructure Installation and Configuration Guide GUI Mode Installation 4 2 GUI Mode Installation Note Ensure you have followed the steps as mentione
66. E JOBC DRIVER PATH oracle crajdbc app orajdbc product 11 2 0 client 1 jdbc lib 8 Specify the directory location for ojdbc6 jar file Ensure that you do not use the trailing slash file separators The Oracle JDBC driver Download ojdbc6 jar for Oracle 11g R2 file corresponding to the required version of Oracle Client can be downloaded from Oracle Download site Once downloaded you need to place the file in the 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 previous window 9 Click Next The Summary window is displayed Figure 5 4 Summary Create a new JDBC Provider Create a new JDEC Provider Summary of actions Options Scope cells GX 1 S0REV Zone2Node0SCell nodes GXS 2 SOREV Zone2Node0S servers servert pec provider name Oracle JoEC Driver Description Oracle JDEC Driver Class path S ORACLE JOBC DRIVER PATH ojdbc6 jar S ORACLE JDGC DRIVER PATH Implemantati ini Li role ile o Loba arde ola oracie jdbc po jl Ora cleConnactionPoolDataSource 10 Verify the details and click Finish to create the JDBC Provider 11 The options to Save and Review are displayed Click Save 5 4 OFSAA Infrastructure Installation and Configuration Guide Configuring Resource Reference 5 1 2 2 Create Data Source The steps given below are app
67. Helper Class Name from the drop down list and ensure that the checkbox Use this data source in container managed persistence CMP is selected Note For RAC configuration provide the RAC url specified during installation Example jdbc oracle thin DESCRIPTION ADDRESS _ LIST ADDRESS PROTOCOL TCP HOST 10 184 108 91 port 1521 ADDRESS P ROTOCOL TCP HOST 10 184 108 92 PORT 1521 LOAD BALANCE no FAILOVER yes CONNECT_DATA SERVICE NAME pqadb 11 Click Next Figure 5 9 Setup security aliases Create a data source Create a data source Select the authentication values for this resource Component managed authentication alias _ none v Mapping configuration alias mene i Container managed authentication alias _ none x Note You can create a new J2C authentication alias by accessing one of the following links Clicking on a link will cancel the vizard and your current wizard selections vill be lost Global J2C authentication alias Sean Erevious next Cancel Post Installation Configuration 5 7 Configuring Resource Reference 12 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 Next and then Finish Figure 5 10 Summary Create a data source B Create a d
68. IX can be used to install OFSAAI on all supported versions of AIX that is v5 3 and v6 1 Same is applicable for OFSAAAI installers available for specific Operating Systems What are the different modes of OFSAAI installation OFSAAI can be installed in two modes Silent Mode and GUI mode Appendix Frequently Asked Questions D 1 Frequently Asked Questions Can the OFSAA Infrastructure components be installed on multi tier No OFSAA Infrastructure components ficapp ficweb ficdb cannot be installed on multi tier By default they will be installed on single tier However OFSAA Infrastructure can be deployed within the n Tier architecture where the Database Web Server and Web Application Server is installed on separate tiers Is JDK Java Development Kit required during installation of OFSAA Can it be uninstalled after OFSAA installation JDK is not required during installation of OFSAA and only JRE is required For more details refer Table 2 2 Java Runtime Environment section Is JRE required during installation of OFSAA Can it be uninstalled after OFSAAI installation Only JRE Java Runtime Environment is required during installation of OFSAA and cannot be uninstalled as the JRE is used by the OFSAA system to work How do I know what is the Operating system webservers and other software versions that OFSAA supports Refer to OFSAA Technology Stack Matrices What are the different files required to install OFSA
69. Infrastructure To stop Infrastructure services 1 On the machine in which Infrastructure Application components have been installed navigate to FIC APP HOME common FICServer bin and execute the command reveleusshutdown sh To stop ICC server on the machine in which Infrastructure default Application components have been installed navigate to FIC_HOME ficapp icc bin and execute the command iccservershutdown sh Note Only Infrastructure Default Application Server would hold ICC component To stop Back end server on the machine in which Infrastructure database components have been installed navigate to FIC DB HOME bin and execute the command agentshutdown sh 6 4 OFSAA Infrastructure Installation and Configuration Guide Verifying the Installation The OFSAA1733 10g displays the below statistics on completing the installation Please refer the Installation summary and tips given below before proceeding to the Post Install activities INSTALLATION SUMMARY FATAL ERRORS ERRORS 0 0 DEBUG STATEMENTS 399 INFORMATIONS WARNINGS 255 0 ERRORS SUMMARY Tips 1 In the event if one or more than one FATAL ERRORS exists its mandatory to reinstall Oracle Financial Services Analytical Applications Infrastructure application 2 In the event if one or more than one ERRORS exists its preferable to reinstall Oracle Financial Services Analytical Applications Infrastruct
70. Infrastructure applications on a single WebLogic B 1 2 2 Delete Domain in WebLogic 1 Navigate to the following directory WebLogic Installation directory user projects domains domain name bin 2 Execute stopWebLogic sh to stop the Weblogic domain 3 Delete the Weblogic domain B 2 Additional Configurations Refer to the following sections for detailed module specific post installation configurations B 2 1 Configuration for Forms Framework If the webserver is Tomcat copy the jaxrpc jar from the lt OFSAAI Installation Directory gt axis 1_4 webapps axis WEB INF 1ib and place it in under Tomcat Installation Directory lib B 10 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations B 2 2 Configuration for Model Upload Utility The Model Upload Utility uploads the Data Model through the command line parameter by executing a shell script file It is used to upload Models that are huge in size The ERwin file that contains the Data Model information must be placed at lt ftpshare gt lt infodom gt erwin erwinXML The Upload sh file is a shell script which is required to run the utility and it is present at FIC_ HOME ficapp common FICServer bin location B 2 2 1 Run the Model Upload Utility 1 Open Upload sh and enter the following arguments in the file 2 lt infodom gt Refers to the DSN name 2 entire file path Refers to the Erwin File Path 2 username Re
71. Installation 4 1 3 Completing the installation in Silent Mode On launching the installer in silent mode the environment check utility is executed Enter the required information to execute the utility as explained below Table 4 1 Silent Mode Installation 1 Console Prompts User Inputs Please enter OFSAAI Enter the user name for OFSAAI configuration schema CONFIG Schema user name Please enter password Enter the configuration schema password Please enter Oracle SID SERVICE name Enter the SID or service name of the Oracle database instance The status of each checks performed by the utility is displayed as shown in If the status of the utility is Success it proceeds with the installation Figure 4 1 Silent Mode Installation Environment check 4 2 OFSAA Infrastructure Installation and Configuration Guide Silent Mode Installation Table 4 2 Console Prompts User Inputs Please enter Infrastructure configuration schema password Enter the configuration schema password Please enter Infrastructure FTP SFTP password Enter the password to access Product Staging Metadata repository directory in the application server Note During installation stage you need to enter the config schema password again The OFSAAI License Agreement is displayed as shown in Figure 4 2 Figure 4 2 Silent Mode Installation OFSAAUI License Agreement Table 4 3
72. L SERVICES accept the terms of the License Agreement Q do NOT accept the terms of the License Agreement 6 Select the I accept the terms if the License Agreement option and click Next The License Details window is displayed 4 8 OFSAA Infrastructure Installation and Configuration Guide GUI Mode Installation Figure 4 9 License Details License Details Y Preinstall Setup Product Name 3 Installation OFSAA Infrastructure Install Complete Ins F Version 7 3 3 0 0 Operating System Linux Relational Database Oracle Licensed Locale ORACLE en_US FINANCIAL SERVICES 7 Click Next The User Installation Directory window is displayed Figure 4 10 User Installation Directory User Installation Directory License User Installation Directory Prelnstall Setup scratch ofsaadb OFSAA Installation Install Complete ORACLE FINANCIAL SERVICES Install nywhere MEC NEUEN 8 Enter the installation directory path This is the directory you have set in the user profile file in step 2 9 Click Next The OFSAA Infrastructure Server Details window is displayed Installing OFSAA Infrastructure v 7 3 3 0 0 4 9 GUI Mode Installation Figure 4 11 OFSAA Infrastructure Server Details OFSAA Infrastructure Server Details License Enter requested information Prelnstall Setup Note If the JDBC_URL is of RAC type then DB Server IP Hostname instalation field name should be NA
73. MDD TRUSTSTOREPASS TRUST PASSWORD MDD KEYSTORE SKEYSTORE HMDD KEYSTOREPASS KEY PASSWORD PROVIDER PROVIDER FDATE_FORMAT MM dd yyyy B 2 18 Infrastructure LDAP Configuration This provides you with the option of using LDAP Lightweight Directory Access Protocol authentication or Infrastructure SMS authentication for logging on to Infrastructure If you are using the Infrastructure authentication the user and user group details profile creation function and role maintenance and other mappings can be done through the Infrastructure Administration module under Security Management The data in this case will be updated in the CSSMS table However if you wish to use LDAP for user authentication then you have to ensure that the LDAP server is installed and configured Also make sure that OPEN LDAP 2 2 29 is installed and configured in Windows machine Before doing the following configuration it is required to select the Authentication type as LDAP in the B 24 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations Configuration screen of Infrastructure This screen can be accessed by selecting System Configuration gt Configuration in the LHS menu of Infrastructure In the Windows machine in which LDAP Server is installed go to the OpenLDAP installation directory through the command prompt and execute the command slapd d 1
74. OM PATCHES table Table Name Description V INFODOM Name of INFODOM IN SERIAL NO Serial Number of patch V PATCH NAME Version of the patch applied IV REMARKS Remarks D_APPLIED_DATE Patch application date Appendix Webserver Configuration for Infrastructure Application B 19 Additional Configurations Table B 8 Cont INFODOM PATCHES table Table Name Description IV APP ID Indicated whether it is Platform and Applications installed B 2 10 OLAP Data Server Configuration This section is applicable if you are using the OLAP feature of OFSAAL 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 Process Memory Limit Max Thread Stack Size Max Number of Threads per Process 2 Sort Buffer settings This must be set at the Essbase application level appropriate to the anticipated load 2 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 the old instance is completed on the OLAP Data Server before restarting the OPSAAI Server Pause for a period of time based on the load the system was subjected to before restarting the Data Services subsystem B 2 11 Object Migration HTTPS URL
75. ON_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 Post Installation Configuration 5 21 Configuring Web Application Servers 5 2 Configuring Web Application Servers This section will guide you on the necessary steps to configure the different web application servers for OFSAA Infrastructure deployment Configuring IBM WebSphere Application Server Configuring Oracle WebLogic Server Configuring Apache Tomcat Server 5 2 1 Configuring IBM WebSphere Application Server This section is applicable only when the Web Application Server type is WebSphere 5 2 1 1 Create WebSphere EAR File The EAR files are 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 Navigate to the FIC_WEB_HOME directory on the machine in which Infrastructure Web components have been installed and execute the command ant sh This triggers the creation of EAR file contextname ear The contextname is the name given during installation On completion of the EAR files creation the BUILD SUCCESSFUL and Time taken message is displayed and you will be returned to the prompt The EAR file contextname ear is created on the machine on which Infrastructure W
76. ORACLE FINANCIAL SERVICES 19 Enter Oracle SID Service Name JDBC URL Configuration Schema User ID and Database Details NOTE Specify the Database user name which is the user created for configuration database schema For example configuser Specify the Database driver path as ORACLE HOME jdbc lib where ORACLE HOME should be replaced with ORACLE HOME value The ABSOLUTE DRIVER PATH refers to the JDBC driver files path ORACLE SID SERVICE NAME OFSQADB JDEC URL jdbc oracle thin 10 184 135 67 152 1 OFSQADB CONFIG SCHEMA USER ID DOC733CONF Oracle Configuration Schema Password 9900090006 ABSOLUTE DRIVER PATH Iscratch oracle app oracle product 11 2 0 client 1 jdbc lib Restore Defaut Choose Password and Absolute Driver Path Note Absolute Driver Path can be the path where Oracle DB client is installed or JDBC driver is installed For example scratch oracle app oracle product 11 2 0 client 1 jdbc lib 20 Click Next The Ports Configuration window is displayed Figure 4 20 Ports Configuration License Prelnstall Setup O Installation Install Complete ORACLE FINANCIAL SERVICES Ports Configuration Enter required information Note Ports must have unique value Java Port 9999 Native Port 5666 Agent Port 6510 ICC Server Port 6507 ICC Native Port 6509 4 14 OFSAA Infrastru
77. ORACLE Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Release 7 3 3 0 0 E52602 01 September 2014 OFSAAT Installation and Configuration Guide Release 7 3 3 0 0 E52602 01 Copyright O 2014 Oracle and or its affiliates All rights reserved Primary Author Gitcy Paulose Contributing Author Jeevraj Vanjari Bharath S Deepthi Santosh 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 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
78. OTE Ensure that the Data Sources which needs to be added to new JDBC Multi Data Source has been created Figure 5 24 Configure the Multi Data Source Create a New JD8C Multi Data Source ex Cance Configure the Multi Data Source The foloning proper tes wil be used to identify your new JOBC mus data source What would you tke to name your new JOBC mult data source dE Mame JDBC Multi Data Source 0 D name vo jou eign to your ne ac ource E MDI Name dbc infodcmname What algorithm type for this JOBC Mult Data Source would you like to select A Algorithm Type Load Balancing v 5 Enter the JDBC Source Name JNDI name and select the Algorithm Type from the drop down list Click Next Note the following a The JNDI Name has to be specified in the format jdbc infodomname a JNDI Name of the Data Sources that will be added to new JDBC Multi data source should be different from the JNDI name specified during Multi Data Source 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 a JNDI Name provided in multi data source should be the same name that will be mentioned in the web xml file of OFSAAI Application Post Installation Configuration 5 17 Configuring Resource Reference a You can select the Algorithm Type as Load Balancing Figure 5 25 Select Targets Create a New JDBC Multi Data Source
79. S 36 Click Install The Installing OFSAA Infrastructure window is displayed Figure 4 28 Installing OFSAA Infrastructure Installing OFSAAInfrastructure License Prelnstall Setup Y Installation D Install Complete ORACLE Installation is in progress Se eae generar This process may take several minutes Please Wait FINANCIAL SERVICES Installing Execute Script Batch file AdminConf e Cancel 4 18 OFSAA Infrastructure Installation and Configuration Guide GUI Mode Installation Anytime during the installation you can click Cancel to stop the installation Once completed the Installation Summary screen is displayed Figure 4 29 Installation Summary INSTALLATION SUMMARY License INSTALLATION SUMMARY Prelnstall Setup Installation Install Complete Please see the installation log under Jscratch ofsaaapp OFSAAJ 7 3 3 OFSAAJ733 log and Iscratch ofsaaapp OFSAAJ 7 3 3 OFSAAInfrastructure Install log for more details Click on Next to continue ORACLE FINANCIAL SERVICES The Summary screen displays the number of Fatal Errors Errors Debug Statements Informations and Warnings along with the location of log files 37 Click Next The Installation Complete window is displayed Figure 4 30 Installation Complete Installation Complete License Congratulations Oracle Financial Services Analytical Applications Prelnstall Setup Infrastructure has been successf
80. T LOAD BALANCE yes FAILOVER yes CONNECT DATA SERVICE_NAME SERVICE lt InteractionVariable gt For example lt InteractionVariable name JDBC_URL gt jdbc oracle thin dbhost server com 1521 servicel lt InteractionVariable gt or lt InteractionVariable name JDBC_ URL gt jdbc oracle thin dbshost server co m 1521 scan 1 lt InteractionVariable gt or lt InteractionVariable name JDBC_ URL gt jdbc oracle thin DESCRIPTION ADDRE SS LIST ADDRESS PROTOCOL TCP HOST dbhost1 server com port 1521 ADDRESS PROTOCOL TCP HOST dbhost2 server com PORT 1521 LOAD BALANCE yes FAILOVER yes CONNECT_ DATA SERVICE NAME servicel InteractionVariable Yes Appendix OFSAAI InstallConfig xml A 3 OFSAAI InstallConfig xml and OFSAAI_PostinstallConfig xml Parameters Table A 2 Cont OFSAA Infrastructure Installation Tasks and Descriptions InteractionVariable Name Significance and Expected Value Mandatory ORACLE SID SERVICE NAME Identifies the Oracle DB Instance SID or SERVICE NAME Note The Oracle SID value should be exactly the same as it is mentioned in JDBC URL For example InteractionVariable name ORACLE SID SERVICE NAME gt ofsaser lt InteractionVariable gt Yes CONFIGDBUSER ID Identifies the Oracle database user that would hold the OFSAA Infrastructure CONFIG schema For example Inter
81. WEBLOGIC DOMAIN HOMI Lu Identifies the WebLogic Domain Home Specify No the value only if WEBSERVERTYPE is set as 3 WebLogic For example InteractionVariable name WEBLOGIC DOMAIN HOME gt home weblogic bea user_ projects domains mydomain InteractionVariable A 1 2 OFSAAI PostinstallConfig xml The OFSAAI PostInstallConfig xml file is one of the core files of the installation process and it is optional to update this file prior to the installation However it is mandatory to update this file if the value for parameter POST INSTALL in the OFSAAI_ InstallConfig xml file is set to 1 The OFSAAI PostInstallConfig xml is similar to the OFSAAI_InstallConfig xml and organized into multiple sections called layers with each Layer divided into InteractionGroups Each lt InteractionGroup gt contains one or more lt InteractionVariable gt parameters Note Itis mandatory to retain all the layers and their internal elements sub elements Under no circumstances should any of these be removed or tampered The different layers and their significance are mentioned in Table Appendix OFSAAI InstallConfig xml A 7 OFSAAI InstallConfig xml and OFSAAI_PostinstallConfig xml Parameters Table A 3 Layers and their Significance Layer Name Significance OFSAAI APP LAYER This layer contains the Interaction Group that captures information on the shared file system details like the ftp
82. a Manager gt Technical Metadata Data Integrator gt Define Sources window Update the appropriate Source details B 34 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations 5 If you are using Apache Tomcat as Web server update the Context gt Resource tag details in Server xml file from the CATALINA_HOME conf folder In case of Tomcat only Atomic lt Resource gt will exist If you are using WebSphere as Web server a Login to the WebSphere Administration Console from the left side menu b Navigate to Resources gt JDBC gt Data Sources A list of data sources will be populated on the right side c Select the appropriate Data Source and edit the connection details In this case both Config and Atomic data sources will need to be modified If you are using WebLogic as Web server a Login to the WebLogic Administration Console from the left side menu b Under Domain Structure list box expand the appropriate Domain and navigate to Services gt JDBC gt Data Sources A list of data sources will be populated on the right side c Select the appropriate Data Source and edit the connection details In this case both Config and Atomic data sources need to be modified 6 Restart the OFSAAI services B 2 25 Configure Java Virtual Machine While running several database intensive tasks in parallel fetching the database connection from connection pool may face an error To en
83. actionVariable name CONFIGDBUSER ID gt ofsaconf lt InteractionVariable gt Yes ABS_DRIVER_PATH Identifies the directory where the JDBC driver ojdbc6 jar exists This would typically be the SORACLE HOME jdbc lib For example InteractionVariable name ABS DRIVER PATH gt gt oradata6 revwb7 oracle lt InteractionVariable gt Yes OLAP_SERVER_ IMPLEMENTATION Identifies if the OFSAA Infrastructure OLAP component needs to be configured depending on whether you intend to use the OLAP feature The below numeric value should be set depending on the choice 2 YES 1 2 NO 0 No ARBORPATH HYPERION_HOME and ESSBASEPATH Note If value for OLAP_SERVER_IMPLEMENTATION is set to 1 it checks for following environment variables are set in profile SFTP_ENABLE Identifies if the SFTP Secure File Transfer Protocol feature is to be enabled The below numeric value should be set depending on the choice 2 SFTP 1 gt FIP 0 Yes Note The default value set is 1 as this release of the OFSAA Infrastructure mandates the SFTP service be up and running on the system where OFSAA Infrastructure would be installed For example InteractionVariable name SFTP_ENABLE gt 0 lt InteractionVariable gt FILE TRANSFER PORT Identifies the port used for the file transfer service The default value specified is 22 SFTP Specify value as 21 or any other PORT value if value for SFTP ENABLE is 0
84. allation Overview bee trei e denen o ta ub e f nre b ce ee dees 2 1 2 2 Hardware and Software Requirements and Specifications sss 2 2 2 3 Verifying the System Environment sese nennen nnne enne 2 4 2 4 Understanding Installation ModeS oocioncicicnnonionnnnnnnnonconoronnncnnnonoronnn cono roncnnnono no ron cn nennen 2 4 3 Preparing for Installation 3 1 Installer and Installation Prerequisites eese eee eene 3 1 3 2 Obtainirig the SO War Ein ie ede ine et deret ee idee e ice tere deer ien 3 3 3 3 Common Installation Tasks sese eene eene enne rnnt nnne tenent nenne 3 3 3 3 1 Identifying the Installation Directory sse een nnns 3 3 3 3 2 Configuration for GUI Mode Installation sse een 3 4 3 3 3 Copying and Extracting the Software sss eee nennen 3 4 Part Il Installation and Configuration 4 Installing OFSAA Infrastructure v 7 3 3 0 0 4 1 Silent Mode Installation iiie in ert tos eti f poe e ei es 4 1 4 1 1 Configuring OFSAAI InstallConfig xml and OFSAAI PostInstallConfig xml 4 1 4 1 2 Running the installer in Silent Mode sssssssssssssseeeene ee 4 1 4 1 3 Completing the installation in Silent Mode ssssssssseeeeee 4 2 4 2 GUT Mode Installation zn rene eee ete e ne deterrere cveds 4 7 5 Post Installation Configuration 5 1 Configuring Resource Reference
85. an Username Password 3 From the LHS menu Domain Structure click Services Data Sources The Summary of JDBC Data Sources window is displayed Figure 5 14 Summary of JDBC Data Sources ORACLE Weblogic Server Administration Console Me rone Log Out Prelerences E Record Help a Welcome manager Corrected to Mocksel a e Summary of IDEL Data Sources A TOC dite source le an cyst bound to the INDI tree that provides dat abune connectivity through a pocl of IDOC connections Acelicabos can look up amp dat source on the JNDI tree and thans borrow a databaue connection trom a data source Pa page marcas the DOC Gate source obaects that have been created n the doman P Customize thes table Data Seurces FHibered More Columns Exist Nm Orto Showang 110101 Previous fmit E me morem RN A Mer Dein Showing 1 to 19 1 Previous West Post Installation Configuration 5 11 Configuring Resource Reference 4 Click New and select Generic Data Source option The Create a New JDBC Data Source window is displayed You can also select GridLink Data Source or Multi Data Source while creating a Data Source For more information see Create GridLink Data Sourceor Configure Multi Data Sources Figure 5 15 Create a New JDBC Data Source Create a New JDBC Data Source Next Cancel JDBC Data Source Properties The followng properties wil be used to identify your new JOBC data source What would you like
86. an be integrated with other directory services software like MS Active Directory Notes Configuration of Directory services software for OFSAAI installation is optional For more information on configuration see Infrastructure LDAP Configuration Open LDAP needs to be installed on MS Windows Server machine only Desktop Requirements Operating System MS Windows XP SP3 Windows 7 Browser a MS Internet Explorer 8 9 Oracle Java plug in 1 6 0 21 Note Enable caching of static content static files images CSS etc Office Tools a MS Office 2003 2007 Adobe Acrobat Reader 8 or above Screen Resolution 1024 768 or 1280 1024 Multi Language Support MLS See Oracle Financial Services Analytical Applications Infrastructure Language Pack Guide in the Related Documents section for desktop settings related to multi language support 1 This indicates the latest version available at the time of the release Any latest updates may be applied Understanding OFSAA Infrastructure Installation 2 3 Verifying the System Environment OFSAAI recommends the following software combinations for deployment Table 2 3 Recommended Software Combinations Operating System Database Web Application Server Web Server Oracle Linux 5 3 up to Oracle Database 11g R2 Oracle WebLogic Server Oracle HTTP Server 5 8 6 0 and above 11 2 0 2 0 10 3 5 0 Apache HTTP Server Oracle Solaris 5 10 5 11 Oracl
87. ansfer sse B 2 4 Configuration for Dimension and Hierarchy Management sss B 2 4 1 Configure Member Deletion sse eene nennen B 2 4 2 Configure Attribute Default Date Format sees eee B 2 4 3 Configure Members Reverse Population sse eee B 2 4 4 Configure Hierarchy Reverse Population sss B 2 4 5 Configure Maximum Levels allowed in Hierarchies sss B 2 4 6 Configure Node Limit for a Hierarchy Tree B 2 5 BlowFish Algorithm Setting for Solaris 5 11 B 2 6 Configure Information Domain Schema Privileges sss B 2 7 Configure Infrastructure Server Memory sse eee nene B 2 7 1 Infrastructure Application Server Memory Settings sss B 2 7 2 Tomcat Memory 5etlings icoidenesotise tiere idee a b ede eer ago B 2 7 3 WebLogic Memory Settings sese eee eee enne B 2 7 4 WebSphere Memory Settings esses eee eene B 2 8 Internet Explorer Settings sese eene nnne nnnnen B 2 9 Retrieve Patch Details nme SERERE e ide Eee B 2 10 OLAP Data Server Configuration sssssesee eee eene vi B 2 11 Object Migration HTTPS URLConnection configuration for WebLogic B 20 B 2 12 Configure User Attributes Screen sss nennen nennen B 21 B 2 13 Configure Infrastructure Ports sse nnne B 21 B 2 14 Modit
88. ata source Step 1 Enter basic Summary data source information Summary of actions Step 2 Select JOBC Options Values provider T scope cells GXS150REV Zone2NodeOSCell nodes GXS150REV Step 3 Enter Zone2NodeOS servers serverl database specific F properties for the data source Data source name AtomT INDI name jdbc DRYMOCK Step 4 Setup Select an existing security aliases JDEC provider Oracle JDEC Driver Step 5 Summary name URL jdbc oracle thin 210 184 108 91 1521 0rel11gr2 Data store helper class name Implementation class eracle jdbc pool OracleConnectionPoolOataSource com ibm websphere rsadapter Oracle10gDataStoreHelper Use this data source in container managed true persistence CMP Component managed none authentication alias Mapping configuration enone alias die Container managed authentication alias Previous Finish Cancel none You can also create and map J2C authentication alias after creating the data source 13 You must create another Data source by following the above procedure with jdbc FICMASTER as JNDI name pointing to the configuration schema of Infrastructure 5 1 2 3 J2C Authentication Details The steps given below are applicable for creating both config and atomic J2C Authentication To create J2C Authentication details 1 Select the ne
89. ation the WAR file has to be created and deployed in Tomcat 5 20 OFSAA Infrastructure Installation and Configuration Guide Configuring Resource Reference 5 1 4 2 JDBC Connection Pooling To define the JDBC connection pooling do the following 1 Copy SORACLE_HOME jdbc lib ojdbc6 jar to the path TOMCAT DIRECTORY lib 2 Edit the server xml present under the path TOMCAT DIRECTORY conf with the below changes which is required for connection pooling Context path CONTEXTNAMES docBase APP DEPLOYED PATHS debug 0 reloadable true crossContext true Resource auth Container name jdbc INFODOM NAMES type javax sql DataSource driverClassName oracle jdbc driver OracleDriver username ATOMICSCHEMA USERNAMES S password ATOMICSCHEMA_ PASSWORDS url DBC CONNECTION URL maxActive 100 maxIdle 30 maxWait 10000 removeAbandoned true removeAbandonedTimeout 60 log Abandoned true gt lt Context gt Note the following a TOMCAT_DIRECTORY should be replaced by Tomcat application installed path a CONTEXTNAMES should be replaced by OFSAAI context name APP_DEPLOYED_PATHS should be replaced by OFSAAI application deployed path a INFODOM_NAMES should be replaced by Infodom Name ATOMICSCHEMA_USERNAMES should be replaced by Atomic schema database user name ATOMICSCHEMA_PASSWORD should be replaced by Atomic schema database password JDBC_CONNECTI
90. ation on generating and deploying EAR WAR file see Configuring Web Application Servers Restart the OFSAAI Services APP and WEB For more information see Start Stop Infrastructure Services chapter Note This setting will cache the Infodom metadata only for the infodoms that get accessed upon user login Infodoms which do not get accessed will not be cached Sample code is pasted below SERVICE CODE 20 CLASS com iflex fic metadata services MetadataServiceProvider NAME BMD SERVERID DEFAULT PATH LOGGERNAME UMMLOGGER LOGGERLEVEL 10 gt PARAMETERS PARAMETER NAME CACHE ON STARTUP VALUE 0 PARAMETER NAME BACKUP XML VALUE 1 PARAMETER NAME MAX BACKUP XML VALUE 2 PARAMETER NAME PC NONBI BI SWITCH VALUE 2048 PARAMETER NAME HIERARCHY NODE LIMIT VALUE 2000 PARAMETER NAME ALIAS CACHE SIZE VALUE 1000 PARAMETER NAME DATASET CACHE SIZE VALUE 2000 PARAMETER NAME MEASURE CACHE SIZE VALUE 2000 PARAMETER NAME HIERARCHY CACHE SIZE VALUE 2000 Appendix Frequently Asked Questions D 13 Error Dictionary PARAMETER NAME DIMENSION CACHE SIZE VALUE 2000 PARAMETER NAME HIERARCHYATTRIBUTE CACHE SIZE VALUE 10
91. ations For more information refer Appendix B 2 23 Clearing Application Cache section 5 1 Configuring Resource Reference Refer to the required section depending on your webserver configuration Configure Resource Reference in WebSphere Application Server Configure Resource Reference in Weblogic Application Server Configure Resource Reference in Tomcat Application Server 5 1 1 Configure Resource Reference in Infrastructure Web Application The web xml file has to be updated with the Information Domain name as the resource reference name This is required for connection pooling with the Information Domain database schema 5 1 1 1 Configure web xml The web xml file has to be updated with the Information Domain name as the resource reference name An Information Domain refers to a specific area of analysis which consists of stored data models with the related Technical and Business data definitions for processing 1 Navigate to FIC WEB HOME webroot WEB INF 2 Add the Information Domain name in the following block of text at the end of the web xml file resource ref res ref name jdbc INFODOM NAME gt lt res ref name gt res type javax sql DataSource res type res auth Container res auth Post Installation Configuration 5 1 Configuring Resource Reference resource ref Here INFODOM NAME is the name of the Information Domain that you will create
92. ayers and their Significance siaa ea ee eh el aeree aara rE S aeia A 8 Interaction Variables and Expected Values A 8 optimized memory settings required for New model upload B 12 Member Deletion Configuration sssssssssseeeeeee eene enhn nns B 14 Attribute Default Date Format eese nennen enne ethernet three nnne enne enn B 14 Members Reverse population seen nnne nennen B 14 Hierarchy Reverse population sse nnns B 14 Hierarchy Maximum level allowed sse eee enn B 14 Hierarchy Ireemode Mitin eet eee ree ete eene B 15 INEODOM PATCEIS table iii eds et re t ee eet peer e e ee en gn B 19 CSSMS ATTRIB MAST table ineine rie a i hiii iaeei inari B 21 Configuration Schemas icc see eed te tee end teet e eras B 25 WEBBSBRVIGE t ag 1a ite estes case uct met reote laete e ibn m IRE Red B 29 OPERSTION tAE aate titre eene tee eere er nre e eere e Ae nee err ee di ers B 30 II UH INT HM HER B 30 OUTPUT tagaien eet bi egeret et E e Ee ted PD Pe eat has D rios B 30 Notification Gontig ete File na ete eco e ET ertet detis B 33 Summary Audience Preface This Preface provides supporting information for the Oracle Financial Services Analytical Applications Infrastructure Installation Guide and includes the following topics Summary Audience Documentation Accessibility Related Documents a Conventions You can find
93. ce The JNDI and Data Source name are case sensitive and ensure that JNDI name is same as the Information Domain 7 Click Next The Select JDBC provider window is displayed Figure 5 7 Select JDBC provider Create a data source Create a data source Specify a JDBC provider to support the datasource If you choose to create a new JDBC 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 o Create new JDBC provider Select an existing JOBC provider Oracle JDBC Oriver iM 8 Select the option Select an Existing JDBC Provider and select the required JDBC provider from the drop down list Click Next 5 6 OFSAA Infrastructure Installation and Configuration Guide Configuring Resource Reference Figure 5 8 Enter database specific properties Create a data source Set these database specific properties which are required by the database vendor JOBC driver to support the connections that are managed through the datasource Name Value URL 0 184 108 91 1521 0rcl11g Data store helper class name Oraclez1g data store helper Y E Use this data source in container managed persistence CMP 9 Specify the database connection URL URL format jdbc oracle thin lt DB_SEREVER_IP gt lt DB_SERVER_PORT gt lt SID gt 10 Select Data Store
94. com lt InteractionVariable gt A 2 OFSAA Infrastructure Installation and Configuration Guide OFSAAI InstallConfig xml and OFSAAI_PostinstallConfig xml Parameters Table A 2 Cont OFSAA Infrastructure Installation Tasks and Descriptions InteractionVariable Name Significance and Expected Value Mandatory Note The parameter value should be the same specified for OFSAAI APP LAYER IP and OFSAAI DB LAYER IP DBSERVER IP Identifies the hostname or IP address of the system on which the Database Engine is hosted Note For RAC Database the value should be NA For example InteractionVariable name DBSERVER 1P gt 14 15 16 17 lt InteractionVariable gt or InteractionVariable name DBSERVER IP gt dbhost server com lt InteractionVariable gt Yes JDBC_URL Identifies the JDBC URL that will be used for the query executions This release of the OFSAA Infrastructure supports both RAC and NON RAC enabled database connectivity Syntax lt InteractionVariable name JDBC_ URL gt jdbc oracle thin HOST PORT SID lt InteractionVariable or InteractionVariable name JDBC URL jdbc oracle thin Q HOST PORT SER VICE InteractionVariable or InteractionVariable name JDBC URL jdbc oracle thin 8 DESCRIPTION ADDRE SS LIST ADDRESS PROTOCOL TCP HOST HOST port PORT ADDRESS PROTOCOL TCP HOST HOST PORT POR
95. ctive parameter entry can be removed commented off form the OracleDB conf file which resides in the path FIC_ DB_HOME conf As of now the OracleDB conf file has only one parameter namely CNF_DEGREE_OF_ PARALLELISM This parameter indicates the degree of parallelism to be used for a DML operation if parallel DML is explicitly enabled in the session with the ENABLE PARALLEL DML clause of the ALTER SESSION statement The default mode of a session is DISABLE PARALLEL DML If CNF DEGREE OF PARALLELISM is not set then the default degree as decided by Oracle will be used B 2 22 Configure Message Details in Forms Designer You can configure the Message Details in Forms Designer under Data Entry Forms and Queries module by updating the details of mail server in the NotificationConfig cfg file which resides in the path FIC APP HOME common FICServer conf Ensure that the authorized User details for whom you need to configure the Message details are included in Administration gt Security Management gt User Administrator gt User Maintenance window Update the following parameters in the NotificationConfig cfg file Table B 15 NotificationConfig cfg File Parameter Description SMTP SERVER IP Specify the hostname or IP address of SMTP Server SMTP DEBUG MODE To run SMTP service in Debug mode set value to true otherwise set value to false SMTP AUTHORIZATION Set to true if SMTP server requi
96. cture Installation and Configuration Guide GUI Mode Installation 21 Enter Java Port Native Port Agent Port ICC Server Port and ICC Native Port You can proceed with the defaut port values configured 22 Click Next The Ports Configuration window is displayed Figure 4 21 Ports Configuration Ports Configuration License Enter requested information Prelnstall Setup Note Ports must have unique value O Installation Y Install Complete OLAP Pont 10101 Message Server Port 6501 Router Port 6500 ORACLE AM Port FINANCIAL SERVICES es 05 InstallAnywhere 23 Enter OLAP Port Message Server Port Router Port and AM Port 24 Click Next The Default Infrastructure Administrator and Authorizer User Password window is displayed Figure 4 22 Default Infrastructure Administrator and Authorizer User Password Default Infrastructure Administrator and Authorizer User Password License Enter requested information Prelnstall Setup Installation Please enter password for default Infrastructure administrator user SYSADMN Install Complete Please re enter password for default Infrastructure administrator user SYSADMN 99999999 Please enter password for default Infrastructure authorizer user SYSAUTH ORACLE Please re enter password for default Infrastructure FINANCIAL SERVICES authorizer user SYSAUTH 25 Enter the passwords for default System
97. d in the JI e section prior to proceeding with the next steps 1 Log in to the system as non root user 2 Identify a directory for installation and set the same in the user profile file as below set FIC HOMI export FIC HOME E lt ofsaa_install_dir gt im 3 Execute the user profile 4 Run the installer in GUI Mode setup sh GUI 5 Enter the OFSAAI Config schema user name password and Oracle SID Service name when prompted as shown in the following figure Figure 4 6 Validating the installation Installing OFSAA Infrastructure v 7 3 3 0 0 4 7 GUI Mode Installation Figure 4 7 Initialization Window ORACLE FINANCIAL SERVICES Copyright 1993 2014 Oracle and or its affiliates All rights reserved Figure 4 8 License Agreement License Agreement License Welcome to the OFSAAI Installation O Prelnstall Setup This program will guide you through the installation Installation of OFSAA Infrastructure Install Complete am tall amp Copyright 1993 2014 Oracle and or its affiliates All rights reserved 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 ORACLE broadcast modify license transmit distribute FINANCIA
98. database setup that is with or without RAC Click Next Figure 5 17 Transaction Options Create a New JDBC Data Source Back Next Cancei Transaction Options You have selected non XA JOBC driver to create database connecton n your new data source Does this data source support giobal transactons If yes please Choose the transacton protocol for ths data source v Supports Global Transactions Select this option of you want to enable non XA JOBC connectons from the date source to parbopate in global transactions using the Logging Lest Resource QLR transaction optmizaton Recommended n place of Emulate Two Phase Commit Logging Last Resource ct this option if you want to enable non XA 208 connectons from the data source to emulate parbcpaton in global transactions using ITA Select Sys opbon only if your application can tolerate heuristic conditons O Emulate Two Phase Commit Select this option if you want to enable non XA JOBC connectors from the data source to participate in giobal transactions using the one phase commit transaction processing Wish this opson no other resources can partopate n the gobs transacton One Phase Commit Back Next Cancel 7 Select the Supports Global Transactions checkbox and the One Phase Commit option 8 Click Next The Connection Properties window is displayed Figure 5 18 Connection Properties Create a New JDBC Data Source Back Next Cance Connection Properties Defi
99. date the appropriate Source details a If you are using Apache Tomcat as Web server Update the Context gt Resource tag details in server xml file from the SCATALINA_HOME conf folder In case of Tomcat only Atomic lt Resource gt will exist If you are using WebSphere as Web server Login to the WebSphere Administration Console from the left side menu Navigate to Resources gt JDBC gt Data Sources A list of data sources will be populated on the right side Select the appropriate Data Source and edit the connection details In this case both Config and Atomic data sources need to be modified If you are using WebLogic as Web server Login to the WebLogic Administration Console from the left side menu Under Domain Structure list box expand the appropriate Domain and navigate to Services gt JDBC gt Data Sources A list of data sources will be populated on the right side Select the appropriate Data Source and edit the connection details In this case both Config and Atomic data sources need to be modified 4 Restart the OFSAAI services Note If the modified passwords are not updated OFSAAI logs displays the message ORA 28000 the account is locked Does the upload of Business Data model depend on Java Memory Business data model upload through OFSAAI depends on the Java memory settings on the client and server machines Java memory setting varies with the data model size and the ava
100. 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 Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International Inc AMD Opteron the AMD logo and t
101. e Database 11g R2 Oracle WebLogic Server Oracle HTTP Server 11 2 0 2 0 10 3 5 0 Apache HTTP Server IBM AIX 5 3 6 1 Oracle Database 11g R2 IBM WebSphere IBM HTTP Server 11 2 0 2 0 Application Server Apache HTTP Server 7 0 0 17 2 3 Verifying the System Environment To verify your system environment meets the minimum requirements for the installation a Pre Install Check utility is available within the Install Kit archive file This utility can also be obtained separately by contacting Oracle Support Though the system environment verification is an integral and automated part of the installation of this software product Oracle strongly recommends running this utility prior to beginning the installation as part of your organization s Installation Readiness Verification Process Note For more details on download and usage of this utility see Oracle Financial Services Analytical Applications Infrastructure Environment Check Utility Guide given in the Related Documents section 2 4 Understanding Installation Modes OFSAA Infrastructure installation supports two modes of installation Silent Mode Installation Non GUI mode This mode requires configuring the product xml files and following simple instructions at the command prompt Graphical User Interface GUI Mode Installation This mode launches the product installation in a GUI mode Users need to enter the required information on various panels with
102. e below numeric value should be set depending on the choice 2 YES 1 NO 0 For example lt InteractionVariable name INSTALL_ SAMPLEAPP gt 0 lt InteractionVariable gt Note If you intend to install the SAMPLEAPP refer Database User Schema section for prerequisites on installing the SAMPLEAPP 3 This parameter value cannot be 1 if the value for POST INSTALL is set to 0 Layer name OFSAAI DB_LAYER gt Note The below ports are used internally by the various OFSAA Infrastructure services The default values mentioned below are set in the installation If you intend to specify a different value update the parameter value accordingly and ensure this port value is in the range of 1025 to 65535 and the respective port is enabled JAVAPORT 9999 Yes NATIVEPORT 6666 Yes AGENTPORT 6510 Yes ICCPORT 6507 Yes ICCNATIVEPORT 6509 Yes OLAPPORT 10101 Yes MSGPORT 6501 Yes ROUTERPORT 6500 Yes AMPORT 6505 Yes Layer name OFSAAI_ WEB_LAYER gt Appendix OFSAAI InstallConfig xm A 5 OFSAAI InstallConfig xml and OFSAAI PostlnstallConfig xml Parameters Table A 2 Cont OFSAA Infrastructure Installation Tasks and Descriptions InteractionVariable Name Significance and Expected Value Mandatory HTTPS ENABLE Identifies if the UI should be accessed using HTTP or HTTPS scheme The default value set is 0 The below numeric value should be set depend
103. e following apphcation If you do not want to remove the appications cick Cancel to return to the previous page Name AIXGAST 2E 6 Click OK to confirm 7 Click Save to save the master file configuration 8 2 OFSAA Infrastructure Installation and Configuration Guide Uninstalling EAR Files in WebLogic 8 3 Uninstalling EAR Files in WebLogic On the machine that hosts WebLogic perform the following steps to uninstall any previously deployed application 1 Open the URL in the browser window http lt ipaddress gt lt admin server port gt console https if SSL is enabled The Login window of the WebLogic Server Administration Console is displayed 2 Login with the WebLogic user credentials having administrator privileges 3 From the Domain Structure LHS menu click Deployments The Summary of Deployments screen is displayed Figure 8 4 Summary of Deployments Summary of Deployments Control Monitoring This page displays a list 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 dick the Install button V Customize this table Deployments instal Update Delete start y Showing 1to 1of1 Pr
104. e of the data to be loaded in the CSSMS_ATTRIB_MAST table is given below Table B 9 CSSMS_ATTRIB_MAST table ATTRIBUTE ID ATTRIBUTE DESC ALLOWED VALUES T YPE PH Phone Number 0 HT Home Town Bangalore Mumbai Delhi Chennai fl MGR Manager select case when v usr id 2 lt USER gt then null else v_usr_id end v usr name from cssms_usr_ profile Here ALLOWED VALUES column holds the values that can be specified for the attribute and TYPE specifies how to get the allowed values The values that can be specified in the TYPE column are as follows 0 USER INPUT 2 1 Comma Separated Values 2 Execute the SQL select query in ALLOWED VALUES column to get the list of allowed values The query should select two columns the first of which will be the actual values and the second the description which will be displayed in the select list lt USER gt should be replaced with a valid Infrastructure user id B 2 13 Configure Infrastructure Ports This step is applicable only in the event you wish to change any of the ports used by Infrastructure services after the installation process The ports that are used by the Infrastructure application are distributed across the machines on which Infrastructure Web Application and Database components have been installed Therefore you must perform the port changes on all the machines on which Infrastructure components have been installed PortC jar can
105. e the changes within the data model with respect to the one already present in the system and enables propagation of incremental changes in a consistent manner What are the different types of uploading a business data Model OFSAAI supports uploading of business data model from client desktop and also by picking up the data model from the server location Can the OFSAAI Configuration Schema password be modified post installation The OFSAAI configuration schema password can be modified post installation OFSAAI application stores the password in the database and few configuration files thus any changes to the configuration schema password would necessitate updating in these Contact OFSAAI support for more details D 10 OFSAA Infrastructure Installation and Configuration Guide Frequently Asked Questions Can the OFSAAI Atomic Schema password be modified The OFSAAI Atomic Schema password can be modified OFSAAI application stores the atomic schema password in the database and few configuration files thus any change to the atomic schema password would necessitate updating the password To change the Atomic Schema password follow the steps 1 Login to OFSAA 2 Navigate to System Configuration gt Database Details window Select the appropriate connection provide the modified password and save 3 Navigate to Unified Metadata Manager gt Technical Metadata gt Data Integrator gt Define Sources window Up
106. eb components are installed under FIC WEB HOME directory Note This process overwrites any existing version of EAR file that exists in the path 5 2 1 2 Deploy WebSphere EAR Files To deploy Infrastructure application in WebSphere 1 Start WebSphere Profile by navigating to the path Websphere Installation Directory IBM WebSphere AppServer profiles Profile Name bin and execute the command startServer sh serverl Open the following URL in the browser http ipaddress Administrative Console Port ibm console https if SSL is enabled The login screen is displayed 5 22 OFSAA Infrastructure Installation and Configuration Guide Configuring Web Application Servers Figure 5 29 Login Window Integrated Solutions Console Log in to the console User ID upgs73 Password Errr L tes in pe iA pz Pat hy ewe 4 3 Enter the user credentials which has administrator rights and click Log In 4 From the LHS menu select Applications and click New Application The New Application window is displayed Figure 5 30 New Application New Application New Application This page provides links to create nev applications of different types Install a New Application ce New Enterprise Application 5 Click New Enterprise Application The Preparing for the application installation window is displayed Post Installation Configuration 5 23
107. ely before starting the next server 1 Onthe machine in which Infrastructure Application components have been installed navigate to FIC APP HOME common FICServer bin and execute the following command to start the Infrastructure Server reveleusstartup sh Note the following a When starting the server for the first time it must be done in the foreground to answer prompts Enter the password of the Oracle Configuration Schema when it prompts for a system password This password is asked only for the first time of starting Infrastructure server Ifthe Oracle Configuration Schema password is changed delete the Reveleus SEC file under FIC HOME conf and start the server When saving Database Server Details during Infrastructure Configuration the Infrastructure server must also be started in the foreground do not use nohup to answer the following prompt which appears in the Unix server command on Save The host 10 123 45 678 is currently unknown to the system The host key fingerprint is 1023 le 35 46 7f 81 e7 16 6b 33 e8 59 f7 d cf 5b bl Do you want to allow this host key Yes No Always Always should be entered when prompted and Save operation will complete successfully in the Database Server Details screen a You can also start the Infrastructure Server by executing the command nohup reveleusstartup sh amp Starting the process using nohup and amp will return Start Stop Infrastructure Services 6
108. entries in the profile file will have to be removed manually a The files folders under the file system staging area ftpshare have to be deleted manually a All the Database objects from Atomic Schemas have to be dropped manually 8 2 Uninstalling EAR Files in WebSphere Following are the steps to uninstall any previously deployed application 1 Open the URL in the browser window http ipaddress Administrative Console Port ibm console https if SSL is enabled The Login window is displayed 2 Login with the user id that has admin rights 3 Expand Applications Application Types WebSphere enterprise applications from the LHS The Enterprise Applications window is displayed with all the deployed applications Figure 8 2 Enterprise Applications Enterprise Applications 4 Enterprise Applications Use this page to manage installed applications A single application can be deployed onto multiple servers E Preferences Start Stop Install Uninstall Update Rollout Update Remove File export Export DDL Export File us Select Name Application Status 9 You can administer the following resources E DefaultAsslication O ivtApo o guery o se g lsa Total 4 4 Select the checkbox adjacent to the application to be uninstalled and click Stop 5 Click Uninstall The Uninstall Application window is displayed Figure 8 3 Uninstall Application Cick OK to remove th
109. es and restarts Configuration editing is enabled Future changes will automatically be activated as you modify add or delete items in this domain Domain Structure upg7273 amp Environment Deployments Services Security Realms Interoperability Diagnostics How do L System Status Welcome upg7273 Connected to upg7273 M Home Log Out Preferences Record Help a Home gt Summary of Deployments Summary of Deployments Control Monitoring This page displays a list 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 dick the Install button V Customize this table Deployments Showing 1to 1of 1 Previous Next Fo IN mmo Jostal Showing 1to 1of1 Previous Next 6 Click Install The Install Application Assistant window is displayed 7 Select the Exploded EAR directory after browsing to the directory where it is saved and click Next Explode EAR To explode EAR follow the below steps 1 Create the applications folder under domain name For example Bea user_ projects domains Domain name applications 2 Create context name ear folder under
110. essage is displayed and you will be returned to the prompt 6 The EAR file contextname 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 file in the path 5 2 2 2 Deploy EAR WAR file for WebLogic Following are the steps for deploying Infrastructure application that would be created during installation 1 Navigate to the path lt WebLogic Installation directory user projects domains domain name bin in the machine in which WebLogic is installed 2 Start WebLogic by executing the command startWebLogic sh d64 file 3 Open the URL in the browser window http lt ipaddress gt lt admin server port console https if SSL is enabled The Sign in window of the WebLogic Server Administration Console is displayed Note Ensure that you have started Infrastructure Server by executing reveleusstartup sh as mentioned in Start Infrastructure section 4 Logon to the WebLogic Server by entering the user credentials having privileges to deploy the EAR file Post Installation Configuration 5 29 Configuring Web Application Servers 5 From the Domain Structure LHS menu click Deployments The Summary of Deployments window is displayed Figure 5 39 Summary of Deployments ORACLE WebLogic Server Administration Console Change Center View chang
111. evious Next instal Update Delete Start Stop y Showing ito 1of1 Previous Next 4 Select the checkbox adjacent to the application to be uninstalled and click Stop Force Stop Now 5 Click Yes in the confirmation dialog to stop the selected deployment Figure 8 5 Summary of Deployments Messages Messages Y Selected Deployments have been requested to stop Summary of Deployments Control Monitoring This page displays a list 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 dick the Install button V Customize this table Deployments ostat Showing 1to 1of1 Previous Next qoo o epp de instal Showing 1to 1of1 Previous Next Uninstalling OFSAA Infrastructure 8 3 Uninstalling WAR Files in Tomcat Select the checkbox adjacent to the application and click Delete to delete the selected deployment Click Yes in the confirmation dialog to remove the selected deployment from the domain configuration 8 4 Uninstalling WAR Files in Tomcat On the machine that hosts Tomcat perform the following steps to uninstall any previously deployed application 1 Comment out Context path section from
112. fers to the username 2 lt uploadmode N R AM AP Refers to the Upload Choice Code 2 N Refers to the New Model Upload R Refers to the Complete Model Rebuild Upload 2 AM Refers to the Incremental Model Upload 2 AP Refers to the Sliced Model Upload 2 runscriptsFlag Refers to the running of SQL Script 2 true Updates the database schema with the Model changes 2 lt false gt Does not update the database schema with Model changes 2 Execute the script using the command upload sh Note Ensure that you are provided with the execute permission Logs are updated in regular Model Upload log at ftpshare infodom logs infodom LOG last data model version lt MM DD YYYY gt lt HH MM SS gt log Note During incremental model upload when the uploadmode is set as AM some of mappings done in Data Integrator may get invalidated You are required to save these mappings again B 2 2 2 Model Upload Details Some Java settings need to be configured while uploading the data model with various sizes of xml files This can be done by 2 Picking from the server 2 Model Upload Utility gt Browsing the file in the local computer These Java settings differ depending on the availability of RAM You have to ensure that the Default and Temporary table space assigned to Oracle user is allocated with Appendix Webserver Configuration for Infrastructure Application B 11 Additional Config
113. file TARGETNAMESPACE The attribute value for the targetNamespace of the wsdl definitions tag XMLNS_XSD The attribute value for the xmlns s of the wsdl definitions tag SENCODINGSTYLE The attribute value for the xmlns soapenc of the wsdl definitions tag SSERVICENAME Name of the service found under the wsdl service name tag of the wsdl file SPORTTYPENAME wsdl port type name as mentioned in the wsdl file SESSION MAINTAIN PROPERTY This could be given as also SUSERNAME User name to access the web services Enter if no user name is required PASSWORD Password to access the web services Enter if no password is required SWEBSERVICESTYLE This can take either rpc in case of DII mode of invoking web services or stub in case of static mode This is a mandatory parameter STUBIMPLEMENTATION Fully qualified class name package name classname Attributes for OPERATION tag Ensure that the operation tag Appendix attributes are repeated for each of the operation tags Webserver Configuration for Infrastructure Application B 29 Additional Configurations Table B 12 OPERSTION tag Placeholder Description CODE Should be unique within the Webservice tag SNAME The name of the Function that is to be called by the wsdl file SOAPACTION The URL for the Operation to access This is associated with the Operation tag of the wsdl file SSTYLE This can take rpc if the web serv
114. frastructure FTP SFTP password 9999999 ORACLE FINANCIAL SERVICES 32 Enter the path of the ftpshare directory and the User Id and password for OFSAAI Server Note The transfer of data files between the OFSAAI Server and the Web Application Server happens over FTP SFTP Ensure the necessary host configurations are made for a successful handshake 33 Click Next The Sample Application Installation window is displayed Figure 4 26 Sample Application Installation Sample Application Installation License Do you want to install Sample Application Prelnstall Setup Installation Y Install Complete ONO YES ORACLE FINANCIAL SERVICES Installing OFSAA Infrastructure v 7 3 3 0 0 4 17 GUI Mode Installation 34 Select Yes if you want to install Sample Application Note Ensure the appropriate DB schemas are created for holding the Sample Application data See Database User SchemaDatabase User Schema Database User Schema section 35 Click Next The Pre Installation Summary window is displayed Figure 4 27 Pre Installation Summary Pre installation Summary License Please review the following before continuing Prelnstall Setup Installation Product Name OFSAAInfrastructure Install Complete Version 7 3 3 0 0 Installation Folder Iscratch ofsaadb OFSAAI Required Space 990 MegaBytes ORACLE Available Space NANA ARIAS 57849 MegaBytes FINANCIAL SERVICE
115. ftware re Foundation ww apache org Tomcat Web Application Manager List Applications Sawer Status Start Siop Reload Undeploy Expire sessions we oea 30 Jmnures 5 Click the Undeploy link against the deployed Infrastructure application A confirmation message is displayed on the application Infrastructure being uninstalled Uninstalling OFSAA Infrastructure 8 5 Uninstalling WAR Files in Tomcat 8 6 OFSAA Infrastructure Installation and Configuration Guide A Appendix OFSAAI InstallConfig xml A 1 OFSAAI InstallConfig xml and OFSAAI_PostinstallConfig xml Parameters Prior to installing the OFSAA Infrastructure v7 3 3 0 0 in SILENT mode it is mandatory to update the OFSAAI_InstallConfig xml and OFSAAI PostInstallConfig xml files This section details the various parameters available in the OFSAAI _ InstallConfig xml and OFSAAI PostInstallConfig xml files and the values that need to be updated A 1 1 OFSAAI InstallConfig xml The OFSAAI InstallConfig xml file is one of the core files of the installation process and it is mandatory to update this file prior to the installation The OFSAAI InstallConfig xml is organized into multiple sections called layers with each Layer divided into InteractionGroups Each lt InteractionGroup gt contains one or more lt InteractionVariable gt parameters Note Itis mandatory to retain all the layers and their internal elements
116. fy the metadata which is being updated refreshed beyond the specified cache size limit Accordingly increase the cache size limit in Dynamicservices xml depending on the currently logged count for the specific metadata For example if the MEASURE CACHE SIZE is set to 1000 and total measure reported in log is 1022 increase the limit to 2000 approximately 4 Restart Reveleus OFSAAI servers Web and APP and check the issue What should I do if I get OutOfMemoryError while deploying EAR file in WebSphere application server The Java memory needs to be increased in ejbdeploy sh file which is present under WebSphere Install directory AppServer deploytool itp For example SJAVA_CMD Xbootclasspath a ejbd bootpath Y Xms256m Xmx1024m What configurations should I ensure if my data model size is greater than 2GB In order to upload data model of size greater than 2GB in OFSAAI Unified Metadata Manager Import Model you need to configure the required model size in struts xml file available in the path FIC WEB HOME webroot WEB INF classes Note The size requirements have to be always specified in bytes For example if you need to configure for model size of 2 5GB then you can approximately set the max size to 3GB 3221225472 bytes as indicated below in order to avoid size constraints during model upload constant name struts multipart maxSize value 3221225472 gt After configuring struts xml
117. g enterprise applications and modules Specify the virtual host vhere you want to install the Web modules that are contained in your application You can install Web modules on the same virtual host or disperse them among several hosts EJ Apply Multiple Mappings eu v OFSAAI Web Application Summary 13 Select the Web Application check box and click Next The Summary page is displayed Figure 5 37 Summary Install New Application Specify options for installing enterprise applications and modules Step 1 S installation options Summary of installation options Step 2 Map modules to servers Options Precompile JavaServer Pages files No Directory to install application Distribute application Yes Map virtual Use Binary Configuration No Neb Deploy enterprise beans Yes Application name Create MBeans for resources Yes Override class reloading settings for Web and EJE modules Reload interval in seconds Deploy Web services No Validate Input off warn fail warn Process embedded configuration No File Permission dll 755 s0 755 a 755 sl 755 Application Build ID Unknown Allow dispatching includes to remote resources No Allow servicing includes from remote resources Business level application name Asynchronous Request Dispatch Type Disabled Allow EJB reference targets to resolve automatically No
118. he AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices UNIX is a registered trademark of The Open Group This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates 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 POCO AA E EAS xi SUMMAITY sensacional lalala diaria xi AU te eran ee ado Sst xi Documentation Accessibility ein dene eed nete rude ne Pe E eer e rit Ee nd Xi Related Documents a eiie et t iS xii Conventions ennn ee EE diee Eee Er d Ene gen ea p rc E La Ee ER e E EE e dp oe EP La Ie Ded ip da Xii Organization of the Guide ette teet Eat secet ec irte read xiii Part Introduction and Preparation 1 Understanding OFSAA Infrastructure 1 1 Whatis OESAA2 4 o eee nere pet E ree Eee i ee eere eed 1 1 1 2 What is OFSAA Infrastructure esee i trennen erret tnter serene ensis 1 1 1 3 OFSAA Infrastructure Components sese eene nennen nennen nnne tenens 1 2 1 4 OFSAA Infrastructure High Availability eese eene 1 2 2 Understanding OFSAA Infrastructure Installation 2 1 Inst
119. he wizard fills in the name and the description fields but you can type different information values Step 3 Summary Scop cells GXS150REV Zone2NodeOSCellinodes GXS150REV iZone2Node05 5s serveri Database type Oracle Mi Provider type s Oracle JDBC Driver A Implementation type Connection pool data source x Name Oracle JDBC Driver J Description 6 Enter the following details Database Type Oracle Provider Type Oracle JDBC Driver Implementation Type Connection pool data source a Name The required display name for the resource Description The optional description for the resource 7 Click Next Post Installation Configuration 5 3 Configuring Resource Reference Figure 5 3 Enter database class path information Create a new JDBC Provider Create a new JDEC Provider Set the environment variables that represent the JOBC driver class files which WebSphere R Application Server uses to define your JDBC provider This wizard page displays the file names you supply only the directory locations of the files Use complete directory paths when you type the JDEC driver file locations For example Cr SQLLIEB java on Windows 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 ojdbce jar which is saved as WebSphere variable ORACL
120. hen _RUNJDB SJAVA_HOME bin jdb Change it to Set standard commands for invoking Java RUNJAVA SJAVA BIN java if os400 true then _RUNJDB JAVA_BIN 3jdb If the Tomcat server is already running it requires a re start after the above configuration is done 5 36 OFSAA Infrastructure Installation and Configuration Guide Configuring Web Application Servers 5 2 3 4 Configure Servlet Port The Servlet Port specified during the Infrastructure installation process must be configured if your Web Application Server is Tomcat If you are using the default port 8080 then you are not required to configure the same since it is already configured If you are using a different port number you must first configure the port in the server xml in the conf directory of Tomcat Installation directory The following steps guide you through the configuration process 1 Navigate to SCATALINA HOME conf Open server xml and locate the tag Define a non SSL HTTP 1 1 Connector on port 8080 2 Against this tag a parameter is specified Connector port 8080 Edit this value to the new port number that was used during the Infrastructure installation process 3 Save your changes in server xml 5 2 3 5 Create Tomcat WAR Files The WAR files are required to assemble servlets jsp files web pages and other static content into a deployable unit The following steps will guide you through the WAR files crea
121. hlighted as indicated below Figure 8 23 Error Dictionary Error code OFSAAI 1003 Cause JAVA HOME bin not found in PATH variable Resolution Import JAVA HOME bin into PATH variable Example PATH SJAVA_HOME bin SPATH export PATH View the details of the issues its cause and resolution specific to the error code Repeat the step to find an answer to any other errors that you notice during installation If you are not able to resolve the issue even after following the steps provided in resolution you can contact support oracle com along with log files and appropriate screen shots D 14 OFSAA Infrastructure Installation and Configuration Guide Error Dictionary D 2 2 Error Code Dictionary Error code OFSAAI 1001 Cause Unix shell is not korn shell Resolution Change the shell type to korn Use chsh unix command to change SHELL type Shell type can also be changed by specifying shell path for the Unix user in etc passwd file Note chsh command is not available in Solaris OS Error code OFSAAI 1002 Cause No proper arguments are available Resolution Provide proper arguments Invoke Setup sh using either SILENT or GUI mode Example Setup sh SILENT or Setup sh GUI Error code OFSAAI
122. ices invoking is in DII mode or stub if it is in static mode This is a mandatory parameter PACKAGENAME Represents the JAXB package of input object Attributes for INPUT tag Table B 13 INPUT tag Placeholder Description SORDER The sequential number of the INPUT tag Should start from 0 This is in line with the input order of the arguments that the API accepts which is called by this operation PARAMNAME Input parameter name to be called by the wsd file SARGTYPE Input Parameter Data Type If the input argument type is complex object specify SARGTYPE as xmlstring SCLASSNAME Represents class name of input object parameter Attributes for OUTPUT tag Table B 14 OUTPUT tag Placeholder Description PARAMNAME Output parameter name to be returned by the web service SRETURNTYPE Output parameter Data Type If the web service response is a complex object then specify SRETURNTYPE as object SCLASSNAME Represents class name of output object parameter B 2 19 2 web xml Entries Navigate to lt OFSAAI Installation Directory gt EXEWebService lt WebServer gt ROOT WI explained below Entry for WSConfig File The WSCONFIG file DynamicWSConfig xm1 is available in the WebServer Deployment EXEWebService ear EXEWebService war conf directory This file can be Path gt placed in any directory that is accessible by the applicat
123. ilable RAM Contact OFSAAI support for more details Why do the Business Metadata Management screens Business Processors screen in User Interface takes longer time to load The Log file in DynamicServices xml which resides in FIC HOME conf is continuously being updated refreshed to cache meta data This can be observed when you are starting reveleusstartup sh andif any of the log file Ex SMSService log in DynamicServices xml is being continuously refreshed for longer time Appendix Frequently Asked Questions D 11 Frequently Asked Questions By default the Metadata Log file cache size is set to 1000 If in case the log is being updated beyond this limit retrospectively the preceding entries are overwritten For example the 1001th entry is overwritten by deleting the first entry This results in the application screen taking a longer time to load Increase the cache size limit in Dynamicservices xml located at lt FIC_HOME gt conf depending on the currently logged count for the specific metadata 1 Generate the Log report by executing the below query in config schema select count 1 t metadata name m dsn id from metadata master m metadata type master t where m metadata type t metadata type group by t metadata name m dsn id 2 The above query returns a list of codes with their respective metadata count You can refer to metadata type master table to identify the metadata name 3 View the log report to identi
124. in the UI 2 4 OFSAA Infrastructure Installation and Configuration Guide 3 Preparing for Installation This chapter provides necessary information to review before installing OFSAA Infrastructure v7 3 3 0 0 components It includes the following topics Installer and Installation Prerequisites Obtaining the software Common Installation Tasks 3 1 Installer and Installation Prerequisites Table 3 1 mentions the list of prerequisites required before beginning the installation for OFSAA Infrastructure The Installer EnvCheck utility will notify you if any requirements are not met Preparing for Installation 3 1 Installer and Installation Prerequisites Table 3 1 Prerequisite Information Category Sub Category Expected Value Environment User Permission a User to have 755 permission on the directory Settings identified for installation FIC HOME Note Required only in GUI mode User to have 755 permission on the profile file Java Settings a PATH in profile to be set to include the Java Runtime Environment absolute path Note Ensure the absolute path to JRE bin is set at the beginning of PATH variable For example PATH usr java jrel 6 bin ORACLE_ HOME bin PATH Oracle Database Settings a TNS ADMIN to be set in profile pointing to appropriate tnsnames ora file a ORACLE HOME to be set in profile pointing to appropriate Oracle Client installation a PATH in profile t
125. ing block of text with the appropriate values Note DSNID refers to Information Domain name dn DSNID DSN ID ou Domains GLDAP DIRECTORY ROOTCONTEXTG changetype add mappedsegments lt Mapped segments gt dsnid lt DSN ID gt infodomname lt Information Domain Name gt objectClass Infodom objectClass top infodomdescription lt Information Domain Description gt Example dn DSNID FUSIONMOCK ou Domains dc FTP1 dc com mappedsegments dsnid FUSIONMOCK infodomname FUSIONMOCK objectClass Infodom objectClass top infodomdescription FUSIONMOCK B 26 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations Then navigate to LDAP installation directory and execute the command D ROOTDN w ROOTPASS f data Domains ldif Note Youcan add entries for multiple Information Domains at the same time B 2 18 3 Migrate Data from CSSMS tables to LDAP server If you are using LDAP authentication it is required to migrate all the details from the CSSMS table which contains the information entered using the Infrastructure Administration module under Security Management to the LDAP Server To migrate data from CSSMS tables to LDAP server 1 Invoke the LDAP Migration sh file in FIC HOME MigrationUtilities Migration LDAP bin folder The Select Source amp Destination for Migration window is displayed with the option to migrate the data from SMS to
126. ing on the choice 2 YES 1 NO 0 For example InteractionVariable name HTTPS ENABLE gt 0 lt InteractionVariable gt Yes information Note If value for HTTPS_ENABLE is set to 1 ensure you have a valid certificate available from a trusted CA and the same is configured on your web application server For more details on configuring your setup for HTTPS see Section B 2 17 Configure HTTPs Certificate WEB SERVER IP Identifies the HTTP Server IP Hostname or Web Application Server IP Hostname to be used for accessing the UI This IP would typically be the HTTP Server IP If no separate HTTP Server is available the value should be Web Application Server IP Hostname For example InteractionVariable name WEB SERVER 1P gt 10 11 12 13 lt InteractionVariable gt or lt InteractionVariable name WEB_SERVER_ IP gt myweb server com lt InteractionVariable gt No WEB_SERVER_PORT Identifies the Web Server Port This would typically be 80 for non SSL and 443 for SSL If no separate HTTP Server exists the value should be the port configured for Web Server Note The port value will not be accepted as 80 if HTTPS ENABLE is 1 and as 443 if HTTPS_ENABLE is 0 For example lt InteractionVariable name WEB_ SERVER PORT 580 InteractionVariable CONTEXT NAME Identifies the web application context name which will be used to built the URL to access the OFSAA applications
127. ion The path where the WSCONFTG file is placed must be specified in place of SWSCONFIGFILELOCATION in the below block of text in web xml context param B 30 OFSAA Infrastructure Installation and Configuration Guide EB INF and edit the web xml file as Additional Configurations description WebServices Configuration File lt description gt lt param name gt WSCONFIGFILE lt param name gt lt param value gt WSCONFIGFILELOCATIONS lt param value gt lt Specify the Location of DynamicWSConFig xml lt context param gt Proxy Settings The following block of text in web xml file replace the param value given in bold below with appropriate values If no values are required leave the lt param value gt blank context param description http Proxy Host description lt param name gt http proxyHost lt param name gt param value PROXYHOST param value lt Specify the IP address or hostname of the http proxy server gt context param context param description http Proxy Port description lt param name gt http proxyPort lt param name gt lt param value gt SPROXYPORT lt param value gt lt Port Number for the Proxy Server gt lt context param gt lt context param gt lt description gt http proxy UserName lt description gt lt param name gt http proxyUserName lt param name gt lt param value gt PROXYUSERNAME lt param value gt lt User
128. ion Deployment Applicable only if the web container is WebLogic You can deploy multiple Infrastructure applications on different domains of a stand alone weblogic application server To create multiple WebLogic Domains in a stand alone server you can use the Domain Creation wizard A domain is the set of files that define the runtime environment At least one domain must exist to run WebLogic Application Server B 1 2 1 Creating Domain in WebLogic Server To create a new domain using Configuration Wizard in WebLogic do the following 1 Navigate to the directory lt weblogic_Home Directory gt wlserver_ 10 3 common bin and execute the command config sh The Welcome window of the Configuration Wizard is displayed B 4 OFSAA Infrastructure Installation and Configuration Guide Webserver Configuration for Infrastructure Application Figure 8 9 Welcome F Fusion Middleware Configuration Wizard Welcome 9 Create a new WebLogic domain Create a WebLogic domain in your projects directory O Extend an existing WebLogic domain Use this option to add new components to an existing domain and modify configuration settings 2 Select Create a new WebLogic domain option and click Next The Select Domain Source window is displayed Figure 8 10 Select Domain Source F Fusion Middleware Configuration Wizard Select Domain Source Generate a domain configured automatically to support the following products
129. is set as Y then an error is displayed as Error occurred in Reverse populating the hierarchy B 2 4 6 Configure Node Limit for a Hierarchy Tree This property is required to display the Hierarchy as a small or a large hierarchy If the tree node limit exceeds the set limit the Hierarchies are treated as large Hierarchy Table B 7 Hierarchy Tree node limit Value Code Example Tree node limit for the TREE NODE TREE NODE LIMIT 30 hierarchy Values is Integer LIMIT VALUE number B 2 5 BlowFish Algorithm Setting for Solaris 5 11 OFSAA client call uses blowfish cbc 3des cbc algorithm during SFTP But BlowFish algorithm is not supported on Solaris 11 operating system Perform the following steps manually to enable it 1 Login as a root user 2 Append the following line to etc ssh sshd config Ciphers aes128 ctr aes192 ctr aes256 ctr arcfour128 arcfour256 arcfour blowfish cbc 3des cbc 3 Restart ssh daemon Svcadm v restart ssh B 2 6 Configure Information Domain Schema Privileges As the Information Domain Schema uses some of the tables from the configuration schema ensure to execute the below file from the Infrastructure configuration database user before Information Domain is created Infrastructure Database Layer Install Directory config table privileges for atomic user sql B 2 7 Configure Infrastructure Server Memory The memory settings for Infrastructure Application Server
130. 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 Appendix Webserver Configuration for Infrastructure Application B 23 Additional Configurations B 2 16 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 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 Once executed you need to create and deploy the EAR WAR file depending on the configured Web Application Server For more information see 5 2 Configuring Web Application Servers B 2 17 Configure HTTPs Certificate information Update the following section from FICWeb cfg file with the HTTPs certificate related details File path is lt OFSAAT 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 FICWeb cfg When you deploy the EAR this will have the change The following properties are to be uncommented for an HTTPS setup and the provider for WebSphere setup com ibm jsse IBMJSSEProvider EMDD PROTOCOL PROTOCOL MDD TRUSTSTORE TRUSTSTORE F
131. lespassword ofsaai Note While using the manageprofiles sh command to create a New Profile in WebSphere you can also use validatePorts to validate if the specified ports are not reserved or in use Additionally you can specify new ports with startingPort base port which specifies the starting port number to generate and assign all ports for the profile For more information on using these ports refer WebSphere manageprofiles command B 1 1 2 Manage Applications in WebSphere To manage the installed applications in WebSphere do the following 1 Open the administrator console using the following URL http ipaddress Administrative Console Port ibm console Example http 10 111 222 333 9003 ibm console https if SSL is enabled Note Administrative Console Port value is available in serverindex xml file within WebSphere Profile Directory config cells Node Cell nodes Node Name directory The Integrated Solutions Console Login window is displayed B 2 OFSAA Infrastructure Installation and Configuration Guide Webserver Configuration for Infrastructure Application Figure 8 7 Integrated Solutions Console Login Integrated Solutions Console Log in to the console User ID Log in o oa 4 2 Logon with the User ID provided with the admin rights 3 From the LHS menu expand the Applications gt Application Type WebSphere Enterprise Applications
132. leusstartup sh ljava Execute permission denied while executing reveleusstartup sh file What is to be done 2 Ensure JAVA_BIN environment variable path is set on the unix user terminal from where the reveleusstartup sh file is invoked 2 Ensure the profile where the environment path settings are made has been executed successfully OFSAAI Login page does not come up error message Could not retrieve list of locales is displayed What should one do This could be due to 2 reasons 2 System is unable to resolve the hostname configured 2 Conflict with the ports configured To correct them follow the below steps A Steps to replace the hostnames with IP address 1 Stopallthe OFSAA services See Stopping Infrastructure section on how to stop the services 2 Replace all the hostnames with the IP address in all the places mentioned in the document Where to find port IP address HTTPS Configuration for OFSAAI 7 2 Installation DOC ID 1500479 1 3 Restart all the OFSAAI services See Starting Infrastructure section B Steps to correct the port number conflicts 1 Stop all the OFSAA services 2 Referto the port numbers stated in the document Where to find port IP address HTTPS Configuration for OFSAAI 7 2 Installation DOC ID 1500479 1 and check on the discrepancy in the port numbers and correct them 3 Restart all the OFSAAI services Appendix Frequently Asked Questions D 7 Frequently Asked Questions
133. licable for both config and atomic data source creation 1 Open this URL in the browser window http ipaddress administrative console port ibm console https if SSL is enabled The Login window is displayed 2 Login with the user id that has admin rights 3 Expand the Resources option in the LHS menu and click JDBC gt Data sources option The Data sources page is displayed Figure 5 5 Data Sources Data sources Use this page to edit the settings of a datasource that is associated with your selected JDEC provider The datasource object supplies your application with connections for accessing the database Learn more about this task in a quided activity A guided activity provides a list of task steps and more general information about the topic E Scope Celi GXS150REV Zone2NodeOSCell liode GXSISOREV Zone2Node05 Serversserverl Scope specifies the level at which the resource definition is visible For detailed information on what scope is and how it works NodesGXS150REV Zone2Node05 Servereserveri Y E Preferences New Delete Test connection Manage state euo T Select Name INDI name 2 Scope You can administer the following resources E Default DefaultDatasource Nodes GXS150REV Datasourse Zone2NodeOS Servereserveri O EICMASTER jdbc FICMASTER Node GXS1SOREV Zone2Node05 Servereserveri O SQREEW jdbe RORFFW NodesGXS1SOREV Zone2Node05 Server serverl o RORPN jdbc RORPNC Node
134. me war file name B 2 24 Configuring Password changes This section explains about how to modify the OFSAA Infrastructure Config Schema and Atomic Schema passwords B 2 24 1 OFSAA Infrastructure Config Schema password modification To change the Config Schema password perform the following steps 1 2 3 Change the Config schema User Password in the database Delete the FIC HOME conf Reveleus SEC file Shutdown the OFSAAI App service cd S FIC APP HOME common FICServer bin reveleusshutdown sh Start the Infrastructure Server in foreground directly on the server or through X Windows software using the command reveleusstartup sh At the prompt enter System Password Enter the new Config schema password The service will start and initialize itself if it is able to successfully connect to the DB Post successful startup of the service if required the Infrastructure server may be shut down and restarted in the background using nohup mode B 2 24 2 OFSAA Infrastructure Atomic Schema password modification To change the Atomic Schema password perform the following steps 1 2 Change the Atomic schema User Password in the database Login to the application from the browser using SYSADMN account or any user id which has System Administrator role mapped Navigate to System Configuration Database Details window Select the appropriate connection and edit the password Navigate to Unified Metadat
135. n The command to create a profile without admin security through command line is as follows manageprofiles sh create profileName profile profilePath profile path templatePath template path nodeName node name cellName cell name hostName host name Example Susr home gt manageprofiles sh create profileName mockaix profilePath websphere webs64 Appserver profiles mockaix templatePath websphere webs64 Appserver profileTemplates default nodeName ipa020dorNode04 cellName ipa020dorNode04Cell hostName ipa020dor Appendix Webserver Configuration for Infrastructure Application B 1 Webserver Configuration for Infrastructure Application The command to create a profile with admin security through command line is as follows manageprofiles sh create profileName lt profile gt profilePath lt profile_ path templatePath template path nodeName node name cellName cell name hostName host name enableAdminSecurity true adminUserName Admin User Name adminPassword Admin User Password samplespassword sample User Password Example Susr home gt manageprofiles sh create profileName mockaix profilePath websphere webs64 Appserver profiles mockaix templatePath websphere webs64 Appserver profileTemplates default nodeName ipa020dorNode04 cellName ipa020dorNode04Cell hostName ipa020dor enableAdminSecurity true adminUserName ofsaai adminPassword ofsaai samp
136. n and Configuration Part II details the installation and post installation configurations steps Part II covers the following chapters Chapter 4 Installing OFSAA Infrastructure v 7 3 3 0 0 Chapter 5 Post Installation Configuration Chapter 6 Start Stop Infrastructure Services Chapter 7 Verifying the Installation 4 Installing OFSAA Infrastructure v 7 3 3 0 0 Follow the instructions in this chapter to install the OFSAA Infrastructure depending on the mode of installation This chapter includes the following sections a Silent Mode Installation a GUI Mode Installation 4 1 Silent Mode Installation Note Ensure you have followed the steps as mentioned in the Copying and Extracting the Software section prior to proceeding with the next steps 4 1 1 Configuring OFSAAI InstallConfig xml and OFSAAI_PostinstallConfig xml 1 Login to the system as non root user 2 Navigate to the directory OFSAAI 73300 OS and locate the OFSAAI InstallConfig xml and OFSAAI PostInstallConfig xml files 3 Configure the OFSAAI InstallConfig xml and OFSAAI PostInstallConfig xml files with appropriate details prior to triggering the installation For details on how to configure these files see Appendix A 4 1 2 Running the installer in Silent Mode To install the OFSAA Infrastructure in Silent mode execute the below command setup sh SILENT Installing OFSAA Infrastructure v 7 3 3 0 0 4 1 Silent Mode
137. n modify these settings or accept the defaults General What do you want to name this deployment Name upg7273 Security What security model do you want to use with this application DD Only Use only roles and policies that are defined in the deployment descriptors Custom Roles Use roles that are defined in the Administration Console use policies that are defined in the deployment descriptor Custom Roles and Policies Use only roles and policies that are defined in the Administration Console O Advanced Use a custom model that you have configured on the realm s configuration page Source accessibility How should the source files be made accessbie Use the defaults defined by the deployment s targets Recommended selecton Copy this application onto every target for me Dunng deployment the fies wil be copied automatically to the managed servers to which the application is targeted Iwill make the deployment accessible from the following location Location oradata2 v11035 Oracle Middleware user projects domail Provide the location from where all targets wil access this appicaton s fles This is often a shared drectory You must ensure the appicaton files most in ths location and that each target can reach the locaton Back Next Finish Cancel je 4 Enter a Name for the deployment if required 5 Under the Security section select the DD only option to specify that only roles and policies that a
138. nd the UI and presentation logic runs on the other The Ul and presentation layer is deployed on any of the supported J2EE Servers Figure 1 1 depicts the various frameworks and capabilities that make up the OFSAA Infrastructure Figure 1 1 OFSAA Infrastructure Framework Framework Framework Framework zi 7 Cube Builder Statistical Library Business Processors Conditional Exec i Relational Mart Blder Modeling sand box Baseline Run Multi hierarchy conditional rules Aggregator amp OLAP Computed Measures M Framework BPEL Workflows 7 Simulation Run Stress Testing Rules executed in DB Forms Manager METADATA Business Mapper M Framework A UNIFIED ANALYTICAL M Management Data Quality Data Movement Multi node dispatch DataModelMgt Data Aggregations Business Integrity Scheduler Metadata Trace DQ Reporting Data Access Svcs Metadata Browser SCD and Controls 1 4 OFSAA Infrastructure High Availability The current release of the OFSAA Infrastructure supports only Single Instance installation for the Infrastructure components However the High Availability HA for the Database Server and or the Web Application Server clustering and deployment are supported in this release 1 2 OFSAA Infrastructure Installation and C
139. ne Connection Proper ses Whats the name of the database you would ike to connect to Database Name fsgbu What is the name or IP address of the database server Host Name 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 connectons Database User Name ssatom What s the database account password to use to create database Connections Password s Confirm Password Back Next 9 Enter the required details such as the Database Name Host Name Port Oracle User Name and Password Post Installation Configuration 5 13 Configuring Resource Reference 10 Click Next The Test Database Connection window is displayed Figure 5 19 Test Database Connection Create a New JD8C Data Source Test Configuration Back Next Finish Cancel Test Database Connection Test the database avalebilty end the connecton propertes you provided hat is the ful package name of JOBC driver class used to create database connectons n the connection poo Driver Class Name oracle jdbc OracleDrver What is the URL of the database to connect to The format of the URL varies by JDBC driver unt jdbc oracle thin 910 184 vhat database account user name do you want to use to create database comectors Database User Name ssatom hat s the database account password to use to create database connectons Password
140. nfrastructure is comprised of a set of frameworks that operates on and with the Oracle Financial Services Analytical Applications Data Model This infrastructure delivers unified metadata across the stack and provides a single set of computational engines stochastic modeling methods and business rules to feed overlapping but independent analytical business functions such as profitability economic capital FTP and regulatory capital Pre integrated and extensible with common objects and dimensions this infrastructure powers business user analyses with performance that scales to meet the demands of the world s largest institutions The individual Analytical Applications provide domain specific data and information computed Understanding OFSAA Infrastructure 1 1 OFSAA Infrastructure Components with and within the Infrastructure to business users management and even regulators via corresponding sets of pre built reports alerts and dashboards These analytics are delivered with Oracle s industry leading Business Intelligence platform 1 3 OFSAA Infrastructure Components The OFSAA Infrastructure is comprised of a set of frameworks that operates on and with the Oracle Financial Services Analytical Applications Data Model and form the array of components within the Infrastructure The OFSAA Infrastructure components frameworks are installed in two layers primarily the metadata server and Infrastructure services run on one layer a
141. nish 5 1 3 2 Create GridLink Data Source If you have selected the option New gt GridLink Data Source while creating the Data Source you can directly specify the JDBC URL as indicated Figure 5 21 Create a New JDBC GridLinkData Source Create a New JDBC GridLink Data Source Next Cance JOBC GridLink Data Source Properties The following propertes wil be used to entity your new JOBC GndLirk data source What database type would you like to select Database Type Orsce s ths C XA Driver e Cance 1 Enter Data Source Name and JNDI Name Ensure that the JNDI Name field is specified in the format jdbc infodomname and the XA Driver checkbox is not selected Click Next Post Installation Configuration 5 15 Configuring Resource Reference Figure 5 22 JDBC GridLinkData Source Connection Properties Create a New JD8C GridLink Data Source Back Next Cance Connection Properties Define Comecton Properte Complete JDBC URL Database User Name database account password to use to create database connections Password Confirm Password Back Next Cance 2 Specify Complete JDBC URL Database User Name and Password Click Finish The created Data Source is displayed in the list of Data Sources 5 1 3 3 Configure Multi Data Sources A JDBC 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
142. ntal Sliced model upload might give errors if there are NOT NULL columns that are being added to a table that already has rows or if the columns that are being dropped have values Check the data model changes excel file for any such cases In such a case take a backup of the table and truncate the table Insert records back into the table with a default value for the NOT NULL column B 2 3 FTP SFTP Configuration for File Transfer In OFSAA certain modules require transfer of files from the web application server to the OFSAA server over SSH Follow these steps to ensure the OFSAA server recognizes the web application server during file transfers 1 Login to the web application server 2 Typesftp lt user gt lt OFSAA Server 3 Specify Yes when prompted for permission Are you sure you want to continue connecting yes no 4 This will add an entry into the known hosts file 5 The following confirmation message is displayed Permanently added OFSAA Server RSA to the list of known hosts Note Ensure PasswordAuthentication is set to Yes in file etc ssh sshd config B 2 4 Configuration for Dimension and Hierarchy Management These configuration changes are applicable when Dimension Management features provided in OFSAAI are used You can open AMHMConfig properties file present in the FIC WEB HOME webroot conf directory to set the properties for the following 2 Member Deletion gt Attrib
143. nts Control Monitoring his page displays a ist of Java EE applications and stand alone application modules that have been mstaled to this domain installed appicatons and modules can be started stopped updated redeployed or deleted from the domain by first selecting the applicabon name and using the controls on this page To install a new application or module for deployment to targets in this domain cick the Instal button V Customize this table Deployments instal Showing ito 10f1 Previous Next Enterprise Application instal Showing 1to 1of1 Previous Next The State of the deployed application will be displayed as Active if started successfully 5 2 2 3 WebLogic HTTPS Configuration Following are the steps for configuring an HTTPS Transport on WebLogic 1 Create a domain using the Domain Creation Wizard in WebLogic Note Note down the HTTPS port specified during this process and use the same as servlet port or web server port during OFSAAI Installation To enable https configuration on Infrastructure assign value 1 to HTTPS ENABLI in OFSAAI InstallConfig xml for silent mode OFSAAI installation See Appendix A 1 OFSAAI InstallConfig xml and OFSAAI PostInstallConfig xml Parameters E Post Installation Configuration 5 35 Configuring Web Application Servers 5 2 3 Configuring Apache Tomcat Server This section is applicable only when the Web Application Server type is Tomcat 5 2 3
144. o be set to include appropriate SORACLE_HOME bin path ARBORPATH ESSBASEPATH HYPERION HOME to be set in the profile pointing to an appropriate Oracle Essbase Client installation Note These paths need to be specified only if you have set OLAP_SERVER_ IMPLEMENTATION 1 in OFSAAIInstallConfig xml file 1 indicates OLAP implementation is enabled that is if you use Oracle Essbase as the multi dimensional database for analytical processing OS File System Settings File Descriptor Greater than 9216 Settings Total Number of Greater than 4096 Process Settings JDBC Driver Oracle JDBC Thin Driver v3 0 exists in the path identified for ABS DRIVER PATH of OFSAAIInstallConfig xml Port Settings Default port numbers to be enabled on the system are 6500 6501 6505 6507 6509 6510 6666 9999 and 10101 Time Zone If OS is Solaris 11 set the environment variable TZ to a valid time zone region For example export TZ Asia Calcutta Staging Area a A directory to hold the application metadata Metadata artifacts and additionally act as staging area Repository The directory should exist on the same system as the OFSAA Infrastructure can be on different mount User to have 777 permission on this folder 3 2 OFSAA Infrastructure Installation and Configuration Guide Common Installation Tasks Table 3 1 Cont Prerequisite Information Category Sub Category Expected Value
145. oading settings for Web and EJE modules Reload interval in seconds E Deploy Web services Validate Input off v rn fail C Process embedded configuration File Permission Allow all files to be read but not written to Allow executables to execute Allow HTML and image files to be read by everyone dil 755 so 755 a 7552 sl 755 lication Build ID Unknown O Allow dispatching includes to remote resources O Allow servicing includes from remote resources Business level application name Create New BLA i Asynchronous Request Dispatch Type Disabled v o Allow EJB reference targets to resolve automatically 8 Enter the required information and click Next The Map Modules to Servers window is displayed Post Installation Configuration 5 25 Configuring Web Application Servers Figure 5 34 Map Modules to Servers Install New Application Specify options for installing entergri pplications 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 efg xml for each Web server is generated based on the applications that are routed through Clus
146. olution Provide a valid installation path Check if you are able to create the directory mentioned in USER INSTALL DIR tag value of OFSAAI_ InstallConfig xml file Appendix Frequently Asked Questions D 17 Error Dictionary D 18 OFSAA Infrastructure Installation and Configuration Guide
147. om Documentation Library for OFSAAI 7 3 OTN m Oracle Financial Services Analytical Applications Infrastructure Administration Guide a Oracle Financial Services Analytical Applications Infrastructure Language Pack Guide a Oracle Financial Services Analytical Applications Infrastructure User Guide a Oracle Financial Services Analytical Applications Infrastructure Environment Check Utility Guide The following document is available in My Oracle Support MOS and you should have SSO credentials to access MOS a Oracle Financial Services Analytical Applications Infrastructure Security Guide Conventions Xii The following text conventions are used in this document Convention Meaning boldface Boldface type indicates graphical user interface elements associated with an action file names or terms defined in text or the glossary italic Italic type indicates book titles emphasis screen names or placeholder variables for which you supply particular values monospace Monospace type indicates commands within a paragraph URLs code in examples text that appears on the screen or text that you enter AIX Advanced Interactive eXecutive DEFQ Data Entry Forms and Queries DML Data Manipulation Language EAR Enterprise Archive EJB Enterprise JavaBean ERM Enterprise Resource Management FTP File Transfer Protocol GUI Graphical User Interface HTTPS Hypertext Transfer Protocol Secure
148. on Guide Hardware and Software Requirements and Specifications Table 2 2 Cont Configurations Supported IBM AIX IBM AIX Runtime Java Technology JRE 1 6 0 SR10 64 bit Oracle Database Server and Client partitioning Oracle Database Enterprise Edition Release 11 2 0 2 0 64 bit RAC Non RAC with OracleClient 11g R2 11 2 0 2 0 64 bit OLAP Oracle Hyperion Essbase V 11 1 2 1 0 Server and Client Oracle OLAP V 11 2 0 2 0 Note Oracle Hyperion Essbase amp Oracle OLAP is required only if you are using the OLAP feature of OFSAAI For Oracle OLAP ensure that you have configured the Oracle Database server with OLAP option Web Server Web Application Server Oracle Linux Red Hat Enterprise Linux Oracle Solaris Oracle HTTP Server 11 1 1 1 Apache HTTP Server 2 2 x Oracle WebLogic Server 10 3 5 0 IBM AIX IBM HTTP Server IBM WebSphere Application Server 7 0 0 17 with IBM Java Runtime v1 6 0 SR9 FP1 64 bit Notes OFSAA Infrastructure web component deployment on Oracle WebLogic Server 10 3 5 0 with Oracle JRockit 6 R28 2 7 1 6 0 45 64 bit is supported a OFSAA Infrastructure web component deployment on Apache Tomcat Server 7 0 19 with Java 1 6 0 25 64 bit is supported Other Software Directory Services OFSAAT is qualified on both OPEN LDAP 2 2 29 and Oracle Internet Directory v 11 1 1 3 0 However it c
149. on Guide in the Related Documents section Does OFSAAI support Oracle Linux versions other than 5 5 OFSAAI supports the Oracle Linux versions from 5 5 up to 5 10 D 4 OFSAA Infrastructure Installation and Configuration Guide Frequently Asked Questions On the UNIX System terminal error message shows Insert New Media Please insert Disk1 or type it s location while executing setup sh what should be done 1 Login as root user on the Unix machine where OFSAAL is getting installed 2 Navigate to the path etc security 3 Edit the file limits conf to add edit a row for the unix user installing OFSAA Unix User soft nofile 9216 4 After saving the changes log in as unix user with which OFSAAL is getting installed and execute the command ulimit n The command should return the value 9216 How does one verify if the system environment is ready for OFSAAI installation To verify the system environment meets the minimum requirements for the installation a Pre Install Check utility is available within the Install Kit archive file This utility can also be obtained separately by contacting Oracle Support See Verifying the System Environment section for additional information How does one know if the installation is completed successfully The OFSAA Infrastructure installation performs a post install health check automatically on successful installation of the product To rerun the post install verification at a later
150. onfiguration Guide 2 Understanding OFSAA Infrastructure Installation This chapter provides a brief overview of OFSAA Infrastructure version 7 3 3 0 0 Installation This chapter includes the below topics Installation Overview Hardware and Software Requirements and Specifications Verifying the System Environment Understanding Installation Modes 2 1 Installation Overview This section gives an overview of the OFSAA Infrastructure Installation Figure 2 1 shows the order of procedures you will need to follow Figure 2 1 OFSAA Infrastructure Installation Flowchart Verify Systems Environment Obtainthe Software Install OFSAAI Configure OFSAAI Verify Installation Understanding OFSAA Infrastructure Installation 2 1 Hardware and Software Requirements and Specifications Table 2 1 provides additional information and links to specific documentation for each task in the flowchart Table 2 1 OFSAA Infrastructure Installation Tasks and Descriptions Tasks Details and Documentation Verify Systems To verify that your system meets the minimum necessary Environment requirements for installing and hosting the OFSAA Infrastructure see Hardware and Software Requirements and Specifications and Verifying the System Environment Obtain the software See Obtaining the software Install OFSAA See Installing OFSAA Infrastructure v 7 3 3 0 0 Infrastructure Configure OFSAA See Post
151. our file s and or confirm that your appicaton contains the requred deployment descriptors Path loradata2 wl1035 Oracle Middleware user projects domains upg7273 applications Recently Used Paths foradata2 vd 1035 Orade M dieware user projects domains upg7273 applicaons Current Location 10 184 134 147 oradata2 141035 Orade Middleware user projects domains 1997273 applications o 3 upg7273 ear open Grectory Next Cancel 2 Click Next Figure 5 41 Install Application Assistant Install Application Assistant Targets are the servers dusters and virtual hosts on which this deployment will run There are several ways you can target an appiicaton Install this deployment as an application The application and its components wil be targeted to the same locations This is the most common usage O Install this deployment as a library Application libraries are deployments that are available for other deployments to share Libraries should be available on al of the targets running ther referencng applications Back Next Cancel H 3 From the Choose targeting style section select the Install this deployment as an application option and click Next The Optional Settings window is displayed Post Installation Configuration 5 31 Configuring Web Application Servers Figure 5 42 Optional Settings Install Application Assistant Back Next Finish Cancel Optional Settings You ca
152. pe is and how it works see the scope settings helo Node GXS1S0REV Zone2Node0S Server serverl Preferences Ne Delete a n Mon Select Name Scope gt Description gt You can administer the following resources oO Node GXSi SOREV Derby embedded non XA JDBC Zone2Node0S Serverzserveri Provider O FICMASTER Nodes GXS150REV Oracle JDEC Driver Zone2Node05 Server server1 o Oracle JDEC Driver NodesGXS1S50REV Oracle JDEC Driver Zone2NocdeOS Server servert Oo RORFFW Node GXS150REV RORFFW Zone2hiode05 Server serverl o AQRPNC NodezGXS1 OREV RORPNC Zone2NodeO5 Server D YOGsorr NodezGXS1SOREV UPGSPFT Zone2Node05 Server server E YOGSROR Node GXS5150REV UPGSROR Zone2Node05 Serversserveri O PGESAN Node GXSISOREV Zone2Node05 Servermserver 5 2 OFSAA Infrastructure Installation and Configuration Guide UPGSSAND Configuring Resource Reference 4 Select the Scope from the drop down list Scope specifies the level at which the resource definition is visible 5 Click New to add new JDBC Provider under the Preferences section The Create new JDBC provider window is displayed Figure 5 2 Create a new JDBC Provider Create a new JDBC Provider Create a new JDBC Provider Set the basic configuration values of a JOBC provider which encapsulates the specific Step 2 Enter vendor JDEC driver implementation classes that are required to access the database database class path T
153. pected Value Mandatory Layer name GENERAL gt USER INSTALL DIR PATH Identifies the Installation Directory for the Yes OFSAA Infrastructure where all the OFSAA Infrastructure components would be installed For example InteractionVariable name USER INSTALL DIR PATH oradata6 revwb7 ofsaa InteractionV ariable WEBAPPSERVERTYPE Identifies the web application server on which Yes the OFSAA Infrastructure web components would be deployed The below numeric value should be set depending on the type Apache Tomcat 1 IBM WebSphere Application Server 2 Oracle WebLogic Server 3 For example InteractionVariable name WEBAPPSERVERTYPE gt 3 lt InteractionVari able gt OFSAAI APP LAYER IP Identifies the Hostname or IP Address of the Yes system on which the OFSAA Infrastructure components such as the metadata server would be installed For example InteractionVariable name OFSAAI APP LAYER 1P gt 10 11 12 13 lt InteractionVariable gt or InteractionVariable name OFSAAI APP LAYER IP gt my server com lt InteractionVariable gt OFSAAI DB LAYER IP Identifies the hostname or IP address of the Yes system on which the OFSAA Infrastructure components such as the backend computation engines would be installed For example InteractionVariable name OFSAAI DB LAYER 1P gt 10 11 12 13 lt InteractionVariable gt or InteractionVariable name OFSAAT DB LAYER _ IP gt my server
154. pending on your Oracle database version As OFSAAI is certified on Oracle 11gR2 copy the Oracle JDBC driver file ojdbc6 jar from Oracle Home jdbc 1ib and place it in Tomcat Home lib 5 1 4 1 Create Data Source To create data source for Infrastructure application navigate to Tomcat Home conf and edit the following block of text by replacing the actual values in server xml Context path lt context name docBase lt Tomcat Installation Directory webapps context name debug 0 reloadable true crossContext true gt lt 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 password for the above user id 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 I name jdbc INFORMATION DOMAIN NAME type javax sql DataSource driverClassName oracle jdbc driver OracleDriver username user id for the database password password for the above user id url jdbc oracle thin lt DB engine IP address gt lt DB Port gt lt SID gt maxActive 100 maxIdle 30 maxWait 10000 Context Note the following The Resource tag must be repeated for each Information Domain created After the above configur
155. pplication Servers Figure 5 44 Settings for Deployment Name gt Settings for upg7273 Overview DeoloymentPlan Configuraten Security Targets Control Testng Monitoring Notes Save Use this page to view the general configuration of an Enterprise application such as ts name the physical path to the application fies the associated deployment plan and so on The table at the end of the page ists the modules such as Web applications and EJBs that are contained in the Enterprise applicaton Click on the name of the module to view and update its configuration Name upg7273 The name of this Enterprise Application More Info Path oradata2 wi1035 Orade Mddieware user projects Gomains upg7273 appications upg7273 ear e source of the deployable unit on the Info Deployment Plan no plan specified The path to the deployment plan document on Administration Server More Info Staging Mode not specified ed from acng ares Security Model DOOnly The security model that is used to secure a deployed module More Info a Deployment Order 100 vt is deployed relatrve to other gt More info j Deployment Principal Name the anonymous princpal wil be used More Info Saxe Modules and Components Showing 1 to 1of1 Previous Next Enterprise StateLessCaheleanBean AR gj u097273 d SERE 1d e NE Showing ito 1of1 Previous Next 9 Review the general configu
156. ps lt NodeCel1Name gt For Tomcat The Absolute Tomcat Path window is displayed Figure 4 14 Absolute Tomcat Path Absolute Tomcat Path License Enter absolute Tomcat Installation path where Oracle Financial Prelnstall Setup Services Analytical Applications Infrastructure is to be deployed installation Example homej datal tomcat 7 0 19 webapps Install Complete ORACLE FINANCIAL SERVICES InstallAnywhere Enter the Tomcat installation path till webapps where OFSAAI will be deployed For WebLogic The Weblogic Home window is displayed Installing OFSAA Infrastructure v 7 3 3 0 0 4 11 GUI Mode Installation Figure 4 15 Weblogic Home Weblogic Home License Enter Weblogic Home 3 Prelnstall Setup For Ex home weblogic bea weblogic 10 3 5 0 O Installation Install Complete ORACLE FINANCIAL SERVICES Previous Next a Enter the WebLogic home directory path Figure 4 16 Weblogic Setup Details Weblogic Setup Details License Enter Weblogic Domain Home Prelnstall Setup For Ex home weblogic bea user_projects domains mydomain Installation 9 Install Complete FINANCIAL SERVICES Install Enter the path of the Weblogic domain home directory and click Next The OLAP Details window is displayed 4 12 OFSAA Infrastructure Installation and Configuration Guide GUI Mode Installation Figure 4 17 OLAP Details OLAP Details License Note Prelnstall Setup
157. ration details of the deployment You can also update the configuration of the deployment in this window In the Overview tab you can view the complete deployment configuration 10 Click Save to update the changes if any 11 From the LHS menu click Deployments The Summary of Deployments window is displayed 5 34 OFSAA Infrastructure Installation and Configuration Guide Configuring Web Application Servers Figure 5 45 Summary of Deployments Summary of Deployments Control Monitoring This page displays a ist of Java EE applications and stand alone application modules that have been mstaled to ths doman Installed applca ons 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 dick the Install button V Customize this table Deployments instal Update Delete 52 Stop v Showing ito lofi Previous Servicing all requests Next Serviong only administration requests instal Update Delete Staty Stopy Showing 1 to tofi Previous Next 12 Select the newly deployed Infrastructure application and click Start gt Servicing all requests Ensure that the Infrastructure server is up and running Figure 5 46 Summary of Deployments Messages f Start requests have been sent to the selected Deployments Summary of Deployme
158. re Installation sese C 1 Appendix Frequently Asked Questions D 1 Frequently Asked Q estiofis nin iini iie iiir ka be eri Een ets D 1 D 2 Error o dE D 14 D 2 1 Accessing Error Dictionary ismi imir ioe aae aaien nennen D 14 D 2 2 Error CodeDicti naty 4e ee t e ee tee i eoa eataa aa EASES D 15 List of Figures 1 1 OFSAA Infrastructure FraMewoTk cccionmiooinacisnconionanocinacinnonanononinnononacinnonanaconnonanoconncnanonanins 1 2 2 1 OFSAA Infrastructure Installation Flowchart sse 2 1 4 1 Silent Mode Installation Environment check sese 4 2 4 2 Silent Mode Installation OFSAAUI License Agreement eesssssssseee eee 4 3 4 3 Silent Mode Installation Installing esee eene enne 4 4 4 4 Silent Mode Installation Post Install Health Check esse 4 5 4 5 Silent Mode Installation Sample Application installation sse 4 6 4 6 Validating the installation 2 ert ahahaha nies asi ete is 4 7 4 7 Initialization NINO Weitere di e ente Eire 4 8 4 8 LICENSE ARTE bil A A ione aee Ad A 4 8 4 9 Liceise Details A GNE REGN A ED EE ETEA 4 9 4 10 User Installation Directory ueniet pite meon Hen reri ces 4 9 4 11 OFSAA Infrastructure Server Details sss eene nennen 4 10 4 12 Web Application Server ae eee ter rite o p teinte edes 4 10 4 19 WebSphere Setup Detalls 2 aiite ee E Re
159. re defined in the deployment descriptors should be used 6 Select the I will make the deployment available from the following location option under the Source accessibility section 7 Click Next to continue The Deployment Summary window is displayed 5 32 OFSAA Infrastructure Installation and Configuration Guide Configuring Web Application Servers Figure 5 43 Deployment Summary Install Application Assistant Back Finish Cancel Review your choices and click Finish Click Finish to complete the deployment This may take a few moments to complete Additional configuration In order to work successfully this appicaton may require additional configuration Do you want to review this appicaton s configuration after completing this assistant Yes take me to the deployment s configuration screen No I will review the configuration later Summary Deployment oradata2 v41035 Orade Midieware user projects domains upg7273 appbcatons upg 7273 ear Name 972733 Staging mode Use the defaults defined by the chosen targets Security Model DOOnly Use only roles and polices that are defined in the deployment descriptors Target Summary components tots NNI upg7273 ea AdminServer Back Finish Cancel 8 Select the Yes take me to the deployment s configuration screen option and click Finish The Settings for lt Deployment Name gt window is displayed Post Installation Configuration 5 33 Configuring Web A
160. res the client to be authenticated otherwise set to false SMTP USERNAME Username required for logging into SMTP server if authentication is not required use a dummy value SMTP PASSWORD Password required for logging into SMTP server if authentication is not required use a dummy value SMTP MAILID If the Messages has to go from a Particular ID that ID need to be added Exchange server forces you set a valid ID that is there in the exchange server Based on Security settings Ensure that the authorized User details are included in Administration Security Management User Administrator User Maintenance window Appendix Webserver Configuration for Infrastructure Application B 33 Additional Configurations B 2 23 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 2 Tomcat lt Tomcat installation folder gt work Catalina localhost lt Application name org apache jsp WebLogic lt Weblogic installation location gt domains lt Domain name gt servers lt Server name tmp WL user Application name gt qaelce jsp_ servlet WebSphere Websphere installation directory AppServer profiles Profile name temp Node name serverl Application na
161. ross different JVM s machines based on the various services and Information Domains in other words Load balancing could be achieved with distribution of services Why do we need Ftpshare Why is it needed on all the layers Can we have ftpshare on another machine other than the machines where OFSAAI is installed Ftpshare is a Metadata Repository directory All the metadata related files used in Infrastructure are stored in the ftpshare directory The ftpshare contains folders for each Information Domain with each Information Domain folders holding Erwin log and scripts folder The transfer of data among the Web Application and Database servers in Infrastructure takes place through FTP SFTP You need to configure FTP SFIP and enable communication between the servers by providing App server s FIP SFTP credentials to the Web server and DB server users Yes we can have ftpshare on another machine other than the machines where OFSAAT is installed Is it mandatory to provide the ftplsftp password Yes OFSAAI needs credentials of the user which has complete permissions on ftpshare directory and should be able to independently login to the unix server What are the permissions required for ftpshare and when should I give them It is recommended to provide 777 permissions on ftpshare in case of installations done across different machines or VMs multi tier installation In case of single tier installation 770 permissions can be p
162. rovided if the unix users of OFSAAI and web server belong to the same unix group And on any new file that is created in the ftpshare folder of any installation layer should be granted specific explicit permission D 8 OFSAA Infrastructure Installation and Configuration Guide Frequently Asked Questions Port Change utility could be used to have the Port number modified which are currently being used by the Infrastructure application For more information refer Configure Infrastructure Ports section Are there any in built system administration users within OFSAAI Application The three in built system administration users are provided to configure and setup OFSAAL SYSADMN SYSAUTH GUEST Does OFSAAI Application support both FTP and SFTP OFSAAI supports both FTP and SFTP configuration Is it necessary to enable the FTP SFTP services to use the OFSAAI Yes enabling of FTP SFTP services and its ports is a pre requisite step towards using the OFSAAI OFSAAI Configuration Unable to save the server details 2 Ensure the input User ID Password and Share Name are correct 2 Ensure FIP SFIP services are enabled 2 Have a test FIP SFIP connection made and confirm if they are successful During Information Domain creation the message Please create a database and then create the information domain appears What should be done Information Domain is mapped to only one Database and thus before the creation of Information
163. s Note OFSAAI supports only default zoom setting in Internet Explorer that is 100 Cookies should be enabled The following browser settings have to be specified at every client machine prior to accessing the Infrastructure application 1 Open Internet Explorer Select Tools gt Internet Options The Internet Options window is displayed 2 Click the Settings button The Settings window is displayed 3 Select the option Everytime I Visit the webpage and click OK Appendix Webserver Configuration for Infrastructure Application B 17 Additional Configurations Figure 8 18 OFSAAI Login window Internet Options wal Temporary Internet Files and History Settings x Temporary Internet Files Home page ria ea re agr ipd uo To create home page tabs type each address on its own line i 9 1 Check for newer versions of stored pages S Every time I visit the webpage O Every time I start Internet Explorer Browsing history Disk space to use 8 1024MB 50 Delete temporary files history cookies saved passwords Recommended 50 250MB and web Form information Current location C Documents and Settings tusharBh Local Settings Temporary Search Internet Files O Change seen defauts de Tabs how in net etre ee anios J History Specify how many days Internet Explorer sho
164. sGXS150REV Zone2Node03 Server serverl B WEGSPET jdbc UPGSPFT Node GXS150REV Zone2Node0S Serversserveri E UeGSROR jd5c UPGSROR Node GXS1S50REV Zone2Node05 Serverzserveri Total 6 n Provider gt Derby JDEC Provider FICMASTER RORFFW RORPNC UPGSPFT UPGSROR Description Category gt Datasource for the WebSphere Default Application New JDEC Datasource New JDBC Datasource New JOBC Datasource New JOBC Datasource New JOBC Datasource 4 Select the Scope from the drop down list Scope specifies the level at which the resource definition is visible 5 Click New The Create a Data Source window is displayed Post Installation Configuration 5 5 Configuring Resource Reference Figure 5 6 Create a data source Create a data source Create a data source Set the basic configuration values of a datasource for association with your JOBC 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 Scop celis GXS150REV Zone2NodeOSCallinodes GXS15S0REV Zone 2Node05 servers serveri Data source name mT JNDI name 6 Specify the Data Source name and JNDI name for the new Data Sour
165. stallation Folder gt context param DynamicWSConfig xml For each third party web service that needs to be accessed using the OFSAAI Web services framework and the operation to be invoked make corresponding entries into this file This file is to be placed in the location that is specified in the web xml as WSCONFIGFILE parameter B 2 20 Deploy OFSAAI Web Services You can deploy OFSAAI Web Services separately if you had not configured OFSAAI Web Services as part of the installation 1 Complete the manual configuration of OFSAAI Web Services 2 Navigate to lt OFSAAI Installation Directory gt EXEWebService lt WebServer gt and execute the command ant sh This will trigger the EAR WAR file creation which is required for the deployment 3 Deploy the generated EXEWebService EAR EXEWebService WAR file into the WebServer If you have already configured OFSAAI Web Services as part of the installation deploy the generated EXEWebService EAR EXEWebService WAR file into the OFSAAI Deployment area in WebServer profile B 32 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations B 2 21 Configure Oracle database operations A configuration file OracleDB conf has been introduced to accommodate any configurable parameter related to operations on oracle database If you do not want to set a parameter to a specific value then the respe
166. stalling WAR Files in Tomcat eee ee een nennen nennen Appendix OFSAAI InstallConfig xml A 1 OFSAAI InstallConfig xml and OFSAAI PostInstallConfig xml Parameters A 1 1 OFSAAT InstallConfig xil aeterne etre eet eee eene A 1 2 OFSAAI PostInstallConfig xml ccc een n nnne nnns Appendix Webserver Configuration for Infrastructure Application B 1 Webserver Configuration for Infrastructure Application sss B 1 1 Configurating WebSphere for Infrastructure Application Deployment B 1 1 1 Creation of New Profile in WebSphere sess B 1 1 2 Manage Applications in WebSphere sss eene B 1 1 3 Delete WebSphere Profiles iei m eere niece te eee fe e Ae re Pera B 1 2 Configurating WebLogic for Infrastructure Application Deployment B 1 2 1 Creating Domain in WebLogic Server sess eee B 1 2 2 Delete Domain in WebLogic sese eee B 2 Additional Configurations oneni a oenen EE Eiere PE E ae A ES a EE S anne E B 2 1 Configuration for Forms Framework sess eee nee B 2 2 Configuration for Model Upload Uktility sse B 2 2 1 Run the Model Upload Utility sse nennen B 2 2 2 Model Upload Details sic ci 5 iet ete teres etes ere fett reete reped B 2 2 3 Common Errotz nienti ee Ie emer aree best easet pase linia B 2 3 FIP SFTP Configuration for File Tr
167. sure no such error is encountered add the line securerandom source file dev urandom in the java security configuration file available in JAVA_HOME jre lib security path This needs to be con figured only on the machine where the OFSAAI database components ficdb layer are installed Appendix Webserver Configuration for Infrastructure Application B 35 Additional Configurations B 36 OFSAA Infrastructure Installation and Configuration Guide C Appendix Patching Your OFSAA Infrastructure Installation C 1 Patching Your OFSAA Infrastructure Installation Oracle strongly recommends installing the latest available patchset so as to be up to date with the various releases of the OFSAA Infrastructure product You can refer to the below links on http support oracle com for more information on latest releases and upgrade compatibility Latest OFSAAI 7 3 Release and OFSAA 6 0 and 6 1 Release Information Doc ID 1456593 1 OFSAAI 7 3 Upgrade and Compatibility Reference Doc ID 1590502 1 Appendix Patching Your OFSAA Infrastructure Installation C 1 Patching Your OFSAA Infrastructure Installation C 2 OFSAA Infrastructure Installation and Configuration Guide D Appendix Frequently Asked Questions This section of the document consists of resolution to the frequently asked questions and error codes noticed during OFSAAI installation 2 Frequently Asked Questions 2 Error Dictionary OFSA
168. taller was not unzipped rightly or corrupted during unzip 2 setup sh file which resides within the install archive was not transferred in ASCII or text mode which could have corrupted the file To correct this follow the steps 1 Copy the installer in BINARY mode to the system on which the OFSAA Infrastructure components will be installed 2 Unzip the installer using the command unzip OFSAAT Installer zip 3 The corrupted setup sh file would have introduced certain M characters into the file You can remove M characters from setup sh file by following the below steps D 6 OFSAA Infrastructure Installation and Configuration Guide Frequently Asked Questions a Login to the server where the installer is copied b Navigate to the directory OFSAAI_73300 c Open the setup sh file in the vi editor using the command vi setup sh d Inside vi editor in Esc mode type s M g Note To enter M hold the CTRL key then press V and M in succession e Save the setup sh file by typing wq Does OFSAA support Oracle DB 11g Standard edition The OCI client and the jdbc driver does not change depending on whether it is a standard or enterprise edition So OFSAAI will work with standard edition as well We do not recommend standard edition because it will not scale and does not support partition pack database security vault or advanced analytic On the UNIX System terminal Error message shows reve
169. te Deiode es 4 11 A4 14 Absolute Tomcat Paths ei tee Seit teo ra ca ad Rep oe a Eb a Hb feriens 4 11 4 145 Weblogic Hore iet dte edt ene a tdi 4 12 4 16 Weblogic Setup Details nete ete ete deque tede eedem 4 12 4 17 OLAP Details ae aaa 4 13 4 18 Web Server Details irc eb aereo arae tee o aee gre oce Ree 4 13 4 19 Database Detailseite tte d eee pere RO e de a Qe i E e re IERI its 4 14 4 20 Ports Configuration esiisa ri et e o nee e HE ee lee te op ta Puede ees 4 14 4 21 Ports Configuration 2e te quete dea eee deep ies 4 15 4 22 Default Infrastructure Administrator and Authorizer User Password sss 4 15 4 29 SSETP Detuils i iteeoo iet ether bateria 4 16 4 24 Post Install rte eem uet eb ee as 4 16 4 25 OESAAL Post Install Details o eo RR eed ee Atenas 4 17 4 26 Sample Application Installation essent 4 17 4 27 PreInstallatiorm Summary x t dite ttt ete ipae e rre trs 4 18 4 28 Installing OESAA Infrastructure iuste erre rr Ree Acs 4 18 4 29 Installation Summary uie sets sc deste iia 4 19 4 30 Installation Complete i taa id thon o 4 19 4 931 Installation Complete needed tane tei ees 4 20 5 1 JIDBCProviders eee eee A e Ee D EET Ner mee 5 2 5 2 Create a new JDBC Provider e eet terere esee reinen 5 8 5 8 Enter database class path information eene 5 4 5 4 SUMMATTU s aestate eae on ti qiti nde bond Pd EO ea D E reete e 5 4 5 5 Data SOU CES Ji 285 ete
170. ters and servers WebSphere cell ipa024dorliiode05Cell mode ipal4dorliiode0S server serverl Apply WebSphere cell ipa024dorNode05Cell node ipa24dorNode05 server server1 f beancache jar META E bemncacnajar INF ejo jar xml aixpr2 war WEB WebSphere cell ipa024dorNode05Cell node ipa24dorNode05 server server1 TEE mato ira OFSAAI Web Application 9 Select the Web Application and click Next The Map Resource References to Resources window is displayed Figure 5 35 Map Resource References to Resources Specify options for installing enterprise applications and modules ofsa73 war WEB INF web xml jdbc RHELATOMST authorization ofsa73 war WEB Container INF web xml MDM FICMASTER Erorae Authentication method None 10 Map each resource defined in the application to a resource JNDI name defined earlier 11 Click Modify Resource Authentication Method and specify the authentication method created earlier You can specify config for FICMASTER resource or atomic for atomic resource as the authentication method 12 Select the OFSAAI Web Application check box and click Next The Map Virtual hosts for Web Modules window is displayed 5 26 OFSAA Infrastructure Installation and Configuration Guide Configuring Web Application Servers Figure 5 36 Map Virtual host for Web Modules Install New Application P Specify options for installin
171. the https port specified during this process and use the same as servlet port or web server port during OFSAAI installation 3 To enable https configuration on Infrastructure assign value 1 to HTTPS ENABLE in OFSAAI InstallConfig xml for Silent mode OFSAAI installation See Appendix A 1 DFSAAI InstallConfig xml and OFSAAI PostInstallConfig xml Parameters 5 28 OFSAA Infrastructure Installation and Configuration Guide Configuring Web Application Servers 5 2 2 Configuring Oracle WebLogic Server This section is applicable only when the Web Application Server type is Oracle WebLogic 5 2 2 1 Create EAR WAR file for WebLogic The EAR files are 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 Navigate to the path lt WEBLOGIC_INSTALL_DIR gt Bea user_ projects domains lt DOMAIN_NAME gt bin 2 Start WebLogic Domain by executing the command startWeblogic sh d64 3 Navigate to the 3FIC WEB HOME directory in the machine in which Infrastructure Web components have been installed 4 Execute the command ant sh This will trigger the creation of EAR file contextname ear Here contextname is the context name given during installation 5 Oncompletion of the EAR files creation the BUILD SUCCESSFUL and Time Taken m
172. tion sess eee eene nennen 5 28 5 2 2 Configuring Oracle WebLogic Server sse eene 5 29 5 2 2 1 Create EAR WAR file for WebLogic esee eee 5 29 5 2 2 2 Deploy EAR WAR file for WebLogic esses eee n 5 29 5 2 2 3 WebLogic HTTPS Configuration sees eee enne 5 35 5 2 3 Configuring Apache Tomcat Server sse 5 36 5 2 3 1 Configuring jaxrpc Jar AAA terit crei tee rabies 5 36 5 2 3 2 Tomcat User Administration ccccsccsscessesscescessesscessecsecssesaecsseeseceesesseeseeseeseasenes 5 36 5 2 3 3 Configure Tomcat to use JAVA 64 bit Executables sss 5 36 5 2 3 4 Configure Servlet Ports eee ene ie e beers 5 37 5 2 3 5 Create Tomcat WAR Eiles imum epe aer t Rede eerta 5 37 5 2 3 6 Deploy Tomcat WAR Files eee nennen E 5 37 5 2 3 7 Non SSL Port Configuration sse eene nennen 5 39 5 2 3 8 SSL Port Configuration etim e Bacon tote eee i idest ids 5 39 6 Start Stop Infrastructure Services 6 1 Starting Infrastructure eoe etge dardo e Re i e iet eise dice it eie 6 1 6 2 Stopping Infrastructure nite HI e tdt bee ited ets 6 4 dl Verifying the Installation Uninstalling OFSAA Infrastructure 8 1 Uninstalling OFSAA Infrastructure ssnst iissa o an us inti nnne nnne 8 2 Uninstalling EAR Files in WebSphere sse 8 3 Uninstalling EAR Files in WebLogic sess eee 8 4 Unin
173. tion Properties sese eee 5 16 Summary of JDBC Multi Data Sources mococenonenonnnnnnonnnnnnrnrnnnennnanananoncnrnranancn conan nrnararanannnnararans 5 17 Configure the Multi Data Source nennen 5 17 Select Targets E 5 18 Select Data Source TYPE ico e nte eoe eet eee et edens 5 18 Add Data SourceS 2s reete eee e e te i Celi ee e reto e AATRE 5 18 Settings for Data Source Name ssssssssssseeeeee eene n nennen nnne 5 19 Login WINDOW eis teet de et e ene tate ip e ten erties a ES 5 23 New App catolico E OM rte Meet ou ol AT ts 5 23 Preparing for the application installation seen 5 24 Installation Options d rettet rre ee e eo leet e eee ettet ctas 5 24 Install New Application eco he t iie Does dere ii e BORSE de ug 5 25 Map Modwules 10 S6ruers e oti e a tete hr eet tle ens 5 26 Map Resource References to Resources ococonionononmonenconaninnnncnnonanenonononanan an onononan an on rn ononarananononono 5 26 Map Virtual host for Web Modules sse 5 27 E A coe e ea irte Ht ade tede e ein ortus dtl etra Heise aste 5 27 Enterprise Applications o is ct e te odes te salt e m i eds 5 28 Summary of Deployments eet entere er rne hen eie tentiae 5 30 Install Application Assistant esee eee tenete nennen nnne nennen 5 31 Install Application Assistants iis i esee ee oe dt rn ee S EE e e e e reb deg 5 31 OphonalSet gs ossi S eta ern Dea Fs ce E EN S Lem ederet ir 5 32 Deplo
174. tion process 1 Onthe machine in which Infrastructure Web components have been installed navigate to the path FIC WEB HOME 2 Execute the command ant sh This will trigger the creation of WAR file lt contextname gt war The lt contextname gt is the name given during installation 3 Oncompletion of the WAR files creation a confirmation message will be displayed and you will be returned to the prompt 4 The WAR file contextname war is created on the machine on which Infrastructure Web components are installed under FIC WEB HOME directory Note the following This process will not overwrite any existing version of WAR file that exists in the path Rename delete any existing war file Proceed with the Tomcat WAR Files Deployment Logon to the server in which Tomcat is installed 5 2 3 6 Deploy Tomcat WAR Files Before deploying the WAR files ensure that the previously deployed applications of Infrastructure are uninstalled See Uninstalling Previously Deployed WAR Files in Tomcat for the procedure to uninstall the previously deployed Infrastructure war files On the machine that hosts Tomcat follow the steps outlined to deploy Infrastructure application 1 Open the URL in Browser window http lt IP address gt lt Tomcat server port gt https if SSL is enabled The Tomcat home window is displayed Post Installation Configuration 5 37 Configuring Web Application
175. to name your new JOSC data source a Mame ATOMSTSOL What JNOi name would you like to assign to your new JO6C Data Source 43 INDI Name jdbc ATOMSTSOL What database type would you lie to select Database Type Oracle Next Cancel 5 Enter JDBC data source Name JNDI Name and select the Database Type from the drop down list Click Next Ensure the following a The JNDI Name field should be in the format jdbc informationdomain 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 xml file of OFSAAI Application Required Database Type and Database Driver should be selected Figure 5 16 JDBC Data Source Properties Create a New JDBC Data Source Back Next Cancel JDBC Data Source Properties The folowing properties wil be used to identify your new JDBC 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 Orade WebLogk Server Database Driver Oracle s Driver Thin XA for Instance connections Versions 9 0 1 and later Back Next Cancel 5 12 OFSAA Infrastructure Installation and Configuration Guide Configuring Resource Reference 6 Select the Database Driver from the drop down list You need to select the Database Driver depending on
176. ture Installation Directory ficapp common FICServer conf LDAP LDIF folder to LDAPServer Schema folder 2 Copy the Domains ldif and Reveleus ldif files from Infrastructure Installation Directory gt ficapp common FICServer conf LDAP_LDIF folder to OpenLDAPServer folder Appendix Webserver Configuration for Infrastructure Application B 25 Additional Configurations Note Make sure that the ROOTCONTEXT in the Domains 1dif and Reveleus 1dif files are the same as slapd conf file 3 Provide the appropriate entries for ROOTDN ROOTPASS and ROOTCONTEXT in slapd conf file in the OpenLDAPServer folder 4 Add the text include schema reveleusSchema schema as the first line of the slapd conf file Note The above steps of the configuration are for OpenLDAP Server only If you need to configure Infrastructure for any other LDAP Server you will have to make the changes appropriately 5 In the command prompt navigate to the LDAP installation directory and execute the command 1dapadd D ROOTDN w ROOTPASS f data Reveleus ldif This is for creating the entries for Users User Groups Functions Profiles Segments Domains Roles and HolidayMaster in the Data information Tree of LDAP 6 Make an entry in the Domains 1dif file for each Information Domain that is created through the Infrastructure UI To add an entry corresponding to the new Information Domain to the Domains 1dif file add the follow
177. typically be the user HOME directory and will require to hold the below files directory Product Installer File Archive To be copied Product Installation Directory FIC HOME To be created prior to installation if the installation is in GUI mode Product Staging and Metadata Repository Directory To be created prior to installation This is also referred as FTPSHARE Note Youcan identify any other installation directory provided the user permission set on it is 755 Preparing for Installation 3 3 Common Installation Tasks 3 3 2 Configuration for GUI Mode Installation To install this product in GUI mode you need to ensure the below software and configurations are available Install and configure any PC X Server software such as Open Text Exceed formerly Hummingbird Exceed on the user desktop system from which the installation is triggered Configure DISPLAY variable Ensure to set the DISPLAY variable in user profile on the system on which the OFSAAI will be installed to point to the user desktop system where the PC X Server software has been installed Syntax export DISPLAY hostname n where hostname is the IP Address Host Name of the user desktop system and n is the sequence number usually 0 For example 10 11 12 13 0 or myhostname 0 3 3 3 Copying and Extracting the Software Once you obtain the installer copy the installer in BINARY mode to the system on which the
178. uld save the list of websites you have visited Days to keep pages in history Appearance Css Cueros ras Cnt Ce Ca 9 Jem wow 4 Inthe Internet Options window select the Security tab and select the Internet option under Select a zone to view or change the security settings B 18 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations Figure 8 19 Internet Options Internet Options General Security Privacy Content Connections Programs Advanced Select a zone to view or change security settings e amp yO Internet Local intranet Trusted sites Restricted sites Internet e This zone is for Internet websites except those listed in trusted and restricted zones Security level for this zone Allowed levels for this zone Medium to High Medium high em Appropriate for most websites zp Prompts before downloading potentially unsafe content Unsigned ActiveX controls will not be downloaded Custom level 5 Click Default Level under Security level for this zone B 2 9 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 Table B 8 INFOD
179. ully installed Installation Click on Done to exit the installer Please do not close the Install Complete console Post Install activites will be performed in console ORACLE FINANCIAL SERVICES InstallAnywhere 38 Click Done The Installation Complete window is displayed Installing OFSAA Infrastructure v 7 3 3 0 0 4 19 GUI Mode Installation Figure 4 31 Installation Complete Log File The log files OFSAA1733 10g and OFSAAInfrastructure_Install log can be found in the installation path FIC_HOME The log files contain detailed summary of installation processes It also shows the number of Fatal Errors Errors Debug Statements Information and Warnings Note The warnings IMP 00041 object created with compilation warnings present in sampleapp log can be ignored 4 20 OFSAA Infrastructure Installation and Configuration Guide 9 Post Installation Configuration Once the Infrastructure installation is completed successfully certain post installation steps are required to set configuration parameters These configuration parameters are distributed across the machines on which Infrastructure Web Application and Database components have been installed Note the following Ensure to clear the application cache prior to the deployment of Infrastructure or Application Service Packs One off patches This is applicable to all Web Servers WebSphere WebLogic Tomcat and OS combin
180. urations required space The below table consists of the Java settings done on both client and server machines Table B 1 optimized memory settings required for New model upload X_ARGS_APP ENV Size of Data Model XML Variable in OFSAAI APP Model Upload Options File Layer Pick from Server 106 MB Xms1024m Xmx1024m B6 MB Xms2048m Xmx2048m 815 MB Xms4096m Xmx4096m 1243 MB Xms6144m Xmx6144m Model Upload Utility 106 MB Xms1024m Xmx1024m 836 MB Xms2048m Xmx2048m 815 MB Xms4096m Xmx4096m 1243 MB Xms6144m Xmx6144m Save New Erwin File In 106 MB Xms1024m Xmx1024m das 836 MB Xms2048m Xmx2048m 815 MB Xms4096m Xmx4096m 1243 MB Xms6144m Xmx6144m B 2 2 3 Common Errors Some of the common errors during data model upload are ORA 02296 cannot enable OFSAA ATOMIC null values found Inside the Rollback Segment 2 ORA 01439 column to be modified must be empty to change the datatype 2 ORA 01758 table must be empty to add mandatory NOT NULL column inside the Rollback Segment 2 ORA 01440 column to be modified must be empty to decrease precision The above errors can be solved by truncating the table ORA 01442 column to be modified to NOT NULL is already NOT NULL This error can be solved by updating the column to NULLABLE B 12 OFSAA Infrastructure Installation and Configuration Guide Additional Configurations Note Increme
181. ure application 3 In the event if one or more than one DEBUG statements exists its optional on reinstall of Oracle Financial Services Analytical Applications Infrastructure application and he User could patch up the installation as required 4 In the event if one or more than one WARNINGS to have a confirmatory check done on the Schema creations insertions and updations If there are any ERRORS or FATAL ERRORS report them to Oracle Support or see OFSAA Infrastructure Frequently Asked Questions The OFSAA Infrastructure installation performs a post install health check on successful installation of the product To rerun the post install verification at a later time perform the following steps 1 2 Navigate to FIC HOMI q Execute the command piverify sh Note This utility is applicable only for base install of the product This utility should not be run if any patchsets are installed However if the installation was completed with POST INSTALL parameter value as 0 and the Post Installation Configuration was performed manually we recommend you to run this health check verification utility Verifying the Installation 7 1 7 2 OFSAA Infrastructure Installation and Configuration Guide 8 Uninstalling OFSAA Infrastructure This chapter includes the following sections Uninstalling OFSAA Infrastructure Uninstalling EAR Files in WebSphere Uninstalling EAR Files in WebLogic
182. user and ftp folder path OFSAAI DB LAYER This layer contains the Interaction Group that captures information on the shared file system details like the ftp user and ftp folder path You need to manually set the InteractionVariable parameter values as mentioned in Table If a value is not applicable enter NA and ensure that the value is not entered as NULL Table A 4 InteractionVariables and Expected Values InteractionVariable Name Significance and Expected Value Mandatory Layer name OFSAAI APP LAYER APP FTPSHARE PATH Identifies the absolute path to the directory Yes identified as file system stage area Notes 1 The directory should exist on the same system on which the OFSAA Infrastructure is being installed can be on a separate mount 2 The user mentioned in APP SFTP USER ID parameter below should have RWX permission on the directory For example InteractionVariable name APP FTPSHARE _ PATH gt gt oradata6 revwb7 ftpshare lt Interac tionVariable gt APP_SFTP_USER_ID Identifies the user who has RWX permissions on Yes the directory identified under parameter APP_ FTPSHARE_PATH above Layer name OFSAAI_DB_LAYER gt DB_FTPSHARE_PATH Identifies the absolute path to the directory Yes identified as file system stage area Note This value should be same as mentioned in parameter APP_FTPSHARE_PATH above DB_SFTP_USER_ID Identifies the user who has RWX permissions
183. ute Default Date Format 2 Members Reverse Population Hierarchy Reverse Population 2 Maximum levels allowed in Hierarchies 2 Node Limit for a Hierarchy Tree Configuration for Dimension and Hierarchy Management has to be done only after the application solution installation is done The properties specific to Information Domain are 2 SINFODOMS lt Name of the Information Domain DIMENSION ID Dimension ID for which the property to be set B 2 4 1 Configure Member Deletion This property should be set to allow the user to delete the Members for the Dimension Appendix Webserver Configuration for Infrastructure Application B 13 Additional Configurations Table B 2 Member Deletion Configuration Value Code Example Member Deletion MEMBER MEMBER __ Configuration VALUE DEL INFODOM DIME DEL ORAFUSION 1 Y Y N NSION_ID VALUE B 2 4 2 Configure Attribute Default Date Format This property should be set to display the Default Date Format for Date type Attribute in Attributes window Table B 3 Attribute Default Date Format Value Code Example Attribute Default Date ATTR DEF DATE ATTR DEF DATE Format DB DATE FORMAT INFODOM FORMAT ORAFUSION D FORMAT DD MON YYYY DB DATE FORMAT D MON YYYY B 2 4 3 Configure Members Reverse Population This property should be set for reverse population of Members for the Dimensions in required Information
184. virtual machine could be If the error message reads No Java virtual machine could be found from your PATH environment variable You must install a VM prior to running this program then 2 Check whether java path is set in PATH variable See the Table 3 1 Prerequisite Information section in this document 2 Check whether sufficient temporary space is available 2 Ensure that the movement of OFSAAI Installer text files to the target system is done in the Text mode so that setup sh file does not contain control line feed characters M Appendix Frequently Asked Questions D 3 Frequently Asked Questions During the installation what should one do if the error message shows OracleDriver Files Not Found Please Choose the Right Path To Continue Check whether the provided path for Oracle Driver files is correct and whether the user has permissions to access the files During installation what is to be done if the error always reads User must have CREATE TABLE CREATE VIEW CREATE TRIGGER CREATE INDEX CREATE SEQUENCE CREATE PROCEDURE even though the oracle schema user created has the mentioned privileges OFSAAL installer validates the database details provided during installation so ensure 2 Whether the oracle schema user has the required set of privileges for successful installation 2 Whether the oracle schema user has been created with quota privileges on tablespace to create database objects
185. wly created Data Source and click JAAS J2C authentication data link under Related Items JAAS J2C authentication data 5 8 OFSAA Infrastructure Installation and Configuration Guide Configuring Resource Reference Data sources gt Default Datasource gt JAAS 32C authentication data Specifies a list of user identities and passwords for Java TM 2 connector security to use v Prefix new alias names with the node name of the cell for compatibility with earlier releases Apply E Preferences New Delate sh QS Select Alias gt UserID gt Description gt You can administer the following resources O gxsizosgv upgsconf FICMASTER ne2N MA El x Y 4 M torffw O x Zon i on rorpnc O EXE REV Zone2h PET upgspft upgspft E exsisorev upgsprod upgsprod ZonsziodedS UPGSEROD O Sxzisongv upgsror upgsror Zenezhodeos UPGSROR o QXS120REY upgssand upgssand ZonezNodeQs UPGSS AND O x REV Zone2N T upgscont upgscont Total 8 2 Click New under the Preferences section Figure 5 11 JAAS J2C authentication data New Data sources gt Default Datasource gt JAAS J2C authentication data 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 een Description Atomic Instance ok Reset Cancel 3 Enter the Alias User ID Password and Description Ensure the following
186. xample FICMASTER Figure 5 28 Settings for Data Source Name Settings for FICHASTER Configuration Targets Monitoring Control Security Notes Statstcs Testing Use this page to test database connections in this JOBC data source P Customize this table Test Data Source Filtered More Columns Exist 4 Selectthe server and click Test Data Source A message is displayed indicating that the test was successful 5 Once the Data Source is created successfully the following messages are displayed a All changes have been activated No restart is necessary a Settings updated successfully If not follow the steps given above to recreate the data source 5 1 3 5 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 5DATA SOURCES and navigate to the path Home gt Summary of Services JDBC gt Summary of JDBC Data Sources JDBC Data Source x INFODDOM NAME 2 Setthe 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 3 Click Save Post Installation Configuration 5 19 Configuring Resource Reference 5 1 4 Configure Resource Reference in Tomcat Application Server This section is applicable only when the Web Application Server type is Tomcat Copy the JDBC driver file de
187. y Web Server Dort enr eee eee in eiie dre ie dais B 23 B 2 15 OFSAAI Setup Information Fetching Tool eee B 23 B 2 16 Encryption CHANGER siendo boe dere etre eterne et E B 24 B 2 17 Configure HTTPs Certificate information sse B 24 B 2 18 Infrastructure LDAP Configuration see eee eee nennen B 24 B 2 18 1 Configure Infrastructure Configuration Schema sess B 25 B 2 18 2 Configure OpenLDAP Files cit retten ter aE B 25 B 2 18 3 Migrate Data from CSSMS tables to LDAP server s sees B 27 B 2 19 Configure OFSAAI Web Services sess eee eene nnn nennen B 28 B 2 19 1 Configure DynamicWSConfig xml File sse B 28 B 2 19 2 web xml Entries ird ia IE de teet a tede cec B 30 B 2 20 Deploy OFSAAL Web Services cities i eite B 32 B 2 21 Configure Oracle database operations sss B 33 B 2 22 Configure Message Details in Forms Designer sse B 33 B 2 23 Clearing Application Cache sese eene eene B 34 B 2 24 Configuring Password changes sss eene nnne B 34 B 2 24 1 OFSAA Infrastructure Config Schema password modification B 34 B 2 24 2 OFSAA Infrastructure Atomic Schema password modification B 34 B 2 25 Configure Java Virtual Machine nitet nti tertiae ette B 35 Appendix Patching Your OFSAA Infrastructure Installation C 1 Patching Your OFSAA Infrastructu
188. yment SUMMA a eerte eee e e tU ee AA e re ee E es 5 33 Settings for Deployment Name eese eee 5 34 Summary of DeployMents us seen e ee RU en aie nde gerent Laeta 5 35 Summary Of Deployments iet ee eet ette 5 35 MM RM 5 38 Tomcat Web Application Manager c ccccccccsessesssesssteteesceeenescscenensnesesesnenssescecesesescsnananeneees 5 39 OESAAT Lobin WIN OW tee te it ete ite et be tato ete le debe Uti ste cet e ELE eee ia 6 3 UnimnstallinoOESAA Infrastructure ied e adeb eet deett 8 1 Enterprise Applications eter green eR ere eee eer eee eee es 8 2 Uninstall Application 7 1m erre rre e tne te eee perte reete rete irte eerte 8 2 Summary OF Deployiments het det e delet bb bue diete eere iere tgo 8 3 Summary of Deployments MessSageS ccococonenenoncncnnecnnnrnnnnncanananonnarnrannnnarananarnanararannn nara rannnnos 8 3 Tomcat Web Application Manager sssssess eee eee eee nennen nnne nennen 8 5 Integrated Solutions Console Login sse B 3 Enterprise Applications ai nee npe gente tenete eg eee Pepe ii B 3 Welt to estet t Co tA Ds Heo EMS B 5 Select DOMAIN Source ete Gis A EE rester ie inde i e HE E E ee B 5 Specify Domain Name and Location sse eee enne nennen B 6 Configure Administrator Username and Password sss B 6 Configure Server Start Mode and JDK s sss B 7 Select Optional Configuration seen nnne nennen nennt B 8

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