Winsomesoft

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.