Oracle 12.x Patch, Install and Maintain

Course code: O1291

5 days £2,750.00

Oracle 12.x Patch, Install and Maintain hands on training for Oracle eBusiness Suite.

Course content >

Who Should Attend?

  • Oracle DBA's
  • Oracle Functional Consultants
  • Oracle Technical Consultants
  • Oracle Support Teams
  • Oracle Project Managers


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


Course Contents

Hands on Oracle r12.x trainng course exploring the installation and maintenance of the Oracle eBusiness Suite, releases 12.0 & 12.1.

The configuration, monitoring, tuning, patching and support of th Oracle eBusiness Suite can be a daunting task: this essential course will provide attendees with a practical, comprehensive overview of the functions and processes found with the eBusiness Suite.
Attendees will explore standardised and Express installation types moving on to explore maintenance issues with hands on exercises providing practical experience in R12 tools, utilities. Attendees will also explroe in detail Oracle E-Business Suite patching tasks and good practice.

As with all iTrain courses this can be delivered as a closed course on your site or a third party location. As company specific training iTrain will work with you to tailor content to your organisation and project's specific requirements and objectives. To assist with this iTrain provide a full mobile classroom the Classroom in a Box.

Oracle E-Business Suite Overview
Oracle E-Business Suite Introduction
Oracle E-Business Suite Architecture
Oracle E-Business Suite Installation Tools

Preparing For Your Installation
Overview of Rapid Install
Supported Platforms and Environments
Prerequisites and Preparatory
Tasks Starting Rapid Install
Obtaining Help

Performing an Installation
Installation Types and Options Standard Installation
Express Installation

Finishing Your Installation
Post-Installation Steps
Administration and Maintenance Tasks
Oracle E-Business Suite Components
Oracle E-Business Suite Technology Stack
Desktop Tier
Application Tier
Database Tier
Oracle E-Business Suite Technology Layer
Oracle Applications DBA
Oracle Application Object Library
Oracle E-Business Suite Utilities

Environment Files, Control Scripts, and Languages
Oracle E-Business Suite Environment Files
Application Tier
Service Control
Scripts Character Sets
Globalization Features
Language Support

Oracle E-Business Suite File System
File System Overview
INST_TOP Directory
Structure Database
Tier File System Application
Tier File System APPL_TOP Directory Structure
Product Directories
Technology Stack Directory
Database Directories

Oracle E-Business Suite Database
Database Overview
Oracle E-Business Suite Database Objects and Schemas
Implementing Multiple Organizations
Reporting Currencies
Monitoring Features
Performance Features
Scalability Features
Database Tier Server
Control Scripts

Advanced Configuration Options
Shared Application Tier File System
Load Balancing
Network Features

Using the AD Utilities
Setting the Environment
The AD Utilities
Command Line Arguments and Flags
AD Utilities Features and Prompts
Parallel Processing Options and Distributed AD
Log and Restart Files
Maintenance Mode
AD Administration: Generate Applications Files Tasks
Preliminary Tasks
Prompts and Log Files
Generate Applications Files Menu
Generate Message Files
Generate Form Files
Generate Report Files
Generate Product JAR Files

AD Administration: Maintain Applications Files Tasks
Maintain Applications Files Menu
Relink Applications Programs
Copy Files to Destinations
Convert Character Set
Maintain Snapshot
Information Checking for Missing Files
Performing File System Tasks

AD Administration: Maintain Database Entities Tasks
Maintain Database Entities Menu
Validate APPS Schema
Recreate Grants and Synonyms
Maintain Multi-lingual Tables
Check DUAL Table

AD Administration: Compile/Reload Database Entities Tasks
Compile/Reload Database Entities Menu
Compile APPS Schema
Compile Menu Information
Compiling Flexfield Data in AOL Tables
Reloading JAR Files into Database

AD Administration: Non-Interactive Operation and Maintenance Mode
Creating AD Administration Defaults File
Running AD Administration in Non-Interactive Mode
Using Maintenance Mode

Special Utilities
AD Controller Overview
Worker Status Flow
Restarting an AD Utility
Shutting Down Managers
AD Relink Overview
Running AD Relink

AutoConfig Overview
Context Files
AutoConfig Tasks
Running AutoConfig
AutoConfig Log Files
Rolling Back an AutoConfig Session
Running AutoConfig in Test Mode
Other AutoConfig Features

License Manager
Accessing License Manager
Registering Oracle E-Business Suite
Registering Component Applications
Registering Individual Products
Registering Country-Specific Functionalities
Registering Languages
License Manager Reports

Reporting Utilities
AD Configuration
AD File Identification
AD Job Timing Report

Configuration Utilities
AD Splicer Overview
AD Splicer Control Files
Editing newprods.txt File
Post-Splice Steps
File Character Set Converter

Patching and the AutoPatch Process
Patch Terminology and Components
Downloading Patches
AutoPatch Features
Patch Wizard
Running AutoPatch
OAM Timing Reports
Other Patching Topics
Applied Patches Information

Cloning Oracle E-Business Suite
Principles and Terminology
Cloning Scenarios
Prerequisite Steps
Cloning Steps
Finishing Tasks
Refresh a Target System
Clone a Multi-Node System
Add a Node to an Existing System

Contact us for more information