Oracle BI 11g - System Administration

Course:  OBIAD
Duration:  4 Days
Level:  I
Course Summary

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

Tools include:

  • Fusion Middleware (FMW) Control to monitor, manage, and configure Oracle BI system components
  • Oracle WebLogic Server (WLS) Administration Console to monitor and manage Oracle BI JEE Java components
  • Oracle Process Manager and Notification Server (OPMN) Tool to manage Oracle BI system components
  • Oracle BI Administration Tool to perform administrative tasks.

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.

« Hide The Details
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:

  • Enable usage tracking to track queries and database usage, and improve query performance
  • Identify Oracle BI system administration tasks
  • Describe the Oracle BI system logical architecture
  • Identify and describe Oracle BI Java components and Oracle BI system component
  • Identify and describe the system administration tools that are available for managing Oracle BI
  • Centrally manage Oracle BI components using Fusion Middleware Control
  • Centrally manage Oracle BI Java components using the Oracle WebLogic Server Administration Console
  • Stop and start Oracle BI components
  • Set up security to authenticate users and assign appropriate permissions and privileges
  • Set up query logging for testing and debugging
  • Diagnose and resolve issues in Oracle BI using diagnostic log files
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%)

« Hide The Details
Related Courses
Code Course Title Duration Level
OR11A1
Oracle Database 11g Administration I
5 Days
I
Details
ODI11G
Oracle Data Integrator 11g
4 Days
I
Details
OR11A2
Oracle Database 11g Administration II
5 Days
II
Details

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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com