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>;