5.8.5

Preparing the
vCenter Operations Manager
Database 4
Before you can install vCenter Operations Manager, you must create a database in either Microsoft SQL
Server or Oracle to store the vCenter Operations Manager data.
This chapter includes the following topics:
n
“Prepare a SQL Database on a Windows Host,” on page 15
n
“Prepare an Oracle Database on a Windows Host,” on page 16
n
“Prepare an Oracle Database on a Linux Host,” on page 16
Prepare a SQL Database on a Windows Host
You prepare a SQL database for vCenter Operations Manager by running SQL scripts. The
vCenter Operations Manager installation package includes the SQL scripts.
Prerequisites
n
Familiarize yourself with the database server requirements for vCenter Operations Manager. See
“Database Server Requirements for vCenter Operations Manager,” on page 10.
n
Install SQL Server.
n
Create a Windows authentication account and an SQL authentication account that has sufficient
privileges to create a new database and a 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 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.
What to do next
Install vCenter Operations Manager server. See “Install vCenter Operations Manager on Windows,” on
page 19.
VMware, Inc.
15