About Oracle Apps DBA Training in Bangalore
Oracle Apps DBA Training Course Contents
Course Conents for Oracle EBS R12: Installation, Patching
and Maintenance:
Oracle eBusiness Suite R12.1.3/12.2.3 Architecture Overview
· Oracle eBusiness History
· Oracle eBusiness Infrastructure Design
· Introduction
to Oracle eBusiness Suite R12.1.3/12.2.3
· Oracle
eBusiness Suite R12.1.3/12.2.3 Architecture
· Oracle
eBusiness Suite R12.1.3/12.2.3 Multi-Tier Architecture
· Desktop Tier
· Application
Tier
· Database
Tier
· Oracle Homes
Architecture
· Oracle
E-Business Suite Technology Layer
Preparing for your Installation
· Advantages
of Rapid Install
· Technology
Stack Components
·
Pre-requisites required (Platform Hardware and Softwares)
· Staging
Software
· How
Installation works
Performing an Installation
· Types of
Installation (Standard/Typical/Express)
· Single Node
Installation
· Multi-Node
Installation
· Validation
of Parameters passed
· Restart /
Troubleshooting fresh Install
· Rapid
Install progress monitoring
Finishing your Installation
· Explain
required post-installation tasks
· Describe the
client software configuration process
· Describe
installation-specific post-installation tasks
· Sanity
Checks after successful installation
Oracle Applications Components
· Identify and
describe the high-level technology stack components that make up the desktop,
application and database tiers
· Understand
how Oracle Applications uses the various technology stack components
· Identify the
various oracle homes used by the Oracle Applications
· Identify and
describe the role of the various Applications Technology layer products
· Identify the key changes in the R12 applications technology stack
Environment Files, Control Scripts and Languages
· Describe the
Oracle Applications main environment file and its key parameters
· Identify
other important environment files
· Identify
application tier server control scripts
· Explain how
languages are supported by Oracle Applications
Oracle Applications File System
· Describe the
Oracle Applications file system (both database tier and application tier)
· Describe the
product directory structure
· Identify the
important product directories (AD, AU)
· Describe the
role of the following directories:
APPL_TOP, COMMON_TOP, INST_TOP
· List the
directories that are new with Release 12
Oracle Applications Database
· Describe the
objects and schemas that exist in the Oracle Applications database
· Describe the
purpose of the APPS schema and Additional Schema
· Impending
Multiple Organization and Reporting Currencies
· Overview of
Database Features
· Database
Monitoring Features
· Database
Performance Features
· Database
Scalability and Business Intelligence Features
· How to Start
and Shutdown the database server and listener
Advanced Configuration Options
· Understand
the use of a shared application tier file system in Oracle Applications
· Explain the
benefits of using a staged APPL_TOP
· Identify the
main load balancing options and their key features
· Understand
the major factors in efficient network design for Oracle Applications
R12 Use Oracle Applications AD Utilities
·
Configuration and environment files
· Identify the
AD utilities
· Understand
the usage of command line arguments and flags
· Describe
parallel processing
· Identify the
location and usage of log and restart files. (adadmin.log and adwor0xxx.log)
· Distributed
AD
AD Administration: Maintain Applications Files Tasks
· Relink
Oracle Applications programs
· Create the
main Applications environment file
· Identify the
appropriate servers for file system administration tasks
· Maintain
Snapshot Information
AD Administration: Compile/Reload Database Entities Tasks
· Using
Compile/Reload Database Entities Tasks
· Alternative
methods to compile/generate & reload objects
AD Administration:
Non-interactive Operation and Maintenance Mode
· Create a
defaults file and running AD Administration in non-interactive mode
· Enable and
Disable maintenance mode
· Benefits of
Running AD Administration in Non-interactive Mode
· Defaults
file available menu options
Special Utilities
· Overview of
AD Controller
· Understand the worker status
· Troubleshoot
worker processes
· Restart and
shutdown a worker
· AD Relink
Utility
· Describe the
Upgrade Process
· Review
Worker Status & It's Flow
Autoconfig
· Describe the
Applications Context
· Describe
Autoconfig
· Identify
Scripts used by Autoconfig
· Run
Autoconfig to configure an Oracle Application System
· Update
Applications Context Parameters
· Restore
Applications Context Parameters
· Roll Back an
Autocofig Session
· Run
Autoconfig in Test Mode
· Troubleshooting / Dependency while running Autoconfig
· Benefits of
Context Files
· Autoconfig
in OAM
AD Administration: Maintain Database Entities Tasks
· Using
Different Options Maintain Database entities task
· Dual Table
License Manager
· License
Manager Utility
· Register
products
· Register
country-specific functionalities
· Register
languages
· Identify
licensed products and languages
· License
Manager Summary Report
Reporting Utilities
· Overview of
Command Line Reporting Utilities
· AD
Configuration Report
· AD File
Identification
· AD Job
Timing Report
· Running AD
Configuration
Configuration Utilities
· Install a
new off-cycle product
· How to use
AD Splicer
· Convert the
character set of Applications files
Patching and the AutoPatch Process
· Overview of
patches (includes the purpose, types of patches, naming convention)
· Describe the
elements of a patch
· Distinguish
between a patch, minipack, maintenance pack and consolidated updates
· Describe how
a patch is created
· Overview of
Autopatch and its features/ Options
· Explain the
steps AutoPatch goes through to apply a patch
· How to apply
a Patch (both on single node and multi node configuration
· Downloading
a Patch
Printers
· Managing
Printers
· Registering Printers
·
Troubleshooting Printer Issues
Oracle eBusiness Suite Cloning Concepts & Process
· Rapidclone
Concepts
· Cloning From
Single node to Single node
· Cloning From
Multi-Node to Multi-Node
· Cloning From
Multi-Node to Single-Node
· Database
Refresh
· Post-Clone
Procedures
Security
· Creating
Users
· Assigning
Responsibilities
· FNDCPASS
Concepts
· Changing
User Passwords using FNDCPASS
Maintenance of Workflow in eBusiness Suite
· Introduction
to Oracle Workflow
· Workflow
Configuration· Workflow
Troubleshooting
· System
Administration
· Creating
Users
· Assigning
Responsibilities
· Setting Up
Printers
· Changing
Profile Options
Additional Documents
· Interview Q
& A
· Real Time
Troubleshoot Scenarios
· Soft &
Hard Copy of all notes
· Notes on R12
Application