VMware, Inc. 67
Chapter 6 Installing VMware Infrastructure Management
To connect Oracle locally
1 CreateanewtablespacespecificallyforVirtualCenterusingthefollowingSQL
statement:
CREATE TABLESPACE "VPX" DATAFILE 'C:\Oracle\ORADATA\VPX\VPX.dat'
SIZE 1000M AUTOEXTEND ON NEXT 500K;
2 Createauser,suchasvpxAdmin,foraccessingthistablespacethroughODBC:
CREATE USER vpxAdmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;
3Eithergrantdbapermissiontotheuser,orgrantthefollowingpermissionstothe
user:
grant connect to <user>
grant resource to <user>
grant create view to <user>
grant create any sequence to <user> # For VirtualCenter upgrade only
grant create any table to <user> # For VirtualCenter upgrade only
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
4 CreateanODBCconnectiontothedatabase.Thefollowingareexamplesettings:
Data Source Name: VMware VirtualCenter
TNS Service Name: VPX
User Id: vpxAdmin
Configuring an Oracle Connection to Work Remotely
TouseanOracledatabaseasyourVirtualCenterdatabaseandhaveVirtualCenter
accessthedatabaseremotely,usethefollowingprocedure.
Beforeyoubeginthisprocedure,reviewtherequireddatabasepatchesspecifiedin
Table 2‐1,“SupportedDatabaseFormats,”onpage 19.Ifyoudonotprepareyour
databasecorrectly,theVirtualCenterinstallermight
displayerrorandwarning
messages.
To prepare an Oracle database to work remotely with VirtualCenter
1InstalltheOracleclientontheVirtualCenter Servermachine.
2 DownloadandinstalltheODBCdriver.
