1.1.2 Database Installation

This topic provides information on Database Installation.

Database installation is not part of this installer, it is expected that the Oracle 19c database needs to be installed and required schemas needs to be created before installation start.

1. Create required database schemas with TABLE SPACES.
   Example: PLATO, PLATOUI, PLATOSEC, PLATOFEED, PLATOBATCH, PLATOORCH ,CMNCORE, SMS, PLATOALERTS, REPORTSERVICE, OBPYBPROC, PARTY, PLATOTRANSPORT, PLATORULE.
2. Set the custom password by referring to the Databag topic.
   The Default password is displayed and it is same for all the above schemas and it is highly recommended to change the default password. The same password will be used for JNDI creations.
3. During FCIS installation, if you click the Generate Report button in the Logs folder, the installer creates an SQL file grantScript.sql containing the script for granting the privileges.
   You can use this file to get the grant access. Provide grant permissions to all the above schemas.

   Note:

   Only system user can execute the file grantScript.sql for granting privileges.
4. Create the following table within the PLATOORCH schema that was created in the previous step.
   CREATE TABLE task_config AS SELECT * FROM PLATO_TM_TASK_CONFIG;
   Alter table task_config drop column MOD_NO;
   Alter table task_config drop column AUTH_STAT;
   Alter table task_config drop column RECORD_STAT;
   Alter table task_config drop column ONCE_AUTH;
   Alter table task_config drop column MAKER_ID;
   Alter table task_config drop column MAKER_DT_STAMP;
   Alter table task_config drop column CHECKER_DT_STAMP;
   Alter table task_config drop column MAKER_REMARKS;
   Alter table task_config drop column CHECKER_REMARKS;