Add a View Composer Database to Oracle 12c or 11g

You can use the Oracle Database Configuration Assistant to add a new View Composer database to an existing Oracle 12c or 11g instance.

Prerequisites

Verify that a supported version of Oracle 12c or 11g is installed on the local or remote computer. See Database Requirements for View Composer and the Events Database.

Procedure

1. Start the Database Configuration Assistant on the computer on which you are adding the View Composer database.

   Database Version	Action
   Oracle 12c	Select Start > All Programs > Oracle-OraDb12c_home > Configuration and Migration Tools > Database Configuration Assistant.
   Oracle 11g	Select Start > All Programs > Oracle-OraDb11g_home > Configuration and Migration Tools > Database Configuration Assistant.

2. On the Operations page, select Create a database.
3. On the Database Templates page, select the General Purpose or Transaction Processing template.
4. On the Database Identification page, type a Global Database Name and an Oracle System Identifier (SID) prefix.
   For simplicity, use the same value for both items.
5. On the Management Options page, click Next to accept the default settings.
6. On the Database Credentials page, select Use the Same Administrative Passwords for All Accounts and type a password.
7. On the remaining configuration pages, click Next to accept the default settings.
8. On the Creation Options page, verify that Create Database is selected and click Finish.
9. On the Confirmation page, review the options and click OK.
   The configuration tool creates the database.
10. On the Database Creation Complete page, click OK.

What to do next

Follow the instructions in Add an ODBC Data Source to Oracle 12c or 11g.