
VMware, Inc. 25
Chapter 3 External Database Setup
Upgrading for Oracle
WhenupgradingtheexternaldatabaseforOracle:
1Ensurethesync_adm_olaptaskisremovedfromthecronjobasfollows:
aAtthecommandprompt,type:
crontab -e
b Deletethetaskfromthefile.
c Saveandexit.
2LogintotheADMConsoleasadminuser.
3FromtheADMConsole,navigatetoConnectors>Reports>ExternalReportsSchemeIntegrationStatus
andcheckiftheSynchronizationStatusiscomplete.Ifthestatusissyncinprogress,waitforitto
complete.
4 Backupthefolderinwhichyouoriginallyinstalledtheadm_olapfiles.Thisfolderincludesthe
sync.propertiesandtheoracle.propertiesfiles,thatcontainsyourconfigurationsettings.
5Executethefollowingscriptslocatedin adm_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
6 Backuptheoldadm_olapfolder(includesthesync.propertiesandoracle.propertiesfiles,and
containsyourconfigurationsettings).
7Proceedwiththeinstallationinstructionsin“InstallingandConfiguringtheExternalDatabasefor
Oracle”onpage 16.
I
MPORTANTThedataintheexternalreportdatabaseislostasaresultofthefollowingstep.Thedatais
recoveredonceyouperformafullsynchronizationaftertheupgradeiscomplete.
CAUTIONDonotcopythenewconfigurationfilesoverthebackedupconfigurationfiles.Usethebackedup
configurationfilesonlyasareferencetomanuallyupdatethenewfile.
Komentarze do niniejszej Instrukcji