Oracle Apps DBA Training

Oracle Apps DBA Training

Oracle Apps DBA Training Course Content


Module – 1

1. Oracle E-Business Suite 11i, R12.1.3/12.2.3 Architecture
•Introduction to Oracle E-Business Suite 11i, R12.1.3/12.2.3
•Oracle E-Business Suite 11i, R12.1.3/12.2.3 Architecture
•Oracle E-Business Suite 11i,
•1.3/12.2.3 Multi-Tier Architecture
•Desktop Tier
•Application Tier
•Database Tier
•Oracle Homes Architecture
•Oracle E-Business Suite Technology Layer

2. Installation
•Single Node Installation (12.1 and 12.2)
•Multi-Node Installation (12.1 and 12.2).
•Context File and Interpretation.

3. File System
•Oracle Applications Technology
•Oracle Applications Environment Files and Server Process Scripts
•Oracle Applications Entire File System
•The Applications and Database Context Files

4. AD Utilities
•What are the AD Utilities?
•AD Administration
•Special Utilities
•Context Editing
•Reporting Utilities
•Configuration Utilities

5. Concurrent Managers
•Managing Concurrent Programs and Reports and Output Post processor.
•Administering Concurrent Managers
•Managing Profile Options
•Incorporating a Custom Program
•Scheduling requests and Request Sets

6. Patching
•Patch Types, Terminology, and Components
•Patch Creation and Patching Order
•Patching Utilities
•Introduction to Online Patching
•Architectural Changes to Support Online Patching
•Database Implementation
•Editioning Views and the Application Data Model
•Phases of the Online Patching Cycle

7. Running the AD Online Patching Utility
•AD Online Patching Utility
•Running the adop Utility
•adop Commands
•Executing the Patching Cycle
•Status of a Patching Cycle
•Patching in Multi-Node Environments
•adop Remote Invocation
•Hotpatch Mode

8. AutoConfig and Configuration Changes
•Reduced Role for AutoConfig
•Configuration Tools
•New AutoConfig Tools for System Configuration
•Service Groups and Services in Release R12.1.3/12.2.3
•AutoConfig Managed Service Groups and Services
•Managing Oracle HTTP Server Configurations
•Web Applications
•Summary of Configuration Changes
•Autoconfig Template and Driver files Concepts

Module – 2

9. Cloning
•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
•2.X and R12.1.X key changes
•Post-Clone Procedures

10. Security
•Creating Users
•Assigning Responsibilities
•FNDCPASS Concepts
•Changing User Passwords using FNDCPASS

11. Workflow
•Workflow Configuration
•Workflow Troubleshooting and Debugging

12. System Administration
•Creating Users
•Assigning Responsibilities
•Setting Up Printers
•Changing Profile Options.
•XML Publisher and Administration in DBA Perspective.
•Code Migrations and awareness on Migration tools.
•Key roles in Support for APPS DBA.
•OAF Migrations

13. Troubleshooting & Performance Tuning
•User connectivity issues Troubleshooting
•Apache Troubleshooting
•Jserv Troubleshooting
•OC4J Troubleshooting
•Forms & Concurrent Processing Troubleshooting
•Autoconfig related issues Troubleshooting
•Long-Running Jobs Troubleshooting
•Java Memory Settings and Tuning
•Troubleshooting Cloning Issues
•Apps Health Monitoring
•Certification matrix / CPU patchig for Applications and DB.
•Raising DB and Apptier monitoring

14. Oracle Applications Advanced Topics
•Creating Custom Product Top’s
•Creating Custom Concurrent Managers
•Weblogic Installation
•Weblogc Domain Creation
•Weblogic Administration
•RAC  DB and Oracle Applications using effectively.

Top ↑