Oracle Apps DBA Training R12
We would like to take an honor in announcing and declaring Cympac as one of the best Oracle Apps DBA trainers all over Pune/Mumbai and across India.
Modules Covered:
You can send your enquiry to
info@cympac.in mentioning course name in the subject line.
Oracle Apps R12 Courseware
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)
- 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
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
Patch Wizard
- Describe and access Patch wizard
- Download the Patch Information
Bundle
- Define the stage directory
- Define patch filters
- Submit and view Patch Wizard
requests
- Analyze Patch Wizard results
- Perform Patch Impact analysis
Running AutoPatch
- Perform setup tasks prior to running
AutoPatch
- Register products
- Understand and answer the
autopatch prompts
- Identify the location and usage of
log files
- Perform additional tasks after
running AutoPatch
- Troubleshoot autopatch failure and
restart autopatch
OAM Timing Reports
- Describe the features of OAM
Timing Reports
- Identify the key information in the
Timing Detail reports
- Track an in-progress patch session
Other Patching Topics
- Describe the Autopatch modes
- Run autopatch in different modes
- Use AutoPatch command line
options
- Apply Java Patches
- Merge patch drivers from multiple
patches
Applied Patches Information
- Describe the features of OAM
Applied Patches Information
- Explain the relationship between
the autopatch mode and OAM
applied patch information
- Identify the Applied Patches reports
Cloning Oracle Applications
- Describe situations that may require
cloning
- Explain the prerequisites for rapid
Clone at OS Level (Software)
- Explain the prerequisites for rapid
Clone at Application level
- Prepare the Source System
Database Tier for Cloning
- Prepare the Source System
Application Tier for Cloning
- Copy the Source System to the
Target System
- Configure the Target System
- Check for and Update Instance-
Specific Settings
- Perform the Finishing Tasks
Advanced Cloning Options
- Refresh a cloned target system
- Clone a single-node system to a
multi-node system
- Clone a multi-node system to a
multi-node system
- Add a node to an existing system
- Reduce the number of nodes on a
multi-node system
AD Administration: Generate
Applications Files Tasks
- Setting up Environment
- Generate message, form, report,
graphics, and product jar files
- Generate files options
*All Trainings will be covered for Cympac Employees only.