Oracle Apps DBA (Oracle E-Business Suite R12)


Overview :

The training for Oracle Apps DBA is designed to develop the real time production skill required to manage an integrated Oracle Apps Environment . We will explain how a Real time Environment is different from a Vanilla Environment, What actual challenges are faced by Apps DBAs. The training provides every individual an opportunity to set up an Oracle E-Business Suite setup with a Production like specification .

Objectives :

Understand the architecture of Oracle E-Business Suite and identify the various components at each tier

Learn How to install E-Business suite R12 on Linux 64 bit platform in single and multinode environment

Administer the users, responsibilities , workflow , notification, alerts , security in E-Business Suite

Understanding AD utilities for Administration , Patching and Cloning of E-Business Suite

Perform Manual as well as Auto method of Cloning from Production to Development environments

Learn how to incorporate custom changes in E-Business Suite

Learn how to manage and maintain Apps in Production and Development environments

Understand Good and Bad Practices in implementing and maintaining Oracle E-Business Suite.

The Lab exercise are designed to make sure every concept is understood by implementing it personally in the LAB


Duration :-
8 Days (60 Hours)

Details of the Topics Covered :-

1-> R12i Oracle Applications Install
1.1 Oracle Applications Overview
1.2 Preparing for Your Installation
1.3 Single-node Installation
1.4 Multi-node Installation
1.5 Finishing Your Installation

2-> R12i Oracle E-Business Suite Architecture
2.1 Oracle Applications Technology
2.2 Oracle Applications Environment Files, Server Process Scripts, and Languages
2.3 Oracle Applications File System
2.4 Oracle Applications Database

3-> R12i Use Oracle Applications AD Utilities
3.1 What are the AD Utilities?
3.2 AD Administration
3.3 Special Utilities
3.4 Context Editor
3.5 AutoConfig
3.6 License Manager
3.7 Reporting Utilities
3.8 Configuration Utilities

4-> R12i Patch and Maintain Oracle Applications
4.1 Patching and the AutoPatch Process
4.2 Patch Advisor
v4.3 Running AutoPatch
4.4 Other Patching Topics
4.5 Patch History Database

5-> R12i Oracle Applications Advanced Topics
5.1 Cloning Oracle Applications
5.2 Advanced Cloning Options
5.3 Other Advanced Topics

6-> R12i System Administrator Fundamentals
6.1 Incorporate custom help files and concurrent programs
6.2 Manage system resources, printers, and folders
6.3 Manage concurrent managers, programs, and reports
6.4 Manage application security
6.5 Implement Oracle Alert
6.6 Managing Application Security
6.7 Managing Concurrent Programs and Reports
6.8 Administering Concurrent Managers
6.9 Managing Profile OptionsDetails of the Topics Covered :-
6.10 Incorporating a Custom Program
6.11 Auditing System Resources
6.12 Managing Printers
6.13 System Management using Oracle Application Manager (OAM)
6.14 Forms Personalization
6.15 Applications DBA Duties
6.16 Introduction to Oracle Workflow