Documentation Center

Creating the Oracle 12.1 database

The procedure for Oracle 12.1.

Before you begin

This procedure requires that you are part of the local Windows administration group as well as the ORA_DBA group.

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 Create Database, then Next.
  6. On the Creation Mode page, select Advanced Mode, then Next.
  7. On the Database Template page, select the SDL-Trisoft.InfoShare-Database-Template template, then select Next.
  8. On the Database Identification page, fill in the Global Database Name field with the database name, then select Next.
  9. On the Management Options page, select Configure Enterprise Manager (EM) Database Express, and specify the port in the field below, then select Next.
  10. On the Database Credentials page, fill in the required fields (passwords), then select 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 select Next.
  12. Leave the Storage Location page as is and selelct Next.
  13. On the Database Options page, leave the Database Components page as is and selelct Next.
  14. On the Initialization Parameters page, make sure that the Use Automatic Memory Management box is checked and select Next.
  15. On the Creation Options page, select Create the database, then Next.
  16. On the Summary page, select Finish.