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

VMware, Inc. 17

Chapter 3 External Database Setup

Create the External Reporting Database User

To create an external reporting database user

1Switchtoauserwithoraclepermissionsforexample:

$ su - oracle

$Password:

2 Changedirectoryto

unzip_path

/adm_olap/schema/oracle/:

unzip_path

/adm_olap/schema/oracle/

where

unzip_path

/adm_olap/schema/oracle/ isthedirectoryinwhichthe

adm_olap_v.X.X-XXX.zipfilewasextracted.

3LogintotheSQLplusserver:

$ sqlplus '/as sysdba'

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Dec 12 14:17:01 2007

Connected to:

Oracle Database 10g Release 10.1.0.2.0 - Production

4Verifythattheinstanceisrunning,thedatabaseismounted,andthelistenerisstarted.

5RuntheSQLscripttocreatetheadm_olapuser:

sql> @create_olap_user.sql

User created.

Grant succeeded.

6Typequittoexitthesqlplusprompt.

Create the adm_olap Tables

To create the adm_olap tables

1LogintoSQLplusasadm_olap:

sqlplus adm_olap/adm_olap

2RuntheSQLscripttocreatethetables:

SQL> @create_tables.sql

3Typequittoexitthesqlplusprompt.

OTEYoumusthavedatabaseadministratorpermissionstocreateanadm_olapuserandhave

$ORACLE_HOME/bin dirinthePATHtoinstallandconfigurethehostonwhichtheexternaldatabaseis

installed.

OTETheusercreatedheremustbe thesameuserthatwasdefinedwhensettinguptheExternalReports

SchemeConfigurationpolicy.TheExternalReportsSchemeConfigurationdefinestheFTPserverwhere

theextracteddatafilesaretransferredandhowoftenthesynchronizationoccurs.

NOTETheadm_olapschemacreationismeanttobemanagedbytheclientDatabaseAdministrator(DBA).

SimpleSQLscriptsareprovidedtosupportthebasicADMtables.Tosupportadditionalinformationadd

externaltables.ChangestothetablesprovidedwithADMareoverwrittenwitheachload.Thescriptsare

locatedwhere

theadm_olap_v.x.X-XXX.zip filewasextractedfollowedby/schema/oracle.

OTEDonotaddconstraints.Withtheconstraintsturnedon,theloaderfailstoloadthedata.

1 2 ... 12 13 14 15 16 17 18 19 20 21 22 ... 41 42

Comentários a estes Manuais

Sem comentários

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

Comentários a estes Manuais

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