Applications Dba Course Content

Oracle Applications(Ebusiness Suite) DBA ---------------------------------------------------------------------------------------------

What you will learn at S.L. Data Solutions? This course provides students with a basic understanding of the architecture, database and file system used in Oracle Applications Release 11i & R12. Students learn about the multi-tier architecture used to provide user access over the Internet or an intranet and the relationship between Oracle Applications and the Oracle database. The course covers the structure of the file system used to store the Oracle Applications product files, environment files, and additional files required to support multiple languages in Release 11i & R12. Students also learn how to use Rapid Install to perform both single and multi-node installations of Oracle Applications, AD Administration and other AD utilities to maintain Oracle Applications, AutoPatch to automate the application of Oracle Applications patches, upgradation to other versions, complete knowledge of all adutilities to administer applications, Making configuration changes using autoconfig, Rapid Clone to clone an Oracle Applications system and knowledge on system administration. It will cover complete 11i and R12.

Prerequisites Knowledge of Oracle SQL and PL/SQL Database administration skills

Course Objectives Introduction to ERP World Oracle Applications Overview Use Rapid Install to install an Oracle Applications system Describe the Oracle Applications Architecture Oracle Applications File System Oracle Applications AD Utilities and Spl Utilities apply patches to an Oracle Applications system Clone an Oracle Applications system Upgrade Oracle applications System administration New features of R12

Course Topics ERP Meaning and ususage of ERP Advantages of Oracle apps as ERP Oracle Applications Overview Oracle E-Business Suite Home Page HTML Interface Forms Interface Oracle Applications Architecture Oracle Applications Technology Stack Product Families Product Dependencies Vision Demo Database Preparing for an Installation Overview of Rapid Install System Requirements Creating Operating System Accounts Setting Up Stage Area Specifying an Installation Environment Selecting Configuration Parameters Rapid Install Log Files Performing an Installation Overview of Basic Installation Procedure Simplest Installation More Typical Installation Standard Installation Steps Single-node Installation Multi-node Installation Oracle Applications File System Database Tier File System Application Tier File System Product Directories APPL_TOP Directories Common Components Directory Java Files and Directories Applications Technology Stack Directory Database Directories Advanced Configuration Options Shared Application Tier File System Load Balancing Network Features Oracle Applications AD Utilities Overview of the AD Utilities

Running the AD Utilities Command Line Arguments Parallel Processing Distributed AD Log Files Maintenance Mode Restricted Mode Special Utilities AD Controller Reviewing Worker Status and Resolving a Failed Worker Restarting a Failed Patch Process Restarting a Terminated Worker Running AD Relink AutoConfig Context Files AutoConfig Tasks AutoConfig Operation Running AutoConfig AutoConfig Log Files Rolling Back an AutoConfig Session Running AutoConfig In Test Mode Editing Parameters License Manager Accessing License Manager Registering Products Registering the E-Business Suite Registering Component Applications Registering Individual Products Registering Country-Specific Functionalities Registering Languages License Manager Reports Reporting Utilities Introduction to Reporting Utilities AD Configuration AD File Identification AD Job Timing Report Configuration Utilities Introduction to Configuration Utilities AD Splicer File Character Set Converter Patching and the AutoPatch Process Patch Types and Terminology Patch Components Downloading Patches from OracleMetaLink AutoPatch Operation AutoPatch Features Applying a Patch

Reducing Patching Downtime Patch Wizard Other Patching Topics AutoPatch Modes AutoPatch Command Line Arguments and Options Java Release Infrastructure and Java File Patching Deploying Patches Merging Patches with AD Merge Patch Cloning Oracle Applications Principles and Terminology Prerequisite Steps Cloning Phases Prepare the Source System Copy Source System Files to Target System Configure the Target System Finishing Tasks Advanced Cloning Options Upgrading Oracle Applications Preparing the system for upgrade Using adutilities to upgrade to higher versions Post upgrade Tasks System administration Complete knowledge on Profiles Benefits of Oracle Applications Manager OAM Dashboard Managing Concurrent Requests and Programs Administering Concurrent Managers Application Responsibilities and Menus Enhancements in R12 New features in R12 Introduction to new tops(INST_TOP) File system comparisons with 11i Complete knowledge on R12