Oracle APPS Database Admin

Oracle APPS Database Admin

Oracle Applications DBA tasks is a complex framework of modules that performs basic business administration and the DBA must have a fundamental understanding of the business processes. It is very different from a regular Oracle database administrator and requires specialized skills in business administration and Oracle application server architectures.

Training Objectives of Oracle Apps DBA
Our Training course content designed basic to advanced levels topics for every participant as per the current Industry Requirements. Our Training will give you great understanding on Oracle Apps DBA roles and responsibilities. We provide complete course material and also provide placement support and Resume Preparation. We will provide extensive support for your career and you should be on your way to becoming proficient in Oracle Apps DBA. Our Trainer real time Oracle Apps DBA project scenarios training helps to work on this project in the company.

Target Students and Prerequisites:
Students must have awareness in Concepts of Oracle PL/SQL and D2K. Some basic Java Programming knowledge is required.

Course Contents:
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

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

Patch Administrations
Patching Activities
Creating a Patch
Running Patches
Patching history Database
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

Maintaining Oracle Applications Utilities
What are the AD Utilities?
using AD Administration
using other AD Utilities
Auto Config Utility
Config Utilities
Context Editor

Cloning Oracle Application Using Manual AD Clone and Rapid Clone Methods
Oracle Core DBA Concept
Oracle Database Architecture
All Background Process
Tables Related to Oracle Applications
Export and Import of Database

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

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