ESX Server 3 and VirtualCenter Installation Guide
66 VMware, Inc.
Thedatabasetopicsarecoveredinthefollowingsections:
“ConfiguringanOracleConnectiontoWorkLocally”onpage 66
“ConfiguringanOracleConnectiontoWorkRemotely”onpage 67
“ConfiguringaSQLServerODBCConnection”onpage 68
“ConfiguringMicrosoftSQLServer2005Express”onpage 71
“MaintainingYourVirtualCenterDatabase”onpage 72
Configuring an Oracle Connection to Work Locally
TouseanOracledatabaseasyourVirtualCenterdatabaseandhaveVirtualCenter
accessthedatabaselocally,usethefollowingprocedure.
Beforeyoubeginthisprocedure,reviewtherequireddatabasepatchesspecifiedin
Table 2‐1,“SupportedDatabaseFormats,”onpage 19.Ifyoudonotprepareyour
databasecorrectly,theVirtualCenterinstallermight
displayerrorandwarning
messages.
To prepare an Oracle database to work locally with VirtualCenter
1 DownloadOracle9iorOracle10gfromtheOracleWebsite,installit,andcreatea
database(VirtualCenter).
2 DownloadOracleODBCfromtheOracleWebsiteifyouareusingOracle9i.Ifyou
downloadedOracle10g,theODBCisincludedintheproductmedia.
3Install
theOracleODBCcorrespondingdriverthroughtheOracleUniversal
Installer(directionsareprovidedwiththedriver).
4 Increasethenumberofopencursorsforthedatabase.Addtheentry
open_cursors = 300totheC:\Oracle\ADMIN\VPX\pfile\init.orafile.
