Courses Offered :
Oracle App’s DBA
- Architecture and Overview of Oracle Apps 11i/R12
- Architecture of Apps
- Oracle Applications Environment
- Oracle Applications File System
- Oracle Applications Database
- Identify the important product directories (AD, AU)
- Role of the following directories: APPL_TOP, COMMON_TOP, INST_TOP
- List the directories that are new with Release 12
- Components in 11i & R12
- 11i & R12 File System including important files
- Installation of Oracle Apps
- Single Node Installation
- Multi Node Installation
- Hands on Installation of 11i / R12
- Startup/Shutdown Apps & DB
- Oracle Applications Utilities
- Identify the AD utilities
- Identify the location and usage of log and restart files
- 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
- 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
- Apps Patch using adpatch
- 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 & adpatch options
- Hands on practice for patching
- Frequently asked interview Questions in patching
- Cloning
- Describe situations that may require cloning
- 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
- Hands on rapid clone
- 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
- Upgrade
- Upgrade scenarios
