VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Manual do Utilizador descarregar pdf (Página 19)

VMware, Inc. 19

Chapter 3 External Database Setup

bIfyouhaddefinedacustomadm_olapusernameandpasswordwhenyouhadcreatedthedatabase

userasdescribedin“CreatetheExternalReportingDatabaseUser”onpage 17,thenchangetheuser

nameandpasswordcredentialsaccordingly:

user.id=adm_olap/adm_olap

c Changethedelete.data.filesparameterto=trueifyouwanttodeletethedatafilesaftertheyare

loaded.Ifyoukeepthedefault,youneedadditionaldataspacethandefinedin“ExternalDatabase

SystemRequirements”onpage 15:

delete.data.files=false

3Loadthetimedata.

Thecurrentadm_olapschemahasatimedimensiontablethatisstatic.Fillthetimetableonceandleave

itunchangedthereafter.Performthefollowingstepsbeforetheloaderfirstrun:

cd adm_olap

unzip static_data/time.csv.zip -d data/

Thetime.csvdataisloadedthenexttimethesynchronizationprocessruns.

4Testtheconfigurationtoensurethatyouhaveinstalledandconfiguredtheclientcorrectly:

aRunacompletesynchronizationfromtheADMConsoleasdescribedin“Runningthe

SynchronizationProcessNow”onpage 13.

bAftertheuploadcompletes,performthefollowing

stepsonthesystemonwhichthedatabaseis

installed:

iLoginasauserwithOraclepermissions.

ii Changedirectoriesto

unzip_path

/adm_olap/andrunthesynchronizationprocess:

<unzip_path>

/adm_olap/

chmod 755 sync_adm_olap.pl

$ ./sync_adm_olap.pl

5SchedulethesynchronizationprocessonLinux.

aLoginasauserwithoraclepermissionsandenter:

crontab -e

bVerifythefollowinginformation.Ithastobepartofthecrontabforittorunproperly:

PATH=... <oracle home full path/bin>

ORACLE_SID=<>

ORACLE_HOME=<>

install_dir

>/adm_olap/log/sync.log 2>&1

ThefollowingisanexampleofacronentryinLinux,wheretheprocessisscheduledtorunafterevery

15 minutes:

PATH=...

ORACLE_SID=...

ORACLE_HOME=...

*/15 * * * * <install dir>/adm_olap/sync_adm_olap.pl >> <

install dir

>/adm_olap/log/sync.log

2>&1

NOTEForsecureftp,usethesync_adm_olap_sftp_oracle.plscriptinsteadof

sync_adm_olap.pl

OTEForsecureftp,usethesync_adm_olap_sftp_oracle.plscriptinsteadofsync_adm_olap.pl

and for more information about cron expression please contact your unix admin.

1 2 ... 14 15 16 17 18 19 20 21 22 23 24 ... 41 42

Comentários a estes Manuais

Sem comentários

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Manual do Utilizador Página 19

Comentários a estes Manuais

Manuais e produtos relacionados com Software de bases de dados VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY