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

Page: 44 / 276

You now have an Oracle database user that you can reference in the vCenter Server installer.
What to do next
Create the Oracle database, including all necessary table spaces and privileges.
Use a Script to Create a Local or Remote Oracle Database
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. You also can create the
database manually.
When using the script, you can customize the location of the data and log files. The user created by this
script does not follow any security policy. The passwords are provided only for convenience. Change the
passwords as appropriate.
Procedure
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/vCenter-
Server/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.
What to do next
You can run a script to create the database schema.
(Optional) 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.
To have the vCenter Server installer create your schema for you, see
“Configure an Oracle Connection for
Local Access,” on page 46 or “Configure an Oracle Database Connection for Remote Access,” on page 46,
depending on your environment.
Prerequisites
Create the Oracle database and user. You can create the Oracle database and user manually or by using
scripts.
Procedure
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.
vSphere Installation and Setup
44 VMware, Inc.