ORACLE APPS DBA


Oracle Apps DBA – Course Content

Overview:
Oracle Applications DBA covers all the pertinent aspects of administrating Oracle Applications from installation to day-to-day maintenance. It is responsible for managing the middle ware (application Server) as well as Oracle Database. It covers all upgrading, patching, cloning, maintenance and troubleshooting of the application system.
Training Objectives of Oracle Apps DBA:
Oracle Apps DBA should have skills in Designing of Database, Oracle Application Server and Functional Expertise in areas like finance, accounts etc. Using this Course you can able to Prepare Database Design and Oracle Application Server Internals. This Exclusive intensive Oracle Applications DBA online course is designed for both Students as well as Working Professionals.
Target Students / Prerequisites:
Students must have awareness in Concepts of Oracle PL/SQL and D2K. Some basic Java Programming knowledge is required.
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
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
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 Utilties
what are the AD Utilities?
using AD Administration
using other AD Utilities
Auto Config Utility
Config Utilities
Context Editor
Cloning
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
Interfaces
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