5.0

Table Of Contents
n
Use a SQL Statement to Add a View Composer Database to an Oracle Instance on page 31
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.
n
Configure an Oracle Database User for View Composer on page 31
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.
n
Add an ODBC Data Source to Oracle 11g or 10g on page 32
After you add a View Composer database to an Oracle 11g or 10g instance, you must configure an ODBC
connection to the new database to make this data source visible to the View Composer service.
Add a View Composer Database to Oracle 11g or 10g
You can use the Oracle Database Configuration Assistant to add a new View Composer database to an existing
Oracle 11g or 10g instance.
Prerequisites
Verify that a supported version of Oracle 11g or 10g is installed on the vCenter Server computer. See “Database
Requirements for View Composer,” on page 10.
Procedure
1 On the vCenter Server computer, start the Database Configuration Assistant.
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.
What to do next
Follow the instructions in “Add an ODBC Data Source to Oracle 11g or 10g,” on page 32.
VMware View Installation
30 VMware, Inc.