Oracle Applications DBA Workshop On Oracle E-Business Suite R 12
Course Pre-requisite: Oracle 10g or 11g DBA Knowledge Duration: 1 Month
Software Requirement: Oracle EBS R12, Oracle Enterprise Linux 5.5
Activities:
Day 1:
Understanding the Concept of Enterprise Resource Planning The Famous Three Tier Architecture
Understanding the Applications Components
Introduction to Database Server, Apache Web Server, Form Server, Report Server, Concurrent Manager Serer and other Server
Day 2:
Preparing the Environment of EBS R12 Installation Understanding the software and hardware requirements Installation of Oracle Enterprise of Linux 5.5 for EBS R12 Demonstration of downloading EBS software
Staging the software System Setup for Installation Performing the Installation
Day 3:
Finishing the Installation
Verifying the Oracle Applications Installation
Verifying Database Server
Verifying Apache Component
Verifying Forms Server Component
Verifying and Compiling JSP
Logging into Oracle Applications as Applications DBA
Day 4:
Understanding the Applications File System and Context Name Understanding the Use of Environments Files
Understanding APPL_TOP, INST_TOP, DB_TOP etc Describing the Directory Structure
Identifying Product Directories
Day 5:
Oracle Application Database
Description of Apps Schema and Other Schemas
Managing Database Listener
Starting and Stopping Database Services
Database Performance Features
Day 6:
Identifying AD Utilities
Usage of Command Line Arguments
Identifying Log Locations
Describe Parallel Processing
Re linking Oracle Application Program
Creating Main Application Environment File
Identifying Servers
ADADMIN
Changing into Maintenance Mode ADCTRL
ADSPLICE
Day 7:
Describing Application Context
Describe AUTOCONFIG
Run AUTOCONFIG script
Update Application Context Parameter
Restoring Application Context Parameter
Troubleshooting AUTOCONFIG
Day 8:
Internal Concurrent Manager
Conflict Resolution Manager
Starting and Stopping Concurrent Manager
CONCSUB Utility
Administering Concurrent Managers
Parallel Concurrent Processing
Day 9:
Patch Classification
AUTOPATCH Introduction
Features of AUTOPATCH
Download a Patch
Applying a Patch
Interactive and Non-Interactive Patch
Auto Patch Mode (Test and Pre-Install)
Merging Patch
ADPATCH Command Line Option
Restarting AUTO PATCH
Day 10:
Introduction ADCLONE
Rapid Install Cloning
Performing Cloning
Rapid Clone
Day 11:
Introduction to Oracle Application Manager
Application Dash Board
Diagnostic
Security
Maintenance
Day 12:
Managing Security
Creating user
Creating Responsibilities
Changing Password
From OAM
Using FNDCPASS
Day 13:
Upgrading Database (RUP)