This chapter describes how to install Oracle Utilities Data Model and other components you use to create an Oracle Utilities Data Model data warehouse:
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 reports (and schemas) that you can use for ideas about how to design your own reports. Installing the reports is optional.
Different items are installed depending on whether you install the database objects, or the reports and schemas.
Utilities Data Model Installation
When you perform a Utilities Data Model installation of Oracle Utilities Data Model, 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 and OLAP components of Oracle Utilities Data Model, including the Oracle Utilities Data Model data mining results tables. This schema also contains all the mining components of Oracle Utilities Data Model.
See:
For detailed information about all created objects in the OUDM_SYS schema, see the Oracle Utilities Data Model Reference.There is no data in this schema. You must populate data into the schema.
When you perform a Sample Reports installation of the Oracle Utilities Data Model, the installer creates the Oracle Utilities Data Model sample schema in the target database. Specifically, the installer installs:
The following files that provide the data for the 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 isoudm_sample.oudm_sample.eif which is a dump file containing sample data for the Oracle Utilities Data Model analytic workspace (that is, the OLAP cubes).
The following files that define and create the sample reports:
oudm.rpd
oudmwebcat.zip
Oracle Utilities Data Model Home Directory Structure
The installation image contains the following directories under ORACLE_HOME/oudm:
report: which contains the sample report files required for Oracle Utilities Data Model installation.
pdm: which contains the physical schema dump, creation scripts, and lookup value population in subdirectories:
| Subdirectory | Description |
|---|---|
relational |
Relational schema installation scripts and relational related files |
relational/calendar |
Calendar data population package |
relational/ddl |
Relational schema installation scripts |
relational/intra_etl |
Intra-ETL files |
relational/lookup_value |
Lookup data population script |
relational/sample_schema |
Physical sample schema |
mining |
Data mining scripts and related files |
olap |
OLAP scripts and related files |
Installation of Oracle Utilities Data Model requires the following tasks:
Read Oracle Utilities Data Model Release Notes to identify any last minute changes.
Verify that your system is one of the supported platforms and that it satisfies the hardware and software requirements as described in Chapter 1, "Hardware and Software Requirements."
Identify and perform any necessary preinstallation tasks, as described in "Preinstallation Tasks".
Install the Oracle Utilities Data Model component or the Oracle Utilities Data Model reports as described in "Installer Execution".
Tip:
You can also perform a silent installation, see "Silent Installation" for more information.Identify and perform any necessary postinstallation tasks, as described in "Postinstallation Tasks".
Install the additional components that you need to create an Oracle Utilities Data Model data warehouse or run the reports, as described in Chapter 4, "Installation of Additional Components."
Note 1:
To deinstall Oracle Utilities Data Model, you do not simply run the Oracle Universal Installer in deinstall mode. To deinstall Oracle Utilities Data Model, follow the directions in Chapter 5, "Backup, Recovery, and Deinstallation of Oracle Utilities Data Model."Note 2:
You must deinstall Oracle Utilities Data Model before you reinstall it over an existing version of Oracle Utilities Data Model.