Oracle App DBA

This Oracle Database: Program with Oracle DBA training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more. Practice Material, Certification, Resume & Interview Guidance are included in this App DBA.


REGULAR SCHEDULES: LIVE Online Training

Schedule Free Demo Start Date
6:30 AM June 8th June 8th Register
10:00 AM June 8th June 12th Register
7:00 PM June 15th June 19th Register
 

WEEKEND SCHEDULES: LIVE Online Training

Schedule Free Demo Start Date
6:30 AM June 8th June 8th Register
10:00 AM June 8th June 12th Register

Trainer: Mr Srinivas (18+ Yrs Exp)

Dur: 16 Weeks (Mon - Fri).

Total Course Fee: INR 55,000/- (USD 700)

 

Highlights

  • ✔ Completely Practical and Realtime
  • ✔ Theory Material provided in Advance
  • ✔ Highly Interactive and Interesting
  • ✔ Certification Guidance and FAQs
  • ✔ 80% Hands on Training, 20% Theroy part Explanantion

Pre-requisites for this course: NONE. Anyone can join!


Oracle App DBA Training PDF

Course Content


Module: I

Chapter -1 Oracle E-Business Suite an Overview
  • What is ERP
  • Reasons for Moving ERP
  • Advantages of ERP
  • Oracle E-Business Suite as an ERP Solution
Chapter -2 Oracle Applications Architecture
  • Database Tier
  • Application Tier
  • Oracle Applications Tier
  • Oracle HTTP Server
  • Forms Server
  • Admin Server
  • Concurrent Processing Server
  • What’s New in R12
  • Client Desktop
  • Forms Client Applet
  • Oracle Container for Java(OC4J)
  • Oracle Applications Technology Layer
  • Oracle Applications DBA(AD)
  • Oracle Application Object Library(FND)
  • Oracle Common Modules(AK)
  • Oracle Application Utilities(AU)
  • Oracle Alert(ALR)
  • Oracle Workflow(WF)
  • Oracle Application Framework(OAF)
Chapter -3 Oracle Application File System
  • R12 file System
  • Instance Overview
  • Instance Directory Structure
  • Configuration files
  • Log files
Chapter-4 Installing Oracle Applications
  • Planning the installation
  • System requirements
  • Pre-Installation Tasks
  • Installation process
  • Starting the rapid Install
  • Single Node Installation
Chapter -5 Checking & Configuring Oracle Applications
  • Database & Listener Check
  • Environment File Check
  • HTTP & Web Listener Check
  • DBC File Check
  • Checking Form Server
  • Configuring Oracle Applications
  • Logging into Oracle Applications
Chapter -6 Managing Oracle Applications
  • Managing the Database
  • Starting the Oracle Database
  • Shutting down the Oracle Database
  • Starting & Stopping Database Listener
  • Managing the Applications
  • Managing the Middle Tier Listener
  • Managing the Web Server
  • Managing the Forms
  • Managing the Concurrent Manager
  • Managing the OC4J
  • Managing the OPMN
  • Starting & Stopping all the Middle Tiers
Chapter-7 Concurrent Processing and Concurrent Manager
  • Internal Concurrent Manager
  • Conflict Resolution Manager
  • Standard Manager
  • Concurrent Program
  • Starting Concurrent Manager
  • Location of Concurrent Manager Log files
  • Querying the Concurrent Manager
  • Stopping the Concurrent Manager
  • Submitting Concurrent requests
  • CONCSUB Utility

Module: II

  • Flow of a Concurrent request
  • Combination of Phase & Status
  • The Completed Phase
  • The Running Phase
  • The Pending Phase
  • The Inactive Phase
  • Defining Concurrent managers
  • Parallel Concurrent processing details
  • Work Shifts
  • Defining work Shifts
  • Administrating Concurrent Managers
  • Controlling Specific Managers
  • Parallel Concurrent Processing
  • Generic Service Management
Chapter – 8 Patching Oracle Applications
  • Patch Classification
  • One –off patches,Mini Packs, Maintenance packs
  • Family Packs
  • Patch File Structure
  • Patch Drivers
  • Auto Patch
  • Downloading a Patch
  • Metalink
  • Querying a patch
  • Downloading a patch
  • Applying a Patch
  • Interactive and Non-Interactive Patching
  • Auto patch Modes
  • Test Mode
  • Pre-Install Mode
  • Merging Patches
  • Applying Merged patches
  • Adpatch Command Line options
  • Patch Failures
  • Restarting the Auto patch
  • Monitoring patch progress
Chapter -9 Ad utilities
  • Auto patch
  • Ad admin
  • Generate Applications Files Menu
  • Maintain Application Files
  • Compile/Reload Applications Database Entries
  • Maintain Application Database Entries
  • Changing Maintenance Mode
  • Adctrl
  • Ad splice
  • AD relink
  • License Manager
  • AD ident
Chapter -10 Cloning
  • Ad clone
  • Running Rapid install
  • Running ad clone
  • Autoconfig
  • Rapid Clone
  • Apply the rapid clone patch
  • PPA
  • Sanity Check
Chapter -11 Upgrading Oracle Applications
  • Pre-Upgrade Process
  • Post Upgrade Process
  • Software & memory requirement
Chapter-12 Managing Applications Security
  • Creating Users
  • Defining Responsibilities
Chapter-13 Printer Setup
  • Defining printers
  • Defining new style

Register Today