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.