ORACLE APPS DBA

Course Overview :

An Oracle Applications DBA is very different from a regular Oracle database administrator and requires specialized skills in business administration and Oracle application server architectures. The Oracle Applications DBA job role is less compartmentalized than a traditional Oracle DBA and the Oracle Applications DBA must also have skills in these areas Database Design, Oracle Application Server, Functional Expertise.

Prerequisties

• All attendees should have a basic knowledge of configuration.

Course Content

• R12 Oracle Applications Install
  • Oracle Applications Overview
  • Preparing for Your Installation
  • Single-node Installation
  • Multi-node Installation
  • Finishing Your Installation
• Components and Architecture
  • Components – Client, Web Node, Forms and Concurrent Nodes, Admin and Database Node
  • Apps Architecture
  • Best Practices
• Configuration
  • Application Context File
  • AD Config
  • Web and Forms Node Config
  • Admin and Concurrent Node Config
  • DB config
  • Best Practices
• Monitoring and Troubleshooting
  • Methods of Monitoring
  • Database
  • Apache Server
  • Forms Server
  • Concurrent Manager
  • Network
  • Best Practices
• Performance Tuning
  • Identifying Performance issue
  • Developing an Action Plan
  • Tuning the Database
  • Tuning the Server
  • Tuning the Apps Tier
  • Trace Files
  • Common performance issues
  • Best Practices
• Patching
  • Application Patching
  • Types of Application Patches
  • Getting ready to Patch
  • Applying Patches
  • Monitoring and Resolving Patching problems
  • Post Patching Steps
  • Patching Cleanup
  • Database Patching
  • Best Practices
• Tool kit
  • APPS utilities and commands
  • Startup and Shutdown scripts
  • Changing passwords
  • Relinking Executables
  • Regenerating Forms, Libraries and Menus
  • Determining Component Versions
  • Scheduling Scripts
  • Application Instance Clones