Oracle FLEXCUBE Direct Banking
Contents
1. 12Batabase Partitioningi E 31 13 Oracle Database Vauht anna 31 14 Related Documentation for Oracle FLEXCUBE Direct Banking database esseese esseen ernennen eee 32 4 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup Preface 1 1 Intended Audience Oracle FLEXCUBE Direct Banking Database setup document in particular is targeted toward the following groups of users with good knowledge of Oracle database administration e Database administrator performing database setup for Oracle FLEXCUBE Direct Banking e Oracle FLEXCUBE Direct Banking Development Teams e Oracle FLEXCUBE Direct Banking Implementation Teams e Oracle FLEXCUBE Direct Banking Implementation Partners 1 2 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 1 3 Access to OFSS Support https flexsupp oracle com 1 4 Structure This manual is organized into the following categories Preface gives information on the intended audience It also describes the overall structure of the User Manual Document explains setup of database for Oracle FLEXCUBE Direct Banking 1 5 Related Information Sources For more information on Oracle FLEXCUBE Direct Banking Release 12 0 2 0 0 refer to the following documents Oracle FLEXCUBE Direct Banking Licensing Guide 5 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Da2. 2 Run the sql script FCDB_PARTITION_TABLES sql as FCDB Admin db user Above script will partition the existing tables 13 Oracle Database Vault Oracle Database Vault With Oracle Database Vault organizations can pro actively safeguard application data stored in the Oracle database from being accessed by privileged database users Application data can be further protected using Oracle Database Vault s multi factor policies that control access based on built in factors such as time of day IP address application name and authentication method preventing unauthorized ad hoc access and application by pass Vault can be used for enabling disabling different features like 31 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup e RESTRICT USERS THROUGH PLSQL Developer e RESTRICT USERS FROM IP e RESTRICT USERS FROM MACHINE Please refer to Oracle documentation for enabling Database Vault 14 Related Documentation for Oracle FLEXCUBE Direct Banking database Related documentation provided by Oracle FLEXCUBE Direct Banking e Oracle_FLEXCUBE_Direct_Banking_Database_Design This document provides detail information on objects in Oracle FLEXCUBE Direct Banking database 32 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup
3. database CREATE TABLE CREATE user SEQUENCE CREATE TRIGGER CREATE DATABASE LINK CREATE VIEW CREATE PROCEDURE CREATE SYNONYM CREATE TYPE CREATE JOB Application FCDBAPP FCDBAPP ROLE CONNECT database user Note e The above two database users will be created by automated Oracle FLEXCUBE Direct Banking database setup script e The roles for above database two users will be created by automated Oracle FLEXCUBE Direct Banking database setup scripts e The user FCDBAPP created by automated Oracle FLEXCUBE Direct Banking database setup script will be created as locked user The DBA needs to explicitly unlock the user before use 12 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 5 2 Database Schema for Oracle XML BI Publisher for Reporting e The Oracle XML BI Publisher Server requires a separate database to maintain information for the scheduler which executes scheduled tasks for the reports This schema will be required only if report generation is part of the FLEXCUBE Direct Banking setup User ID XXXXX As Per Bank Policy The same needs to be updated during installation of FLEXCUBE DIRECT BANKING application Password XXXXX As Per Bank Policy The same needs to be updated during installation of FLEXCUBE DIRECT BANKING application Database Permissions CONNECT RESOURCE DBA DBA rights are required initially for this database and once the reports sch
4. 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 failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software 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 2 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 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 kin
5. remote FCC database o The scripts will also prompt to enter the FCDB App username Database link creations and their related synonyms are contained in the following scripts based on host Login as the FCDB EHMS database user amp execute the relevant host script Navigate to lt FCDB BASE DIR gt dbsetup entity UBS 12 0 Message prompted in sequence Description Example Enter target FCC username Username of the FCC database FCTEST Enter target FCC password Password of the FCC database FCTEST Enter the Base Directory Path Path for the base directory e g D FCDB Enter value forfcc_dest_host Hostipofthe FCC database 10 180 57 251 si Enter value for fcc dest port Port of the FCC database 1521 25 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup Enter value for fcc dest SID Give the SID of FCC database FCDB 1 Replace FCUBS schema with null 2 Enter the DBLink Enter value for identity B001 Enter value for File Path Provide the path lt FCDB BASE lt FCDB BASE DIR dbsetup entity UBS 1 2 0 DIR dbsetup entit y UBS 12 0 Enter The Value of Schema 1 In case of Schema To Schema Schema 1 Enter The Value Of FCUBS Schema FCUBS12R2 Name 2 Replace DBLink with null DBLink Enter The DBLink In case of DBLink Schema DBLink FCATFC CLink Enter value for time zone Time zone of the entity Asia Calcutta Enter entity hos
6. ARACTERSET AL16UTF16 The following database schemas are reguired for the installation of FLEXCUBE Direct Banking The User ID and Passwords for each of the schemas is expected to be different for each of the below schemas Other parameters in Oracle Initialization File 10000 Open Cursors 10 Setup Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database 5 Overview of Database Users for Oracle Flexcube Direct Banking 11 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 5 1 Oracle FLEXCUBE Direct Banking database users Oracle FLEXCUBE Direct Banking recommends creation of two database users 1 Admin database user The database user to administer Oracle FLEXCUBE Direct Banking database objects Schema of this user will house all the Oracle FLEXCUBE Direct Banking database objects 2 Application database user This user will used by the application to access the Oracle FLEXCUBE Direct Banking database objects The application user will house no database objects but will have pre defined access rights to database objects maintained in admin user s schema The predefined database object access should not be modified explicitly Below is brief overview of the two database users for Oracle FLEXCUBE Direct Banking Type Recommended Role created assigned Privilege assigned in the Role User Name by setup script Admin FCDBADMIN FCDBADMIN ROLE CONNECT CREATE SESSION
7. E Direct Banking 12 0 2 0 0 Database 6 Navigate to folder lt FCDB BASE DIR dbsetup dbscripts Date_Patch This folder contains the automated script for Oracle FLEXCUBE Direct Banking patch database setup 7 Please update the fcat properties located in lt FCDB BASE DIR gt system home with the properties lt IDENTITY gt Al lt PREFIX JNDI NAME gt lt IDENTITY gt AP lt PREFIX JNDI NAME gt lt IDENTITY gt CN lt PREFIX JNDI NAME gt lt IDENTITY gt BT lt PREFIX JNDI NAME gt 21 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 9 Multi Entity setup This chapter would provide the information on the Creation of Multi entities Installer by default creates 2 entities Global entity and Oracle FLEXCUBE Direct banking In order to create an entity over and above the default entities following steps needs to be carried out 10 Login to the Oracle FLEXCUBE Direct Banking database as Admin user 11 Execute the interactive FCDB_ENTITY_CLONE sql Navigate to folder lt FCDB BASE DIR dbsetup entity COMMON The Admin will be prompted to provide following information Message prompted in sequence Description Example Enter the path where logs will be The exact path where the script execution D FCDB logs created logs are expected has to be provided Enter entity identifier to be cloned The id provided for the existing entity B001 whose configuration is to be
8. Oracle FLEXCUBE Direct Banking Database Setup User Manual Release 12 0 2 0 0 Part No E50108 01 September 2013 ORACLE 1 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2008 2013 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended
9. backup policy based on the information provided data volume amp business considerations Tablespace Offline during backup Can be purged Archiving required TBS LOGDATA No No Yes TBS ROUTERDATA No No Yes TBS OFFLINE Yes Yes Yes TBS DOCPROC No No Yes TBS FULFILLMENT No No Yes TBS IDX LOGDATA No No Yes TBLSPC REPORTS SCH No No Yes EDULER FCAT No No Yes 28 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 11 Flashback Data Archive and Oracle Advanced Security TDE This chapter provides information to manage Flashback Archive and Transparent Data Encryption for Oracle FLEXCUBE Direct Banking Database Flashback Data Archive Flashback Data Archive is new feature in Oracle Database 11g that can automatically track and maintain historical changes to all oracle data in highly application transparent secure and efficient manner Part of Oracle Total Recall Option Flashback Data Archive overcomes the limitations of current approaches to historical data management and provides enterprise with a quick centralized and extremely efficient solution to meet their historical data management need Oracle FLEXCUBE Direct Banking provides sql script to enable disable flashback archive on selective tables in local database However flashback archive management is not part of the sql and should be handled by database administrator Please refer to Oracle Data
10. base documentation for more Steps to enable flashback 1 Flashback archive has been created by database administrator and relevant privileges granted Navigate to folder lt FCDB BASE DIR gt dbscripts dbobject misc 3 Run the sql script FCDB FLASHBACK ENABLE sql as FCDB Admin db user Flashback has been enabled on selective tables Steps to disable flashback 1 Navigate to folder lt FCDB BASE DIR gt dbscripts dbobject misc 2 Run the sql script FCDB FLASHBACK DISABLE sq1 as FCDB Admin db user 3 Flashback has been disabled 29 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup Oracle Advanced Security Transparent Data Encryption TDE Oracle Advanced Security TDE provides the ability to encrypt sensitive application data on storage media completely transparent to the application itself Oracle Advanced Security TDE column encryption was introduced in Oracle Database 10g Release 2 enabling encryption of application table columns containing sensitive data Oracle FLEXCUBE Direct Banking provides sql script to enable disable transparent data encryption on sensitive columns of selective tables in local database However wallet management pre requisite to TDE is not part of the sql and should be handled by database administrator Please refer to Oracle Database documentation for more Steps to enable TDE 5 Wallet Management has been completed pre requisite to TDE and wallet is now open fo
11. d 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 3 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup Contents t LTE A 1 44 Intended Te Ee EE A 1 2 Documentation Accessibili scssi iii K a EE N AA AE a 4 UE Access ET ET TEEN 4 AAS re sf 225 18004018 cate faced vce ak A E A ai EE 4 1 5 Related Information Gources nanaanaaaanneaeas 5 ZX ADBIEVIATIONS EE 6 SEENEN Ee kal alte al A ata he tata Ata ei ku Eech at ad 7 3 4 Ce EE 8 SEET VOL dere Eege 9 4 Database Installation Parameters AAA 10 5 Overview of Database Users for Oracle Flexcube Direct Banking 11 5 1 Oracle FLEXCUBE Direct Banking database users 12 5 2 Database Schema for Oracle XML BI Publisher for Reporting sssssssesssessressrssrresrssrrssrresrresrresre 13 6 Table space Structure for Oracle Flexcube Direct Banking 14 7 Automated Database Setup Scripts for Oracle FLEXCUBE Direct Banking 16 8 Single Entity Setup kostma Lada tea aged ananassae deeded ene ia ee ES 18 Si MOO Entity SEET he eke BASIS HEE ee EI A SS as 22 10 Backup 8 Purge policy for Oracle FLEXCUBE Direct Banking database cccesseeseeseeeeseseeees 27 11 Flashback Data Archive and Oracle Advanced Security TDE ccc cceeeeceeeeeeeeeeeeeeeeeseeeeseaeeseneeeeaes 29
12. ege assigned in the Role Name EHMS FCDB lt B001 gt lt environment CONNECT CREATE SESSION info gt CREATE DATABASE LINK CREATE VIEW CREATE PROCEDURE CREATE SYNONYM CREATE JOB 18 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 4 Database link creations and their related synonyms are contained in the following scripts based on host Login as the FCDB EHMS database user amp execute the relevant host script Navigate to lt FCDB BASE DIR gt dbsetup entity UBS 12 0 e FCDB MULTIENTITYFCATFCC MASTER sql o The administrator will be prompted to enter the Database link name Username password and SID for the remote FCC database o The scripts will also prompt to enter the FCDB App username Message prompted in sequence Description Example Enter target FCC username Username of the FCC database FCTEST Enter target FCC password Password of the FCC database FCTEST Enter the Base directory Path Path for the base directory e g D FCDB 2 Replace DBLink with null Enter target FCC database Host ip of the FCC database 10 180 57 251 host name ip Enter target FCC database port Port of the FCC database 1521 Enter target FCC database SID Give the SID of FCC database FCDB Enter entity Identifier B001 Enter the File Path Provide the path lt FCDB BASE lt FCDB BASE DIR dbsetup entity UBS 12 0 DIR dbsetup entit y UBS 12 0 Enter The Value of Sch
13. ema 1 In case of Schema To Schema Schema 1 Enter The Value Of FCUBS Schema FCUBS12R2 Name DBLink Enter The DBLink In case of DBLink 1 Replace FCUBS schema with null Schema DBLink GFCATFC 2 Enter the DBLink CLink Enter time zone Time zone of the entity Asia Calcutta Enter entity host mapping schema Value of EHMS schema FCDBBOO1 without identifier Enter Environment_Variable Value Of Env Variable TEST e FCDB FCATFCIS sql o To be executed only if Oracle FLEXCUBE Investment Services is to be installed o The administrator will be prompted to enter the Database link name Username password and SID for the remote FCIS database o The scripts will also prompt to enter the FCDB App username 19 Setup Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database 20 Setup e FCDB FCATFCR sql o Tobe executed only if Oracle FLEXCUBE Retail is to be installed o The administrator will be prompted to enter the Database link name Username password and SID for the remote FCR database o The scripts will also prompt to enter the FCDB App username After the execution of these scripts all the remote database related synonyms views and procedures will be created For updating the time zone of an Entity FCDB_ENTITY_JOBS sql located in lt FCDB BASE DIR dbsetup dbscripts JOB needs to be executed and the entity whose time zone is to be updated is given as an input Oracle FLEXCUB
14. ema is created the DBA rights can be revoked Tablespace TBLSPC_REPORTS SCHEDULER The name can be as per the bank policy Only a single Tablespace is required for this schema Storage Space To be determined based on requirements e e Note The database user table space for Oracle XML BI Publisher for Reporting module should be explicitly created by DBA and is not created by automated Oracle FLEXCUBE Direct Banking database setup script 13 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 6 Table space Structure for Oracle Flexcube Direct Banking This chapter lists the Oracle Flexcube Direct Banking application table spaces along with their purpose 14 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup Table space Accessible to Purpose TBS LOGDATA Admin database user All transactional log tables reside in this table space Data from this table space will be purged up to a pre decided purge period and moved to TBS OFFLINE periodically This table space needs to be coalesced TBS FULFILLMENT Admin All customer related fulfillment data will be stored in database user this table space TBS IDX LOGDATA Admin Table space to house the indexes database user FCAT Admin This is the default table space for admin 8 database user Application database user application user This will house all the other database object
15. g JNDI names lt A1 PREFIX JNDI NAME gt lt CN PREFIX JNDI NAME gt lt BT PREFIX JNDI NAME gt For the datasource creation refer the document Oracle FLEXCUBE Direct Banking Installation On Weblogic pdf section 4 Setup JDBC data source and Connection Pooling 18 Please create the corresponding war file e g BOOX war by using the existing B001 war 10 Backup amp Purge policy for Oracle FLEXCUBE Direct Banking database 27 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup This chapter provides information needed by Oracle FLEXCUBE Direct Banking DBA to decide on backup purge policy for Oracle FLEXCUBE Direct Banking database All the tablespaces except TBS OFFLINE is required to be always online amp accessible to the application hence cannot be taken offline for backup Scheduled job JOB MAINTAIN LOG moves all the log data from relevant tables to corresponding offline tables lying in TBS OFFLINE table space Now the tablespace TBS OFFLINI E can be taken offline for backup without any impact to the Oracle FLEXCUBE Direct Banking application After archiving the tablespace TBS OFFLINE it should be purged and made online The run interval of the job should be updated based on number of days log data be available online through the application The scheduled jobs are registered by FCDB ADMIN JOBS sql part of automate setup script The DBA should determine the
16. ity to reset admin user after application deployment Please refer the document documents FLEXCUBE Direct Banking Installation Steps for application deployment 2 Logs for all the scripts will be created at the chosen location Please review the log after completion of the setup script execution Unlock the Database user FCDBAPP user created by above script These scripts would complete the creation of 2 entities namely Global entity and Oracle Flexcube Direct Banking 17 Setup Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database 8 Single Entity Setup This chapter provides information on steps required to configure a single entity If the installation of Oracle FLEXCUBE Direct Banking has been done with Oracle FLEXCUBE Universal Banking Solution the steps enlisted below should be followed to configure the entity Note For installations involving External Core Banking System non FLEXCUBE the steps mentioned in this chapter are not to be followed 1 Navigate to folder lt FCDB BASE DIR gt dbsetup entity COMMON This folder contains the automated script for Oracle FLEXCUBE Direct Banking database setup 2 Login to the Oracle FLEXCUBE Direct Banking database as DBA Execute the interactive FCDB_ENTITY_SCHEMA_MASTER sal The DBA will be prompted to provide following information 3 Below is brief overview of the two database users for Oracle FLEXCUBE Direct Banking Type Recommended User Privil
17. nded DIR dbsetup Enter Path where this sql file is Provide the path lt FCDB BASE lt FCDB BASE located DIR dbsetup entity COMMON DIR dbsetup entit y COMMON Enter identifier for the new entity eg The Id of the new entity to be created B001 B002 Enter timezone region for the Time zone of the entity Asia Calcutta business entity B002 The EHMS user which will be created will have the following privileges 23 Setup Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Below is brief overview of the two database users for Oracle FLEXCUBE Direct Banking Type Recommended User Privilege assigned in the Role Name EHMS FCDB lt B001 gt lt environment CONNECT CREATE SESSION info gt CREATE DATABASE LINK CREATE VIEW CREATE PROCEDURE CREATE SYNONYM CREATE JOB 24 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup In case of schema to schema run file FCUBS_GR_PRIV sql Copyright ic 982 2010 Oracle All rights Enter u name FC1Z01RiDUP FC1201INST Enter password Connected to Oracle Datak lig Enterprise Edition Relea With the Partitioning OLAP Data Mining and cratch vork area DEV Installer 1201 sh_test Installer FCDB dbsetup entit ripts lue for identity FCDBB value for em info FCDB e FCDB MULTIENTITYFCATFCC MASTER sql o The administrator will be prompted to enter the Database link name Username password and SID for the
18. r use Navigate to folder lt FCDB BASE DIR gt dbscripts dbobject misc 7 Run the sql script FCDB TDE ENABLE sql as FCDB Admin db user TDE has now been enabled Steps to disable TDE 4 Navigate to folder lt FCDB BASE DIR gt dbscripts dbobject misc 5 Run the sql script FCDB_TDE DISABLE sql as FCDB Admin db user 6 TDE has now been disabled Note The above scripts are optional and not part of automated setup script The script s have to be run manually if needed 30 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 12 Database Partitioning This chapter provides information on the partitioning which helps in increasing performance Manageability and availability of data Partitioning Overview Table partitioning allows the table index or Index organized table to be subdivided into smaller pieces Each partition is db object with its own characteristics For this no modifications are necessary when accessing a partitioned table using SQL queries and DML statements This helps in faster querying as only required partitions are queried on the whole table Please refer to Oracle Database documentation for more details Oracle FLEXCUBE Direct Banking provides sql script to month wise partition of the following tables in local database e Auditlog e HostAuditlog e RouterAuditlog Steps to create partitioned table 1 Navigate to folder lt FCDB BASE DIR gt dbscripts dbobject misc
19. replicated Enter identifier for the new entity The Id of the new entity to be created B002 Enter description for the new entity Description of new entity Oracle flexcube 12 Navigate to folder lt FCDB BASE DIR dbsetup entity COMMON This folder contains the automated script for Oracle FLEXCUBE Direct Banking database setup 13 Login to the Oracle FLEXCUBE Direct Banking database as DBA 14 Execute the interactive FCDB ENTITY SCHEMA MAGTER sol The DBA will be prompted to provide following information 22 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup Message prompted in sequence Description Example Enter username for the entity host Schema name for the new entity FCDBB001 mapping EHM schema Identifier will environment Identifier will be auto be auto appended appended Enter the environment identifier Property to distinguish between the DEV _SIT various environments like SIT UAT etc The provided identifier will be appended when creating Enter Password Schema Password for the new entity schema Enter Password e g FCDBB002 Enter the Base directory Path Path for the base directory e g D FCDB Enter Value Of Schema Admin user id for the schema created FCDBADMIN using installer environment Identifier will be auto appended Enter location of grant scripts Grants script execution lt FCDB BASE dbscripts GRWN will be auto appe
20. ructure for Oracle Flexcube Direct Banking This chapter lists the Oracle Flexcube Direct Banking application tablespaces along with their purpose Chapter 6 Automated Database Setup Scripts This chapter discussed available scripts for Oracle Flexcube Direct Banking database setup Chapter 7 Single Entity setup This chapter provides information on steps required to configure a single entity for Oracle Flexcube Direct Banking Chapter 8 Multi Entity setup This chapter would provide the information on the Creation of Multi entities for Oracle Flexcube Direct Banking Chapter 9 Backup amp Purge policies for Oracle FLEXCUBE Direct Banking database This chapter provides information needed by Oracle FLEXCUBE Direct Banking DBA to decide on backup purge policy for Oracle FLEXCUBE Direct Banking database 9 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 4 Database Installation Parameters This section gives a detailed explanation of the database installation setup required The NLS settings to be configured for the database are mentioned below Database Parameter Parameter Value NLS LANGUAGE AMERICAN NLS TERRITORY AMERICA NLS CURRENCY Y NLS ISO CURRENCY AMERICA NLS NUMERIC CHARACTERS s NLS_CHARACTERSET AL32UTF8 NLS CALENDAR GREGORIAN NLS DATE FORMAT DD MON RRRR NLS DATE LANGUAGE AMERICAN NLS SORT BINARY NLS NCHAR CH
21. s This will house the tables containing application user details customer details and configuration details for Oracle FLEXCUBE Direct Banking Note The above tablespaces will be created by the by automated Oracle FLEXCUBE Direct Banking database setup script However the datafiles might have to be updated based on storage space requirements 15 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 7 Automated Database Setup Scripts for Oracle FLEXCUBE Direct Banking This chapter provides information on available scripts to setup the Oracle FLEXCUBE Direct Banking database Note The creation of FCDB Admin database is possible only using the installer 16 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup After the execution of the installer following objects will be created Details of the database object can be found in document Oracle FLEXCUBE Direct Banking Database Design Table spaces Roles Admin Application database users Tables Synonyms Views Functions Stored procedures Seguences Triggers Scheduled Jobs and Packages In case of Multi Entity Setup please skip Step 4 mentioned below Please follow steps detailed in section 7 Multi Entity Setup to create host specific Entity schema instead 1 After the execution of installer A Flexcube Direct Banking Application Admin user which end user will input will be created which will be locked This user should be unlocked using the java util
22. t mapping schema Value of EHMS schema FCDBB001 without identifier ehms Enter value for env info Value Of Env Variable TEST e FCDB FCATFCIS sql o The administrator will be prompted to enter the Database link name Username password and SID for the remote FCIS database o The scripts will also prompt to enter the FCDB App username o This file needs to be executed if the the host is FCIS e FCDB FCATFCR sql o The administrator will be prompted to enter the Database link name Username password and SID for the remote FCR database o The scripts will also prompt to enter the FCDB App username o _ This file needs to be executed if the the host is FCR After the execution of these scripts all the remote database related synonyms views and procedures will be created 15 For updating the time zone of an Entity FCDB_ENTITY_JOBS sq located in lt FCDB BASE DIR dbsetup dbscripts JOB needs to be executed and the entity whose time zone is to be updated is given as an input 16 Please update the fcat properties located in lt FCDB BASE DIR gt system home with the properties lt IDENTITY gt A1 lt A1 PREFIX JNDI NAME gt lt IDENTITY gt AP lt AP PREFIX JNDI NAME gt 26 Setup Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database lt IDENTITY gt CN lt CN PREFIX JNDI NAME gt lt IDENTITY gt BT lt BT PREFIX JNDI NAME gt 17 Please create a new datasource in the application server for the followin
23. tabase Setup 2 Abbreviations FCDB Oracle FLEXCUBE Direct Banking J2EE Java 2 Enterprise Edition Java EE Java Enterprise Edition J2SE Java 2 Standard Edition DBA Database Administrator FCDB BASE DIR FCDB Base Working Directory 6 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 3 Overview The following document details the parameters for the database setup for Oracle FLEXCUBE Direct Banking 7 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 3 1 Pre requisite Oracle FLEXCUBE Direct Banking Database setup document assumes e Oracle Database 10g is installed e Target Oracle Database instance for Oracle FLEXCUBE Direct Banking is available e Oracle Flexcube Direct Banking is installed using Oracle FLEXCUBE Direct Banking Installer without Dayzero setup mode Note If Oracle Flexcube Direct Banking is installed with Oracle FLEXCUBE Direct Banking Installer using Dayzero setup mode then the entities mentioned in this document will be created by the Installer 8 Oracle FLEXCUBE Direct Banking 12 0 2 0 0 Database Setup 3 2 Structure This document contains Chapter 3 Database Installation Parameters This chapter contains the requisite parameters during database installation Chapter 4 Overview of Oracle Flexcube Direct Banking Database Users This chapter discusses different database users required for Oracle Flexcube Direct Banking Chapter 5 Tablespace St
Download Pdf Manuals
Related Search