Oracle® Utilities Data Model

Installation Guide

Release 12.2

E81920-01

September 2017

Oracle Utilities Data Model Installation Guide, Release 12.2

E81920-01

Copyright © 2011, 2017, Oracle and/or its affiliates. All rights reserved.

Primary Authors: Reema Khosla, Thomas Van Raalte

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Preface

- Audience

- Documentation Accessibility

- Related Documents

- Conventions

1 Introduction to Oracle Utilities Data Model Installation

- Types of Installations Provided for Oracle Utilities Data Model

- Oracle Utilities Data Model Home Directory Structure

- Installation Checklist

2 Hardware and Software Requirements

- Supported Platforms

- Hardware Requirements

- Software Requirements

- Oracle Database Requirements

- Oracle Business Intelligence Suite Extended Edition

3 Installation of Oracle Utilities Data Model

- Pre-installation Tasks

- Ensuring that Required Software is Installed

- Confirming that Oracle Advanced Analytics and OLAP Options are Installed

- Confirming that Oracle Business Intelligence Suite Extended Edition is Installed

- Confirming that Oracle Business Intelligence Developer Client Tools Installer is Installed

- Changing the Default Value for the Maximum Processes Initialization Parameter

- Changing the Maximum Data Files Option

- Disabling the Oracle Database Vault Option

- Ensuring a Value is Set for the Service Name

- Creating Utilities Data Model Tablespaces

- Creating Sample Report Tablespaces

- Installer Execution

- Silent Installation

- Selecting a Response File

- Editing the Response File

- Specifying a Response File and Starting the Installation

- Silent Installation Log Files

- Security Tips for Silent Installations

- Error Handling

- Silent Install Parameters for Oracle Utilities Data Model

- Post-Installation Tasks

- Unlocking the OUDM_SYS Account

- Unlocking the OUDM_USER and OUDM_REPORT Accounts

- Postinstallation for Sample Reports

- Unlocking the OUDM_SAMPLE Account

- Installing Oracle Business Intelligence Suite Extended Edition Catalog for Oracle Utilities Data Model

- Installing RPD and Web Catalog for Oracle Business Intelligence Suite Extended Edition

- Configuring the Working OLAP Environment

- Re-Enabling Oracle Database Vault

- Ensuring That Oracle Utilities Data Model Objects Are Valid

- Ensuring That PGA_AGGREGATE_TARGET is Set to the Proper Value

4 Installation of Additional Components

- Creating an Oracle Business Intelligence Suite Extended Edition Catalog

- Installing Analytic Workspace Manager

5 Backup, Recovery, and Deinstallation of Oracle Utilities Data Model

- Backing Up and Recovering Oracle Utilities Data Model

- Exporting Oracle Utilities Data Model

- Importing Oracle Utilities Data Model

- Deinstalling Oracle Utilities Data Model

- Pre-Deinstallation Tasks

- Match Oracle System Identifier with Net Service Name

- Deinstallation Execution

- Post-Deinstallation Tasks

6 Installing Oracle Utilities Data Model on Oracle Cloud

- Installing Oracle Utilities Data Model on Oracle Cloud

- Oracle Database Cloud Service Requirements

- Creating a Secure Shell (SSH) Public/Private Key Pair

- Creating the Oracle Database Cloud Service Instance

- Requirements for Service and Database Configuration Parameters

- Requirements for Backup and Recovery Configuration Parameters

- Monitoring Oracle Database Cloud Service Status

- Install Oracle Utilities Data Model on Oracle Cloud

- Connect to Oracle Database Cloud Service VM

- Adding the SYSTEM Username and Password to the Wallet

- Install Oracle Utilities Data Model Shiphome

- Monitor Oracle Utilities Data Model Installation Status

- Unlock Oracle Utilities Data Model Database Accounts

- Oracle Business Intelligence Cloud Service Requirements

- Creating the Oracle Business Intelligence Cloud Service Instance

- Downloading Oracle Utilities Data Model RPD and Catalog

- Modifying Oracle Utilities Data Model RPD

- Uploading Oracle Utilities Data Model RPD to Oracle Business Intelligence Cloud Service

- Uploading Oracle Utilities Data Model Catalog to Oracle Business Intelligence Cloud Service

A License Information

Index

Preface

The Oracle Utilities Data Model Installation Guide describes how to install and configure Oracle Utilities Data Model.

- Audience

- Documentation Accessibility

- Related Documents

- Conventions

Audience

This guide is intended for anyone responsible for installing Oracle Utilities Data Model on a supported operating system platform.

Installation of Oracle Utilities Data Model requires basic knowledge of Oracle Database, Oracle OLAP, Oracle Data Mining, and Oracle Business Intelligence Suite Enterprise Edition.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Related Documents

For more information about Oracle Utilities Data Model, see the following documents in the Oracle Utilities Data Model documentation set:

- Oracle Utilities Data Model Implementation and Operations Guide

- Oracle Utilities Data Model Reference

- Oracle Utilities Data Model Installation Guide

Conventions

The following text conventions are used in this document:

Convention

Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.

italic

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

1 Introduction to Oracle Utilities Data Model Installation

This chapter describes how to install Oracle Utilities Data Model and other components you use to create an Oracle Utilities Data Model data warehouse:

- Types of Installations Provided for Oracle Utilities Data Model
Specifies details for the Utilities Data Model installation type and the Sample Reports installation type.

- Oracle Utilities Data Model Home Directory Structure
The installation image contains directories that are installed under the path ORACLE_HOME/oudm.

- Installation Checklist
Provides a checklist of the steps involved to install Oracle Utilities Data Model.

Types of Installations Provided for Oracle Utilities Data Model

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

- Oracle Utilities Data Model Reference

Oracle Utilities Data Model Home Directory Structure

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

Metadata creation and population scripts

mining

Data mining scripts and related files

olap

OLAP scripts and related files

relational

Relational schema installation scripts and relational related files

relational/ddl

Relational schema installation scripts and related scripts

relational/ddl/calendar

Calendar and time data population scripts

relational/ddl/intra_etl

Intra-ETL scripts

relational/ddl/lookup_value

Lookup data population scripts

relational/sample_schema

Physical sample schema

Installation Checklist

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.

Related Topics

- Installer Execution

- Pre-installation Tasks

- Hardware and Software Requirements

- Oracle Utilities Data Model Release Notes

- Installation of Additional Components

- Post-Installation Tasks

2 Hardware and Software Requirements

Describes the hardware and software requirements of Oracle Utilities Data Model.

Before you install Oracle Utilities Data Model, you must verify that the system meets all hardware and software requirements.

- Supported Platforms
Specifies the Oracle Utilities Data Model supported platforms.

- Hardware Requirements
Specifies the Oracle Utilities Data Model hardware requirements.

- Software Requirements
Specifies minimum software requirements for Oracle Utilities Data Model.

Supported Platforms

Specifies the Oracle Utilities Data Model supported platforms.

Supported Platforms for Oracle Database 12c Release 2 (12.2)

Oracle Utilities Data Model release is supported on the following platforms. For each platform, the given operating system version or later versions are required:

- Linux x86–64
The following kernels are supported:

- Oracle Linux 7 with the Unbreakable Enterprise kernel

- Oracle Linux 7 with the Red Hat Compatible kernel:

- Red Hat Enterprise Linux 7

- Oracle Linux 6.4 with the Unbreakable Enterprise kernel

- Oracle Linux 6.4 with the Red Hat Compatible kernel:

- Red Hat Enterprise Linux 6.4

- SUSE Linux Enterprise Server 12

- Oracle Solaris on SPARC (64-bit)
The following Oracle Solaris on SPARC (64-Bit) kernels are supported:

- Oracle Solaris 11.2 SRU 5.5

- Oracle Solaris 10 Update 11

Supported Platforms for Oracle Database 12c Release 1 (12.1.0.2) and Oracle Database 11g Release 2 Enterprise Edition (11.2.0.4)

Oracle Utilities Data Model release is supported on the following platforms. For each platform, the given operating system version or later versions are required:

- HP-UX Itanium 11.31

- Linux x86-64

- Oracle Linux 5

- Oracle Linux 6

- Oracle Linux 7

- Red Hat Enterprise Linux 5

- Red Hat Enterprise Linux 6

- Red Hat Enterprise Linux 7

- Linux x86-64 SLES 11

- Linux x86-64 SLES 12 only supported on Oracle Database 12c Release 1 Enterprise Edition (12.1.0.2)

- Oracle Solaris on SPARC (64-bit)

- Oracle Solaris on x86-64 (64-bit) 10

- Oracle Solaris on x86-64 (64-bit) 11

- Oracle Solaris on x86-64 (64-bit)

- Oracle Solaris on x86-64 (64-bit) 10

- Oracle Solaris on x86-64 (64-bit) 11

- IBM AIX on POWER Systems (64-bit)

- AIX 6.1 64-bit kernel

- AIX 7.1 64-bit kernel

- IBM: Linux on System z

- Linux on System z SLES 11

- Linux on System z Red Hat Enterprise Linux 5

- Linux on System z Red Hat Enterprise Linux 6

Hardware Requirements

Specifies the Oracle Utilities Data Model hardware requirements.

The Oracle Database installation guide for your platform includes procedures for checking that your installation meets the hardware and operating system requirements for Oracle Database.

Additionally, for a complete installation of Oracle Utilities Data Model, the minimum hardware requirement is disk space of at least 12 GB (including at least 2 GB for the software files in the Oracle home directory).

The minimum hardware requirement for Oracle Utilities Data Model Sample Reports installation is disk space of at least 25 GB.

Software Requirements

Specifies minimum software requirements for Oracle Utilities Data Model.

The minimum software requirements for Oracle Utilities Data Model are as follows:

- Oracle Database Requirements
Specifies Oracle Database requirements for Oracle Utilities Data Model installation.

- Oracle Business Intelligence Suite Extended Edition
Specifies Oracle Business Intelligence Suite Extended Edition (12.2.1 or later). This is Optional for Oracle Utilities Data Model and Sample Reports installation steps but is required to deploy the Oracle Utilities Data Model sample reports RPD and webcat and to view the sample reports on the Oracle Business Intelligence Suite Extended Edition instance.

Oracle Database Requirements

Specifies Oracle Database requirements for Oracle Utilities Data Model installation.

Oracle Utilities Data Model installation requires one of the following Oracle Database releases:

- Oracle Database 12c Release 2 Enterprise Edition (12.2)

- Oracle Database 12c Release 1 Enterprise Edition (12.1.0.2)

- Oracle Database 11g Release 2 Enterprise Edition (11.2.0.4)

Note:

For Oracle Database 11g Release 2 (11.2.0.4) on Oracle Real Application Clusters (Oracle RAC) with ASM storage option, Oracle Utilities Data Model install may fail with ORA-37162: OLAP error. To prevent this, perform the following steps before Oracle Utilities Data Model install on 11.2.0.4 on RAC with ASM storage option:

1. Execute the following SQL on all nodes of RAC:

ALTER system SET "_olap_parallel_update_server_num"=4 COMMENT='Sets OLAP Parallel Update Slaves per Session.' SID='*' SCOPE=spfile;

2. Apply patch 25027309 containing OLAP E PATCH.

Tip:

When you install the Database ensure that the database character set is Unicode (AL32UTF8) to support multi-language installations since Oracle Utilities Data Model permits the installation of support for English and one other language.

Installation of the Oracle Utilities Data Model component requires the following options to the Database:

- Oracle Partitioning

- Oracle Online Analytical Processing (OLAP)

- Oracle Advanced Analytics

After you download and install the Database, upgrade to the latest patch. Patches are available from support (My Oracle Support).

Related Topics

- Confirming that Oracle Advanced Analytics and OLAP Options are Installed

Oracle Business Intelligence Suite Extended Edition

Specifies Oracle Business Intelligence Suite Extended Edition (12.2.1 or later). This is Optional for Oracle Utilities Data Model and Sample Reports installation steps but is required to deploy the Oracle Utilities Data Model sample reports RPD and webcat and to view the sample reports on the Oracle Business Intelligence Suite Extended Edition instance.

You must have the Oracle Business Intelligence Suite Extended Edition installed before you use the Oracle Utilities Data Model sample reports (Oracle Business Intelligence Suite Extended Edition is required to deploy the Oracle Utilities Data Model sample reports RPD and webcat and to view the sample reports).

Oracle Business Intelligence Suite Extended Edition can be downloaded from the "Oracle Business Intelligence downloads" link on Oracle Technology Network at:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/index.html

Installation instructions are included in the documentation.

3 Installation of Oracle Utilities Data Model

Describes the pre-installation, installation, and post-installation tasks and running the installer for Oracle Utilities Data Model.

To install Oracle Utilities Data Model, you perform the tasks as described:

- Pre-installation Tasks
Specifies the pre-installation tasks. Before you install the Oracle Utilities Data Model, perform these tasks.

- Installer Execution
Describes the steps to perform to install Oracle Utilities Data Model.

- Silent Installation
Specifies instructions for using the -silent option with the installer.

- Post-Installation Tasks
Specifies the steps to perform after the installation.

Pre-installation Tasks

Specifies the pre-installation tasks. Before you install the Oracle Utilities Data Model, perform these tasks.

- Ensuring that Required Software is Installed
You must have certain software installed before you can successfully install Oracle Utilities Data Model component or the Oracle Utilities Data Model sample data and reports.

- Changing the Default Value for the Maximum Processes Initialization Parameter
Oracle Utilities Data Model requires that the initial value for the PROCESSES initialization parameter be set to a value greater than the default database installation value.

- Changing the Maximum Data Files Option
Oracle Utilities Data Model supports the partition of transaction-related fact tables according to your data volume estimation. To support the partition of transaction-related fact tables, you might need a different value for the maximum number of data files that is presently specified for the Database.

- Disabling the Oracle Database Vault Option
For an Oracle Database with the Oracle Database Vault enabled, disable the Oracle Database Vault before you install Oracle Utilities Data Model.

- Ensuring a Value is Set for the Service Name
Ensure that the tnsnames.ora file includes a value for SERVICE_NAME.

- Creating Utilities Data Model Tablespaces
In previous releases of Oracle Utilities Data Model the installation scripts create the tablespaces and create the database objects in those tablespaces. In this release, Release 12.2, the Oracle Utilities Data Model installation does not create tablespaces. You must create the Oracle Utilities Data Model tablespaces prior to Oracle Utilities Data Model installation, according to your data and security requirements.

- Creating Sample Report Tablespaces
In previous releases of Oracle Utilities Data Model the installation scripts create the tablespaces and create the database objects in those tablespaces. In this release, Release 12.2, the Oracle Utilities Data Model installation does not create tablespaces. You must create the Oracle Utilities Data Model tablespaces prior to Oracle Utilities Data Model installation, according to your data and security requirements.

Ensuring that Required Software is Installed

You must have certain software installed before you can successfully install Oracle Utilities Data Model component or the Oracle Utilities Data Model sample data and reports.

Perform the following steps to ensure that for each type of installation, the required software is installed:

- Confirming that Oracle Advanced Analytics and OLAP Options are Installed
Provides the commands to check that Oracle Advanced Analytics and OLAP options are installed.

- Confirming that Oracle Business Intelligence Suite Extended Edition is Installed
Test that Oracle Business Intelligence Suite Extended Edition is installed.

- Confirming that Oracle Business Intelligence Developer Client Tools Installer is Installed
Describes how to confirm that Oracle Business Intelligence Developer Client Tools Installer is Installed.

Related Topics

- Software Requirements

Confirming that Oracle Advanced Analytics and OLAP Options are Installed

Provides the commands to check that Oracle Advanced Analytics and OLAP options are installed.

1. To check that the Oracle Advanced Analytics and OLAP options are installed, log in as SYS and enter the following SQL queries:

SELECT VALUE FROM V$OPTION WHERE PARAMETER ='Data Mining';
SELECT VALUE FROM V$OPTION WHERE PARAMETER ='OLAP';

If these queries return TRUE, the options are installed.

Confirming that Oracle Business Intelligence Suite Extended Edition is Installed

Test that Oracle Business Intelligence Suite Extended Edition is installed.

1. To test that Oracle Business Intelligence Suite Extended Edition is installed, open the following link in a browser:

http://hostname:9704/analytics

Use Administrator for both the user name (ID) and the password.

Note:

The 9704 value in the link is the value of the default Oracle Business Intelligence Suite Extended Edition port; if you specified a different port when you installed Oracle Business Intelligence Suite Extended Edition, use the value for that port.

The sample Oracle Business Intelligence Suite Extended Edition login window is displayed.

2. If Oracle Business Intelligence Suite Extended Edition is not installed, then install it.

Related Topics

- Oracle Business Intelligence Suite Extended Edition

Confirming that Oracle Business Intelligence Developer Client Tools Installer is Installed

Describes how to confirm that Oracle Business Intelligence Developer Client Tools Installer is Installed.

Select the version of Oracle Business Intelligence Developer Client Tools Installer according to the version of Oracle Business Intelligence Suite Extended Edition. For example, if the version of Oracle Business Intelligence Suite Extended Edition is 12.2.1, then select Oracle Business Intelligence Developer Client Tools Installer version is 12.2.1.

For more information, see:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/index.html

Changing the Default Value for the Maximum Processes Initialization Parameter

Oracle Utilities Data Model requires that the initial value for the PROCESSES initialization parameter be set to a value greater than the default database installation value.

How to determine the current value for the PROCESSES parameter

To determine the current value for the maximum processes parameter, log in as DB with DBA account, and then execute the following SQL statement:

show parameter processes;

How to change the value for the maximum processes

To change the value for the maximum processes, issue the following statements. Depending on your database options, the value specified for processes should be set to a minimum value greater than or equal to 250:

alter system set processes=250 scope=spfile;
shutdown immediate
startup

Changing the Maximum Data Files Option

Oracle Utilities Data Model supports the partition of transaction-related fact tables according to your data volume estimation. To support the partition of transaction-related fact tables, you might need a different value for the maximum number of data files that is presently specified for the Database.

You can specify the start year and end year for your data. Based on your input the transaction related fact tables are partitioned by the date as one partition for each month.

How to determine the value for maximum number of data files

Use the following formula to determine the value that you need for the maximum number of data files:

Maximum Datafiles = Default Value + 300 + ((End year) - (Start year) + 1) * 12

How to determine the current value for the maximum number of data files

To determine the current value for the maximum number of data files, log in as DB with DBA account, and then execute the following SQL statement:

show parameter db_files

In the results for this statement, the value column shows the current maximum number of data files.

How to change the value for the maximum number of data files

To change the value for the maximum number of data files, issue the following statements where new_number is the new value that you want to specify:

alter system set db_files = new_number scope = spfile;
shutdown immediate
startup

Disabling the Oracle Database Vault Option

For an Oracle Database with the Oracle Database Vault enabled, disable the Oracle Database Vault before you install Oracle Utilities Data Model.

Disabling the Oracle Database Vault Option

The Oracle Utilities Data Model installer requires additional steps on a Vault-enabled database. For an Oracle Database with the Oracle Database Vault enabled, perform the following steps to disable Oracle Database Vault before you install Oracle Utilities Data Model.

To find out if Oracle Database Vault is enabled, do the following:

SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

If this command returns true, then the Vault option is enabled.

To disable the Vault option, do the following:

1. On UNIX systems, ensure that the environment variables, ORACLE_HOME, ORACLE_SID, and PATH are correctly set.

2. Log in to SQL*Plus as user SYS with the SYSOPER privilege.

3. Shut down the Database.

4. From the command line, stop the Database Control console process and the listener. For example:

sqlplus sys as sysoper
Enter password: password
SQL> SHUTDOWN IMMEDIATE
SQL> EXIT
$ emctl stop dbconsole
$ lsnrctl stop listener_name

For Oracle RAC installations, shut down each database instance as follows:

$ srvctl stop database -d db_name

Note:

In Oracle Database 12c, Oracle Enterprise Manager Database Express is built into the Oracle database. It requires no special installation or management.

5. Disable Oracle Database Vault with the following commands (this is a UNIX system example):

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off
cd $ORACLE_HOME/bin
relink all

For Oracle RAC installations, run these commands on all nodes.

6. Startup the Database, Database Control console process, and listener. For example, on UNIX, Log in to SQL*Plus as user SYS with the SYSOPER privilege and restart the database instance. Then from the command line, restart the Database Control console process and listener. For example:

sqlplus sys as sysoper
Enter password: password
SQL> STARTUP
SQL> EXIT
$ emctl start dbconsole
$ lsnrctl start listener_name

For Oracle RAC installations, restart each instance as follows:

$ srvctl start database -d db_name

Related Topics

- Re-Enabling Oracle Database Vault

- Oracle Database Vault Administrator’s Guide

Ensuring a Value is Set for the Service Name

Ensure that the tnsnames.ora file includes a value for SERVICE_NAME.

In a Non Oracle RAC Environment

- In a Non Multitenant Environment
Ensure that in tnsnames.ora the service name is provided. To check and modify tnsnames.ora, perform the following steps:

1. Go to the directory: $ORACLE_HOME/network/admin

2. Edit tnsnames.ora to make sure the SERVICE_NAME value is provided. For example:

orcl= (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = example.oracle.com)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

- In a Multitenant Environment
In a multitenant environment, every container, root, or pluggable has its own service name and you need to use the PDB container for application users. While installing the data model you need to provide the service name of the pluggable database (PDB).

You must manually add the PDB entry in the tnsnames.ora before proceeding with the install:

1. Go to the directory: $ORACLE_HOME/network/admin

2. Edit tnsnames.ora to ensure the SERVICE_NAME value is provided. For example:

PDBORCL12 =   (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
(CONNECT_DATA =       (SERVER = DEDICATED)
(SERVICE_NAME = pdborcl12. example.com)      )    )

To create the entry using the description in tnsnames.ora for the connection to the CDB, copy the CDB entry and then modify the copied CDB entry as the PDB entry.

In an Oracle RAC Environment

The important difference compared with other Oracle RAC service name configuration settings is to use a specific host name, not a Single Client Access Name (SCAN).

Note:

Although a specific host is used, Oracle Utilities Data Model is installed on all the nodes.

- In a Non Multitenant Environment
Ensure that in tnsnames.ora, the service name is provided. To check and modify tnsnames.ora, perform the following steps:

1. Go to the directory:$ORACLE_HOME/network/admin.

2. Edit tnsnames.ora to add an entry to the specific host to use with the actual host name, not the scanname. For example, two Oracle RAC nodes (example00eax, example00eay), the scanname is example00eaxy-scn. and OUI starts on node example00eax. The original tns information, for example is:

CSOUDM=
(DESCRIPTION=
(ADDRESS =  (PROTOCOL =TCP)(HOST=example00eaxy-scn)(PORT=1521))
(CONNECT_DATA =
(SERVER =DEDICATED)
(SERVICE_NAME =csoudm.us.oracle.com)
)
)

Then add an entry specific to host example00eax.

example00eax=
(DESCRIPTION=
(ADDRESS =  (PROTOCOL =TCP)(HOST=example00eax)(PORT=1521))
(CONNECT_DATA =
(SERVER =DEDICATED)
(SERVICE_NAME =csoudm.us.oracle.com)
)
)

Use example00eax as the service name to install Oracle Utilities Data Model. No change is required to the node example00eay.

- In a Multitenant Environment
In a multitenant environment, every container, root, or pluggable, has its own service name and you need to use the PDB container for application users. While installing the data model you need to provide the service name of the pluggable database (PDB).

You must manually add the PDB entry in the tnsnames.ora before proceeding with the install:

1. Go to the directory: $ORACLE_HOME/network/admin

2. Edit tnsnames.ora to ensure the SERVICE_NAME value is provided. For example:

example00eax =   (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =example00eax)(PORT = 1521))
(CONNECT_DATA =       (SERVER = DEDICATED)
(SERVICE_NAME = pdborcl12. example.com)      )    )

To create the entry using the description in tnsnames.ora for the connection to the CDB, copy the CDB entry and then modify the copied CDB entry as the PDB entry.Note, use actual host name(HOST =example00eax) not the scanname, for example: example00eaxy-scn.

Only the tns of the host where OUI starts needs to update the tnsnames.ora, the other tnsnames.ora files at other nodes do not require changes.

Creating Utilities Data Model Tablespaces

In previous releases of Oracle Utilities Data Model the installation scripts create the tablespaces and create the database objects in those tablespaces. In this release, Release 12.2, the Oracle Utilities Data Model installation does not create tablespaces. You must create the Oracle Utilities Data Model tablespaces prior to Oracle Utilities Data Model installation, according to your data and security requirements.

1. Create Tablespaces for Tables:

Table 3-1 Required Tablespace for Tables

Required Tablespace

Example Tablespace Name to Create for Tables

Base

OUDM_BASE_TAB.TBS

Reference

OUDM_REF_TAB.TBS

Lookup

OUDM_LOOKUP_TAB.TBS

Derived

OUDM_DERIVED_TAB.TBS

Aggregate

OUDM_AGGRGTE_TAB.TBS

Figure 3-1 Select Tablespace for Tables Dialog

2. Create Tablespace for Materialized Views:

Table 3-2 Required Tablespace for Materialized Views, OLAP, Default, and Temporary Tables

Required Tablespace

Example Tablespace Name to Create for Materialzied Views, OLAP, and Default, and Temporary Tables

Materialized Views

OUDM_MV.TBS

OLAP

OUDM_OLAP.TBS

Default

OUDM_DEFAULT.TBS

Temporary for Default

OUDM_TEMP.TBS

Figure 3-2 Select Tablespace for Materialized Views Dialog

3. Create Tablespace for Indexes:

Table 3-3 Required Tablespace for Indexes

Required Tablespace

Example Tablespsce Name to Create for Index

Base Index

OUDM_BASE_IDX.TBS

Reference Index

OUDM_REF_IDX.TBS

Lookup Index

OUDM_LOOKUP_IDX.TBS

Derived Index

OUDM_DERIVED_IDX.TBS

Aggregate Index

OUDM_AGGRGTE_IDX.TBS

Figure 3-3 Select Tablespace for Indexes Dialog

Creating Sample Report Tablespaces

In previous releases of Oracle Utilities Data Model the installation scripts create the tablespaces and create the database objects in those tablespaces. In this release, Release 12.2, the Oracle Utilities Data Model installation does not create tablespaces. You must create the Oracle Utilities Data Model tablespaces prior to Oracle Utilities Data Model installation, according to your data and security requirements.

1. If you are installing with the Sample Reports installation option, create Tablespaces for Sample Reports for default tablespace and default temporary tablespace for the sample reports.

Table 3-4 Required Tablespace for Sample Report Tables

Required Tablespace

Example Tablespace Name to Create for Tables

Default

OUDM_SAMPLE.TBS

Temp for Default

OUDM_TEMP_SAMPLE.TBS

Figure 3-4 Select Tablespace for Sample Schema Dialog

Related Topics

- Types of Installations Provided for Oracle Utilities Data Model

Installer Execution

Describes the steps to perform to install Oracle Utilities Data Model.

Before you install Oracle Utilities Data Model, perform the necessary preinstallation tasks.

Note:

You must install Oracle Utilities Data Model on the localhost where the database server is located. You can determine the value of your localhost by issuing the following command where db_name is the name of your Oracle database:

tnsname db_name

Follow these steps to install Oracle Utilities Data Model:

1. Log in using the user ID that you plan to use to run the installation. You should use the same user ID to install Oracle Utilities Data Model as used to install the Oracle Database and Oracle Business Intelligence Suite Enterprise Edition.

2. Set the ORACLE_HOME environment variable to the location of the database where you want to install Oracle Utilities Data Model.

For example, suppose Oracle home is in the directory /loc/app/oracle/product/dbhome

In a Bourne, Bash, or Korn shell, use these commands to set ORACLE_HOME:

$ ORACLE_HOME=/loc/app/oracle/product/dbhome
$ export ORACLE_HOME

In a C shell, use this command to set ORACLE_HOME:

% setenv ORACLE_HOME /loc/app/oracle/product/dbhome

3. Start the installer from the directory that contains the Oracle Utilities Data Model installation files:

cd directory-containing-OUDM_installation-files
./runInstaller

4. The Welcome page is displayed. Click Next.

5. In the Select Installation Type page, select the type of Oracle Utilities Data Model installation that you want to perform:

- If you want to install the Oracle Utilities Data Model component, select Utilities Data Model.

- If you want to install the Oracle Utilities Data Model reports and sample data, select Sample Reports.

Oracle Utilities Data Model supports English. The option provided to add support for one language in addition to English is not used at the time of this release.

Click Next.

6. In the Specify Home Details page, verify that the Name and Path correspond to the database in which you want to install Oracle Utilities Data Model. You can click Browse to navigate to any valid local data file path.

Click Next.

7. In the Product-Specific Prerequisite Checks page, if one or more items are flagged, manually verify that your environment meets the minimum requirements. For details about performing this manual verification, click the flagged item and review the details in the box at the bottom of the page.

When the status of all items are checked as Succeeded, click Next.

8. In the Specify Database Connection Information page, provide the following information:

- Select the Net Service Name which is the alias used for a connect descriptor to connect to the Oracle Database where Oracle Utilities Data Model will be installed.

Tip:

A net service name is a simple name for a service that resolves to a connect descriptor. Net service names are populated from the OracleHome/network/admin/tnsnames.ora file.

- Enter the Password for SYSTEM user of the Oracle Database where Oracle Utilities Data Model will be installed.

Click Next.

9. The Specify OUDM Schema Information page is displayed when you select to install the component, Utilities Data Model. In this dialog specify where all the data files that correspond to the Oracle Utilities Data Model tablespace should reside:

- If you do not want to use the Automatic Storage Management (ASM) feature in Oracle Database, but instead want to explicitly specify a folder name, select File System and enter a folder name. You can click Browse to navigate to any valid local data file path.
Click Next.

- If you have stored your Oracle database files using the Automatic Storage Management (ASM) feature, and you also want store Oracle Utilities Data Model data files using ASM, select Automatic Storage Management (ASM).
Click Next.

In the Select ASM Disk Group page, select the disk group in which you want to install the Oracle Utilities Data Model data files.

Click Next.

10. The Select Tablespace for Tables page displays. In this dialog, in the dropdown lists, select the tablespaces for tables you created prior to running the installer.

11. The Select Tablespace for Materialized Views page displays. In this dialog, in the dropdown lists, select the tablespaces you created prior to running the installer.

12. The Select Tablespace for Indexes page displays. In this dialog, in the dropdown lists, select the tablespaces you created prior to running the installer.

13. The Specify OUDM Sample Schema Information page displays when you select to install the Sample Reports. In this dialog you specify where all the data files that correspond to the Oracle Utilities Data Model sample schemas should reside:

- If you do not want to use the Automatic Storage Management (ASM) feature in Oracle Database, but instead want to explicitly specify a folder name, select File System and enter a folder name. You can click Browse to navigate to any valid local data file path.
Click Next.

- If you have stored your Oracle database files using the Automatic Storage Management (ASM) feature, and you also want store Oracle Utilities Data Model data files using ASM, select Automatic Storage Management (ASM).
Click Next.

In the Select ASM Disk Group page, select the disk group in which you want to install the Oracle Utilities Data Model data files.

Click Next. When you install the sample reports, the next page shows the installer Summary that summarizes the information that you specified.

a. The Select Tablespace for Sample Schema page displays when you install the Sample Reports. In this dialog, select the tablespace you created prior to running the installer.

14. In the Specify Calendar Date Range page, specify the calendar date range by providing values for Start Date and Number of Years. The installer uses this information to populate the calendar data. A recommended Number of Years value is 15 years. Specifying larger Number of Years values proportionally increases the time it takes to implement the partitioning portion of Oracle Utilities Data Model install activity. The start year specified with Start Date should be the lowest possible dates from your historical data load (lowest possible CDR date typically). There is no easy method to incrementally extend the time dimension, so your initial choice for Number of Years should be specified to meet your needs for a reasonably long time.

Start Date must be in the format YYYY-MM-DD; for example, 2011-01-01 stands for January 1, 2011. Number of Years must be a whole number.

Note:

These calendar dates have nothing to do with the number of years you will effectively keep the data. The calendar as such is totally independent of the Information Lifecycle Management process you may use.

Click Next.

15. In the Specify Partitions for reference and base tables page, specify the number of Second Level hash partitions for each entity, Organization, Customer, Party, Account, Agreement, MeterReading, InitialReading, FinalReading, ServiceQuantity, and Interval Partition Start Date. Specify a value for each field. If you enter an invalid value, then the installer shows a dialog displaying the valid values. For each value you specify, you should choose a value that is a power of 2 (for example: 4, 8, 16, 32, 64 and so on). Enter a date for the Interval Partition Start Date in the specified format (YYYY-MM-DD).

Click Next.

16. The installer summarizes the information that you specified. Check that this information is correct. If necessary, click Back to return to previous screens and make corrections. When you are satisfied with the information, click Install.

17. The Oracle Utilities Data Model component or sample reports are installed. If there are any problems, messages are displayed. After the installation finishes, the end of installation screen appears. Click Exit to exit the installer.

After you exit the installer, perform any necessary post-installation tasks. Then install the additional components that you need to create an Oracle Utilities Data Model warehouse.

Related Topics

- Pre-installation Tasks

- Types of Installations Provided for Oracle Utilities Data Model

- Post-Installation Tasks

- Installation of Additional Components

Silent Installation

Specifies instructions for using the -silent option with the installer.

A silent installation has no graphical output and no input by the user. It is accomplished by supplying Oracle Universal Installer with a response file and specifying the -silent flag on the command line. Use silent installation when you want the same installation parameter on more than one computer.

- Selecting a Response File
Before performing a silent installation, you must provide information specific to your installation in a response file.

- Editing the Response File
Use any text editor to edit the silent install response file to include information specific to your system.

- Specifying a Response File and Starting the Installation
To make Oracle Universal Installer use the response file at installation time, specify the location of the response file as a parameter when starting Oracle Universal Installer.

- Silent Installation Log Files
The success or failure of silent installations is logged in the installActions.log file.

- Security Tips for Silent Installations
The response file contains the installation password in clear text. To minimize security issues, follow these guidelines for the silent installation.

- Error Handling
Describes silent installation error handling.

- Silent Install Parameters for Oracle Utilities Data Model
Provides response file input parameters for Oracle Utilities Data Model silent installation for installation type Utilities Data Model and Sample Reports.

Selecting a Response File

Before performing a silent installation, you must provide information specific to your installation in a response file.

The installer fails if you attempt an installation using a response file that is not configured correctly. Response files are text files that you can create or edit in a text editor. The response file (udm.rsp) is located in the /response directory in the directory that contains the Oracle Utilities Data Model installation files. Edit the response file according to your requirements for silent installation. To use a response file, first copy it to your system.

Note:

You must install Oracle Utilities Data Model on the "localhost" where the database server is located. You can determine the value of your "localhost" by issuing the following command where db-name is the name of your Oracle Database:

tnsname db-name

Editing the Response File

Use any text editor to edit the silent install response file to include information specific to your system.

You must specify values for variables in your response file. Each variable listed in the response file is associated with a comment, which identifies the variable type. For example:

string = "Sample Value"
Boolean = True or False
Number = 1000
StringList = {"StringValue 1", "String Value 2"}

For a silent installation, specify values for the strings with <Value Required>. Remove the comment from the variable values in the response file before starting the Oracle Utilities Data Model installation.

Specifying a Response File and Starting the Installation

To make Oracle Universal Installer use the response file at installation time, specify the location of the response file as a parameter when starting Oracle Universal Installer.

Before you specify a response file, ensure that all values in the response file are correct. To perform a silent installation, use the -silent parameter as follows:

./runInstaller -silent -responseFile absolute_path_and_filename

Caution:

During installation, response files may be copied to subdirectories in the Oracle home. If you have provided passwords or other sensitive information in your response files, then for security purposes you should delete them after completing and verifying the installation.

Silent Installation Log Files

The success or failure of silent installations is logged in the installActions.log file.

The silent installation creates the silentInstall.log file. The log files are created in the /oraInventory/logs directory. The silentInstallDate_Time.log file contains the following line if the installation was successful:

The installation of Oracle Utilities Data Model was successful.

The corresponding installActionsDate_Time.log file contains specific information regarding installation.

Security Tips for Silent Installations

The response file contains the installation password in clear text. To minimize security issues, follow these guidelines for the silent installation.

- Set the permissions on the response files so that they are readable only by the operating system user performing the silent installation.

- If possible, remove the response files from the system after the silent installation is completed.

Error Handling

Describes silent installation error handling.

- Variables that are outside any section are ignored.

- Values for variables that are of the wrong context, format, or type are treated as null.

- If you attempt a silent installation with an incorrect or incomplete response file, or if Oracle Universal Installer encounters an error, such as insufficient disk space, then the installation fails.

Silent Install Parameters for Oracle Utilities Data Model

Provides response file input parameters for Oracle Utilities Data Model silent installation for installation type Utilities Data Model and Sample Reports.

Table 3-5 Utilities Data Model Parameters for Silent Install with udm.rsp

Parameter Name

Description

ORACLE_HOME

Oracle Database Home

ORACLE_BASE

Oracle Base

s_dbSid

SID

s_dbSysPasswd

SYSTEM user password

s_dlgOUDMSelectTablespaceBase

Tablespace for BASE tables

s_dlgOUDMSelectTablespaceReference

Tablespace for REFERENCE tables

s_dlgOUDMSelectTablespaceLookup

Tablespace for LOOKUP tables

s_dlgOUDMSelectTablespaceDerived

Tablespace for DERIVED tables

s_dlgOUDMSelectTablespaceAggregate

Tablespace for AGGREGATE tables

s_dlgOUDMSelectTablespaceIndexesBase

Tablespace for BASE indexes

s_dlgOUDMSelectTablespaceIndexesReference

Tablespace for REFERENCE indexes

s_dlgOUDMSelectTablespaceIndexesLookup

Tablespace for LOOKUP indexes

s_dlgOUDMSelectTablespaceIndexesDerived

Tablespace for DERIVED indexes

s_dlgOUDMSelectTablespaceIndexesAggregate

Tablespace for AGGREGATE indexes

s_dlgOUDMMaterializedViewsMviews

Tablespace for Materialized Views

s_dlgOUDMMaterializedViewsOlap

Tablespace for OLAP objects

s_dlgOUDMMaterializedViewsDefault

Default tablespace for OUDM_SYS schema

s_dlgOUDMMaterializedViewsTempDefault

Default temporary tablespace for OUDM_SYS schema

s_dlgCalendarInfoStartDate

Calendar Start Date

s_dlgCalendarInfoNumberOfYears

Calendar Number of Years

s_dlgPartitionIntervalStartDate

Interval Partition Start Date

s_dlgPartitionKeyOrganization

Number of Hash Partitions for Organization

s_dlgPartitionKeyCustomer

Number of Hash Partitions for Customer

s_dlgPartitionKeyParty

Number of Hash Partitions for Party

s_dlgPartitionKeyAccount

Number of Hash Partitions for Account

s_dlgPartitionKeyAgreement

Number of Hash Partitions for Agreement

s_dlgPartitionKeyMeterReading

Number of Hash Partitions for MeterReading

s_dlgPartitionKeyInitialReading

Number of Hash Partitions for InitialReading

s_dlgPartitionKeyFinalReading

Number of Hash Partitions for FinalReading

s_dlgPartitionKeyServiceQuantity

Number of Hash Partitions for ServiceQuantity

Table 3-6 Sample Report Parameters for Silent Install with reports.rsp

Parameter Name

Description

ORACLE_HOME

Oracle Database Home

ORACLE_BASE

Oracle Base

s_dbSid

SID

s_dbSysPasswd

SYSTEM user password

s_dlgOUDMSampleSelectTablespaceDefault

Tablespace for OUDM_SAMPLE schema

s_dlgOUDMSampleSelectTablespaceTempforDefault

Temporary tablespace for OUDM_SAMPLE schema.

s_dlgCalendarInfoStartDate

Calendar Start Date

s_dlgCalendarInfoNumberOfYears

Calendar Number of Years

s_dlgPartitionIntervalStartDate

Interval Partition Start Date

s_dlgPartitionKeyOrganization

Number of Hash Partitions for Organization

s_dlgPartitionKeyCustomer

Number of Hash Partitions for Customer

s_dlgPartitionKeyParty

Number of Hash Partitions for Party

s_dlgPartitionKeyAccount

Number of Hash Partitions for Account

s_dlgPartitionKeyAgreement

Number of Hash Partitions for Agreement

s_dlgPartitionKeyMeterReading

Number of Hash Partitions for MeterReading

s_dlgPartitionKeyInitialReading

Number of Hash Partitions for InitialReading

s_dlgPartitionKeyFinalReading

Number of Hash Partitions for FinalReading

s_dlgPartitionKeyServiceQuantity

Number of Hash Partitions for ServiceQuantity

Post-Installation Tasks

Specifies the steps to perform after the installation.

After you run Oracle Universal Installer perform the following post-installation steps:

- After you install Oracle Utilities Data Model, obtain the IP Patch. To obtain the IP Patch for the latest information about Oracle Utilities Data Model, patch sets, go to: My Oracle Support.

- Review the Security chapter in the Oracle Utilities Data Model Implementation and Operations Guide.

- Unlocking the OUDM_SYS Account
Describes how to unlock the OUDM_SYS account and set a password on this account.

- Unlocking the OUDM_USER and OUDM_REPORT Accounts
Describes how to unlock the OUDM_USER and OUDM_REPORT accounts and set a passwords on these accounts.

- Postinstallation for Sample Reports
If you installed the sample reports, you need to also perform several postinstallation steps.

- Configuring the Working OLAP Environment
To set up a working OLAP environment for an Oracle Utilities Data Model warehouse, configure the database with the specified parameter and configuration settings.

- Re-Enabling Oracle Database Vault
Describes the process of re-enabling Oracle Database Vault if before installing you disabled Oracle Database Vault, and then you want to re-enable Oracle Database Vault.

- Ensuring That Oracle Utilities Data Model Objects Are Valid
Describes recompiling all objects in oudm_sys schema.

- Ensuring That PGA_AGGREGATE_TARGET is Set to the Proper Value
To improve performance ensure that the PGA_AGGREGATE_TARGET is set to the proper value.

Unlocking the OUDM_SYS Account

Describes how to unlock the OUDM_SYS account and set a password on this account.

Unlocking the OUDM_SYS Account

At the end of the installation, the OUDM_SYS account is locked. To unlock this account:

1. Connect to the database with a DBA ID.

Note:

The password is case sensitive.

2. Unlock the account and set the password by issuing the following SQL statement:

alter user oudm_sys account unlock identified by new_password;

WARNING:

Enter a password for the OUDM_SYS account that is secure, according to the password guidelines described in Oracle Database 2 Day DBA. Do not to use OUDM_SYS as a password.

Related Topics

- Oracle Database 2 Day DBA

Unlocking the OUDM_USER and OUDM_REPORT Accounts

Describes how to unlock the OUDM_USER and OUDM_REPORT accounts and set a passwords on these accounts.

Unlocking the OUDM_USER and OUDM_REPORT Accounts

At the end of the installation, the OUDM_USER and OUDM_REPORT accounts are locked. To unlock these accounts:

1. Connect to the database with a DBA ID.

Note:

The password is case sensitive.

2. Unlock the accounts and set the passwords by issuing the following SQL statements:

alter user oudm_user account unlock identified by new_password1;
alter user oudm_report account unlock identified by new_password2;

WARNING:

Enter a password for each account that is secure, according to the password guidelines described in Oracle Database 2 Day DBA. Do not to use OUDM_REPORT or OUDM_USER as passwords.

Related Topics

- Oracle Database 2 Day DBA

Postinstallation for Sample Reports

If you installed the sample reports, you need to also perform several postinstallation steps.

If you installed the Oracle Utilities Data Model sample reports, then perform the following steps:

- Unlocking the OUDM_SAMPLE Account
Describes how to unlock the OUDM_SAMPLE account.

- Installing Oracle Business Intelligence Suite Extended Edition Catalog for Oracle Utilities Data Model
After Oracle Business Intelligence Suite Extended Edition is installed, follow these steps to install an Oracle Business Intelligence Suite Extended Edition catalog for Oracle Utilities Data Model. If you install the Oracle Utilities Data Model sample reports, then configure the database connection information for the Catalog.

- Installing RPD and Web Catalog for Oracle Business Intelligence Suite Extended Edition
Describes installing the RPD file and deploying the Web Catalog.

Unlocking the OUDM_SAMPLE Account

Describes how to unlock the OUDM_SAMPLE account.

Unlocking the OUDM_SAMPLE Account

At the end of the installation of the Oracle Utilities Data Model sample reports, the OUDM_SAMPLE account is locked. To unlock this account:

1. Connect to the Database with a DBA ID.

Note:

The password is case sensitive.

2. Unlock the account and set the password by issuing the following SQL statement:

alter user oudm_sample account unlock identified by <password>;

WARNING:

Enter a password for the OUDM_SAMPLE account that is secure, according to the password guidelines described in Oracle Database 2 Day DBA. Do not use OUDM_SAMPLE as a password.

Related Topics

- Oracle Database 2 Day DBA

Installing Oracle Business Intelligence Suite Extended Edition Catalog for Oracle Utilities Data Model

After Oracle Business Intelligence Suite Extended Edition is installed, follow these steps to install an Oracle Business Intelligence Suite Extended Edition catalog for Oracle Utilities Data Model. If you install the Oracle Utilities Data Model sample reports, then configure the database connection information for the Catalog.

1. Add a definition for oudm_db for the Oracle Utilities Data Model repository to use when connecting to the database. Add this definition to the file $ORACLE_HOME/network/admin/tnsnames.ora:

oudm_db =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.domain)(PORT = port-number))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID) # Change your SID, Hostname, and Listener PortNumber
)
)

Tip:

Be careful to split these commands properly when you add them to the file; for example, do not add them as one long concatenated line of code.

Note:

If you want to use another database name, you must change the tnsname in the Oracle Business Intelligence Suite Extended Edition repository. See the Oracle Business Intelligence Suite Extended Edition documentation for directions for defining a database connection in repository.

Related Topics

- Oracle Business Intelligence Suite Extended Edition

Installing RPD and Web Catalog for Oracle Business Intelligence Suite Extended Edition

Describes installing the RPD file and deploying the Web Catalog.

If you installed the Oracle Utilities Data Model sample reports, you need to deploy the Oracle Utilities Data Model RPD and Web Catalog on the Oracle Business Intelligence Suite Extended Edition 12c instance. For more information on deploying RPD and Web Catalog in BIEE, see Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

After you use the installer to install the sample reports, you can find the RPD file and the Web Catalog file in the $ORACLE_HOME/oudm/report directory:

oudm.rpd

oudmwebcat.zip

Unzip the Web Catalog

Before you deploy the Web Catalog, you need to unzip oudmwebcat.zip.

Update the RPD Connection Pool

Do the following to update the RPD connection pool:

1. Open Oracle Business Intelligence Developer Client Tools and select File->Open->Offline...,
Browse to locate $ORACLE_HOME/oudm/report/oudm.rpd

2. Double click Connection Pool in ODWT at the Physical layer.

3. Update the Host, Port, Service and User name to point to Oracle Utilities Data Model schema.

Note:

In addition, follow steps 2 and 3 to update the connection pool in OUDM_OLAP at the Physical layer.

4. Click OK to exit and then click Save.

5. Test the connection pool to check that it is successfully configured. Right click a table in the ODWT.OUDM_SYS. Select, Update Row Count. If no errors are reported then the connection pool is successfully configured.

Deploy the RPD and Web Catalog

Perform the following steps to deploy the Oracle Utilities Data Model RPD and Web Catalog:

1. Use your browser to open the weblogic Enterprise Manager portal:

http://SERVERNAME:7001/em

Log in with the weblogic admin ID and password.

From the Business Intelligence tab select coreapplication, then select Deployment and click Repository. Next deploy the RPD and Web Catalog.

Note:

When you deploy the RPD you need to provide an RPD password. Contact Oracle Support to obtain a temporary RPD password, at My Oracle Support.

2. Use your browser to open the WebLogic console portal:

http://SERVERNAME:7001/console/login/LoginForm.jsp

Log in with your WebLogic Admin ID and password. Go to your security realm and create a user named oudm and set a password for this user.

Configuring the Working OLAP Environment

To set up a working OLAP environment for an Oracle Utilities Data Model warehouse, configure the database with the specified parameter and configuration settings.

Configuring the Working OLAP Environment

- Set sga_target to 35% of available memory.

- Set pga_aggregate_target to 35% of available memory

- Set olap_page_pool_size=0. (This specifies dynamic page pool.)

- Set _olap_page_pool_hi=30 (that is, lower than default of 50).

- Set _olap_parallel_update_threshold and _olap_parallel_update_small_threshold to a high value (for example, ~2Gb.. 2147483647). These settings turn off parallel update for the analytic workspace.

- Set memory_max_target to value greater than SGA and PGA settings. This is maximum amount of memory used for both SGA and PGA. The SGA and PGA settings specified are the minimum settings. (Note that failure to set memory_max_target leads to failure of instance startup (the next time these settings are validated which occurs if spfile had an older and distinct setting for memory_max_target).

The following statements illustrate changing these settings:

alter system set sga_target=1365M scope=spfile;
alter system set pga_aggregate_target=1365M scope=spfile;
alter system set memory_max_target=3030M scope=spfile;
alter system set olap_page_pool_size=0 scope=spfile;
alter system set "_olap_parallel_update_small_threshold"=2147483647 scope=spfile;
alter system set "_olap_page_pool_hi"=30 scope=spfile;
alter system set job_queue_processes=5 scope=spfile;
shutdown immediate;
startup;

Re-Enabling Oracle Database Vault

Describes the process of re-enabling Oracle Database Vault if before installing you disabled Oracle Database Vault, and then you want to re-enable Oracle Database Vault.

Re-Enabling Oracle Database Vault

If you are using Oracle Database Vault and disabled this option before installation then re-enable Oracle Database Vault by taking the following steps:

1. Shutdown the Database, Database Control console process, and listener. For example on UNIX, ensure that the environment variables, ORACLE_HOME, ORACLE_SID, and PATH are correctly set. Log in to SQL*Plus as user SYS with the SYSOPER privilege and shut down the database. Then from the command line, stop the Database Control console process and listener. For example:

sqlplus sys as sysoper
Enter password: password
SQL> SHUTDOWN IMMEDIATE
SQL> EXIT
$ emctl stop dbconsole
$ lsnrctl stop listener_name

For Oracle RAC installations, shut down each database instance as follows:

$ srvctl stop database -d db_name

Note:

In Oracle Database 12c, Oracle Enterprise Manager Database Express is built into the Oracle database. It requires no special installation or management.

2. Enable Oracle Database Vault:

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_on
make -f ins_rdbms.mk ioracle

3. Startup the Database, Database Control console process, and listener. For example, on UNIX, Log in to SQL*Plus as user SYS with the SYSOPER privilege and restart the instance. Then from the command line, restart the Database Control console process and listener. For example:

sqlplus sys as sysoper
Enter password: password
SQL> STARTUP
SQL> EXIT
$ emctl start dbconsole
$ lsnrctl start listener_name

For Oracle RAC installations, restart each instance as follows:

$ srvctl start database -d db_name

4. For Oracle RAC installations, repeat these steps for each node on which the database is installed.

Ensuring That Oracle Utilities Data Model Objects Are Valid

Describes recompiling all objects in oudm_sys schema.

Recompiling Objects in OUDM_SYS

To ensure that all Oracle Utilities Data Model objects are valid, log in to the database with a DBA id and password and recompile all objects in OUDM_SYS by issuing the following SQL statements:

exec utl_recomp.recomp_serial('OUDM_SYS');

Ensuring That PGA_AGGREGATE_TARGET is Set to the Proper Value

To improve performance ensure that the PGA_AGGREGATE_TARGET is set to the proper value.

The value specified for PGA_AGGREGATE_TARGET depends on the physical RAM of your Database Server.

Setting PGA_AGGREGATE_TARGET

Ensure that the WORKAREA_SIZE_POLICY parameter is set to AUTO.

Note:

Setting PGA_AGGREGATE_TARGET to a nonzero value has the effect of automatically setting the WORKAREA_SIZE_POLICY parameter to AUTO.

Related Topics

- Oracle Database Performance Tuning Guide

4 Installation of Additional Components

Describes how to install Oracle components that you did not need to install before you installed the Oracle Utilities Data Model component or sample reports, but that you will use when you are creating an Oracle Utilities Data Model data warehouse:

- Creating an Oracle Business Intelligence Suite Extended Edition Catalog
The sample reports provided with Oracle Utilities Data Model are created using the Oracle Business Intelligence Suite Extended Edition.

- Installing Analytic Workspace Manager
Although not required before you install Oracle Utilities Data Model, install the Analytic Workspace Manager to view and modify Oracle Utilities Data Model OLAP cubes.

Creating an Oracle Business Intelligence Suite Extended Edition Catalog

The sample reports provided with Oracle Utilities Data Model are created using the Oracle Business Intelligence Suite Extended Edition.

To modify these reports or to use them as the basis for creating new reports install Oracle Business Intelligence Suite Extended Edition and create an Oracle Business Intelligence Suite Extended Edition catalog for Oracle Utilities Data Model.

Installing Oracle Business Intelligence Suite Extended Edition

If you install Oracle Utilities Data Model sample reports, then install Oracle Business Intelligence Suite Extended Edition as a pre-installation step. If you install the Oracle Utilities Data Model component rather than the sample reports, then install Oracle Business Intelligence Suite Extended Edition.

You also need to create a catalog.

Tip:

To check that Oracle Business Intelligence Suite Extended Edition is installed, follow the instructions in "Confirming that Oracle Business Intelligence Suite Extended Edition is Installed".

Related Topics

- Oracle Business Intelligence Suite Extended Edition

- Installing Oracle Business Intelligence Suite Extended Edition Catalog for Oracle Utilities Data Model

Installing Analytic Workspace Manager

Although not required before you install Oracle Utilities Data Model, install the Analytic Workspace Manager to view and modify Oracle Utilities Data Model OLAP cubes.

Analytic Workspace Manager is installed as a standalone product. The latest version of Analytic Workspace Manager is available at the Oracle OLAP home page at http://www.oracle.com/technetwork/database/options/olap/index.html. Installation instructions are included in the documentation.

5 Backup, Recovery, and Deinstallation of Oracle Utilities Data Model

Describes backup, recovery and deinstallation tasks.

- Backing Up and Recovering Oracle Utilities Data Model
Describes backing up and recovering Oracle Utilities Data Model.

- Deinstalling Oracle Utilities Data Model
Perform several tasks to deinstall Oracle Utilities Data Model.

Backing Up and Recovering Oracle Utilities Data Model

Describes backing up and recovering Oracle Utilities Data Model.

To backup and recover Oracle Utilities Data Model perform the following steps:

1. Backup or recover the relational objects.

2. Backup or recover the analytic workspace that is part of Oracle Utilities Data Model.

- Exporting Oracle Utilities Data Model
Perform these steps to backup Oracle Utilities Data Model.

- Importing Oracle Utilities Data Model
Perform these steps to restore Oracle Utilities Data Model from the backup files.

Exporting Oracle Utilities Data Model

Perform these steps to backup Oracle Utilities Data Model.

1. Backup the OUDM_SYS schema by executing the expdp utility.
This utility exports all physical tables containing the data and trained mining models.

2. Backup the analytic workspace that is part of the Oracle Utilities Data Model. The analytic workspace is backed up as an EIF file, named OUDM_BAK.EIF, which is generated under the ORACLE_HOME/oudm/pdm/olap directory.

a. Connect to the Database with oudm_sys.

b. Issue the following SQL statements:

exec dbms_aw.execute('AW ATTACH OUDM);
exec dbms_aw.execute('CDA OUDM_OLAP_DIR');
exec dbms_aw.execute('EXPORT ALL TO EIF FILE ','OUDM_BAK.EIF',' NOTEMPDATA');
exec dbms_aw.execute('AW DETACH OUDM');

Related Topics

- Oracle Database Utilities

Importing Oracle Utilities Data Model

Perform these steps to restore Oracle Utilities Data Model from the backup files.

1. Restore the OUDM_SYS schema by executing the impdp utility.

This utility imports all physical tables containing the data and trained mining models.

2. Connect to the Database with oudm_sys, and import the analytic workspace that was saved as an EIF file, named OUDM_BAK.EIF, under the ORACLE_HOME/oudm/pdm/olap directory.

exec dbms_aw.execute('IMPORT ALL TO EIF FILE ', 'OUDM_BAK.EIF');

Related Topics

- Oracle Database Utilities

Deinstalling Oracle Utilities Data Model

Perform several tasks to deinstall Oracle Utilities Data Model.

To deinstall Oracle Utilities Data Model, you do not simply run Oracle Universal Installer in deinstall mode. Instead, you perform the following tasks:

- Pre-Deinstallation Tasks
Describes the pre-deinstallation tasks to perform before you run the deinstallation script.

- Match Oracle System Identifier with Net Service Name

- Deinstallation Execution
Lists the steps for deinstalling Oracle Utilities Data Model.

- Post-Deinstallation Tasks
Provides the steps for post-deinstallation cleanup.

Pre-Deinstallation Tasks

Describes the pre-deinstallation tasks to perform before you run the deinstallation script.

The deinstallation script removes the oudm_sys schema.

Identifying if the oudm_sys Schema is Active

Before you run the deinstallation script, ensure that there are no active sessions that connect to the oudm_sys schema.

To identify if there are active sessions connecting to these schemas perform the following steps:

1. Sign in as DBA.

2. Execute the following SQL statements:

select SID,SERIAL# from v$session where USERNAME='OUDM_SYS';

If this query returns a session ID, then there is an active session.

Example 5-1 Ending an Active oudm_sys Schema Session

To end an active session, execute the following statements in which you replace sid and serial, the session ID and serial number returned by the earlier query:

alter system kill session 'sid,serial' ;

Match Oracle System Identifier with Net Service Name

The following rules for tnsnames.ora are mandatory for Oracle Utilities Data Model deinstallation.

Non Oracle RAC Environment

For a non Oracle RAC environment, the installer sets the SID to the value of the lowercase tnsnames entry chosen by the user during installation (as the Net Service Name). Thus, during deinstallation the tnsnames entry must accurately reflect the Net Service Name supplied as a parameter during installation.

For example, if the SID is orcl11203, you cannot set the tnsnames entry to OUDM_Test. If SID is orcl11203, then tnsnames entry must be set to orcl11203.

Oracle RAC Environment

For an Oracle RAC environment, the Oracle System Identifier (SID) is set to lowercase tnsnames.ora entry chosen by the user during installation (as the Net Service Name). Thus, the tnsnames.ora entry should accurately reflect the SID for the system on which product is deinstalled in an Oracle RAC environment.

Modify the tnsnames.ora entry name to match the SID of the database node for the system. After the deinstallation, revert the tnsnames entry to the previous entry.

For example, if the SID is orcl2, you cannot set the tnsnames entry to localhost_orcl. In this case, if the SID is orcl2, then the tnsnames entry must be set to orcl2.

Deinstallation Execution

Lists the steps for deinstalling Oracle Utilities Data Model.

To deinstall Oracle Utilities Data Model:

1. Set the ORACLE_HOME to the location of the Database on which to deinstall Oracle Utilities Data Model.

For example, suppose that Oracle home is in the directory /loc/app/oracle/product/12.1/

In a Bourne, Bash, or Korn shell, use these commands to set ORACLE_HOME:

$ ORACLE_HOME=/loc/app/oracle/product/12.1/
$ export ORACLE_HOME

In a C shell, use this command to set ORACLE_HOME:

% setenv ORACLE_HOME /loc/app/oracle/product/12.1/

2. Execute the Oracle Utilities Data Model deinstallation script:

$ORACLE_HOME/oudm/oudm_deinstall.sh

3. When prompted, enter the SYSTEM password.

The script de-configures Oracle Utilities Data Model and executes the Oracle Universal Installer in deinstall silent mode.

Post-Deinstallation Tasks

Provides the steps for post-deinstallation cleanup.

If you are deinstalling the Oracle Utilities Data Model sample reports, then follow these steps to perform additional cleanup:

1. Delete oudm.rpd in the directory BIHome/Server/Repository.

2. Delete the oudmwebcat folder in BIDataHome/web/catalog.

3. Delete the following line from BIHome/Server/Config/NQSConfig.INI:

Star    =    oudm.rpd, DEFAULT

6 Installing Oracle Utilities Data Model on Oracle Cloud

Describes how to install Oracle Utilities Data Model on Oracle Cloud.

- Installing Oracle Utilities Data Model on Oracle Cloud
To install Oracle Utilities Data Model on Oracle Cloud, use the Oracle Database Cloud Service and the Oracle Business Intelligence Cloud Service.

- Oracle Database Cloud Service Requirements
Installing Oracle Utilities Data Model on Oracle Cloud requires a correctly configured Oracle Database Cloud Service instance.

- Install Oracle Utilities Data Model on Oracle Cloud
Install Oracle Utilities Data Model on Oracle Database Cloud Service after you complete the configuration. Oracle Utilities Data Model shiphome for the on-premise install is the same as the Cloud version.

- Oracle Business Intelligence Cloud Service Requirements
Installing Oracle Utilities Data Model on Oracle Cloud requires a configured Oracle Business Intelligence Cloud Service instance.

- Uploading Oracle Utilities Data Model RPD to Oracle Business Intelligence Cloud Service
You upload the modified on-premise Oracle Utilities Data Model RPD to Oracle Business Intelligence Cloud Service.

- Uploading Oracle Utilities Data Model Catalog to Oracle Business Intelligence Cloud Service
After you create an Oracle Business Intelligence Cloud Service instance and upload the modified on-premise Oracle Utilities Data Model RPD to Oracle Business Intelligence Cloud Service, then upload the OUDM catalog.

Installing Oracle Utilities Data Model on Oracle Cloud

To install Oracle Utilities Data Model on Oracle Cloud, use the Oracle Database Cloud Service and the Oracle Business Intelligence Cloud Service.

See the following to obtain the required cloud services: http://docs.oracle.com/cloud/latest/trial_paid_subscriptions/index.html.

After the Oracle Cloud subscriptions are processed and the Oracle Cloud account is set up, you deploy Oracle Utilities Data Model on Oracle Cloud.

Oracle Database Cloud Service Requirements

Installing Oracle Utilities Data Model on Oracle Cloud requires a correctly configured Oracle Database Cloud Service instance.

Purchase subscription of Database Cloud Service (DBCS). Oracle Cloud offers following types of subscriptions:

- Metered Subscription

- Non-metered Subscription

- Creating a Secure Shell (SSH) Public/Private Key Pair
Create an SSH key pair with a public key and a private key to access the Oracle Database Cloud Service instance.

- Creating the Oracle Database Cloud Service Instance
If the subscription type allows you to create an Oracle Database Cloud Service instance, then create the Oracle Database Cloud Service instance from the Cloud My Services console.

- Requirements for Service and Database Configuration Parameters
Specifies the service configuration and database configuration requirements for Oracle Utilities Data Model installation.

- Requirements for Backup and Recovery Configuration Parameters
Specifies the backup and recovery configuration requirements for Oracle Utilities Data Model installation.

- Monitoring Oracle Database Cloud Service Status
After the Oracle Database Cloud Service request is accepted, you can monitor the status of the Oracle Database Cloud Service instance.

Related Topics

- Trial Subscriptions

- http://docs.oracle.com/en/cloud/get-started/subscriptions-cloud/csgsg/overview-buying-metered-oracle-cloud-services.html

- http://docs.oracle.com/en/cloud/get-started/subscriptions-cloud/csgsg/buying-nonmetered-subscription-oracle-cloud-service.html

Creating a Secure Shell (SSH) Public/Private Key Pair

Create an SSH key pair with a public key and a private key to access the Oracle Database Cloud Service instance.

The SSH public key is used when you request the Oracle Database Cloud Service instance. After the Oracle Database Cloud Service instance is created you can access the instance by authenticating with the SSH private key.

1. By default, network access to the compute nodes associated with Oracle Database Cloud - Database as a Service is provided by Secure Shell (SSH). The first step to access the network is to create an SSH key pair.

Related Topics

- Using Oracle Database Cloud Service

Creating the Oracle Database Cloud Service Instance

If the subscription type allows you to create an Oracle Database Cloud Service instance, then create the Oracle Database Cloud Service instance from the Cloud My Services console.

If you are using a trial subscription, the Oracle Database Cloud Service instance is provided by Oracle and a service instance is provided in the My Services console.

1. To create a Oracle Database Cloud Service Instance, see: Creating a Database Deployment.

Requirements for Service and Database Configuration Parameters

Specifies the service configuration and database configuration requirements for Oracle Utilities Data Model installation.

Oracle Database Cloud Service Configuration

Check the following table for detailed service configuration parameter information:

Note:

There are several parameters that are mandatory for which you must provide input.

Table 6-1 Oracle Database Cloud Service Service Configuration Requirements

Parameter Name

Parameter Description

Mandatory/Optional

Valid Values/Format

Service Name

Name of Oracle Database Cloud Service instance

Mandatory

Must not exceed 50 characters. Must start with a letter. Must contain only letters, numbers, or hyphens. Must not contain any other special characters. Must be unique within the identity domain.

Description

Free-form text that provides additional information about the service instance

Optional

No Value

Service Level

Service level for the service instance

Mandatory

Oracle Database Cloud Service

Metering Frequency

Metering frequency for chosen Service Level.

Mandatory

Hourly

Monthly

Software Release

Oracle Database software version

Mandatory

Oracle Database 12c Release 1

Software Edition

Database edition for the service instance

Mandatory

Enterprise Edition – High Performance

or

Enterprise Edition – Extreme Performance

Database Type

Database Type

Mandatory

Single Instance

Oracle Database Cloud Service Database Configuration

Note:

There are several parameters that are mandatory for which you must provide input.

Table 6-2 Oracle Database Cloud Service Database Configuration Requirements

Parameter Name

Parameter Description

Mandatory/Optional

Default Value

Valid Values/Format

DB Name (SID)

Database Name (sid) for the Database as a Service instance

Mandatory

ORCL

string

PDB Name

Pluggable Database Name for the Database as a Service instance.

Mandatory

PDB1

string

Administration Password

Password for Oracle Database administrator users sys and system.

Mandatory

No value

Starts with a letter;Between 8 and 30 characters long;Contains letters, at least one number, and optionally, any number of these special characters: dollar sign ($), pound sign (#), and underscore (_);

Usable Database Storage

Storage volume size for data. Default value is 25 GB. Minimum allowed size is 15 GB. Maximum allowed size is 1200 GB if backup destination is specified and 2048 GB if no backup destination is specified.

Mandatory

25

15 to 500

Compute Shape

Desired compute shape. A shape defines the number of Oracle Compute Units (OCPUs) and amount of memory (RAM)

Mandatory

oc3: 1 OCPU, 7.5 GB memory

oc3: 1 OCPU, 7.5 GB memory
oc4: 2 OCPUs, 15 GB memory
oc5: 4 OCPUs, 30 GB memory
oc6: 8 OCPUs, 15 GB memory
oc1m: 1 OCPU, 15 GB memory
oc2m: 2 OCPUs, 30 GB memory
oc3m: 4 OCPUs, 60 GB memory
oc4m: 8 OCPUs, 120 GB memory

SSH Public Key

Public key for the secure shell (SSH). This key will be used for authentication when connecting to the Database as a Service instance using an SSH client. You generate an SSH public-private key pair using a standard SSH key generation tool.

Mandatory

No Value

No Value

Requirements for Backup and Recovery Configuration Parameters

Specifies the backup and recovery configuration requirements for Oracle Utilities Data Model installation.

Oracle Database Cloud Service Backup and Recovery Configuration

Note:

There are several parameters that are mandatory for which you must provide input.

Table 6-3 Oracle Database Cloud Service Database Backup and Recovery Requirements

Parameter Name

Parameter Description

Mandatory/Optional

Default Value

Valid Values/Format

Backup Destination

Backup destination

Mandatory

Both Cloud Storage and Local Storage

- Both Cloud Storage and Local Storage

- Cloud Storage Only

- None

Cloud Storage Container

Name of the Oracle Storage Cloud Service container used to provide storage for your service instance backups. Use the following format to specify the container name: <storageservicename>-<storageidentitydomain>/<containername>

Provide when Backup Destination is not set to None

No Value

No Value

Cloud Storage Username

Username for the Oracle Storage Cloud Service administrator.

Provide when Backup Destination is not set to None

No Value

No Value

Cloud Storage Password

Password for the Oracle Storage Cloud Service administrator

Provide when Backup Destination is not set to None

No Value

No Value

Create Cloud Storage Container

This item is a check box. Check this option if you want to create a new container with the information specified above.

Provide when Backup Destination is not set to None

No Value

No Value

Monitoring Oracle Database Cloud Service Status

After the Oracle Database Cloud Service request is accepted, you can monitor the status of the Oracle Database Cloud Service instance.

To monitor the status of the Oracle Database Cloud Service instance view the console (https://dbaas.oraclecloud.com/dbaas).

1. The following figure shows the Oracle Database Cloud Service instance creation with status “In Progress”:

It takes about 20 minutes to create the Oracle Database Cloud Service instance.

2. Click the service name to show the details of the service such as Public IP, SQL *NetPort, SID, PDB Name, Connect String. The following figure shows details for OUDM-Product Oracle Database Cloud Service instance:

Related Topics

- Accessing Oracle DBaaS Monitor

Install Oracle Utilities Data Model on Oracle Cloud

Install Oracle Utilities Data Model on Oracle Database Cloud Service after you complete the configuration. Oracle Utilities Data Model shiphome for the on-premise install is the same as the Cloud version.

- Connect to Oracle Database Cloud Service VM
Connect to the Oracle Database Cloud Service VM.

- Adding the SYSTEM Username and Password to the Wallet
Connect to the Oracle Database Cloud Service and set the SYSTEM password in the wallet for the Oracle Utilities Data Model installation.

- Install Oracle Utilities Data Model Shiphome
Provides the steps required to run the install script to install the Oracle Utilities Data Model shiphome.

- Monitor Oracle Utilities Data Model Installation Status
The Utilities Data Model installation takes about fifteen minutes; the Sample Reports installation takes about 30 minutes. Check the progress of the installation in the log files.

- Unlock Oracle Utilities Data Model Database Accounts
The Utilities Data Model installation option creates the Oracle Database accounts: oudm_sys, oudm_user, and oudm_report. The Sample_Reports installation option creates the Oracle Database account: oudm_sample. The accounts are locked. Depending on the installation type, unlock the accounts and set the passwords.

Connect to Oracle Database Cloud Service VM

Connect to the Oracle Database Cloud Service VM.

1. From a Linux machine, connect to the existing Oracle Database Cloud Service instance with SSH as oracle user:

SSH: ssh oracle@DBCS_VM_Public_IP_Address -i ssh_private_key

Related Topics

- Connecting to a Compute Node Through Secure Shell (SSH)

- Using a TNS Alias instead of a DB Connect String

Adding the SYSTEM Username and Password to the Wallet

Connect to the Oracle Database Cloud Service and set the SYSTEM password in the wallet for the Oracle Utilities Data Model installation.

1. Oracle Database Cloud Service instance comes with default wallet, db_wallet. Add SYSTEM username and password to db_wallet:

mkstore –wrl /u01/app/oracle/admin/Container_DB_Name/db_wallet -createCredential TNS_Alias_of_PDB SYSTEM SYSTEM_password

Where: Container_DB_Name: is the SID of the Database.

Note:

Enter the Container_DB_Name, SID name, in the same case you used when you made the request for the Oracle Database Cloud Service instance.

Related Topics

- Connecting to a Compute Node Through Secure Shell (SSH)

- Using a TNS Alias instead of a DB Connect String

Install Oracle Utilities Data Model Shiphome

Provides the steps required to run the install script to install the Oracle Utilities Data Model shiphome.

1. Download the shiphome from eDelivery (https://edelivery.oracle.com). Rename the downloaded file to oudm.zip.

2. Create oidm directory in oracle user home directory:

[oracle@DBCS_Service_Name ~]$ cd /home/oracle
[oracle@DBCS_Service_Name ~]$ mkdir oidm

3. Change directory to oidm:

[oracle@DBCS_Service_Name ~]$ cd oidm

4. Download the oidm_install.sh script from the cloud storage container:

[oracle@DBCS_Service_Name oidm]$ wget https://storage.us2.oraclecloud.com/v1/dbcsswlibd-usoracle13098/OIDM/oidm_install.sh

5. Modify the permissions for the oidm_install.sh script:

[oracle@DBCS_Service_Name oidm]$ chmod 755 oidm_install.sh

6. Copy the downloaded Oracle Utilities Data Model shiphome from your Linux machine to /home/oracle/oidm directory on the Oracle Database Cloud Service instance. Ensure you are in the shell of your Linux machine, not the Oracle Database Cloud Service VM shell:

[user@your_linux_host_name current_directory_name]$ scp -i ssh_private_key OUDM_shiphome_path oracle@DBCS_VM_Public_IP_Address:/home/oracle/oidm

Where: OUDM_shiphome_path: is the file oudm.zip. When this .zip file is unzipped it creates the oudm directory.

7. Connect to Oracle Database Cloud Service VM and run the oidm_install.sh script and include the required parameters. The following table shows Oracle Utilities Data Model configuration parameters:

Table 6-4 Oracle Utilities Data Model Installation Configuration Parameters

Parameter Name

Parameter Description

Mandatory/Optional

Default Value

Valid Values or Format

db_oidm_prod_name

OIDM Product name

Mandatory

NONE

OUDM

db_oidm_install_type

Install Type

Optional

Utilities_Data_Model

Utilities_Data_Model, Sample_Reports

db_oidm_base_tbs

Tablespace for BASE tables

Optional

USERS

Existing tablespace name

db_oidm_ref_tbs

Tablespace for REFERENCE tables

Optional

USERS

Existing tablespace name

db_oidm_lookup_tbs

Tablespace for LOOKUP tables

Optional

USERS

Existing tablespace name

db_oidm_derived_tbs

Tablespace for DERIVED tables

Optional

USERS

Existing tablespace name

db_oidm_aggr_tbs

Tablespace for AGGREGATE tables

Optional

USERS

Existing Existing tablespace name tablespace name

db_oidm_base_idx_tbs

Tablespace for BASE indexes

Optional

USERS

Existing tablespace name

db_oidm_ref_idx_tbs

Tablespace for REFERENCE indexes

Optional

USERS

Existing tablespace name

db_oidm_lookup_idx_tbs

Tablespace for LOOKUP indexes

Optional

USERS

Existing tablespace name

db_oidm_derived_idx_tbs

Tablespace for DERIVED indexes

Optional

USERS

Existing tablespace name

db_oidm_aggr_idx_tbs

Tablespace for AGGREGATE indexes

Optional

USERS

Existing tablespace name

db_oidm_mv_tbs

Tablespace for Materialized Views

Optional

USERS

Existing tablespace name

db_oidm_olap_tbs

Tablespace for OLAP objects

Optional

USERS

Existing tablespace name

db_oidm_default_tbs

Default tablespace for OUDM_SYS schema

Optional

USERS

Existing tablespace name

db_oidm_default_temp_tbs

Default temporary tablespace for OUDM_SYS schema

Optional

TEMP

Existing tablespace name

db_oidm_sample_tbs

Tablespace for OUDM_SAMPLE schema

Note:

Provide when db_oidm_install_type is set to “Sample_Reports”

Optional

USERS

Existing tablespace name

db_oidm_sample_temp_tbs

Temporary tablespace for OUDM_SAMPLE schema.

Note:

Provide when db_oidm_install_type is set to “Sample_Reports”

Optional

TEMP

Existing tablespace name

db_oidm_cl_strt_dt

Calendar Start Date

Optional

"2016-01-01"

YYYY-MM-DD

db_oidm_cl_nbr_yrs

Calendar Number of Years

Optional

5

Number

db_oidm_intvl_prtn_start_dt

Interval Partition Start Date

Optional

"2016-01-01"

YYYY-MM-DD

db_oidm_nbr_of_hash_prtn_org

Number of Hash Partitions for Organization

Optional

4

Number

db_oidm_nbr_of_hash_prtn_cust

Number of Hash Partitions for Customer

Optional

4

Number

db_oidm_nbr_of_hash_prtn_prty

Number of Hash Partitions for Party

Optional

4

Number

db_oidm_nbr_of_hash_prtn_acct

Number of Hash Partitions for Account

Optional

4

Number

db_oidm_nbr_of_hash_prtn_agrmnt

Number of Hash Partitions for Agreement

Optional

4

Number

db_oidm_nbr_of_hash_prtn_mtr_rdng

Number of Hash Partitions for MeterReading

Optional

4

Number

db_oidm_nbr_of_hash_prtn_init_rdng

Number of Hash Partitions for InitialReading

Optional

4

Number

db_oidm_nbr_of_hash_prtn_fnl_rdng

Number of Hash Partitions for FinalReading

Optional

4

Number

db_oidm_nbr_of_hash_prtn_srvc_qnty

Number of Hash Partitions for ServiceQuantity

Optional

4

Number

8. You can also pass Oracle Database parameters to the script. If you have multiple pluggable databases (PDBs) in your container database, then you must pass the PDB name. The following table shows the Oracle Database parameters that you can pass to oidm_install.sh script:

Table 6-5 Oracle Utilities Data Model Database Installation Parameters

Parameter Name

Parameter Description

ohome

Oracle Database Home

obase

Oracle Base

datafile_loc

Data file Location

sid

Container Database Identifier

pdb_name

Pluggable Database Name

system_passwd

SYSTEM user password.

Note:

It is not recommended to pass the SYSTEM password from command line for security reasons. It is recommended to store the SYSTEM password in the DB wallet. The script retrieves the password from the default wallet.

Note:

Enter the pdb_name in the same case as you provided while requesting the Oracle Database Cloud Service instance.

For example:

[oracle@DBCS_Service_Name oidm]$ ./oidm_install.sh db_oidm_prod_name=OUDM pdb_name=PDB1 db_oidm_install_type=Utilities_Data_Model

Related Topics

- Connect to Oracle Database Cloud Service VM

Monitor Oracle Utilities Data Model Installation Status

The Utilities Data Model installation takes about fifteen minutes; the Sample Reports installation takes about 30 minutes. Check the progress of the installation in the log files.

1. Connect to Oracle Database Cloud Service instance using SSH:

ssh oracle@DBCS_VM_Public_IP_Address -i ssh_private_key

2. Check the log files to monitor OUDM installation status:

/home/oracle/tmp/name.out [Only for Fresh DBCS Instance]
/home/oracle/oidm/oudm_install.sav
/u01/app/oracle/cfgtoollogs/oudm/oudm_timestamp.log

After the installation completes, check the messages in oudm_install.sav:

OUDM "OUDM_install_type" option Setup Completed Successfully.

OR

OUDM "OUDM_install_type" option Setup Completed With Errors.
Check OUDM install config log at /u01/app/oracle/cfgtoollogs/oudm directory.

If you see the first message, then the Oracle Utilities Data Model installation completed successfully, otherwise the installation completed with errors.

Note:

When installation completes with errors, report the errors to Oracle Support.

Unlock Oracle Utilities Data Model Database Accounts

The Utilities Data Model installation option creates the Oracle Database accounts: oudm_sys, oudm_user, and oudm_report. The Sample_Reports installation option creates the Oracle Database account: oudm_sample. The accounts are locked. Depending on the installation type, unlock the accounts and set the passwords.

1. Log in as SYSTEM account:

sqlplus system@pdb_name

2. For the Utilities Data Model installation option enter the SYSTEM password when prompted and unlock the accounts and modify the passwords:

alter user oudm_sys account unlock identified by new_password;
alter user oudm_user account unlock identified by new_password;
alter user oudm_report account unlock identified by new_password;

3. For the Sample_Reports installation option enter the SYSTEM password when prompted and unlock the account and modify the password:

alter user oudm_sample account unlock identified by new_password;

4. Log in to sqlplus as oudm account, the login prompts to modify the password. The password of all accounts is the account name in lower case, for example, oudm_sys is the password for oudm_sys account.

Oracle Business Intelligence Cloud Service Requirements

Installing Oracle Utilities Data Model on Oracle Cloud requires a configured Oracle Business Intelligence Cloud Service instance.

The Oracle Utilities Data Model product includes the OUDM reports RPD and catalog. To use the out of the box sample reports, upload the RPD and catalog to Oracle Business Intelligence Cloud Service instance. If you already have the Oracle Business Intelligence Cloud Service instance, skip the first step.

- Creating the Oracle Business Intelligence Cloud Service Instance
If the subscription type allows you to create an Oracle Business Intelligence Cloud Service instance, you create the Oracle Business Intelligence Cloud Service instance from the Cloud My Services console. If you are using a trial subscription, the instance is provided by Oracle and a service instance is provided in the My Services console.

- Downloading Oracle Utilities Data Model RPD and Catalog
Oracle Utilities Data Model installation copies product files to $ORACLE_HOME/oudm directory on the Oracle Database Cloud Service instance.

- Modifying Oracle Utilities Data Model RPD
Describes required modifications for the RPD file for Data Source Name, User Name, and Password for accessing the Oracle Utilities Data Model reports.

Creating the Oracle Business Intelligence Cloud Service Instance

If the subscription type allows you to create an Oracle Business Intelligence Cloud Service instance, you create the Oracle Business Intelligence Cloud Service instance from the Cloud My Services console. If you are using a trial subscription, the instance is provided by Oracle and a service instance is provided in the My Services console.

1. To create a Oracle Business Intelligence Cloud Service Instance, see: Creating a Service Instance.

Downloading Oracle Utilities Data Model RPD and Catalog

Oracle Utilities Data Model installation copies product files to $ORACLE_HOME/oudm directory on the Oracle Database Cloud Service instance.

1. Listing the OUDM installation directory shows the contents, including the report directory that contains the Catalog and RPD files.

2. Download oudm.rpd and oudm.catalog from Oracle Database Cloud Service instance to your local windows machine. You can find those files in the $ORACLE_HOME/oudm/report directory on the Oracle Database Cloud Service instance:

Modifying Oracle Utilities Data Model RPD

Describes required modifications for the RPD file for Data Source Name, User Name, and Password for accessing the Oracle Utilities Data Model reports.

After you download the RPD oudm.rpd to the windows machine, ensure that the Oracle Business Intelligence Developer Client tool is installed on the windows machine. If you do not have the Client tool, download it from OTN and install:

- Accept the OTN License Agreement on the following page: http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/index.html

- Download the appropriate Oracle Business Intelligence Developer Client Tool from OTN and install:
http://download.oracle.com/otn/nt/bi/111190/biee_client_install_x64.zip

or

http://download.oracle.com/otn/nt/bi/1221/Setup_BI_Client_12.2.1.0.0_Windows.X64.zip

1. Open Oracle Business Intelligence Developer Client Tool and open the RPD in offline mode. The RPD is password protected; contact Oracle Support for the RPD password. After you enter the RPD password, modify the following properties of Connection Pool object of all databases in RPD physical layer:

a. Modify Data Source Name, TNS string of Oracle Database Cloud Service instance PDB, where OUDM is installed.
For example:

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <DBCS VM Public IP>)(PORT = <DB Port>)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = <PDB name in Upper Case>.<Cloud Identity Name>.oraclecloud.internal) ) )

b. Modify User Name, the OUDM database user name.
For example:. oudm_sys or oudm_report for “Utilities Data Model” install type and oudm_sample for “Sample Reports”. The oudm_report user is a less privileged user created to access data in oudm_sys schema.

c. Modify Password, the OUDM database user password.

2. After modifying the connection pool properties for the servers in the RPD physical layer, save the RPD. When you click OK, Oracle BI Administration Tool prompts to check Global Consistency:

3. Click Yes and check for errors.

Uploading Oracle Utilities Data Model RPD to Oracle Business Intelligence Cloud Service

You upload the modified on-premise Oracle Utilities Data Model RPD to Oracle Business Intelligence Cloud Service.

You should already have an Oracle Business Intelligence Cloud Service instance. To determine the Oracle Business Intelligence Cloud Service instance URL, go to My Services (http://myservices.us.oraclecloud.com) console, click the Oracle Business Intelligence Cloud Service instance, and then find the Service Instance URL

1. Open the Oracle Business Intelligence Cloud Service instance URL in your browser:

2. From the home page, navigate to Console -> Snapshots and Models Click Console -> Snapshots and Models to show the Snaphot System State:

3. Click Replace Data Model to upload the modified on-premise repository, oudm.rpd.

4. Browse to select oudm.rpd. Enter the RPD password, and click OK.

The Oracle Business Intelligence Cloud Service console shows a message if the RPD uploads successfully. Otherwise the display shows an error message.

Uploading Oracle Utilities Data Model Catalog to Oracle Business Intelligence Cloud Service

After you create an Oracle Business Intelligence Cloud Service instance and upload the modified on-premise Oracle Utilities Data Model RPD to Oracle Business Intelligence Cloud Service, then upload the OUDM catalog.

You should already have an Oracle Business Intelligence Cloud Service instance. To determine the Oracle Business Intelligence Cloud Service instance URL, go to My Services (http://myservices.us.oraclecloud.com) page, click the Oracle Business Intelligence Cloud Service instance, then find the Service Instance URL.

1. Open the Oracle Business Intelligence Cloud Service instance URL in your browser. From the home page, navigate to Catalog.

2. Click the Company Shared folder in the Folders pane.

3. By default, the Company Shared folder contains the Sample App folder of the Sample App catalog. Create a new folder OUDM in the Company Shared folder.

4. Upload the Oracle Utilities Data Model catalog file (oudm.catalog). Click the OUDM folder in Folders pane, and then click Unarchive in the Tasks pane.

5. In the Unarchive dialog click Browse to select oudm.catalog. In the Replace field select None and click OK.

The Shared Folders are created in the OUDM folder.

6. Navigate to dahsboards/reports: Shared Folders folder to open Welcome to OUDM dashboard.

A License Information

Product

Subproduct

Licensing Description

Oracle Utilities Data Model

None

Oracle Utilities Data Model is a standards-based, prebuilt approach to utilities data warehousing enabling a utilities company to realize the power of insight more quickly.

Oracle Utilities Data Model includes the following:

- Physical implementation of the data model consisting of a foundation layer in third-normal-form schema, as well as dimensional models leveraging star schemas and OLAP cubes.

- Automatic data movement (intra-ETL) to populate the dimensional models based on data from the foundation layer.

- Predefined data mining model for predictive analysis.

- Prebuilt sample reports and dashboards.

Prerequisites: Oracle Utilities Data Model requires the use of other Oracle software, which must be licensed separately. Contact your Oracle sales representative for additional information.

Index

A  B  D  E  I  O  P  R  S  U

A

- Analytic Workspace Manager, installing 1

B

- baking up Oracle Utilities Data Model 1

D

- Database Vault option

- installing Oracle Utilities Data Model with 1

- DDL triggers, before and after

- re-enabling 1

- deinstalling Oracle Utilities Data Model 1

E

- exporting Oracle Utilities Data Model 1

I

- importing Oracle Utilities Data Model 1

- initialization parameters, Oracle Utilities Data Model 1

- installing

- Analytic Workspace Manager 1

- Oracle Utilities Data Model 1 , 2 , 3 , 4 , 5

- other components used by Oracle Utilities Data Model 1

- sample reports for 1

O

- OLAP environment

- for Oracle Utilities Data Model 1

- Oracle Business Intelligence Suite Extended Edition

- catalog for Oracle Utilities Data Model 1

- confirming installation of 1

- downloading 1

- Oracle Data Mining option, confirming installation of 1

- Oracle OLAP option, confirming installation of 1

- Oracle Utilities Data Model

- backup 1

- deinstalling 1

- export 1

- home directory structure 1

- import 1

- installation process 1

- installer execution 1

- postinstallation tasks 1

- preinstallation tasks 1

- recovery 1

- sample reports 1 , 2 , 3

- silent installation 1

- types of installations 1

- Oracle Utilities Data Model installation

- hardware requirements 1

- Oracle Database requirements 1

- software requirements 1

- supported platforms 1

- OUDM_REPORT account, unlocking 1

- OUDM_SAMPLE account, unlocking 1

- OUDM_SYS account, unlocking 1

- OUDM_USER account, unlocking 1

P

- platforms for Oracle Utilities Data Model 1

- postinstallation tasks, Oracle Utilities Data Model 1

- pre-installation tasks, Oracle Utilities Data Model 1

R

- requirements for installation

- hardware 1

- software 1

S

- sample reports, Oracle Utilities Data Model 1 , 2 , 3

- sample reports for Oracle Utilities Data Model, installing 1

U

- unlocking

- OUDM_SAMPLE account 1

- OUDM_SYS account 1

- OUDM_USER account 1

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2017, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Pre-General Availability Draft Documentation Notice

If this document is in public or private pre-General Availability status:

This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Pre-General Availability Draft Documentation Notice

If this document is in private pre-General Availability status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your pre-General Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.