Toll Free : 1-800-929-0849

Request a Call back
Crescent Help Desk

Google Plusface booktin
713-589-2879
713-589-5479
704-248-2649
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