facebook twitter googleplus linkedin blogger

Oracle Apps DBA Master Course

1. Architecture and Configuration

  • Oracle Applications Architecture
  • Oracle Applications Components
  • Oracle Applications Environment Files, Control Scripts, and Languages
  • Oracle Applications File System
  • Oracle Applications Database
  • Preparing for Installation
  • Single Node Installation of 11i
  • Multi Node Installation of R12
  • Advanced Configuration Options
  • Finishing the Installation
  • 2. AD Utilities

  • Startup and Shutdown of Application Services in 11i and R12
  • Front End Access , Resolve Browser Problems
  • Status Checks to Ensure that Oracle Applications Services are fine
  • Oracle Applications Configuration Files
  • Component wise configuration files
  • AD Utilities
  • AD Administration: Maintain Applications and Database=>adadmin utiity
  • Autoconfig
  • Adident
  • Adsplice
  • License Manager
  • Configuration Utilities
  • Checking Oracle Applications and Product Versions
  • Oracle Applications AD and FND Tables
  • 3. Patching, Worker Administration and Cloning

  • Patching and the AutoPatch Process =>adpatch utility
  • Analyzing Patch Pre Requisites
  • Running AutoPatch.
  • AutoPatch Modes• & Testing
  • Patching Options , Hot patch , Defaults file
  • Post Patching
  • Patching for a Shared APPL_TOP
  • Admrgpch to merge Patches
  • Adctrl to control Workers
  • Troubleshooting Commonly Encountered Patching Issues
  • Cloning Oracle Applications using Rapid Clone
  • Cloning using Hot Backup and Cold Backup
  • 4. Users, Profiles, Responsibilities, Concurrent Managers and Requests

  • Post Clone Configuration
  • Debugging each component of Oracle Applications
  • Oracle Applications Users, Profiles and Responsibilities
  • Creating Oracle Application Users , Assigning Responsibilities
  • Important Profile Options and resetting Profile Options
  • Resetting Password for Oracle Applications Users
  • Resetting Apps Password
  • Users , profiles , responsibilities Tables and Scripts
  • Defining Concurrent Programs and Managers
  • Types of Concurrent Managers
  • Scheduling & Debugging of Concurrent Requests
  • CM Administration
  • Concurrent Manager & Concurrent Requests Tables and Scripts
  • Generating a trace for a Concurrent Request
  • Common Problems and Troubleshooting Scenarios
  • Concurrent Requests for Daily Maintenance of Applications and Workflow
  • 5. System Administration for Apps DBA

  • Monitoring Concurrent Requests, Programs, And Processes
  • Different Concurrent Managers and Their Significance
  • The Phase and Status of Concurrent Request
  • The CONCSUB Utility, Dealing with Workshifts and Custom Concurrent Managers
  • Troubleshooting Concurrent Processing related Issues
  • Dealing with User Creation, Responsibilities, Data Groups
  • Request Groups, Printer Configuration, Workflow Notification mailer, Profile Options.
  • 6. OAM and FND Utilities

  • Oracle Application Manager
  • FNDLOAD utility
  • FNDCPASS utility and AFAPASS utility
  • 7. Workflow Notification Mailer

  • Workflow Notification Mailer Configuration
  • Management of Workflow Services and Troubleshooting
  • Troubleshooting and Debugging of Apache Problems
  • Troubleshooting Forms Performance Problems
  • Troubleshooting Slow Running Concurrent Requests
  • Generating an FRD Trace for Form Error Diagnosis
  • Troubleshooting and Load Balancing of JVMs
  • Introduction to DMZ
  • Introduction to PCP
  • 8. Troubleshooting & Performance Tuning

  • Apache, Jserv, OC4J, Forms & Concurrent Processing Troubleshooting. Proactive    Performance
  • Management of Oracle Applications, Different Performance Issues and the solutions,    Tracing
  • 9. Upgradations

  • Upgrading Oracle Applications Database from 9i to 10g to 11g, Upgrading to 11.5.10.2
  • Upgrading Oracle Applications from 11i to R12
  • 10. High Availability and Advanced Topologies

  • Introduction to various options for Oracle Applications High Availability and their    Architectures
  • Detailed Explanation on Shared APPL TOP( Shared Application Tier)
  • Distributed AD
  • PCP (Parallel Concurrent Processing)
  • Load Balancing the Oracle EBS Applications
  • Working with RAC environment for Oracle EBS applications
  • Working with Dataguard environment for Oracle EBS applicationsBalancing, 11i/R12 with    RAC, SSL Configuration, SSO & OID Integration, DMZ, RAC Basics
  • Contact



    Phone no. - 00-971564914177

    Training

    OraSols - The Complete Oracle Solutions in one place.

    All training sessions if online will be recorded and training Video is shared at the end of session. Class Room Training for a batch of 4 and above will be provided. Individual online training by special focusing on Real time examples and Interviews and job related queries will be covered in details to meet the IT best practices.  Click to read more....