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.

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/vCenter-Server/dbschema directory.

3

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

a

VCDB_oracle.SQL

b

VCDB_views_oracle.SQL

c

insert_stats_proc_oracle.sql

d

load_stats_proc_oracle.sql

e

purge_stat2_proc_oracle.sql

f

purge_stat3_proc_oracle.sql

g

purge_usage_stats_proc_oracle.sql

h

stats_rollup1_proc_oracle.sql

i

stats_rollup2_proc_oracle.sql

j

stats_rollup3_proc_oracle.sql

k

cleanup_events_oracle.sql

l

delete_stats_proc_oracle.sql

m

load_usage_stats_proc_oracle.sql

n

TopN_DB_oracle.sql

o

calc_topn1_proc_oracle.sql

p

calc_topn2_proc_oracle.sql

q

calc_topn3_proc_oracle.sql

r

calc_topn4_proc_oracle.sql

s

clear_topn1_proc_oracle.sql

t

clear_topn2_proc_oracle.sql

u

clear_topn3_proc_oracle.sql

v

clear_topn4_proc_oracle.sql

w

rule_topn1_proc_oracle.sql

x

rule_topn2_proc_oracle.sql

y

rule_topn3_proc_oracle.sql

z

rule_topn4_proc_oracle.sql

aa

process_license_snapshot_oracle.sql

ab

l_purge_stat2_proc_oracle.sql

ac

l_purge_stat3_proc_oracle.sql

ad

l_stats_rollup1_proc_oracle.sql

ae

l_stats_rollup2_proc_oracle.sql

af

l_stats_rollup3_proc_oracle.sql

4

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

a

job_dbm_performance_data_oracle.sql

b

process_performance_data_oracle.sql

5

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

a

job_schedule1_oracle.sql

b

job_schedule2_oracle.sql

c

job_schedule3_oracle.sql

d

job_cleanup_events_oracle.sql

e

job_topn_past_day_oracle.sql

f

job_topn_past_week_oracle.sql

g

job_topn_past_month_oracle.sql

h

job_topn_past_year_oracle.sql

You created the vCenter Server tables manually.

Note

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