Contents

Title and Copyright Information

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