Oracle database setting

When manually installing the physical MDM database on Oracle, if you omit the execution of the create_schema_ora.sql script then you must alter the Oracle database system.

Inside the create_schema_ora.sql script, make sure that the ALTER SYSTEM SET open_cursors statement is set as:

ALTER SYSTEM SET open_cursors = 1500 SCOPE=BOTH;

Also verify that the grants are done specially as

GRANT CREATE
SEQUENCE TO <SCHEMA>;