
VMware, Inc. 25
Chapter 3 External Database Setup
7Proceedwiththeinstallationinstructionsin“InstallingandConfiguringtheExternalDatabaseforMS
SQL”onpage 20.
Upgrading for Oracle
WhenupgradingtheexternaldatabaseforOracle:
1Ensurethesync_adm_olaptaskisremovedfromthecronjobasfollows:
aAtthecommandprompt,type:
crontab -e
b Deletethetaskfromthefile.
c Saveandexit.
2LogintotheADMConsoleasadminuser.
3FromtheADMConsole,navigatetoConnectors>Reports>ExternalReportsSchemeIntegrationStatus
andcheckiftheSynchronizationStatusiscomplete.Ifthestatusissyncinprogress,waitforit
to
complete.
4 Backupthefolderinwhichyouoriginallyinstalledtheadm_olapfiles.Thisfolderincludesthe
sync.propertiesandtheoracle.propertiesfiles,thatcontainsyourconfigurationsettings.
5 Backupthefolderinwhichyouoriginallyinstalledtheadm_olapfiles.Thisfolderincludesthe
sync.propertiesandtheoracle.propertiesfiles,thatcontainsyourconfiguration
settings.
6Executethefollowingscriptslocatedinadm_olap/scheme/oracle:
sqlplus adm_olap/adm_olap @ drop_constraints.sql
sqlplus adm_olap/adm_olap @ truncate_data.sql
sqlplus adm_olap/adm_olap @ drop_tables.sql
7 Backuptheoldadm_olapfolder(includesthesync.propertiesandoracle.propertiesfiles,andcontains
yourconfigurationsettings).
8Proceedwiththeinstallationinstructionsin“InstallingandConfiguringtheExternalDatabasefor
Oracle”onpage 16.
CAUTIONDonotcopythenewconfigurationfilesoverthebackedupconfigurationfiles.Onlyusethe
backedupconfigurationfilesasareferencetomanuallyupdatethenewfile.
IMPORTANTThedataintheexternalreportdatabaseislostasaresultofthefollowingstep.Thedatais
recoveredonceyouperformafullsynchronizationaftertheupgradeiscomplete.
CAUTIONDonotcopythenewconfigurationfilesoverthebackedupconfigurationfiles.Usethebacked
upconfigurationfilesonlyasareferencetomanuallyupdatethenewfile.
Comentários a estes Manuais