Contents
• Introduction
• Logical View – Flexcube 12
• Backups, Reporting and Batches
• Flexcube 12 Database
• Challenges
Introduction
• Flexcube is oracle’s core banking, online banking, mobile banking and
wealth management solution. The main components of flexcube include
Universal banking (core banking), Direct Banking (Internet banking) and
Mobile Banking.
• This presentation will focus on the database as part of the oracle flexcube
system. We will look at the client base experience and some of the new
discoveries found during the database implementation.
• We will also give an opportunity to other flexcube administrators that
have implemented the solution on their site to share their experience
Flexcube 12 Database
( version 11.2.0.4 )
Storage and Shared File systems
• The Database files are stored on a SAN storage with AIX 7 Files systems
structure.
• RMAN backups are written directly to tape using Tivoli Storage Manager.
• Shared file system for the flexcube debug logs and flexcube swift
messages.
Flexcube Application Schemas
• FCUBS – Flexcube Universal Banking
• FCDB – Flexcube Direct Banking
• FCDBB001, FCDB_ADMIN – Direct Banking Admin users
The RCU installer requires a user with sysdba privileges and this creates
additional tablespaces with datafiles, application users and grant privileges.
Some of Application Users Privileges
• UTL_FILE
• UTL_TCP
• UTL_SMTP
• UTL_HTTP
• DBMS_LOB
• DBMS_SQL
• DBMS_JOB
• DBMS_RANDOM
• DBMS_LOCK
• DBMS_AQ
• DBMS_ALERT
• DBMS_SCHEDULER, etc.
Flexcube Database Objects ( over 50 000 )
• The application build is based on packages, procedures, functions
etc. inside the database.
• There is dependency among these objects, thus the status of these
objects should be monitored.
• Revoking any of the program privileges could invalidate most of the
objects which will affect the functionality of the application.
Objects Stats Collection and Jobs
• Flexcube best practice recommends that objects stats must be
collected without histograms.
• The histograms must be switched off before gathering stats on
objects.
• Stats are gather automatically every weekend during the
maintenance window.
• The flexcube jobs are scheduled through oracle scheduler and
the flexcube application has an interface that is used for
monitoring the jobs.
• The RMAN backup jobs are scheduled via the control-m
scheduler.
Challenges
• Control of Privileges granted to application users, how
do we comply to IT AUDITs
• Management and maintenance of Shared File Systems
• Exports and Imports performance (over 50 000 )
• Database datafiles naming standards
DISCUSSION
Share Your Experience