Oracle R12 Install, Patch and Maintain Oracle E-Business Suite Applications

This course is designed for Oracle Database Administrators, technical consultants and functional implementers.

By the end of this Oracle R12 Install, Patch and Maintain course, delegates will be able to Install Oracle Applications Release 12, apply patches to the Oracle E-Business Suite and run the standard Oracle Applications maintenance utilities. They will have gained an understanding of and be able to use AutoConfig utility and the License Manager. Delegates will also have gained an understanding of Oracle Applications key features and architecture. They will gain an understanding of how an Oracle Applications system can be cloned.

Oracle R12 Install, Patch and Maintain Oracle E-Business Suite Applications Training Course

Course Contents - DAY 1
Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: OVERVIEW OF THE ORACLE E-BUSINESS SUITE

• Oracle E-Business Suite Home Page
• Oracle E-Business Suite Architecture
• Oracle E-Business Suite Technology Stack
• Oracle E-Business Suite Product Overview
• Product Dependencies
• Vision Demo Database

Session 2: PREPARE FOR AN INSTALLATION

• Installation Tools
• Prepare for an Installation
• Overview of Rapid Install
• Release 12 Platform Support
• System Prerequisites
• Create Operating System Accounts
• Setup a Stage Area
• Setup an Installation Environment
• Set Configuration Parameters

Session 3: INSTALL THE ORACLE E-BUSINESS SUITE

• Start Rapid Install
• Rapid Install Log Files
• Overview of Basic Installation Procedure
• Standard Installation
• Express Installation
• Perform an Installation

Oracle R12 Install, Patch and Maintain Oracle E-Business Suite Applications Training Course

Course Contents - DAY 2
Session 4: POST INSTALLATION STEPS

• Log into Oracle Applications
• Change the Default Passwords
• Configure the Database Initialization Parameters
• Security Issues
• Configure Client Software
• Conditional Post Installation Steps
• Backup Oracle Applications

Session 5: COMPONENTS OF THE ORACLE E-BUSINESS SUITE

• The Oracle E-Business Suite Technology Stack
• Database Tier
• Application Tier
• Desktop Tier
• The Oracle E-Business Suite Technology Layer
• The Oracle Applications DBA
• Oracle Application Object Library
• The Oracle E-Business Suite Utilities

Session 6: ENVIRONMENT FILES, CONTROL SCRIPTS AND LANGUAGES

• The Oracle E-Business Suite Environment Files
• The Application Tier Control Scripts
• Character Sets
• Globalization
• National Language Support (NLS)

Session 7: THE ORACLE E-BUSINESS SUITE FILE SYSTEM

• An Overview of the E-Business Suite File System
• The INST_TOP Directory Structure
• The Database Tier File System
• The Application Tier File System
• The APPL_TOP Directory Structure
• The Product Directories
• The Technology Stack Directory
• Common Components Directory
• Java Files and Directories
• The Database Directories

Oracle R12 Install, Patch and Maintain Oracle E-Business Suite Applications Training Course

Course Contents - DAY 3
Session 8: THE E-BUSINESS SUITE DATABASE

• Overview of the Database
• The E-Business Suite Database Objects
• Database Schemas and Oracle Applications Product Schemas
• Database Features Overview
• Performance Features
• Scalability Features
• Business Intelligence Overview
• Server Control Scripts for the Database Tier

Session 9: ADVANCED CONFIGURATION OPTIONS

• Shared Application Tier Load Balancing
• Load Balancing
• Networking Features

Session 10: ORACLE APPLICATIONS AD UTILITIES

• Overview of the Oracle Applications AD Utilities
• Run the AD Utilities
• AD Command Line Arguments
• Use Parallel Processing
• AD Log Files
• Maintenance Mode
• Restricted Mode

Session 11: AD ADMINISTRATION

• Generate Applications Files Tasks
• Maintain Applications Files Tasks
• Maintain Database Entities Tasks
• Compile/Reload Database Entities Tasks
• Non-Interactive Operation and Maintenance Mode

Session 12: SPECIAL UTILITIES

• The AD Controller
• View Worker Status and Resolve a Failed Worker
• Restart a Failed Patch Process
• Restart a Terminated Worker
• Run AD Relink

Session 13: THE AUTOCONFIG UTILITY

• Run AutoConfig
• Context Files
• AutoConfig Tasks
• AutoConfig Operation
• Run AutoConfig
• AutoConfig Log Files
• Roll Back an AutoConfig Session
• Run AutoConfig In Test Mode
• Edit Parameters

Session 14: LICENSE MANAGER

• Access License Manager
• Register Products
• Register the E-Business Suite
• Register Component Applications
• Register Individual Products
• Register Country-Specific Functionalities
• Register Languages
• License Manager Reports

Oracle R12 Install, Patch and Maintain Oracle E-Business Suite Applications Training Course

Course Contents - DAY 4
Session 15: REPORTING UTILITIES

• Introduction to Reporting Utilities
• AD Configuration
• AD File Identification
• AD Job Timing Report

Session 16: CONFIGURATION UTILITIES

• Introduction to Configuration Utilities
• AD Splicer
• File Character Set Converter

Session 17: PATCH THE E-BUSINESS SUITE

• The Patching and AutoPatch Process
• Patch Types and Terminology
• Patch Components
• Download Patches from My Oracle Support
• AutoPatch Operation and Features
• Apply a Patch
• Minimise Patch Downtime
• The Patch Wizard

Oracle R12 Install, Patch and Maintain Oracle E-Business Suite Applications Training Course

Course Contents - DAY 5
Session 18: RUN AUTOPATCH

• The AutoPatch Setup
• AutoPatch Usage and Prompts
• Patch File Name and Location
• AutoPatch Messages
• Patch History
• The Timing Report
• Patch Log Files
• Patch Completion Tasks

Session 19: OAM TIMING REPORTS

• Overview of the OAM Timing Reports
• The Timing Reports Main Page
• AutoPatch Timing Details
• Track a Patch Session
• AD Administration Timing Details
• The Job Timing Report
• The Phase Information Report
• The Exceptions Report

Session 20: OTHER AUTOPATCH TOPICS

• AutoPatch Modes
• AutoPatch Command Line Arguments and Options
• Java Release Infrastructure and Java File Patching
• Deploy Patches
• Merge Patches with AD Merge Patch

Session 21: INFORMATION ABOUT APPLIED PATCHES

• Applied Patch Information and AutoPatch Modes
• Applied Patches: Simple and Advanced Searches
• Applied Patches Reports

Session 22: OVERVIEW OF CLONING ORACLE APPLICATIONS

• Overview of Cloning Oracle Applications
• Cloning Terminology
• Prerequisite Steps
• Cloning Phases
• Prepare the Source System
• Copy the Source System Files to the Target System
• Configure the Target System
• Completion Tasks