Oracle Application DBA

  • Tweet
  • Tweet

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)