VMware, Inc. Update–3
Updates for the ESX Server 3 Installation Guide
3 CreateanewtablespacespecificallyforVirtualCenterbyrunningthefollowing
SQLstatement:
CREATE TABLESPACE "VPX" DATAFILE 'C:\Oracle\ORADATA\VPX\VPX.dat'
SIZE 1000M AUTOEXTEND ON NEXT 500K;
4 Createauser(forexample,vpxAdmin),foraccessingthetablespacethrough
ODBC:
CREATE USER vpxAdmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;
5Eithergrantdbapermissiontotheuser,orgrantthefollowingpermissionstothe
user:
grant connect to <user>
grant resource to <user>
grant create view to <user>
grant execute on dbms_job to <user>
grant execute on dbms_lock to <user>
grant unlimited tablespace to <user> # To ensure space limitation is not
an issue
6UsetheNet8ConfigurationAssistanttoaddthefollowingentry:
VPX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=vpxd-Oracle)(PORT=1521))
)
(CONNECT_DATA =
(SERVICE_NAME = VPX)
)
)
Inthisexample,HOSTisthemanagedhosttowhichtheclientneedstoconnect.
7 CreateanODBCconnectiontothedatabase.
Thefollowingareexamplesettings:
Data Source Name: VMware VirtualCenter
TNS Service Name: VPX
User Id: vpxAdmin
Comentarios a estos manuales