Oracle Apps DBA Course Content

Document Sample
Oracle Apps DBA Course Content Powered By Docstoc
					Oracle Applications(Ebusiness Suite) DBA

What you will learn at S.L. Data Solutions?

This course provides students with a basic understanding of the architecture,
database and file system used in Oracle Applications Release 11i & R12. Students
learn about the multi-tier architecture used to provide user access over the Internet
or an intranet and the relationship between Oracle Applications and the Oracle
database. The course covers the structure of the file system used to store the Oracle
Applications product files, environment files, and additional files required to support
multiple languages in Release 11i & R12. Students also learn how to use Rapid
Install to perform both single and multi-node installations of Oracle Applications, AD
Administration and other AD utilities to maintain Oracle Applications, AutoPatch to
automate the application of Oracle Applications patches, upgradation to other
versions, complete knowledge of all adutilities to administer applications, Making
configuration changes using autoconfig, Rapid Clone to clone an Oracle Applications
system and knowledge on system administration. It will cover complete 11i and R12.


Knowledge of Oracle SQL and PL/SQL
Database administration skills

Course Objectives

Introduction to ERP World
Oracle Applications Overview
Use Rapid Install to install an Oracle Applications system
Describe the Oracle Applications Architecture
Oracle Applications File System
Oracle Applications AD Utilities and Spl Utilities
apply patches to an Oracle Applications system
Clone an Oracle Applications system
Upgrade Oracle applications
System administration
New features of R12
Course Topics

Meaning and ususage of ERP
Advantages of Oracle apps as ERP

Oracle Applications Overview
Oracle E-Business Suite Home Page
HTML Interface
Forms Interface
Oracle Applications Architecture
Oracle Applications Technology Stack
Product Families
Product Dependencies
Vision Demo Database

Preparing for an Installation
Overview of Rapid Install
System Requirements
Creating Operating System Accounts
Setting Up Stage Area
Specifying an Installation Environment
Selecting Configuration Parameters
Rapid Install Log Files

Performing an Installation
Overview of Basic Installation Procedure
Simplest Installation
More Typical Installation
Standard Installation Steps
Single-node Installation
Multi-node Installation

Oracle Applications File System
Database Tier File System
Application Tier File System
Product Directories
APPL_TOP Directories
Common Components Directory
Java Files and Directories
Applications Technology Stack Directory
Database Directories

Advanced Configuration Options
Shared Application Tier File System
Load Balancing
Network Features

Oracle Applications AD Utilities
Overview of the AD Utilities
Running the AD Utilities
Command Line Arguments
Parallel Processing
Distributed AD
Log Files
Maintenance Mode
Restricted Mode

Special Utilities
AD Controller
Reviewing Worker Status and Resolving a Failed Worker
Restarting a Failed Patch Process
Restarting a Terminated Worker
Running AD Relink

Context Files
AutoConfig Tasks
AutoConfig Operation
Running AutoConfig
AutoConfig Log Files
Rolling Back an AutoConfig Session
Running AutoConfig In Test Mode
Editing Parameters

License Manager
Accessing License Manager
Registering Products
Registering the E-Business Suite
Registering Component Applications
Registering Individual Products
Registering Country-Specific Functionalities
Registering Languages
License Manager Reports

Reporting Utilities
Introduction to Reporting Utilities
AD Configuration
AD File Identification
AD Job Timing Report

Configuration Utilities
Introduction to Configuration Utilities
AD Splicer
File Character Set Converter

Patching and the AutoPatch Process
Patch Types and Terminology
Patch Components
Downloading Patches from OracleMetaLink
AutoPatch Operation
AutoPatch Features
Applying a Patch
Reducing Patching Downtime
Patch Wizard
Other Patching Topics
AutoPatch Modes
AutoPatch Command Line Arguments and Options
Java Release Infrastructure and Java File Patching
Deploying Patches
Merging Patches with AD Merge Patch

Cloning Oracle Applications
Principles and Terminology
Prerequisite Steps
Cloning Phases
Prepare the Source System
Copy Source System Files to Target System
Configure the Target System
Finishing Tasks
Advanced Cloning Options

Upgrading Oracle Applications
Preparing the system for upgrade
Using adutilities to upgrade to higher versions
Post upgrade Tasks

System administration
Complete knowledge on Profiles
Benefits of Oracle Applications Manager
OAM Dashboard
Managing Concurrent Requests and Programs
Administering Concurrent Managers
Application Responsibilities and Menus

Enhancements in R12
New features in R12
Introduction to new tops(INST_TOP)
File system comparisons with 11i
Complete knowledge on R12