Classes
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
Duration: 40 Classroom Hours, weekends and weekday evenings.
ORACLE Access: 2 Months ORACLE access for practice and home study from the date of enrollment.
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 theIntegration 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.
- Perform key System Administrator tasks
- Control access to applications and set profile options
- Monitor user activity
Course Objectives
- 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
510-440-1200 or via email
info@mtiedge.com
info@mtiedge.com