Training    ORACLE Database Administration      Oracle Apps DBA

Oracle Apps DBA


Prerequisties

Database Administrator
Fundamentals of Oracle eBusiness Suite

Target Job Roles

Oracle Apps DBA

Target Proffesional Accrediations

Oracle Certified Apps DBA Professional

Format

Class room
Online (Web and Audio conference)
On-Site at your facility
  

Course Outline

Module 1:Components and Architecture

Content:
Components - Client, Web Node, Forms and Concurrent Nodes, Admin and Database Node
Apps Architecture
Best Practices

Module 2:Configuration

Content:
Application Context File
AD Config
Web and Forms Node Config
Admin and Concurrent Node Config
DB config
Best Practices

Module 3:Monitoring and Troubleshooting

Content:
Methods of Monitoring
Database
Apache Server
Forms Server
Concurrent Manager
Network
Best Practices

Module 4:Performance Tuning

Content:
Identifying Performance issue
Developing an Action Plan
Tuning the Database
Tuning the Server
Tuning the Apps Tier
Trace Files
Common performance issues
Best Practices

Module 5:Patching

Content:
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

Module 6:Toolkit

Content:
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