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

Courses Duration : 3-4 weeks