VMware VS4-ENT-PL-A - vSphere Enterprise Plus, Setup Manual

Page: 45 / 276

3 In SQL*Plus, run the scripts in sequence on the database.
path
is the directory path to the
/installation directory/vCenter-Server/dbschema
folder.
@path/VCDB_oracle.SQL
@path/load_stats_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/l_stats_rollup3_proc_oracle.sql
@path/l_purge_stat2_proc_oracle.sql
@path/l_purge_stat3_proc_oracle.sql
@path/l_stats_rollup1_proc_oracle.sql
@path/l_stats_rollup2_proc_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.
Chapter 3 Before You Install vCenter Server
VMware, Inc. 45