1. Installer Database Setup
  2. Install Oracle FLEXCUBE Database

2 Install Oracle FLEXCUBE Database

This topic explains the Oracle FLEXCUBE Database installation.

Introduction

Oracle FLEXCUBE database can be installed in one of the following methods.

Table 2-1 FLEXCUBE Database Installation

Method Description
Import full dump Import the Oracle FLEXCUBE objects into an empty schema using full dump. This is a manual activity.
From shipment media Load the shipment media objects into an empty schema using Installer.

These methods are discussed in detail under the following heads.

Pre-Requisites

Below Privilege must be provided to the Database Schema from SYS Database User. These grants should be provided after schema creation and before the Installation.
  1. ALTER USER ENABLE EDITIONS [FORCE];
  2. GRANT CREATE ANY EDITION TO <SCHEMA NAME>
  3. GRANT DROP ANY EDITION TO <SCHEMA NAME>
  4. GRANT ALTER SESSION TO <SCHEMA NAME>
  5. GRANT EXECUTE on DBMS_SESSION TO <SCHEMA NAME>

Create Schema by Importing Full Dump

In this method, you need to manually import the Oracle FLEXCUBE DMP file into the Oracle FLEXCUBE schema. This can be done using the following command:

$impdp user_name/password directory=dir_name dumpfile=dmp_file_name.dmp logfile=dmp_file_name.log remap_schema=from_schema_name:to_schema_name remap_tablespace=from_tablespace_name:to_tablespace_name transform=OID:n

Create Schema From Shipment Media

In this method, you need to create the schema from the shipment media.