This chapter describes how to install Oracle Utilities Data Model and other components you use to create an Oracle Utilities Data Model data warehouse:
ORACLE_HOME
/oudm
.Specifies details for the Utilities Data Model installation type and the Sample Reports installation type.
Using the Oracle Universal Installer you can perform two types of Oracle Utilities Data Model installation:
Installation of the Oracle Utilities Data Model component, itself. You must install this component to create an Oracle Utilities Data Model data warehouse.
Installation of sample reports (and schemas) that you can use for ideas about how to design your own reports. Installing these samples is optional.
Note:
The reports and dashboards that are used in examples and delivered with Oracle Utilities Data Model are provided only for demonstration purposes.
Different items are installed depending on whether you install the database objects, or the sample reports and schemas.
Utilities Data Model Installation
When you perform the Utilities Data Model installation, the Oracle Universal Installer installs the Oracle Utilities Data Model component without data. Specifically, the installer creates the following schema in the target database:
oudm_sys
which is the main schema for Oracle Utilities Data Model. This schema contains all the relational, mining, and OLAP components of Oracle Utilities Data Model, including the Oracle Utilities Data Model data mining results tables.
There is no data in this schema. You need to populate data into the schema.
Sample Reports Installation
When you perform a Sample Reports installation, the installer creates the Oracle Utilities Data Model sample schema in the target database and you copy and configures all the sample reports to your Oracle Business Intelligence Suite Extended Edition server. Specifically, the installer installs:
The following file that provides the data for the sample reports:
oudm_sample.dmp.zip
which is a dump file of the schemas that contain the sample data for the relational and data mining components of Oracle Utilities Data Model.
Tip:
The default user name for the schema is oudm_sample
.
The following files that define and create the sample reports:
oudm.rpd
oudmwebcat.zip
Related Topics
The installation image contains directories that are installed under the path ORACLE_HOME
/oudm
.
The installation includes the following directories:
report
: which contains the sample report files for Oracle Utilities Data Model installation.
pdm
: which contains the physical schema dump, creation scripts, and lookup value population scripts, as listed in the following table:
Subdirectory | Description |
---|---|
|
Metadata creation and population scripts |
|
Data mining scripts and related files |
|
OLAP scripts and related files |
|
Relational schema installation scripts and relational related files |
|
Relational schema installation scripts and related scripts |
|
Calendar and time data population scripts |
|
Intra-ETL scripts |
|
Lookup data population scripts |
|
Physical sample schema |
Provides a checklist of the steps involved to install Oracle Utilities Data Model.
Installation Checklist for Oracle Utilities Data Model
Release notes: Read Oracle Utilities Data Model Release Notes to identify any changes for the installation.
Hardware and Software: Verify Hardware and Software Requirements
Verify that your system is one of the supported platforms and that it satisfies the hardware and software requirements.
Preinstallation Steps: Perform Preinstallation Tasks
Identify and perform any necessary pre-installation tasks.
Installation and Postinstallation Steps: Run Installer
Select the Oracle Utilities Data Model components to install.
Identify and perform any necessary Postinstallation Tasks.
Add Additional Components: Perform Installation Steps for Additional Components
Install the additional components that you need.
Note:
You must deinstall Oracle Utilities Data Model before you re-install it over an existing version of Oracle Utilities Data Model.
To deinstall Oracle Oracle Utilities Data Model, you do not run the Oracle Universal Installer in deinstall mode.
Note:
You must deinstall Oracle Utilities Data Model before you reinstall over an existing version of Oracle Utilities Data Model.