3.1

Table Of Contents
View Manager Administration Guide
128 VMware, Inc.
8 SelecttheChangethedefaultdatabasetocheckboxandselectthenameofthe
databaseyouhavecreatedforViewComposerfromtheassociatedlist(inthis
example,ViewComposer).ClickNext.
9ClickFinish>OK.
10 ClickOKtoclosetheMicrosoftODBCDataSourceAdministratorwizard.
Creating an Oracle 9i Database and Data Source for View
Composer
ThefollowinginstructionsdescribehowtoaddanewViewComposerdatabasetoan
existingOracle9iinstanceandmakethisdatasourcevisibletoallothercomponents
runningonthehostsystem.
TheseinstructionsassumethatOracle9iisinstalledontheVirtualCenterserverhost.
Theinstructionsalsoassumethat
youareconfiguringthedatabaseonWindowsServer
2003SP1.SomestepsaredifferentifyouareconfiguringtheODBCdatasourceona
WindowsXPProfessionalSP2host.
To add a View Composer database to Oracle 9i
1OntheVirtualCenterserverhostsystemselectStart>AllPrograms>
OracleOraHome92>ConfigurationandMigrationTools>Database
ConfigurationAssistanttostarttheOracleDatabaseConfigurationAssistant.
2WhentheWelcomepageappears,clickNext.
3OntheOperationspage,selectCreateadatabaseandclickNext.
4OntheDatabaseTemplatespage,selectth eDataWarehousetemplateandclickNext.
5OntheDatabaseIdentificationpage,enteraGlobalDatabaseNameandanOracle
SystemIdentifier(SID)prefix.
Forsimplicity,enterthesamevalueforboth.
6OntheDatabaseConnectionOptionspage,selectDedicatedServerMode.
7Ontheremainingconfigurationpages,clickNexttoacceptthedefaultsettings.
8OntheCreationOptionspage,verifythatCreateDatabaseisselectedandclick
Finish.
9ReviewtheoptionsontheSummarypage,andclickOKtocreatethedatabase.
Thedatabaseiscreated.
10 SetpasswordsfortheSYSandSYSTEMadministratoraccounts.
UsetheSYSTEMaccounttosetupthedatasourceconnection.