Creating the Oracle database for the Content Manager Repository
Use the Database Configuration Assitant to create the Oracle database for the Content Manager Repository, using a template.
Before you begin
ORA_DBA group.
About this task
To prepare your environment for the Oracle configuration, first copy the template file to your server. The version mentioned below has been quality-tested with this version of Content Manager.
Target directory on the server: ORACLEHOME\assistants\dbca\templates\
Procedure
- Go to the folder C:\InfoShare\App\Database\InfoShareCM\Common\Oracle\Oracle193.Admin\.
- Copy the template SDL-Trisoft.InfoShare-Database-Template.dbt to a location of your choosing, for example, ORACLEHOME\assistants\dbca\templates, where ORACLEHOME is the Oracle home directory on the server.
- Start the Database Configuration Assistant (DCA). This Assistant is provided by Oracle.
- On the Database Operation page, select Create Database, then select Next.
- Change the configuration mode to Advanced configuration, then select Next.
- On the Database Template page, select SDL Trisoft InfoShare Database Template (19), then select Next.
- On the Database Identification page, fill in the Global Database Name field with the database name; make sure that the Create as Container Database option is not selected, and then select Next.
- On the Storage Option page, do the following:
- Select Use following for the database storage attributes.
- In the Database files storage types list, select File System.
- Fill in the Database files location field with the path to the database.
- Select Next.
- Leave the Fast Recovery Option page as is, then select Next.
- On the Network Configuration page, select the Listener that you previously selected or created for this database, then select Next.
- Leave the Database Options page as is and select Next.
- On the Configuration Options page, on the Memory tab, select Use Automatic Shared Memory Management. You may want to adapt the values to your specific needs.
- On the Configuration Options page, on the 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...) uses 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.
- Leave the rest of the Configuration Options page as is and select Next.
- On the Management Options page, make sure that the specified port is unique and select Next.
- On the User Credentials page, fill in the password fields, then select Next.
- On the Creation Option page, select Create database, then select Next.
- On the Summary page, select Finish.