Boston Computer School

You are here:  Home » Courses » Oracle » ORACLE APPS DBA 

ORACLE APPS DBA

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

Course: ORACLE APPS DBA

BCS Fees: $1750