4.6

Table Of Contents
Create an Oracle Database for View Composer
View Composer can store linked-clone desktop information in an Oracle 11g, 10g, or 9i database. You create
a View Composer database by adding it to an existing Oracle instance and configuring an ODBC data source
for it. You can add a new View Composer database by using the Oracle Database Configuration Assistant or
by running a SQL statement.
n
Add a View Composer Database to Oracle 11g or 10g on page 32
You can use the Oracle Database Configuration Assistant to add a new View Composer database to an
existing Oracle 11g or 10g instance.
n
Add a View Composer Database to Oracle 9i on page 33
You can use the Oracle Database Configuration Assistant to add a new View Composer database to an
existing Oracle 9i instance.
n
Use a SQL Statement to Add a View Composer Database to an Oracle Instance on page 34
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, 10g, or 9i database instance.
n
Configure an Oracle Database User for View Composer on page 34
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 35
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.
n
Add an ODBC Data Source to Oracle 9i on page 36
After you add a View Composer database to an Oracle 9i 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.
VMware View Installation
32 VMware, Inc.