5.2

Table Of Contents
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 11g or 10g,” on page 34.
Use a SQL Statement to Add a View Composer Database to an Oracle Instance
The View Composer database must have certain table spaces and privileges. You can use a SQL statement to
create the View Composer database in an Oracle 11g or 10g database instance.
When you create the database, you can customize the location of the data and log files.
Prerequisites
Verify that a supported version of Oracle 11g or 10g is installed on the local or remote computer. For details,
see “Database Requirements for View Composer,” on page 10.
Procedure
1 Log in to a SQL*Plus session with the system account.
2 Run the following SQL statement to create the database.
CREATE SMALLFILE TABLESPACE "VCMP" DATAFILE '/u01/app/oracle/oradata/vcdb/vcmp01.dbf'
SIZE 512M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT
SPACE MANAGEMENT AUTO;
In this example, VCMP is the sample name of the View Composer database and vcmp01.dbf is the name of
the database file.
For a Windows installation, use Windows conventions in the directory path to the vcmp01.dbf file.
What to do next
If you want to run the View Composer database with specific security permissions, follow the instructions
in “Configure an Oracle Database User for View Composer,” on page 33.
Follow the instructions in “Add an ODBC Data Source to Oracle 11g or 10g,” on page 34
Configure an Oracle Database User for View Composer
By default, the database user that runs the View Composer database has Oracle system administrator
permissions. To restrict the security permissions for the user that runs the View Composer database, you
must configure an Oracle database user with specific permissions.
Prerequisites
Verify that a View Composer database was created in an Oracle 11g or 10g instance.
Procedure
1 Log in to a SQL*Plus session with the system account.
Chapter 4 Installing View Composer
VMware, Inc. 33