VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY Uživatelský manuál stáhnout pdf (Strana 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/:

cd 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 ... 43 44

Komentáře k této Příručce

Žádné komentáře

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY Uživatelský manuál Strana 17

Komentáře k této Příručce

Související produkty a manuály pro Databázový software VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY