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

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

1

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

Database Version

Action

Oracle 11g

Select Start > All Programs > Oracle-OraDb11g_home > Configuration and Migration Tools > Database Configuration Assistant.

Oracle 10g

Select Start > All Programs > Oracle-OraDb10g_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.

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