The vCenter Server installer creates the schema during installation. For experienced database administrators who need more control over schema creation because of environmental constraints, you can optionally use a script to create your database schema.

To have the vCenter Server installer create your schema for you, see Configure an Oracle Connection for Local Access or Configure an Oracle Connection for Remote Access, depending on your environment.

Prerequisites

Create the Oracle database and user. You can create the Oracle database and user manually or by using scripts.

Procedure
1

Open a SQL*Plus window with a user that has schema owner rights on the vCenter Server database.

2

Locate the dbschema scripts in the vCenter Server installation package /<installation directory>/vpx/dbschema directory.

3

In SQL*Plus, run the scripts in sequence on the database.

<path> is the directory path to the /<installation directory>/vpx/dbschema folder.

@<path>/VCDB_oracle.SQL
@<path>/load_stats_proc_oracle.sql
@<path>/purge_stat1_proc_oracle.sql
@<path>/purge_stat2_proc_oracle.sql
@<path>/purge_stat3_proc_oracle.sql
@<path>/purge_usage_stats_proc_oracle.sql
@<path>/stats_rollup1_proc_oracle.sql
@<path>/stats_rollup2_proc_oracle.sql
@<path>/stats_rollup3_proc_oracle.sql
@<path>/cleanup_events_oracle.sql
@<path>/delete_stats_proc_oracle.sql
@<path>/load_usage_stats_proc_oracle.sql
@<path>/TopN_DB_oracle.sql
@<path>/calc_topn1_proc_oracle.sql
@<path>/calc_topn2_proc_oracle.sql
@<path>/calc_topn3_proc_oracle.sql
@<path>/calc_topn4_proc_oracle.sql
@<path>/clear_topn1_proc_oracle.sql
@<path>/clear_topn2_proc_oracle.sql
@<path>/clear_topn3_proc_oracle.sql
@<path>/clear_topn4_proc_oracle.sql
@<path>/rule_topn1_proc_oracle.sql
@<path>/rule_topn2_proc_oracle.sql
@<path>/rule_topn3_proc_oracle.sql
@<path>/rule_topn4_proc_oracle.sql
4

For all supported editions of Oracle Server, run these scripts to set up scheduled jobs on the database.

@<path>/job_schedule1_oracle.sql
@<path>/job_schedule2_oracle.sql
@<path>/job_schedule3_oracle.sql 
@<path>/job_cleanup_events_oracle.sql
@<path>/job_topn_past_day_oracle.sql
@<path>/job_topn_past_week_oracle.sql
@<path>/job_topn_past_month_oracle.sql
@<path>/job_topn_past_year_oracle.sql

You now have a database schema that is compatible with vCenter Server.

What to do next
1

On the machine where you are installing vCenter Server, create a DSN that points to the database server with the schema.

2

Run the vCenter Server installer.

a

If a database reinitialization warning message appears in the vCenter Server installer, select Do not overwrite, leave my existing database in place and continue the installation.

This message appears if you are using a database that has vCenter Server tables created by a previous installation. The message does not appear if the database is clean.

If you leave your existing database in place, you cannot join a Linked Mode group during the installation. You can join after the installation is complete. (See Join a Linked Mode Group After Installation.)

b

When prompted, provide the database user login.

Previous topic: Configure an Oracle Database User
Next topic: Configure an Oracle Connection for Local Access
Help us improve this information. Send feedback to docfeedback@vmware.com.