ORACLE APPS DBA Course Content:

1.Architecture

• Introduction to Oracle 11i E-Business Suite
• Oracle Applications Overview
• Oracle Applications File System
• Oracle Applications Environment files
• Server process Scripts and language
• Oracle Applications in single node and multi node
• Oracle Applications database

2.Installations

• Overview of installation process
• Installing and configuring Oracle Application 11i using single Node install
• Installing and configuring Oracle Application 11i using Multi Node install

3.Patch Administrations

• Patching Activities
• Creating a Patch
• Running Patches
• Patching history Database

4.System Administrator

• Managing Application Security
• Managing Concurrent programs and Reports
• Administering  Concurrent Managers
• Manage Profile Options
• Managing Users Profile Options
• Introduction to Oracle Workflow
• Testing and Monitoring Oracle Workflow
• Check Active user and other Request Status

5.Maintaining Oracle Applications Utilities

• What are the AD Utilities?
• Using AD Administration
• Using other AD Utilities
• Auto Config Utility
• Config Utilities
• Context Editor

6.Cloning

• Cloning Oracle Application Using Manual AD Clone and Rapid Clone Methods

7.Oracle Core DBA Concept

• Oracle Database Architecture
• All Background Process
• Tables Related to Oracle Applications
• Export and Import of Database

8.Interfaces

• Introduction to Interfaces
• Outbound Interfaces
• Using UTL_FILE package
• Inbound Interfaces
• Using SQL * Loader tool

9.Additional Documents

• Interview Q & A
• Real Time Troubleshoot Scenarios
• Soft & Hard Copy of all notes
• Notes on R12 Application