Prerequisites for Oracle

To install a Quantum Fabric Database for Oracle, follow these steps

(This is the Drop-down text)

  1. Unicode support needs to be enabled in Database. This is possible only while creating a database needed for Kony Fabric with a Unicode character set with the properties for Database character set as AL32UTF8 and National character set as AL16UTF16.
  2. Create the following three tablespaces. These tablespaces will be used to create Quantum Fabric database objects:

    • Tables and data tablespace: MF_DATA

    • Index tablespace: MF_INDEX

    • Lob tablespace: MF_LOB_DATA

  3. Using an SQLPlus or another Database client, connect to you Oracle database as Sysdba.
    Replace the <DATA_FILE_PATH> with actual data file path on the Oracle database server.
    
    
    CREATE TABLESPACE MF_DATA DATAFILE '<DATA_FILE_PATH>/MF_DATA_01.DBF' SIZE 2048M AUTOEXTEND ON NEXT 100M MAXSIZE 5120M;
    CREATE TABLESPACE MF_INDEX DATAFILE '<DATA_FILE_PATH>/MF_INDEX_01.DBF' SIZE 2048M AUTOEXTEND ON NEXT 100M MAXSIZE 5120M;
    CREATE TABLESPACE MF_LOB_DATA DATAFILE '<DATA_FILE_PATH>/MF_LOB_DATA_01.DBF' SIZE 2048M AUTOEXTEND ON NEXT 100M MAXSIZE 5120M;
    
  4. Create a dedicated database user with default tablespaces (MF_DATA) and grant quota to two other tablespaces (MF_INDEX and MF_LOB_DATA tablespaces).
    • To create a user based on your Oracle 11g or 12c without PDB, which will be used in the JDBC.
      CREATE USER <install-user> IDENTIFIED BY <password> DEFAULT TABLESPACE MF_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
      GRANT DBA TO <install-user>;
      ALTER USER <install-user> QUOTA UNLIMITED ON MF_DATA;
      ALTER USER <install-user> QUOTA UNLIMITED ON MF_INDEX;
      ALTER USER <install-user> QUOTA UNLIMITED ON MF_LOB_DATA;
      
    • To create a dedicated database user based on your Oracle 12c with PDB, then create a dedicated database local user inside PDB, which will be used in the Java Database Connectivity (JDBC) authentication.
      
      
      Alter session set container = PDB<MF_DB> ;
      CREATE USER <dedicated-database-local-user> IDENTIFIED BY <password> DEFAULT TABLESPACE MF_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT  CONTAINER=CURRENT;
      GRANT DBA TO <install-local-user> CONTAINER=CURRENT;
      ALTER USER <install-local-user> QUOTA UNLIMITED ON MF_DATA CONTAINER=CURRENT;
      ALTER USER <install-local-user> QUOTA UNLIMITED ON MF_INDEX CONTAINER=CURRENT;
      ALTER USER <install-local-user> QUOTA UNLIMITED ON MF_LOB_DATA CONTAINER=CURRENT;
      
  5. If you are using Kony Fabric installer to setup Kony Fabric database, choose the following options based on your Oracle database version.
    • If Oracle database is created with PDB option of Oracle 12c, use service name pointing to PDB in the JDBC URL such as pdborcl or pdbmfdb
      
      
      jdbc:oracle:thin:@<Database_Host_IP>:1521/pdbmfdb
      

      For example: jdbc:oracle:thin:@192.168.1.2:1521/pdbmfdb

    • But if your database is 11g or 12c without PDB, then you can use ORACLE_SID in the JDBC URL such as  orcl  or  mfdb.
      
      
      jdbc:oracle:thin:@<Database_Host_IP>:1521:mfdb

      For example: jdbc:oracle:thin:@192.168.1.2:1521:mfdb

NOTE: Only a qualified Oracle Database Administrator (DBA) must handle the Oracle Database setup in order to successfully complete the Quantum Fabric database deployment. Oracle software must be installed and basic database must be created before to continue with Quantum Fabric database schema setup.

IMPORTANT:  Ensure that a dedicated database user must not be an application user for installation of database. A dedicated user gets logged into audit logs.
After granting privileges, disconnect existing session, and use new session in order to get the new privileges loaded to the user.