Use a Script to Create the Oracle Database Schema

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.

   1. VCDB_oracle.SQL

   2. VCDB_views_oracle.SQL

   3. insert_stats_proc_oracle.sql

   4. load_stats_proc_oracle.sql

   5. purge_stat2_proc_oracle.sql

   6. purge_stat3_proc_oracle.sql

   7. purge_usage_stats_proc_oracle.sql

   8. stats_rollup1_proc_oracle.sql

   9. stats_rollup2_proc_oracle.sql

   10. stats_rollup3_proc_oracle.sql

   11. cleanup_events_oracle.sql

   12. delete_stats_proc_oracle.sql

   13. load_usage_stats_proc_oracle.sql

   14. TopN_DB_oracle.sql

   15. calc_topn1_proc_oracle.sql

   16. calc_topn2_proc_oracle.sql

   17. calc_topn3_proc_oracle.sql

   18. calc_topn4_proc_oracle.sql

   19. clear_topn1_proc_oracle.sql

   20. clear_topn2_proc_oracle.sql

   21. clear_topn3_proc_oracle.sql

   22. clear_topn4_proc_oracle.sql

   23. rule_topn1_proc_oracle.sql

   24. rule_topn2_proc_oracle.sql

   25. rule_topn3_proc_oracle.sql

   26. rule_topn4_proc_oracle.sql

   27. process_license_snapshot_oracle.sql

   28. l_purge_stat2_proc_oracle.sql

   29. l_purge_stat3_proc_oracle.sql

   30. l_stats_rollup1_proc_oracle.sql

   31. l_stats_rollup2_proc_oracle.sql

   32. l_stats_rollup3_proc_oracle.sql

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

   1. job_dbm_performance_data_oracle.sql

   2. process_performance_data_oracle.sql

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

   1. job_schedule1_oracle.sql

   2. job_schedule2_oracle.sql

   3. job_schedule3_oracle.sql

   4. job_cleanup_events_oracle.sql

   5. job_topn_past_day_oracle.sql

   6. job_topn_past_week_oracle.sql

   7. job_topn_past_month_oracle.sql

   8. 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.