Chapter - 1 : Getting Started

---

Please follow this document closely while installing or upgrading OIDG.

Note: Failure to follow the instructions in this guide may result in an inappropriate setup.

Release Download

Download the OIDG release zip file from the Oracle Software Delivery Cloud and extract into a local folder.

System Prerequisites

Following system setup is required.

Name	Version	Notes
Oracle WebLogic Server	12.2.1.3.x
Oracle SOA Suite	12.2.1.3.x
Oracle Java SE 8	1.8.x
Oracle Database Server	12.1.0.2.0
GnuPG	2.2.1	https://www.gnupg.org/
Chef	12.6.0	Download compatible Chef package for your Operating System from the below URL. https://downloads.chef.io/chef/stable/12.6.0
ACORD® AML libraries		Download ACORD AML libraries

Database Configuration

OIDG Database Schema Creation

A database schema needs to be created on a new database when OIDG is installed for the first time.

Follow these steps to set up a new tenant database schema:

1. Connect to the OIDG DB or PDB with SYSDBA privilege.
2. Create a tablespace to hold data for the OIDG schema.
   SQL command:
   Create tablespace OIDX datafile ‘[filepath location/filename.dbf]’ size 2G autoextend on;
3. Run \AML Engine\Database\Installation\OIDG_PDB_SYSDBA.sql.
   Make sure to rename the schema owner name, password, and tablespace name before applying the script.
4. Connect as the schema owner user.
5. Edit the “\AML Engine\Database\Installation\SCI001_OIDX1101_B?_Schema.sql file. Locate the “Scheduler job for daily purge” section and change the schema_owner value to be the schema owner user.
6. Run \AML Engine\Database\Installation\SCI001_OIDG_B?_Schema.sql to create the DB schema.
7. Edit the “\AML\Database\On_Premise\Installation\OIDX_PDB_SYSDBA _Secure.sql file. Locate and change the schema_owner value to be the schema owner user.
8. Run OIDX_PDB_SYSDBA _Secure to create the ‘OIDXAPPUSER’ database user for the application. This user is to be used in the WebLogic data source creation process.

Note: “?” Denotes the build number which needs to be installed.

Follow these steps to migrate the database schema for OIDX from previous builds to the current version:

1. Connect to the OIDX Schema PDB as SYSDBA.
2. Run the following statement to grant the OIDX schema owner right to created views.
   GRANT CREATE ANY VIEW TO [schema owner];
3. Connect to the OIDX Schema PDB with schema owner user.
4. Run “AML\Database\On_Premise\Migration\SCUxxxx_OIDX1101Bxx_To_Bxx.Sql to update the DB components.
   Note: If a user wants to upgrade from an earlier build other than the previous one, then it is required to run all the migration scripts for the previous release (OIDX11.0) in the same order as the script number.
5. Edit the “\AML\Database\On_Premise\Migration\OIDX_PDB_SYSDBA _Secure.sql file. Locate and change the schema_owner value to be the schema owner user.
6. Run Database\Migration\OIDX_PDB_SYSDBA _Secure to update the ‘OIDXAPPUSER’ database user for the application. This database user should be use as the OIDX DataSource connection user in Weblogic..

Note: “?” Denotes the serial number of the script file.

RCU (Infra) Schemas Creation

Create the prerequisite Oracle SOA Infrastructure RCU schemas according to the product documentation provided with Oracle SOA Suite.

Note: The RCU prefix, user, and common password defined during RCU setup will also be needed for OIDG product installation. Do not use special characters [!'@#\$%^\&*()_+*] in the RCU prefix name.