VMware VS4-ENT-PL-A - vSphere Enterprise Plus, Руководство по установке

Страница: 47 / 276

4 Create a user, such as vpxAdmin, for accessing the tablespace through ODBC.
CREATE USER vpxAdmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;
5 Grant permissions to the user, in one of the following ways.
n
Grant dba permission to the user.
n
Grant the following permissions to the user.
grant connect to user
grant resource to user
grant create view to user
grant create sequence to user
grant create table to user
grant create materialized view to user
grant execute on dbms_lock to user
grant execute on dbms_job to user
grant unlimited tablespace to user # To ensure space is sufficient
By default, the RESOURCE role has the CREATE PROCEDURE, CREATE TABLE, and CREATE
SEQUENCE privileges assigned. If the RESOURCE role lacks these privileges, grant them to the
vCenter Server database user.
6 Use a text editor or the Net8 Configuration Assistant to edit the
tnsnames.ora
file located in the
directory
C:\Oracle\Oraxx\NETWORK\ADMIN
, where
xx
is either 10g or 11g.
Add the following entry, where
HOST
is the managed host to which the client must connect.
VPX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=vpxd-Oracle)(PORT=1521))
)
(CONNECT_DATA =
(SERVICE_NAME = VPX)
)
)
7 Configure the TNS Service Name option in the ODBC DSN.
The TNS Service Name is the net service name for the database to which you want to connect, in this
case, VPX. You can find the net service name in the
tnsnames.ora
file.
Connect to an Oracle Database Locally
Before a vCenter Server system can connect to an Oracle database locally, you must set up the connection.
Procedure
1 Create a new tablespace for a vCenter Server system using a SQL statement such as the following
statement.
CREATE TABLESPACE "VPX" DATAFILE 'C:\Oracle\ORADATA\VPX\VPX.dat' SIZE 1000M AUTOEXTEND ON
NEXT 500K;
2 Create a user, such as vpxAdmin, for accessing the tablespace through ODBC.
CREATE USER vpxAdmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;
Chapter 3 Before You Install vCenter Server
VMware, Inc. 47