Prerequisites for Oracle

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

Unicode support must be enabled in the 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.
Create the following three tablespaces. These tablespaces are used to create Kony Fabric database objects:
- Tables and data tablespace: MF_DATA
- Index tablespace: MF_INDEX
- Lob tablespace: MF_LOB_DATA

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;

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 TEM 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;

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 to successfully complete the Quantum Fabric database deployment. Oracle software must be installed and basic database must be created before continuing with Quantum Fabric database schema setup.

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

Steps before installing (or) upgrading Fabric with an existing database

Perform the following activities before installing (or) upgrading Quantum Fabric with the existing database:

Take a backup of your database.
Make sure you have a previously installed directory.
Take a backup of the applications that are deployed at the server level. After the installation is complete, take a backup of the changes that were made to the binaries.
After the installation or upgrade process is complete, replace the old authService.key, workspaceService.key, and ACCOUNTS_ENCRYPTION_KEY keys.
This is only applicable for the identity and workspace components.

Create /tmp Folder

Quantum Fabric Installer requires a /tmp folder in a Linux environment to unpack the installer. When the /tmp folder is not found, the Installer displays an I/O exception at the time of unpack exception.

This must be specified in the pre-req of installation. Installation requires temp folder to unpack MF installer (either default / custom temp folder).