Oracle BI 11g - System Administration
Course: OBIAD
Duration: 4 Days
Level: I
On our website at:
http://www.verhoef-training.com/courses/OBIAD.html
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.
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%)
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 & Backup and Recovery Workshop |
4 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.
