This is a modest initiative for providing help to people who really want to boost their skills in Oracle Apps DBA, with special stress to the Administration area. The main reason behind this initiative has been the problems which we had faced when we ventured out to try our hands at Oracle Apps DB Administration.

Though there was lots of information available out there in the web, we didn't find most of them handy as they didn't give importance to the fact that many people will look for detailed step by step description of each activity. So, we had to go through many channels to finally get the hold on the subject and reach the level we are today.

This was a tough and tedious process, and especially due to this reason, we wanted to come up with a simple and straight forward set of programs which will serve as a kind of guide for all those who want to venture out to the galaxy of Oracle Apps DBA.

Introduction to Oracle E-Business Suite

  • Oracle E-Business suite (ERP, SCM, CRM...)
  • Introduction to Oracle family suites
  • Oracle Application & Oracle Applications technology stack
  • Introduction form based and java based applications

Introduction to Oracle E-Business Suite Architecture

  • Concepts and Architecture ICA Two Tier/Three Tier & fusion Architecture single node/multi node
  • Introduction to oracle Apps Tier components (Apache IAS server, form server, concurrent processing server....)
  • DB Tier component database server

Introduction to E-Business Suite 11i/R12 File System & Directory

  • Business Specific Module & Technology Specific Module

Installation of Oracle E-Business Suite Application 11i/R12

  • Pre & Post Steps/Checklist of installation, Single/Multi node Installation. Creation of Oracle E-Business Suite Stage

EBS Backup & Recovery

  • Planning, Testing and Implementing EBS Application and database backups and restores/recovery.

SYSADMIN MODULE

  • Creating of Users
  • Assinging Responsibilities to users
  • Creation of Custom Responsibilities
  • Creation of request group
  • Creation of data group
  • Creation of Custom Application
  • Managing Concurren Programs & Reports
  • Administrating Concurrent Managers
  • Creation of Custom Concurrent Manager
  • Managing Profiles Options
  • Structure of Profiles
  • Seeded Profiles
  • Managing Flex Fields (KFF,DFF)
  • Managing Printers
  • Managing the Workflows activites ( Notification/Mailer)

Oracle EBS UTILITIES

  • AD Administration (Adadmin)
  • Auto Patch (Ad patch)
  • AD Merge Patch (Admrgpch)
  • AD Controller (adctrl)
  • AD File Identification (adident)
  • AD Rilink (adrelink.sh)
  • AD Splice
  • FNDCPASS
  • FNDLOAD

Oracle Application Manager (OAM)

  • Oracle Application Manager Features
  • Managing/Monitoring EBS system through OAM console

Introductions to Multi-Organization Concepts

  • Introduction
  • Structure of a Patch file & Patch drivers Searching
  • Downloading & Applying patches
  • Pre & Post Steps Checks
  • Patch History
  • Monitoring & Troubleshooting Patch session
  • Reducing Patching Time :- (Merging Patches, Patching Non-Interactively,Patching on
  • Shared Apps Tier Using Distributed AD features, Patcching on Stage instance
  • Troubleshooting Scenarios of Failed Patches and Hanging Patch Session

Cloning

  • Cloning the existing EBS System Types & Methods of Clonig :- (Adclone, Rapidclone, OAMclone)
  • Cloning Single Node to Single with Refresh/Partial Cloning
  • Single Node to Multiple Node
  • Multiple Node to Single Node (With/Without Shared Apps Tier)
  • Online Cloning/ Hot Cloning and Troubleshooting Cloning Issues.

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 gradatin of Oracle E-Business Suite & Database

  • Upgrading EBS 9i datqabase to 10g re12 and Upgrading EBS 11.5.10.2 to R12
  • Upgrading Pre and Post steps, Troubleshooting Upgrade Issues

Troubleshooting

  • Resolving issues like Login & Connectivity Issues
  • Files Corruption/Missing
  • Performance AOL/J diagnostinc test
  • Gathering Diagnostic data using RDA too.
  • Working with Oracle Support Service for rainsing SRs (Service Request)

Conclusion

  • Resume Preparation
  • Real Time Scenarios
  • Documents
COMMENCING NEW BATCHES
ENQUIRY FORM
FOLLOW US ON
SUBSCRIBE TO OUR NEWSLETTER

WE ACCEPT ONLINE PAYMENTS
PAY ONLINE