Oracle 11i Apps DBA

ORACLE APPS-DBA

ERP Concepts (Enterprise Resource Planning) Overview

What is ERP, Brief history of ERP, why is it necessary, Market Leaders and the future of ERP

Oracle Applications Architecture, Release 11i

Oracle Applications Overview
Internet Computing Architecture
Oracle Applications Technology Layer
Oracle Applications Database Structure
Oracle Applications File System
Oracle Applications Environment Files

Description: This course provides students with a basic understanding of the database and file system architecture used within Oracle Applications Release 11i. 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 9i database. During the course, students explore the structure of the file system used to store the Applications product files, configuration files in Release 11i.

Course Objectives
Explain the Internet Computing Architecture used by Oracle Applications 11i
Describe the technology stack and its dependencies, including the
Integration provided by the Applications technology layer
Describe how Oracle Applications 11i uses an Oracle 9i database to store objects and
data.
Describe the file system used to store Oracle Applications 11i product files
Explain the purpose of configuration files used by Oracle Applications 11i

11i Install, Patch and Maintain Oracle Applications
Overview of Installation Process
Using the Single-node Install
Using the Multi-node Install
Post-install Procedures
Using AD Administration
Using other AD Utilities
Cloning Oracle Applications
Patching
Creating a Patch
The Auto Patch Process
Applying a Patch in a Multi-Server Environment
Auto Patch Setup Tasks
Running Auto Patch

Description:
The course covers the structure of the file system used to store the Applications product files, environment files, when and how to use AD Administration and the other AD utilities; and an introduction to patch terminology and the patch creation process. Students will also learn how to use the Rapid Install utility to perform both single and multi-node installs, the AD Administration and other AD utilities to maintain Oracle Applications, and the Auto Patch utility to automate the application of Oracle Applications patches, mini-packs, and maintenance packs.

Course Objectives:
Outline the installation procedure using Rapid Install
Use the Rapid Install tool to create a new Oracle Applications environment with a single node installation
Identify the values Rapid Install uses when installing and configuring the Oracle Application and Forms servers
Identify the default values Rapid Install uses when creating the Oracle Applications database and file system
Determine situations where the single or multi-node install is appropriate
Describe the process to clone Oracle Applications
Explain the components of a patch and how to apply them using Auto Patch
Apply the fundamentals in a hand on practice using AD utilities in various modes of operation
Explain the fundamentals of AD administration and other AD utilities

11i System Administration:
Managing Application Security
Managing Concurrent Programs and Reports
Administering Concurrent Managers
Managing Profile Options
Incorporating a Custom Program
Auditing System Resources
Managing Printers
Applications DBA Duties
Managing Document Sequences
Overview of Flex fields
Using Value Sets
Defining Key Flex fields
Using Additional Flex field Options
Defining Descriptive Flex fields
Overview of Workflow and Discoverer
Overview of Oracle Alert
Starting up/Shutting down apps/db services on Unix and Windows

11i System Administrator Fundamentals
DESCRIPTION
In this course you will learn concepts and functions that are critical to the System Administrator role. You will also learn information to help you manage the 11i E-Business Suite, such as workflows and alerts that are specifically tailored to the System Administrator's needs. The System Administrator Fundamentals course is a part of the Learning Path for Implementation Consultants and will provide you with the foundation you need to effectively control security and ensure smooth operations for an E-Business Suite installation.
Learn to
Perform key System Administrator tasks
Control access to applications and set profile options
Monitor user activity
Course Objectives:
After completing this course, you should be able to:
Manage application security
Manage system resources, printers, and folders
Define flex fields, workflows, and alerts

11i Extend Oracle Applications: Forms

DESCRIPTION
Oracle Application Object Library provides a framework for extending Oracle Applications using Oracle Forms Developer. This framework helps developers build custom forms using Oracle Application Object Library 11i and Oracle Forms Developer 6i. In this class, students learn the graphical user interface (GUI) and coding standards required to develop integrated functional extensions to Oracle Applications using Oracle Forms Developer 6i and the pre-built program components provided with the Oracle Applications. Students learn the same form programming techniques used by Oracle's application development teams to create integrated, user-friendly applications. This class includes extensive hands-on practice building a form to reinforce concepts taught.

Managing and Tuning Application Performance

Planning Applications and Database backup Strategy

Troubleshooting Oracle Applications and DB issues