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 Database Connection for Remote Access, depending on your environment.

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

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
@path/process_license_snapshot_oracle.sql
@path/process_temptable0_proc_oracle.sql
@path/process_temptable1_proc_oracle.sql
@path/process_temptable2_proc_oracle.sql
4

(Optional) You can also run the following scripts to enable database health monitoring.

job_dbm_performance_data_oracle.sql
process_performance_data_oracle.sql
5

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
@path/job_property_bulletin_oracle.sql 

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

6

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

7

Run the vCenter Server installer.

8

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 that were 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.

9

When prompted, provide the database user login.

The Oracle dadtabase schema is created.