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