An Oracle Applications DBA is distinct from Oracle database administrators. Oracle Applications Database administrators require specialized skills in business administration and Oracle application server architectures. Oracle Apps DBA tasks (Oracle Financials, Oracle eBusiness Suite) are a complex framework of modules that can consistently perform basic business administration tasks.
Course Contents
Oracle Applications Technology Desktop Tier
Single-node Installation
Patching and the AutoPatch Process
Patch Types, Terminology, and Components
AD Online Patching Utility Oracle Applications Technology
What are the AD Utilities? Managing Concurrent Programs and Reports Reduced Role for AutoConfig Managing Printers
Rapidclone Concepts Creating Users Introduction to Oracle Workflow Creating Users User connectivity issues TroubleshootingDay 1
Oracle Applications Overview
R12 Oracle E-Business Suite Architecture
Oracle Applications Environment Files, Server Process Scripts, and Languages
Oracle Applications File System
Oracle Applications Database
Oracle E-Business Suite Multi-Tier Architecture
Application Tier
Database Tier
Oracle Homes ArchitectureRelease R12 Installation
Multi-node InstallationHands-on installation of E-Business Suite R12
Day 2
R12 Patch and Maintain Oracle Applications
Patch Advisor
Running AutoPatch
Other Patching Topics
Patch History DatabaseOnline Patching Concepts
Patch Creation and Patching Order
Patching Utilities
Introduction to Online Patching
Architectural Changes to Support Online Patching
Database Implementation
Editioning Views and the Application Data Model
Phases of the Online Patching CycleRunning the AD Online Patching Utility
Running the adop Utility
adop Commands
Executing the Patching Cycle
Status of a Patching Cycle
Patching in Multi-Node Environments
adop Remote Invocation
Hotpatch Mode
Day 3
File System
Oracle Applications Environment Files and Server Process Scripts
Oracle Applications Entire File System
The Applications and Database Context FilesR12 Use Oracle Applications AD Utilities
AD Administration
Special Utilities
Context Editor
AutoConfig
License Manager
Reporting Utilities
Configuration Utilities
Concurrent
Administering Concurrent Managers
Managing Profile Options
Incorporating a Custom Program
Day 4
AutoConfig and Configuration Changes
Configuration Tools
New AutoConfig Tools for System Configuration
Service Groups and Services in Release R12.1.3/12.2.3
AutoConfig Managed Service Groups and Services
Managing Oracle HTTP Server Configurations
Web Applications
Summary of Configuration Changes
Autoconfig Template and Driver files Concepts
Printers
Registering Printers
Troubleshooting Printer Issues
Details of Autoconfig. What exactly happens while running autoconfig
Release R12 Autoconfig Lab
Running Autoconfig on the existing Oracle Application.
Day 5
R12 Oracle Applications Advanced Topics
Cloning Concepts (Manual/RMAN Cold & Hot Backup)
Cloning From Single node to Single node
Cloning From Multi-Node to Multi-Node
Cloning From Multi-Node to Single-Node
Database Refresh
Post-Clone Procedures
Security
Assigning Responsibilities
FNDCPASS Concepts
Changing User Passwords using FNDCPASS
Workflow
Workflow Configuration
Workflow Troubleshooting
Day 6
R12 System Administrator Fundamentals
System Administration
Assigning Responsibilities
Setting Up Printers
Changing Profile Options
Troubleshooting & Performance Tuning
Apache Troubleshooting
Jserv Troubleshooting
OC4J Troubleshooting
Forms & Concurrent Processing Troubleshooting
Autoconfig related issues Troubleshooting
Long-Running Jobs Troubleshooting
Java Memory Settings and Tuning
Troubleshooting Cloning Issues
Apps Health Monitoring