1 Database Setup
This topic describes about the database setup for Oracle Banking Microservices Architecture Installation.
Before proceeding with the below setup, make sure pre-installation setup is done.
Prerequisites
Before proceeding with below setup, ensure that the Schemas are being created.
It is recommended to have different schema for Plato and Plato Security. To configure Plato security, refer to Security Configuration chapter. Make sure that the schema user has the below rights:
Table 1-1 Schema User - Operations
DB OBJECT | CREATE | ALTER | DROP | NSERT | UPDATE | DELETE |
---|---|---|---|---|---|---|
TABLE | Y | Y | N | Y | Y | Y |
VIEW | NA | NA | NA | NA | NA | NA |
SEQUENCE | Y | Y | Y | NA | NA | NA |
PACKAGE | NA | NA | NA | NA | NA | NA |
PACKAGE BODY | NA | NA | NA | NA | NA | NA |
INDEX | Y | Y | Y | NA | NA | NA |
SYNONYM | NA | NA | NA | NA | NA | NA |
FUNCTION | NA | NA | NA | NA | NA | NA |
TRIGGER | NA | NA | NA | NA | NA | NA |
TYPE | NA | NA | NA | NA | NA | NA |
To know the server port number, refer to Check Port Number section in ANNEXURE - 1.
Make sure to configure Placeholder parameters in WebLogic server for plato-config-service, setDomain.env. For more details, refer to Placeholder Update for Oracle Banking Microservices Architecture Services section in ANNEXURE - 1.