When you use an Oracle database with vCenter Server, the database must have certain table spaces and privileges. To simplify the process of creating the database, you can run a script. If you do not use this script, you can create the database manually.

When using the script, you can customize the location of the data and log files.

Note

The user created by this script does not follow any security policy. The passwords are provided only for convenience. Change the passwords as appropriate.

1

Log in to a SQL*Plus session with the system account.

2

Run the following script.

The script is located in the vCenter Server installation package /<installation directory>/vpx/dbschema/DB_and_schema_creation_scripts_oracle.txt file.

CREATE SMALLFILE TABLESPACE "VPX" DATAFILE '/u01/app/oracle/oradata/vcdb/vpx01.dbf'
SIZE 1G AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT 
SPACE MANAGEMENT AUTO;

For a Windows installation, change the directory path to the vpx01.dbf file.

You now have an Oracle database that you can use with vCenter Server.

You can also run a script to create the database schema.