Oracle Applications DBA course Contents 

  • Introduction to Oracle E-business Suite.
  • Introduction to Oracle E-business Suite Architecture
    • Concepts and Architetecture NCA / ICA
    • Three Tier architecture Single and Multi nodes
    • Introduction to oracle APPS Tier components ( Apache
      • Server, Forms Server, Report Server, Concurrent Mgr Server,
      • Admin Server) & DB Tier Component DB server
  • EBS 11i/ R12 File system
    • Directory Structure
    • EBS Data Model ( 11i Schemas, Table space Model)
    • Types of Users
  • Oracle EBS Application Modules
    • Biz. specific and Technology specific Modules

 

  • Installation of Oracle EBS Applications
    • Creation of Oracle EBS Stage
    • Single Node  & Multi Node Installation
    •  
  • SYSADMIN Module :
      • (Creation of Users, Assigning Responsibilities to Users, Creation of Custom
      • Responsibilities, Creation of Request group, Creation of data group, creation
      • Of Custom Application, Managing Concurrent Programs and Reports,
      • Administrating Conc. Mgr, Creation of Custom Conc. Mgrs, Managing
      • Profile Options, structure of profile, Seeded Profiles, Managing Printers,                           
      • ……etc)
  • Oracle EBS Utilities
    • AD Administration ( adadmin)
    • Auto Patch  (ad patch)
    • AD Merge Patch (admrgpch)
    • AD Controller (adctrl)
    • AD File Identification (adident)
    • AD Relink ( adrelink.sh)
    • AutoConfig(adconfig.sh),
    • AD licence ( ad splice) & FNDPASS

 

  • Oracle Application Manager ( OAM)
    • Oracle Application manager Features
    • Managing/ Monitoring EBS system through OAM console
  • Oracle Application Patches
    • Introduction of Patch, and Types of Patches
    • Structure of a Patch file
    • Searching, Downloading & Applying PATCHES
    • Pre & Post Steps Checks
    • Patch History
    • Monitoring and Troubleshooting Patch Session
    • Different Techniques to reduce Patching Time
    • Troubleshooting scenarios of Failed Patches and Hanging Patch Session

 

  • Cloning
    • Introduction to Cloning
    • Types and Methods of Cloning (adclone, rapidclone, OAM)
    • Single node to Single Node cloning
    • Advanced Cloning like, Single to Multi, Multi to Multi & Multi to
      • Single Node, Partial / Refresh Cloning, Online Cloning
  • Performance Tuning
    • Proactive Performance Management
    • Oracle EBS Health Management
    • Effective EBS configuration
    • Routine / Daily tasks
    • Proactive Monitoring
    • Troubleshooting Performance Issues
    • Tracing Forms and Concurrent Program Session

 

  • Up gradation of Oracle EBS and Database
    • Upgrading EBS 9i Database to 10g Rel2 and
      • Upgrading EBS 11.5.10.2 to R12,
    • Upgrade Pre and Post steps
    • Troubleshooting Upgrade issues
  • Troubleshooting
    • Resolving Issues like Login and Connectivity Issue Files
    • Files Corrupting / Missing
    • Performing AOL/J Diagnostic Test
    • Working with Oracle Support Services by raising SR( Service Request)
  • The duration of the Course is 40+ hours of each one hour.