Manually Running Database Scripts

Based on your local security procedures, creating a new database may require a level of access that is not available to the user installing Oracle Data Relationship Management. Thus, during the installation, there is an option to save the database scripts to disk rather than running them automatically. The scripts can then be run separately by the appropriate database administrator.

To manually run scripts:

1. Log into the database server as a user with database administrator privileges.
2. Run the scripts in the following order:

   • drm-create-database.sql

   • drm-create-schema-objects.sql

3. After all scripts have been successfully run, open the Data Relationship Management Configuration Console.
4. Click Add.
5. On the Repository Configuration tab, enter the service connection information and click Save Configuration.

   Note:

   You can click Test Connection to verify connectivity.

   This completes the manual creation of the Data Relationship Management repository.

6. Select the application from the Applications list.

   The database is automatically initialized the first time the application is started.