oracle apps dba course content

Oracle Apps DBA (12.1 and 12.2)

Course Contents & Practical Approach

Module 1: Architecture and File System
1 Oracle Application History
2 What is ERP?
3 Architecture of R12.2
4 Changes from Previous Versions
5 Components of R12.2 Oracle Applications
6 File System & Important Files

Module 2: R12.2 Installation

1 -Installation of R12.2
2 Pre-requisites OS Setup
3 Installation Basics
4 Installation of R12.2 Demo
5 Post Steps
6 Basic Configuration Files

Module 3: Patching and ADOP

1 Patching in Oracle Applications
2 ADOP Basics
3 Online Patching
4 ADOP Command Line and Options

Module 4: Ad-Utilities

1 Ad-Utilites Basics
2 ADADMIN In Detail
3 ADCTRL In Detail
4 Other Utilities

Module 5: AutoConfig

1 AutoConfig
2 Basics to Detail of AutoConfig
3 New in R12.2
4 Walkthrough Oracle Application Manager

Module 6: Cloning

1 Cloning of Oracle Applications
2 Refresh
3 Cloning and Post Steps
4 Password Management in Oracle Applications

Module 7: Upgrade Flow & Overview

1 Basic System Administration in Oracle Applications
2 Upgrade Oracle Application Concepts

Lab Exercise 1: Architecture and File System

1 Provide one working instance of R12.2 to the Trainee
with Front end and backend access

2 Get comfortable with the Terminology/File system/Environment
Variables

3 Understand the Architecture via Navigation

Lab Exercise 2: R12.2 Installation

1 Perform the Installation of R12.2
2 Understand each screen of Installation well
3 Navigation to Weblogic Console / EM
4 Startup Shutdown of Instance

Lab Excercise 3 : Patching & ADOP

1 Apply Basic Patches
2 Apply pre-requisites patches for R12.4 Upgrade Requirements
3 Make trainee comfortable with Online patching phases
and complete patching activities

Lab Exercise 4 : Ad-Utilites

1 ADadmin and ADCTRL Tasks
2 Create another instance using Cloning
3 Adsplice, Adident etc usages

Lab Exercise 5: AutoConfig

1 AutoConfig Utilities Usage
2 Adsplice Usage
3 Adding CUSTOM TOP

Lab Exercise 6: Cloning

1 Pre-Requisites for Cloning
2 Pre Clone on DB Tier
3 Pre Clone on Apps Tier
4 Rapid Clone DB on Target
5 Rapid Clone Apps on Target
6 Post Cloning Steps