Documentation Center

Creating the Oracle 12.2 database

The procedure for Oracle 12.2.

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. Go to CD_Package\Database\Dump\Oracle\Oracle122.Admin\DBCATemplates where CD_Package is the root folder of the CD package.
  2. Open the ReadMe.txt, and copy the template SDL-Trisoft.InfoShare-Database-Template.dbt to the location specified in the ReadMe.txt file.
  3. Start the Database Configuration Assistant (DCA). This Assistant is provided by Oracle.
  4. On the Database Operation page, select Create Database, then Next.
  5. On the Creation Mode page, select Advanced Mode, then Next.
  6. On the Database Template page, select SDL Trisoft InfoShare Database Template (12.2), then Next.
  7. On the Database Identification page, fill in the Global Database Name field with the database name, then select Next.
  8. On the Storage Option page:
    1. Select Use following for the database storage attributes.
    2. In the Database files storage types list, select File System.
    3. Fill in the Database files location field with the path to the database.
    4. Then select Next.
  9. Leave the Fast Recovery Option page as is, select Next.
  10. 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.
  11. Leave the Data Vault Options page as is, select Next.
  12. On the Configuration Options page, Memory tab, select Use Automatic Shared Memory Management. You may want to adapt values to your needs.
  13. On the Configuration Options page, Sizing tab, you may want to increase the processes value, depending on the size of your system. Each current database consumer (end users, services, background tasks...) use a process, so you need to set a sufficient amount of them if you want all the consumers to be able to use the database in parallel.
  14. Leave the rest of the Configuration Options page as is and select Next.
  15. Leave the Management Options page as is, select Next.
  16. On the User Credentials page, fill in the password fields, then select Next.
  17. On the Creation Option page, select Create database, then Next.
  18. On the Summary page, select Finish.