course img

Oracle Apps DBA

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 Programmingknowledge is required.

Course Details

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 singlenode 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 ProfileOptions
  • Managing Users Profile Options
  • Introduction to Oracle Workflow
  • Testing and MonitoringOracle Workflow
  • Check Active user and other Request Status

Maintaining Oracle Applications Utilties

  • what are the AD Utilities?
  • using AD Administration
  • using other AD Utilities
  • AutoConfig 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 Importof Database

Interfaces

  • Introduction to Interfaces
  • OutboundInterfaces
  • Using UTL_FILE package
  • InboundInterfaces
  • Using SQL * Loader tool

Additional Documents

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