5.0.3

Preparing the vCenter Operations Manager Database
Before you can install vCenter Operations Manager, you must create a database in either Microsoft SQL Server
or Oracle to sore the vCenter Operations Manager data.
Prepare a SQL Database on a Windows Host
Prepare a SQL database for vCenter Operations Manager by running SQL scripts. The SQL scripts are included
in the vCenter Operations Manager installation package.
Prerequisites
n
Familiarize yourself with the database server requirements for vCenter Operations Manager. See
“Database Server Requirements for vCenter Operations Manager,” on page 7.
n
Install SQL Server.
n
Create a Windows authentication account or an SQL authentication account that has sufficient privileges
to create a new database and new SQL user.
n
Obtain the vCenter Operations Manager installation package.
n
Extract the zip file that contains the SQL scripts: vcops-db-scripts-sqlserver-<build number>.zip.
Procedure
1 If you are using Windows authentication for SQL Server, log in as a user who has sufficient privileges to
create a database.
2 Create a new database in the Microsoft SQL Server instance.
3 In SQL Server Management Studio, connect to the new database and run the vcops_sqlserver_10.sql
script from the extracted zip file.
4 Alternatively, you can use the command line tool sqlcmd to execute the script vcops_sqlserver_10.sql:
sqlcmd -S <databaseServer> -i vcops_sqlserver_10.sql -U <databaseUsername> -P
<databasePassword> -d <databaseName>
To execute the script, you must download and install the Microsoft SQL Server 2008 R2 Command Line
Utilities and dependancy packages from the Microsoft Web site:
http://www.microsoft.com/en-us/download/details.aspx?id=16978.
What to do next
Install vCenter Operations Manager server. See “Install vCenter Operations Manager on Windows,” on
page 10.
Prepare an Oracle Database on a Windows Host
If the Oracle database is on a Windows host, you can run a batch file to prepare the database to store
vCenter Operations Manager data. The batch file is included in the vCenter Operations Manager installation
package.
The batch file creates a 500MB Oracle tablespace named vcops10_TS, an Oracle schema named vcops, database
objects for vCenter Operations Manager (including tables, indexes, and sequences), and a trigger that makes
the database case insensitive. For more control over the configuration, you can perform these operations
manually. See the Readme.txt file in the vCenter Operations Manager installation directory for instructions on
the manual configuration process.
vCenter Operations Manager Installation Guide
VMware, Inc. 9