Loading...

Oracle R12 Applications DBA

Course code: G1090

3 days £1,380.00
+ VAT

This course is designed for the existing DBA to transfer skills to the management, administration and support of the full Oracle R12 Applications stack.

Course content >

Who Should Attend?

  • Database Administrators
  • Technical Consultants

Prerequisites

iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835

COURSE DATES

Course Contents

This course is designed for the existing DBA to transfer skills to the management, administration and support of the full Oracle R12 Applications stack. Covering the configuration, monitoring, tuning, patching and support of the Oracle eBusiness Suite can be a daunting task: we aim to provide a practical, comprehensive overview of the functions and processes found with the eBusiness Suite.

Oracle Applications Suite Evolution

  • Installation Overview
  • Release R12 Architecture
  • Release R12 Upgrade Overview

Components & Architecture

  • Servicing User Requests
  • Oracle Applications Components
  • The Client
  • Web & Forms node
  • Admin & Database node
  • Oracle Applications Architecture
  • Fundamental & Advanced
  • Architecture & Best Practices

Configuration

  • The Application Context File - Locating, Modifying.
  • Creating port number conventions
  • Using AD Configuration - Executing, Reviewing.
  • Web Node Configuration
  • Apache Config files
  • Forms Node Configuration
  • Concurrent Processing Node
  • Admin Node Configuration
  • Environment files
  • Additional Service Components
  • Database Node Configuration
  • Additional Configuration Topics
  • Best Practices

Plan for the Upgrade

  • New features
  • Rapid Install
  • Maintenance Wizard

Prepare for Upgrade

  • Documentation resources

Monitoring & Troubleshooting

  • Methods for Monitoring
  • Database Monitoring & Troubleshooting.
  • Apache Server Monitoring and Troubleshooting.
  • Forms Monitoring & Troubleshooting.
  • Concurrent Manager Monitoring.
  • Server Monitoring & Troubleshooting.
  • Network Monitoring
  • Ping & Tracert
  • Additional Topics
  • Best Practices

Performance Tuning

  • Performance Tuning Process
  • Performance issues
  • Resolving Performance Issues
  • Tuning the Database, Server &
  • Application Tier.
  • Common Performance Issues
  • Best Practices

Patching

  • Applications Patching
  • Types of Application Patches
  • Preparing to Patch
  • Applying Patches
  • Monitoring & Resolving Patching Problems.
  • Post-Patching Steps
  • Patching Cleanup
  • Database Patching
  • Patching Best Practices

Cloning Overview

  • Rapid Clone
  • The Cloning Process
  • Restoring a Full-Stack Clone
  • Cloning Cleanup

Toolset

  • Oracle Applications Utilities & Commands.
  • Determining Versions
  • Scheduling Scripts
  • Applications Maintenance

Resources

  • Working with Oracle Support
  • MetaLink Search Techniques
  • Oracle Support Service Requests
  • Resource Summary
Contact us for more information