Oracle as a DB backend for the Simplifier requires some additional server settings, which are listed below
Database Settings within the Oracle Database:
Parameter | Recommended Value |
OPEN_CURSORS | 3000 |
Supported Oracle version:
Oracle Database 19c or higher
Desired/recommended instance names (Productive and Test):
simplifierp and simplifierd
Required tablespaces:
See Runtime Sizing
Oracle user and required roles and permissions:
simplifier, simplifier_np (in Prod and Test) permissions to run DDL
Database Characterset:
AL32UTF8
National Characterset:
UTF8
Default language:
German, Germany
Processes and Sessions:
Value to 1000