If you are using an Oracle RAC database system, you must create the tablespaces with the appropriate RDBMS software prior to installation.
Whether the scripts are run automatically or manually, the user must be logged in as SYSTEM. When you manually execute the database scripts, the User ID that was designated for Data Relationship Management database connectivity in the Repository Wizard is created in the RDBMS (if it does not already exist). The user is assigned a default tablespace of DRM_DATA and must have access rights to the following items:
Default tablespace (usually DRM_DATA)
UNLIMITED TABLESPACE
CONNECT
CREATE ANY SEQUENCE
CREATE USER
ALTER USER
When you manually execute the database scripts, the user is logged in as the schema owner which, has a default tablespace of DRM_DATA. This user must have access rights to the following items:
Default tablespace (usually DRM_DATA) — this can be done after the install if the tablespaces were not created.
UNLIMITED TABLESPACE
DBA
CONNECT
CREATE ANY SEQUENCE
CREATE USER
ALTER USER
Note: | You can change the schema owner name during the installation process. |