DBA SCHOOL, #501 & 502, Mahindra Residency, Near Aditya Trade Center, Ameerpet,

Hyderabad
Ph: +91 9966293445 / +91 8142368899 / 040-30629104

Oracle-Apps DBA (11i & R12) Course Contents

(Practical Approach)
1. Oracle E-Business Suite: An Overview

What is an ERP
Reasons for Moving ERP
Advantages of ERP
Oracle E- Business Suite as an ERP Solution

2. Oracle Application Architecture

Database Tier
Application Tier
Oracle HTTP Server (Apache)
Forms Server
Reports Server
Admin Server
Concurrent Processing Server
Discoverer Server
New Changes in R12
Client Desktop
Forms Client Applet
Oracle JInitiator
Changes in the Desktop Tier in Release 12

Oracle Application 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)
Oracle XML Publisher (XML)
DBA SCHOOL, #501 & 502, Mahindra Residency, Near Aditya Trade Center, Ameerpet,
Hyderabad
Ph: +91 9966293445 / +91 8142368899 / 040-30629104

3. Oracle Application File System

11i Application Tier File System

APPL_TOP
COMMON_TOP
Oracle Application Technology Stack
R12 File System
Instance Home Overview
Instance Home Directory Structure
Changes in COMMON_TOP Directory Structure
Changes in Environment Files and Variables
Configuration files
Log Files

4. Installing Oracle Applications – single node

INSTALLING ORACLE APPLICATIONS 11.5.10 CU2

Planning the Installation

System Requirement
Pre-Installation Tasks
The Installation Process
Starting the Rapid Install
Single Node Installation
Using Express Configuration

5. Installing Oracle Applications – Multi-node (Between Two Servers)

INSTALLING ORACLE APPLICATIONS 11.5.10 CU2

Planning the Installation

System Requirement
Pre-Installation Tasks
The Installation Process
Starting the Rapid Install
Multi- Node Installation
Using Express Configuration
DBA SCHOOL, #501 & 502, Mahindra Residency, Near Aditya Trade Center, Ameerpet,
Hyderabad
Ph: +91 9966293445 / +91 8142368899 / 040-30629104

6. Installing Oracle Applications – Multi node (Two Servers)

INSTALLING ORACLE APPLICATIONS 11.5.10 CU2 (11i)

Planning the Installation

The Installation Process
Using Express Configuration

7. INSTALLING ORACLE APPLICATIONS RELEASE 12 (R12)

Planning the Installation

System Requirement
Pre-Installation Tasks
The Installation Process
Starting the Rapid Install
Using Express Configuration in R12
8. Installing Oracle Applications – Multi-node (Between Two Servers)

INSTALLING ORACLE APPLICATIONS 12.1.1

Planning the Installation

System Requirement
Pre-Installation Tasks
The Installation Process
Starting the Rapid Install
Multi- Node Installation
Using Express Configuration

9. Checking and Configuring Oracle Applications

Database and Listener Check

Environment File Check
HTTP and Web Listener Check
Testing the Virtual Directories of the Web Listener
DBC File Check
Testing DBC File
Testing JSP
Checking Forms Server
Configuring Oracle Applications
Configuring Client Desktops
DBA SCHOOL, #501 & 502, Mahindra Residency, Near Aditya Trade Center, Ameerpet,
Hyderabad
Ph: +91 9966293445 / +91 8142368899 / 040-30629104

Logging in to Oracle Applications

Setting Preferences
Using Profiles for Customization
Launching Direct Forms

10. Managing Oracle Applications

Managing the Database

Starting the Oracle Database
Shutting Down Oracle Database
Starting/Stopping Database Listener

Managing Applications
Managing the Middle Tier Listener
Managing the Web Server (Apache)
Managing the Forms
Managing the Reports Server (Only for 11i)
Managing the Concurrent Manager
Managing the OC4J (Only for R12)
Managing the OPMN (Only for R12)
Starting/Stopping all the Middle Tiers

11. Concurrent Processing and Concurrent Manager

Starting concurrent manager

Location of concurrent manager log files
Querying the concurrent manager
Stopping concurrent manager
Submitting concurrent request
DBA SCHOOL, #501 & 502, Mahindra Residency, Near Aditya Trade Center, Ameerpet,
Hyderabad
Ph: +91 9966293445 / +91 8142368899 / 040-30629104

12. Patching Oracle Applications (11i & R12)

Patch classification
Patches, Mini-packs and Maintenance packs
Family Packs and Family Consolidated Upgrade Patches(FCUP)
Patch File Structure
Patch Drivers
Downloading a Patch
Oracle Customer Support
https://support.oracle.com
Querying for Patches
Downloading a Patch

Appling a Patch using adpatch utility

Applying a Patch in a Single-node System (11i & R12)

Applying a Patch in a Two-node or Multi-node System (11i & R12)

13. Patching for Oracle Database

Downloading patches from Oracle Customer connection

https://support.oracle.com

14. Oracle Database Upgrade from 10g to 11g

15. AD Utilities (11i & R12)

Auto patch
Adadmin

Generate Applications Files Menu

Maintain Application Files
Compile/Reload Applications Database Entities
Maintain Applications Database Entries

Changing maintenance mode

Running AD Administration in Non-interactive Mode

DBA SCHOOL, #501 & 502, Mahindra Residency, Near Aditya Trade Center, Ameerpet,
Hyderabad
Ph: +91 9966293445 / +91 8142368899 / 040-30629104

16. Cloning (Oracle Apps 11i)

Applying the Rapid Clone Patch

Preparing the Template
Copying the Files from the Source to the Target Application System
Configuring the Target Application System
Post-cloning Tasks
Complete Cloning Process on Two Servers
Database Cloning as well as Application Cloning

17. Cloning (Oracle Apps R12)

Applying the Rapid Clone Patch

Preparing the Template
Copying the Files from the Source to the Target Application System
Configuring the Target Application System
Post-cloning Tasks
Complete Cloning Process on Two Servers
Database Cloning as well as Application Cloning

18. Oracle Application Manager (11i & R12)

Application Dashboard
Overview
Critical Activities
Diagnostics
Security

Site Map
Administration
Oracle Application Manager Log
Monitoring
Maintenance
Patching and Utilities

19. Managing Application Security (11i & R12)

Creating users
Defining responsibilities
DBA SCHOOL, #501 & 502, Mahindra Residency, Near Aditya Trade Center, Ameerpet,
Hyderabad
Ph: +91 9966293445 / +91 8142368899 / 040-30629104

20. Troubleshooting of Database Servers, Application Servers and Webservers

Troubleshooting of Webservers
Troubleshooting of Application Servers
Troubleshooting of Concurrent Manger
Troubleshooting of Database Servers.
Troubleshooting of Listeners

Faculty: Satya Seelam

(10 Years DBA and Apps DBA Exp in USA)
Visit: www.hyddbatraining.com
Phone: +91 9966293445 / +91 8142368899 / 040-30629114
Contact Us
DBA School (Software Training Institute)
Flat #501 & 502, Mahindra Residency,
Near Aditya Trade Center,
Ameerpet,
Hyderabad