VMware VS4-ENT-PL-A Setup Guide - Page 44
Use a Script to Create a Local or Remote Oracle Database
View all VMware VS4-ENT-PL-A manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 44 highlights
vSphere Installation and Setup 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/vCenterServer/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. 44 VMware, Inc.