Oracle Financial Services Analytical Applications
Contents
1. PARAMETER NAME HIERARCHY CACHE SIZE VALUE 2000 PARAMETER NAME DIMENSION CACHE SIZE VALUE 2000 PARAMETER NAME HIERARCHYATTRIBUTE CACHE SIZE VALUE 1000 PARAMETER NAME CUBE CACHE SIZE VALUE 1000 gt PARAMETER NAME RDM CACHE SIZE VALUE 1000 PARAMETER NAME BUSINESSPROCESSOR CACHE SIZE VALUE 2000 lt PARAMETER NAME DERIVEDENTITY CACHE SIZE VALUE 1000 gt PARAMETER NAME LOG GET METADATA VALUE false gt PARAMETER NAME METADATA PARALLEL CACHING VALUE 0 gt lt PARAMETERS gt lt SERVICE gt Oracle Financial Services Software Confidential Restricted 18 ORACLE OFSAAI 7 3 5 0 0 Installation Guide While creating an Excel Mapping after specifying the excel worksheet the target table and mapping each column in the worksheet to a target table click SAVE and nothing happens But when I click CANCEL a message pops up informing me that all changes will be discarded what is to be done Check if the version of Internet Explorer and JRE Plugin are same as mentioned in Desktop Requirements section of this manual If not use the qualified versions as mentioned Oracle Financial Services Software Confidential Restricted 19 ORACLE ORACLE OFSAAI 7 3 5 0 0 Installation Guide Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle co2. 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 Oracle Financial Services Software Confidential Restricted 16 ORACLE OFSAAI 7 3 5 0 0 Installation Guide What should I do to change context name for a cloned environment Refer to Support Note Which version of ERwin Data Modeler 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 What should I do for viewing the log files in Debug level for troubleshooting By default the log level is set as INFO You need to manually change it to Debug to view the log files in debug level Based on your requirement you can change the log level to Warn Error or Fatal as well 1 Navigate to FIC HOME conf in the APP layer of your OFSAAI installation Change the priority value to Debug in the HevLog4jConfig xml file For example root priority value debug appender ref ref ConsoleAppenderl lt root gt Change the value of LOGGERLEVEL in the DynamicServices xml file from 20 to 0 20 is the value for Info and 0 for Debug NOTE For multi tier installation you need to change the log level to Debug in the DynamicServices xml and HevLog4jConfig xml files which are present in FIC APP HOME conf FIC DB HOME conf
3. to the file using the command chmod 751 OFSAAI 73500 OperatingSystem zip Oracle Financial Services Software Confidential Restricted 6 ORACLE OFSAAI 7 3 5 0 0 Installation Guide 6 Extract the contents of the 7 3 5 0 0 IR archive file using the command unzip os a name of the file to be unzipped NOTE The above a option is mandatory to unzip the archive file For example unzip aix a OFSAAI 73500 OperatingSystem zip 7 Give EXECUTE permission to the IR archive file Navigate to the path OFSAAI 73500 OperatingSystem zip and execute the command chmod 750 OFSAAIUpdate sh 8 Execute OFSAAIUpdate sh file Verify if the IR is applied successfully by checking the log file generated in the installation folder You can ignore ORA 00001 ORA 00955 ORA 02260 and ORA 01430 errors in the log file In case of any other errors contact Oracle Support NOTE This IR installation will enable the RRF Run Rule Framework module by default If you have been using the PR2 module installer validates the existence of PR2 definitions and enables the PR2 module instead of the RRF module However post the installation you can configure and migrate from PR2 to RRF module For more details refer to the PR2 to RRF Migration Guide available in OTN Library 9 Forinformation on securing your OFSAA Infrastructure refer note 1540442 1 in My Oracle Support MOS 10 Refer to the additional configuration instructions
4. Installation and Configuration Guide 15 After the successful installation of the IR restart all the OFSAAI services For more information refer to the Start Stop Infrastructure Services section in OFSAAI 7 3 Installation and Configuration Guide How to Enable OFS Advanced Analytical Applications Infrastructure OFS AAAI OFS AAAI is a separately licensed product After installing OFS AAI successfully perform the following steps to enable OFS AAAI 1 Login to https support oracle com and search for 19194369 under the Patches amp Updates tab 2 Download and install the patch to enable the functionality How to Apply the Patch 21662668 If you wish to use the binaries natively compiled on RHEL Oracle Linux 6 x apply the one off patch 21662668 USE NATIVE G COMPILER FOR BUILDING PLATFORM CPP CODE Perform the following steps after successfully installing 7 3 5 0 0 IR 1 Login to https support oracle com and search for 21662668 under the Patches amp Updates tab 2 Download and install the patch For more details refer the Read Me available with the patch Additional Configuration Configuration for Oracle R Distribution and Oracle R Enterprise ORE Following are the prerequisites for using R scripting in the OFSAAI modeling framework Ensure the below sequence is followed Oracle Financial Services Software Confidential Restricted 8 ORACLE OFSAAI 7 3 5 0 0 Installation Guide 1 Install Oracle R Di
5. Oracle Financial Services Analytical Applications Infrastructure Installation and Configuration Guide Version 7 3 5 0 0 ORACLE FINANCIAL SERVICES DOCUMENT CONTROL Version Number Revision Date Changes Done 1 0 Created August 2014 Captured 7 3 5 0 0 Interim Release enhancement updates Added steps to enable OFS AAAI 2 0 September 2015 Added details of the One off patch 21662668 Created by Reviewed by Approved by Gitcy Bharath Jeevraj Surag Deepthi Subhashini Executive Summary This document includes the necessary instructions to apply 7 3 5 0 0 Interim Release and perform the required post install configurations You can find the latest copy of this document in OTN library which includes all the recent additions revisions if any done till date Oracle Financial Services Software Confidential Restricted ORACLE Table of Contents TABLE OF CONTENTS T OFSAALIRHEEEASE 7 3 5 0 0 cecidere aa ete ssi etn e anaa e ta Cos rusos U genes Talia idc e e rene 4 1 1 Supported Software VErSIONS x5 x epe er eres xin etur fores ase e avai basarsecis tees Gee 4 1 2 Pre B arsi nfojadai re PII MM H 4 1 3 How to Apply This Interim Release eesesssesssesessseeseesen eene nnne nnne tenente nennen nnne nnne neret 5 1344 I stallihg OF S ANAL aui cs Apres iene eben ae aia bane 5 1 3 2 How to Enabl
6. RE section What should do if 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 gt AppServer deploytool itp For example SJAVA_CMD Xbootclasspath a ejbd bootpath Xms256m Xmx1024m Why cannot I view the SQL Rule link under UMM gt Data Management Tools This feature has restricted access However if you want to reinstate access to this feature refer to Support Note Why cannot I view the following links from the OFSAAI homepage post installation of this IR UMM gt BMMs Hierarchy Attribute and Computed Measure System Configuration Hierarchy Security These features are no longer supported Why cannot I view Batch Group link under Operations This feature has restricted access However if you want to re instate access to this feature contact support How to grant privileges if a new Information Domain is created See the nformation Domain section under System Configuration module in OFSAAI User Manual What checks does the 7 3 5 0 0 IR patch perform Environment Check As part of environment check it performs Java validation Environment Variables validation OS specific validation DB specific validation and it shuts down all OFSAAI Services Infrastructure Server ICC Server and back end services Oracle Financial Services Software Confidential Restricte
7. and FIC WEB HOME conf as well 2 Navigate to FIC WEB HOME webroot conf and change the priority value to Debug in the ExportLog4jConfig xml MDBLogger xml and PR2Logger xml files for viewing log files in Debug level for the modules Archive Restore Metadata Browser and RRF respectively 3 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 refer to the Post Installation Configuration section in OFSAAI 7 3 Installation and Configuration Guide 4 Restart the OFSAAI Services APP and WEB For more information refer to the Start Stop Infrastructure Services section in OFSAAI 7 3 Installation and Configuration Guide How do you turn off unused Information Domains Infodoms from caching Follow the below steps to turn off unused infodoms from caching Navigate to FIC_HOME conf in the APP layer of your OFSAAI installation 1 In the DynamicServices xml file identify the section for Service code 20 gt Oracle Financial Services Software Confidential Restricted 17 ORACLE OFSAAI 7 3 5 0 0 Installation Guide 2 Modify the value of parameter CACHE ON STARTUP to 0 default is 1 3 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 information on generating and deploying EAR WAR file refer to the Pos
8. applied on a fresh installation of OFSAAI ensure the Post Installation Configuration of OFSAAI 7 3 GA has been completed prior to proceeding with the installation of this IR If you are applying this IR on an existing working setup of OFSAAI 7 3 x you may skip this step Execute the following query in CONFIG schema ELECT DISTINCT T1 V BATCH ID FROM BATCH MASTER T1 BATCH MASTER WHERE EPLACE TRANSLATE T1 V_BATCH_ID amp 2 1 NNI 22 UU pt tt REPLACE TRANSLATE T2 V BATCH ID Qf amp 2 1 NNI 22 7 AND T1 V CREATED DATE lt gt T2 V CREATED DATE d H U N This query returns a list of Batch Names with special characters space These characters spaces are removed as part of the IR installation However few constraints may fail to get enabled Therefore if the query returns a list of Batch names you need to manually remove and recreate the batches without using the special characters space For more information on creating batches refer to the Operations gt Batch Maintenance section of OFSAAI 7 3 5 0 0 User Manual Provide create synonym privileges for atomic schemas Log in to the database with dba privileges and execute the below grant to provide create synonym privilege on all existing atomic schemas grant create synonym to atomic user NOTE The list of existin
9. d 15 ORACLE OFSAAI 7 3 5 0 0 Installation Guide Post Install check As part of Post install check it checks if OFSAAI services can be successfully started When should I run the MLS utility See the Multiple Language Support MLS Utility section in OFSAAI Administration Guide What are the optimized memory settings required for New model upload The below optimization settings are introduced as a part of 7 3 3 0 0 IR Model Upload Options Size of Data Model X_ARGS APP Environment XML File Variable in OFSAAI APP layer Pick from Server 106 MB Xms1024m Xmx1024m 336 MB Xms2048m Xmx2048m 815 MB Xms4096m Xmx4096m 1243 MB Xms6144m Xmx6144m Model Upload Utility 106 MB Xms1024m Xmx1024m 336 MB Xms2048m Xmx2048m 815 MB Xms4096m Xmx4096m 1243 MB Xms6144m Xmx6144m Save New Erwin File In 106 MB Xms1024m Xmx1024m EM 336 MB Xms2048m Xmx2048m 815 MB Xms4096m Xmx4096m 1243 MB Xms6144m Xmx6144m For additional information refer to the Configuration for Model Upload Utility section in OFSAAI 7 3 Installation and Configuration Guide What should do if my Hierarchy filter is not reflecting correctly after 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
10. e OFS Advanced Analytical Applications Infrastructure OFS AAAI sees 8 1 3 3 How to Apply the Patch 21662668 sicir acria na eerte i nei tpa ia Teaia FERE e a eia gas 8 1 4 Additional Cortfig ratiOl u ciii iit ei hn Re dana EL haue anny Rx ada CERA REP Rx Sa 8 1 4 1 Configuration for Oracle R Distribution and Oracle R Enterprise ORE 8 1 4 2 Property Data File Name in PR2 and RRF Modules eene eterne nnne tnn nnne tenen ne tnnan 11 1 4 3 Stress Testing Framework Configuratio Missean aa Ea eie ie rd eerte a ree ke us 12 1 44 BlowFish Algorithim Setting for Solaris 11 i ime t eie be iR Rr n EA 12 1 5 Module Spe cific Configurations ses sepe ii epe Eee cdg e E Re e d x d pe Rap dl pede N NEEE 13 MAPPED e n 14 Configuration of Internal Service Document upload downloadQ senes 14 Didddb4 e 15 Frequently Asked Question P M 15 Oracle Financial Services Software Confidential Restricted iii ORACLE OFSAAI 7 3 5 0 0 Installation Guide OFSAAI Release 7 3 5 0 0 This Interim Release IR of OFSAAI is cumulative and includes all the enhancements and bug fixes done since the OFSAAI v7 3GA release Conventions and Acronyms Conventions Description Actions are indicated in Bold Command or qu
11. e is listed there by executing the command lc 1 4 1 2 Uninstalling OFSAAIRunner Package Refer to the following instructions to uninstall the OFSAAIRunner package 1 Login to the Oracle Database Server with the same username using which Oracle Database Server installation is done 2 Enter ORE in command prompt and execute the command ORE gt remove packages OFSAATRunner 3 To save workspace image enter the command q 4 Enter y when prompted to save the workspace image Save workspace image y n c y Oracle Financial Services Software Confidential Restricted 10 ORACLE OFSAAI 7 3 5 0 0 Installation Guide 5 Navigate to the directory ORACLE HOME H library and verify the package is not listed there by executing the command ls 1 1 4 2 Property Data File Name in PR2 and RRF Modules The following configuration needs to be done if the patch installation log file states Data File Name not specified for below processes in Infodom Names This error will be shown in case the value for parameter Data File Name in the PR2 RRF Process definitions is blank Then you need to take any one of the following actions as the case may be 1 You need to edit the listed PROCESS definition s and specify a DATAFILENAME with extension Process definition can be edited through the PR2 or RRF framework that you use 2 If there is no explicit file name provided as mentioned above in PR2 or RRF module you can
12. enced in this document refers to the different components of AAI installed on any box For example DB tier would mean the box on which the ficdb components of AAI are installed and does not mean the physical DB engine Similarly the WEB tier would mean the box on which the ficweb component resides and does not mean the physical web server J2EE engine APP tier would mean the box on which the ficapp components reside 3 Shut down all the OFSAAI Services For more information refer to the Start Stop Infrastructure Services section in OFSAAI 7 3 Installation and Configuration Guide 4 Assign WRITE permission to the files folders such as commonscripts EXEWebService ficapp ficweb and ficdb in the FIC HOME folder by executing the command chmod R 750 In case of multi tier installation repeat this step on all tiers 5 f you have Unzip utility skip to the next step Download the Unzip utility OS specific unzip os 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 HOME path or directory in which you have copied the 7 3 5 0 0 IR Uncompress the unzip installer file using the command uncompress unzip_ lt os gt Z NOTE Incase 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
13. ery is indicatedin Courier New font AIX Advanced Interactive eXecutive OFSAAI Oracle Financial Services Analytical Applications Infrastructure OFS AAAI Oracle Financial Services Advanced Analytical Applications Infrastructure RHEL Red Hat Enterprise Linux IR Interim Release ML Maintenance Level R Third party open source software Open source R is governed by GNU General Public License GPL Oracle R Distribution Oracle R Distribution is Oracle s free distribution of open source R Oracle R Enterprise Oracle R Enterprise integrates R the open source scripting language and environment with Oracle Database Atomic Schema Database schema where the application data model is uploaded Config Schema Database schema which contains setup related configurations and metadata 1 1 Supported Software Versions OFSAAI 7 3 5 0 0 version is compatible on RHEL Oracle Linux 6 4 and Solaris 11 NOTE The binaries on 7 3 5 0 0 are natively compiled on RHEL Oracle Linux 5 x If you wish to use the binaries natively compiled on RHEL Oracle Linux 6 x apply the one off patch 21662668 For more details refer to How to Apply the Patch 21662668 section 1 2 Pre Installation Requirements You should have 7 3 GA as the minimum patch set level Oracle Financial Services Software Confidential Restricted 4 ORACLE OFSAAI 7 3 5 0 0 Installation Guide If this IR is being
14. explained in the Additional Configuration section to complete the installation of this IR 11 Post successful installation of IR perform the following steps Clear the application cache Navigate to the following path depending on the configured web application server and delete the files Tomcat lt Tomcat installation folder gt work Catalina localhost lt Application name gt org apache jsp Weblogic lt Weblogic installation location gt domains lt Domain name gt servers lt Server name gt tmp _WL_user lt Application name gt qaelce jsp_servlet Websphere lt Websphere installation directory gt AppServer profiles lt Profile name gt temp lt Node name gt server1 lt Application name gt lt war file name gt Oracle Financial Services Software Confidential Restricted 7 ORACLE 1 3 2 1 3 3 1 4 1 4 1 OFSAAI 7 3 5 0 0 Installation Guide 12 Add umask 0027 in the profile of the UNIX account which manages the WEB server to ensure restricted access permissions 13 Make the necessary module specific configurations as mentioned in Module Specific Configurations section If you wish to make these configurations at a later time proceed with the next step 14 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 refer to the Post Installation Configuration section in OFSAAI 7 3
15. g atomic schemas can be retrieved from DB MASTER table present in config schema by executing this command select dbuserid from db master If you do not have permission to create directory in the OFSAAI installation mount specify the backup location where the installer or patch can create a backup directory for patch deployment in the params conf file present along with installer kit You should have access rights on the specified backup location For example BACKUP LOCATION scratch ofsaaapp backup NOTE If you have permission to create directory in the OFSAAI installation mount backup directory will be created in the OFSAAI installation mount even though you provide another location in the params conf file 1 3 How to Apply This Interim Release 1 3 1 Installing OFS AAI Refer to the following instructions to download extract install and configure this IR Oracle Financial Services Software Confidential Restricted 5 ORACLE OFSAAI 7 3 5 0 0 Installation Guide 1 Login to https support oracle com and search for 19458957 under the Patches amp Updates tab 2 Download the 7 3 5 0 0 IR archive file and copy it to your AAI server in Binary mode NOTE The archive files are different for every operating system like AIX Solaris and RHEL Oracle Linux In case of a multi tier deployment the IR needs to be copied and installed on each tier APP tier DB tier WEB tier Note that the terminology tier refer
16. m us industries financial services Copyright 2014 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this 7 3 5 0 0 Installation Guide and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this 7 3 5 0 0 Installation Guide and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated Oracle Financial Services Software Confidential Restricted 20
17. o create folders with Read Write permission execute the command mkdir m 777 download upload TempDocument Temp 2 Create DocStorage folder in the FTPSHARE location of APP tier and provide Read Write permission To find the exact location execute the below query in CONFIG schema select ftpdrive from app server info Tocreate folder with Read Write permission execute the command mkdir m 777 DocStorage By default the parameter DOCUMENT SERVICE TYPE EXTERNAL value is set to FALSE in the Configuration table in CONFIG schema and hence the application ExeWebService will not be used It is recommended that the value to be set to FALSE and use the Internal service for document upload downloads If you intend to continue using the External ExeWebService set the value to TRUE Navigate to FIC HOME EXEWebService WEBSERVER TYPE directory of WEB tier and type ant sh This triggers the creation of EAR WAR file EXEWebService ear war The EAR WAR file EXEWebService ear war will be created in FIC HOME EXEWebService WEBSERVER TYPE directory of WEB tier Redeploy the generated EAR WAR file onto your configured web application server Oracle Financial Services Software Confidential Restricted 14 ORACLE OFSAAI 7 3 5 0 0 Installation Guide Appendix B Frequently Asked Questions What configurations should I ensure for successful Oracle R executions Refer to the Configuration for Oracle R Distribution and Oracle R Enterprise O
18. provide this through a property Data File Name in File to Table F2T definition 3 If no explicit file name is provided as mentioned in any of the above 2 cases the system expects the sourced file name to be lt F2T definition name gt dat lower case extension by default Note the following Ensure that the flat file s is henceforth sourced in the same format UNIX based systems preserve the case sensitivity Example DAT and dat are not the same This is applicable only for new execution requests raised post installation of this patch Update all the existing flat file extensions present in the ftpshare STAGE area before creating any new run requests If you are using RRF framework execute the below queries on CONFIG schema where Run s Rule s are defined The below query would return the PROCESS names where the property DATAFILENAME is specified and currently blank You need to edit the PROCESS definition s and specify a DATAFILENAME For example STG FCT EXPOSURES DAT process sq The below query would return the RUN names where the property DATAFILENAME is used and currently blank You need to edit the RUN definition s and specify a DATAFILENAME For example STG FCT EXPOSURES DAT Oracle Financial Services Software Confidential Restricted 11 ORACLE OFSAAI 7 3 5 0 0 Installation Guide run sql 1 4 3 Stress Testing Framework Configuration If you are using the Stress Testing Framework in
19. ripts within OFSAAI This package helps in Initializing inputs Mapping framework variables to R objects Configuring possible outputs of the script Storing results back to the Database OFSAAIRunner package OFSAA Runner_1 0 0 tar gz is available under lt OFSAAI Database Installation Directory gt ficdb bin Skip this step if it is already installed Oracle Financial Services Software Confidential Restricted 9 ORACLE OFSAAI 7 3 5 0 0 Installation Guide Prerequisite R amp ORE should be installed on the Oracle Database server before installing OFSAAIRunner package Refer to the following instructions to install OFSAAIRunner package 1 Log in to the OFSAAI DB layer Navigate to the folder FIC DB HOMEY birv 2 Download the file OFSAA Runner_1 0 0 tar gz on to your desktop 3 Login to the Oracle Database Server with the same username using which Oracle Database Server installation is done 4 Copy the file OFSAA Runner_1 0 0 tar gz in Binary mode 5 Navigate to the directory where the file OFSAA Runner_1 0 0 tar gz is copied 6 Install the package by executing the command ORE CMD INSTALL OFSAAIRunner 1 0 0 tar gz Successful installation is indicated in the installation log as DONE OFSAAIRunner Making packages html done NOTE The OFSAAIRunner package is installed in usr lib64 R library 7 Navigate to the directory ORACLE HOME H library and check whether OFSAAIRunner packag
20. ssful IR update in order to use these features For more information on configuration of these features refer to OFSAAI Administration Guide Oracle Financial Services Software Confidential Restricted Dimension Configuration Alphanumeric and Numeric Codes Hierarchy Node Internationalization T2T and PR2 Query Performance Optimization Configure Data Quality Rule Approval Parameters Run Rule Framework Configuration Configure Forms xml to Execute Server Side Rule Data Element Filters Classification Configure Forms Framework Enhancements Multiple Language Support MLS Utility Config Schema Upload Download Settings Database Password Reset Change Configure SSO Authentication 13 ORACLE OFSAAI 7 3 5 0 0 Installation Guide Appendix A Configuration of Internal Service Document upload download This step can be ignored if it has already been configured as part of any previous IR ML installation The Document Upload Download feature has undergone a change and can now be configured to use Internal service for document upload download instead of the earlier ExeWebService To facilitate Internal service for document upload download perform the following configurations 1 Create the folders download upload TempDocument and Temp in the local path of Web application server and provide Read Write permission To find the exact location execute the query in CONFIG schema select localpath from web_server_info T
21. stribution and Oracle R Enterprise Server Components on the Oracle Database server See Oracle R Enterprise Installation and Administration Guide for Windows Linux Solaris and AIX Release 1 3 1 E36763 17 Oracle R Distribution versions supported Oracle Distribution of R version 2 15 1 2 15 2 or 2 15 3 ORE version supported Oracle R Enterprise Server version 1 3 1 NOTE Oracle R Enterprise 1 3 1 requires Oracle Database Enterprise Edition 11 2 0 3 2 Install OFSAAIRunner Package If you have already installed OFSAAIRunner package as part of a previous installation uninstall it and reinstall the latest available OFSAAIRunner package 3 Login to the database with dba privileges and provide the following privilege to Configuration Schema RQADMIN by executing the command grant RQADMIN to config schema 4 Login to the database with dba privileges and provide the following privileges to Atomic Schema CREATE UNLIMITED TABLESPACE privilege by executing the command grant CREATE UNLIMITED TABLESPACE to atomic schema CREATE MINING MODEL privilege to execute the Data Mining models by executing the command grant CREATE MINING MODEL to lt atomic_schema gt 1 4 1 1 Installing OFSAAI Runner Package OFSAAIRunner is an R package built by the framework It is a prerequisite for executing models developed using R sc
22. t Installation Configuration section in OFSAAI 7 3 Installation and Configuration Guide 4 Restart the OFSAAI Services APP and WEB For more information refer to the Start Stop Infrastructure Services section in OFSAAI 7 3 Installation and Configuration Guide 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 lt PARAMETERS gt lt PARAMETER NAME CACHE ON STARTUP VALUE 0 gt lt PARAMETER NAME BACKUP XML VALUE 1 gt 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 gt PARAMETER NAME DATASET CACHE SIZE VALUE 2000 PARAMETER NAME MEASURE CACHE SIZE VALUE 2000 gt
23. the Advanced Analytics Infrastructure section follow the below steps Execute the below query in the Configuration Schema select prb v_run_id from pr2_run_b prb where prb v_seeded_by AAI and prb v infodom name lt infodom gt NOTE Replace lt infodom gt with the required information domain name s Execute the below query in the corresponding Atomic Schemas update dim run dr set dr n run type skey 3 where dr v run id in VAL1 VAL2 NOTE Replace the above place holders lt VAL1 gt VAL2 in the insert query with values from the select query result The list of existing atomic schemas can be retrieved from the DB MASTER table present in the Configuration Schema by executing this command select dbuserid from db master 1 4 4 BlowFish Algorithm Setting for Solaris 11 Perform the following steps to enable the SFTP negotiations on Solaris 11 1 Login as a root user 2 Append the following line to etc ssh sshd config Ciphers aes128 ctr aes192 ctr aes256 ctr arcfouri128 arcfour256 arcfour blowfish cbc 3des cbc 3 Restart ssh daemon svcadm v restart ssh Oracle Financial Services Software Confidential Restricted 12 ORACLE OFSAAI 7 3 5 0 0 Installation Guide 1 5 Module Specific Configurations This IR includes the following module and or feature enhancements done since OFSAAI v7 3 GA release You may be required to do certain specific configurations post succe
Download Pdf Manuals
Related Search