Information Technology Reference
In-Depth Information
Preparing an Oracle Database for vCenter
Perform the following steps to prepare Oracle for vCenter Server if your Oracle database resides
on the same computer as vCenter Server:
1. Log into an SQL*Plus session with the system account to create a database user. Run the
following SQL command to create a user with the correct permissions:
CREATE USER ″vpxadmin″ PROFILE ″DEFAULT″ IDENTIFIED BY ″vcdbpassword″
DEFAULT TABLESPACE
″VPX″ ACCOUNT UNLOCK;
grant connect to VPXADMIN;
grant resource to VPXADMIN;
grant create view to VPXADMIN;
grant create sequence to VPXADMIN;
grant create table to VPXADMIN;
grant create materialized view to VPXADMIN;
grant execute on dbms_lock to VPXADMIN;
grant execute on dbms_job to VPXADMIN;
grant unlimited tablespace to VPXADMIN;
If the RESOURCE role doesn't have CREATE PROCEDURE, CREATE TABLE, and CREATE
SEQUENCE privileges assigned, you'll need to grant them to the vCenter Server
database user.
2. Run the following SQL command to create the vCenter Server database:
CREATE SMALLFILE TABLESPACE ″VPX″ DATAFILE 'C:\Oracle\ORADATA\VPX\VPX.DBF'
SIZE 1G AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT
LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Modify the path to the database as appropriate for your installation.
3. Now you need to assign a user permission to this newly created tablespace. While you
are still connected to SQL*Plus, run the following SQL command:
CREATE USER vpxAdmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;
4. Install the Oracle client and the ODBC driver.
5. Modify the tnsnames.ora i le to rel ect where your Oracle database is located:
VC=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=VPX)
)
)
The HOST= value should be set to localhost if you are accessing the Oracle database
locally or the name of the remote Oracle database server if you are accessing the database
remotely. Specify the remote host as a fully qualii ed domain name (FQDN), such as
esxi-05.lab.local.
Search WWH ::




Custom Search