Oracle BI 11g - System Administration

Course:   OBIAD
Duration:   4 Days
Level:   I
On our website at:
Course Summary

This course teaches the student how to use a variety of tools to manage Oracle Business Intelligence.

Tools include:

The course will also include an overview of Oracle BI system administration tasks, the Oracle BI system logical architecture, and the tools used to complete system administration tasks. The student will also learn how to centrally manage Oracle BI system tasks and components using Fusion Middleware Control and the Oracle WebLogic Server Administration Console. How to stop and start Oracle BI components, scale an Oracle BI deployment, deploy Oracle BI for high availability, manage performance tuning and query caching, diagnose and resolve system issues, enable usage tracking, and set up and manage Oracle BI security will also be covered. Students will use Oracle BI system administration tools to monitor, manage, and configure Oracle BI system components.

Topics Covered In This Course

Oracle BI System Administration Overview

  • Identifying Oracle BI System Administration Tasks
  • Describing the Oracle BI System Logical Architecture
  • Identifying Oracle BI Java Components
  • Identifying Oracle BI System Components.
  • Identifying Oracle BI System Administration Tools

Managing Oracle Business Intelligence

  • Using Fusion Middleware (FMW) Control to Centrally Manage Oracle BI System Components
  • Using Oracle WebLogic Server Administration Console to Centrally Manage Oracle BI Java Components

Configuring the Oracle BI System

  • Using Fusion Middleware Control to Configure Oracle BI
  • Using the Oracle BI Systems Management API to Update Oracle BI Configuration Settings
  • Using a Text Editor to Configure Oracle BI
  • Using the Fusion Middleware Control MBean Browser to Update Configuration Settings
  • Locating Oracle BI Configuration Files

Starting and Stopping Oracle BI

  • Starting Oracle Business Intelligence
  • Using Fusion Middleware Control to Manage Oracle BI System Components
  • Using Oracle WebLogic Server Administration Console to Control Managed Servers
  • Using OPMN to Manage Oracle BI System Components

Scaling an Oracle BI Deployment

  • Performing an Enterprise Install for New Installations
  • Performing an Enterprise Install to Scale Out Existing Installations
  • Setting Up Shared Files and Directories
  • Setting Up Global Cache
  • Using Fusion Middleware Control to Scale System Components
  • Validating That a System Has Been Scaled Correctly

Managing Performance Tuning and Query Caching using FMW Control

  • View Performance Metrics
  • Disallow Repository Updates
  • Set User Session Log-Off Period
  • Set Performance Configuration Options
  • Configure Caching
  • Using Cache Manager
  • Seeding the Cache

Diagnosing and Resolving Issues in Oracle BI

  • Locating Diagnostic Log and Configuration Files
  • Enabling Query Logging for a User
  • Managing the Query Log

Managing Usage Tracking

  • Setting Up a Usage Tracking Business Model
  • Enabling and Testing Usage Tracking

Oracle BI Security

  • Exploring Default Security Settings
  • Creating Users and Groups
  • Creating Application Roles
  • Setting Up Repository Object Permissions
  • Setting Up Row-Level Security (Data Filters)
  • Setting Up Row-Level Security in the Database
  • Setting Query Limits
  • Setting Up Presentation Object Permissions and System Privileges
What You Can Expect

At the end of the course, students will be able to:

Who Should Take This Course

This course is designed for Administrators, Architects, Business Analysts, Business Intelligence Developers, Security Administrators, System Administrators, Technical Administrators, and

Support Engineers.

Training Style

Lecture (50%) / Workshop (50%)

Related Courses
Code Course Title Duration Level
Oracle Database 11g Administration I
5 Days
Oracle Data Integrator 11g
4 Days
Oracle Database 11g Administration II & Backup and Recovery Workshop
4 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.