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.
Procedure
- Open a SQL*Plus window with a user that has schema owner rights on the vCenter Server database.
- Locate the dbschema scripts in the vCenter Server installation package /installation directory/vCenter-Server/dbschema directory.
- In SQL*Plus, run the scripts in a sequence on the database.
VCDB_oracle.SQL
VCDB_views_oracle.SQL
insert_stats_proc_oracle.sql
load_stats_proc_oracle.sql
purge_stat2_proc_oracle.sql
purge_stat3_proc_oracle.sql
purge_usage_stats_proc_oracle.sql
stats_rollup1_proc_oracle.sql
stats_rollup2_proc_oracle.sql
stats_rollup3_proc_oracle.sql
cleanup_events_oracle.sql
delete_stats_proc_oracle.sql
load_usage_stats_proc_oracle.sql
TopN_DB_oracle.sql
calc_topn1_proc_oracle.sql
calc_topn2_proc_oracle.sql
calc_topn3_proc_oracle.sql
calc_topn4_proc_oracle.sql
clear_topn1_proc_oracle.sql
clear_topn2_proc_oracle.sql
clear_topn3_proc_oracle.sql
clear_topn4_proc_oracle.sql
rule_topn1_proc_oracle.sql
rule_topn2_proc_oracle.sql
rule_topn3_proc_oracle.sql
rule_topn4_proc_oracle.sql
process_license_snapshot_oracle.sql
l_purge_stat2_proc_oracle.sql
l_purge_stat3_proc_oracle.sql
l_stats_rollup1_proc_oracle.sql
l_stats_rollup2_proc_oracle.sql
l_stats_rollup3_proc_oracle.sql
- (Optional) You can also run the following scripts to enable database health monitoring.
job_dbm_performance_data_oracle.sql
process_performance_data_oracle.sql
- For all supported editions of Oracle Server, run the scripts to set up scheduled jobs on the database.
job_schedule1_oracle.sql
job_schedule2_oracle.sql
job_schedule3_oracle.sql
job_cleanup_events_oracle.sql
job_topn_past_day_oracle.sql
job_topn_past_week_oracle.sql
job_topn_past_month_oracle.sql
job_topn_past_year_oracle.sql
Results
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.