Oracle Apps DBA

Reading Time: 3 minutes

Oracle Apps DBA

    Module 1: Oracle E-Business Suite 11i, R12.1.3/12.2.3 Architecture

    • Introduction to Oracle E-Business Suite 11i, R12.1.3/12.2.3
    • Oracle E-Business Suite 11i, R12.1.3/12.2.3 Architecture
    • Oracle E-Business Suite 11i,
    • 1.3/12.2.3 Multi-Tier Architecture
    • Desktop Tier
    • Application Tier
    • Database Tier
    • Oracle Homes Architecture
    • Oracle E-Business Suite Technology Layer

    Module 2: Installation

    • Single Node Installation (12.1 and 12.2)
    • Multi-Node Installation (12.1 and 12.2).
    • Context File and Interpretation.

    Module 3: File System

    • Oracle Applications Technology
    • Oracle Applications Environment Files and Server Process Scripts
    • Oracle Applications Entire File System
    • The Applications and Database Context Files

    Module 4: AD Utilities

    • What are the AD Utilities?
    • AD Administration
    • Special Utilities
    • Context Editing
    • Reporting Utilities
    • Configuration Utilities

    Module 5: Concurrent Managers

    • Managing Concurrent Programs and Reports and Output Post processor.
    • Administering Concurrent Managers
    • Managing Profile Options
    • Incorporating a Custom Program
    • Scheduling requests and Request Sets

    Module 6: Patching

    • Patch Types, Terminology, and Components
    • 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 Cycle

    Module 7: Running the AD Online Patching Utility

    • 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

    Module 8: AutoConfig and Configuration Changes

    • Reduced Role for AutoConfig
    • 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

    Module 9: Cloning

    • Rapidclone Concepts
    • Cloning From Single node to Single node
    • Cloning From Multi-Node to Multi-Node
    • Cloning From Multi-Node to Single-Node
    • Database Refresh
    • 2.X and R12.1.X key changes
    • Post-Clone Procedures

    Module 10: Security

    • Creating Users
    • Assigning Responsibilities
    • FNDCPASS Concepts
    • Changing User Passwords using FNDCPASS

    Module 11: Workflow

    • Workflow Configuration
    • Workflow Troubleshooting and Debugging

    Module 12: System Administration

    • Creating Users
    • Assigning Responsibilities
    • Setting Up Printers
    • Changing Profile Options.
    • XML Publisher and Administration in DBA Perspective.
    • Code Migrations and awareness on Migration tools.
    • Key roles in Support for APPS DBA.
    • OAF Migrations

    Module 13: Troubleshooting & Performance Tuning

    • User connectivity issues Troubleshooting
    • 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
    • Certification matrix / CPU patchig for Applications and DB.
    • Raising DB and Apptier monitoring

    Module 14: Oracle Applications Advanced Topics

    • Creating Custom Product Top’s
    • Creating Custom Concurrent Managers
    • Weblogic Installation
    • Weblogc Domain Creation
    • Weblogic Administration
    • RAC DB and Oracle Applications using effectively.