Documentation Center

Creating the Oracle database with a template

You must create the Oracle database instance for the Content Manager repository. This is the place where the data is stored.

About this task

The Oracle database is created using the Database Configuration Assistant (DCA). The creation steps are version dependent and can be performed with the help of a template.

Procedure

  1. Create the database folder, C:\oracle\OraData\ISH.
    The directory is required and not created by Oracle. Make sure that all paths exist.
  2. Go to CD_Package\Database\Dump\Oracle\Oracle121.Admin\DBCATemplates where CD_Package is the root folder of the CD package.
  3. Open the ReadMe.txt, and copy the template "SDL-Trisoft.InfoShare-Database-Template.dbt" to the location specified in the ReadMe.txt file.
  4. Start the Database Configuration Assistant (DCA). This Assistant is provided by Oracle.
  5. On the "Database Operation" page, select the "Create Database" radio button, then click "Next".
  6. On the "Creation Mode" page, select the "Advanced Mode" radio button, then click "Next".
  7. On the "Database Template" page, select the "SDL-Trisoft.InfoShare-Database-Template" template, then click "Next".
  8. On the "Database Identification" page, type in the "Global Database Name", then click "Next".
  9. On the "Management Options" page, check the "Configure Enterprise Manager (EM) Database Express" box, and specify the port in the field below, then click "Next".
  10. On the "Database Credentials" page, fill in the required fields (passwords), then click "Next".
  11. On the "Network Configuration" page, select the Listener that was previously created for this database (refer to the chapter dedicated to the activation of the Listener service), then click "Next".
  12. Leave the currently selected defaults on the "Storage Location" page, just click "Next".
  13. On the "Database Options" page, leave all the boxes in the "Database Components" page unchecked, just click "Next".
  14. On the "Initialization Parameters" page, leave the currently selected defaults but make sure the "Use Automatic Memory Management" box is checked, then click "Next".
  15. On the "Creation Options" page, click on "Create the database", then click "Next".
  16. Finish/complete the creation of the database.