Oracle Apps DBA (R12.2 & 19c)

Oracle EBS 12.2 Has changed, Are you ready?

Oracle EBS 12.2 has under gone major change and introduced Oracle Fusion Middleware Component Oracle WebLogic Server, Online Patching ADOP (replacing ADPATCH), Dual File System (earlier single file system), Startup /Shutdown scripts etc. With both 11i and R12.0 already out of support and R12.1 coming out of support it is important that all the companies using Oracle E-Business Suite must upgrade to Oracle E-Business Suite R12.2 Companies need resources that know and understand Technology Stack (WebLogic & OHS), Patching using ADOP, Concurrent Manager, Cloning E-Business Suite using Rapid Clone and someone who can maintain and support Oracle Applications R12. They need you…..

That’s where YOU come in…

Today, Companies need skilled professionals, who are able to:

  • Manage and Support Oracle E-Business Suite R12
  • Apply patches to not just database using OPatch but also Application Tier Patches using ADOP and ADPATCH
  • Clone Oracle Applications/E-Business Suite from PROD to PRE-PROD or UAT & TEST environments
  • Understand Architecture of Oracle E-Business Suite and Oracle Fusion Middleware Components like WebLogic Server & Oracle HTTP Server on which EBS 12.2 applications are deployed
  • Can troubleshoot any issues like Start-up/Shutdown or patching quickly
  • Able to start/stop services using AD commands and fix issues in start-up

And by the end of this class, you’ll possess all of these skills, and so much more…

Introducing: Oracle Apps DBA R12.2 Training

Become an expert in Oracle Apps DBA by mastering these 10 critical skills.


img

Architecture
img

Installation
img

Patching
img

ADOP
img

ADUtilities
img

AutoConfig
img

Cloning
img

Start / Stop
img

Concurrent Manager
img

Troubleshooting

COURSE BREAKDOWN


  1. APPS DBA TASKS
  2. ORACLE APPS HISTORY
  3. ORACLE EBS ARCHITECTURE
  4. CLIENT TIER
  5. APPLICATION TIER
  6. FORMS SERVLET & SOCKET
  7. CONCURRENT PROCESSING
  8. ARCHITECTURE PREVIOUS VERSION
  9. FMW CONCEPTS
  10. JAVA VS SYSTEM COMPONENT
  11. FMW HOMES
  12. ADMIN & MANAGED SERVER

  1. EBS INSTALLATION KEY POINTS
  2. INSTALLATION OPTIONS
  3. EXPRESS VS STANDARD INSTALL
  4. SINGLE VS MULTI USER INSTALL
  5. STARTCD FEATURES
  6. INSTALLATION TOOL : RAPIDWIZ
  7. SUPPORTED O.S.
  8. INSTALLATION HIGH LEVEL STEPS
  9. HARDWARE REQUIREMENT
  10. INSTALLATION PHASES
  11. STAGING AREA
  12. INSTALLATION IN ACTION
  13. R12.2 INSTALLATION LOGS: DB TIER
  14. R12.2 INSTALLATION LOGS: APPS TIER

  1. FILE SYSTEM: DB & APPS TIER
  2. DUAL FILE SYSTEM
  3. NON EDITION FILE SYSTEM
  4. INSTANCE HOME
  5. FMW HOME
  6. APPL TOP
  7. COMMON TOP
  8. LOG HOME
  9. ENVIRONMENT FILES
  10. CONSOLES (WEBLOGIC & FMW CONTROL)

  1. R12.2 SERVICES START/STOP OVERVIEW
  2. APPS TIER SERVICES IN DETAIL
  3. APPS ADMIN SERVICE START/STOP
  4. R12.2 WEB/OHS & MANAGED SERVICE START/STOP
  5. R12.2 WEB APPLICATION & OTHER SERVICES
  6. START/STOP ALL APPS TIER SERVICES
  7. START/STOP DATABASE & LISTENER
  8. START/STOP DATABASE & LISTENER
  9. ACTIVITY GUIDE: START/STOP IN EBS R12.2

  1. AD UTILITIES
  2. AD ADMIN
  3. MAINTAIN APPLICATION FILE MENU
  4. COMPILE RELOAD DATABASE ENTITIES TASKS
  5. MAINTAIN DATABASE ACTIVITIES
  6. AD CONTROLLER
  7. AD RELINK,AD MERGE PATCH,AD CONFIGURATION, AD JOB TIME REPORT
  8. AD FILE IDENTIFICATION AND LICENSE MANAGER
  9. ADMON UTILITY
  10. ACTIVITY GUIDE: AD UTILITIES

  1. PATCH WHAT & WHY
  2. PATCH COMPONENTS (APPS, DB, WLS, OHS, FORMS)
  3. PATCH TYPES
  4. PATCH STRUCTURE
  5. ADOP: ONLINE PATCHING
  6. DUAL FILE SYSTEM
  7. EDITION BASED REDEFINITION (REQUIRED?)
  8. ADOP ENVIRONMENT VARIABLES
  9. ADOP PHASES/CYCLE
  10. ADOP OPTIONS
  11. ADOP: MODES
  12. ADOP MONITOR/span>
  13. APPLYING TECHNOLOGY PATCHES
  14. ACTIVITY GUIDE: PATCHING & ADOP

  1. WHAT IS CLONING?
  2. RAPID CLONE BASIC STEPS
  3. ORAINVENTORY
  4. PREPARE SOURCE DATABASE TIER
  5. PREPARE SOURCE APPS TIER
  6. CONFIGURE TARGET DATABASE TIER
  7. CONFIGURE TARGET APPS TIER
  8. FINISHING TASK & TROUBLESHOOTING
  9. MULTINODE TO MULTINODE ATTACH HOME RELINK SETUP CLEAN
  10. ACTIVITY GUIDE: CLONING IN EBS R12.2

  1. CONCURRENT PROCESSING AND ITS FEATURES
  2. CONCURRENT MANAGER AND ITS TYPES
  3. CONCURRENT REQUEST AND ITS PHASES LOG FILES PURGING
  4. QUEUE, PROFILE, DATABASE TABLE DESCRIPTION
  5. WORKSHIFTS, CACHE SIZE, SLEEP SECONDS, ICM, CONCURRENT PROFILES
  6. GENERAL ISSUES
  7. ACTIVITY GUIDE: CONCURRENT MANAGERS

  1. AUTOCONFIG: WHAT & WHY
  2. ROLE OF AUTOCONFIG
  3. AUTOCONFIG COMPONENT
  4. RUNNING AUTOCONFIG ON APPS TIER
  5. ENABLE AUTOCONFIG ON DB TIER
  6. RUNNING AUTOCONFIG ON DB TIER
  7. ACTIVITY GUIDE: AUTOCONFIG - APPS & DB TIER

  1. CHANGING PASSWORD: MANAGING PASSWORD IN ORACLE APPLICATIONS, TROUBLESHOOTING
  2. CREATING USER AND ASSIGNING RESPONSIBILITIES
  3. UPDATING AND CHECKING PROFILE OPTIONS
  4. ORACLE APPLICATION MANAGER(OAM) OVERVIEW
  5. ACTIVITY GUIDE: PASSWORD MANAGEMENT

  1. TROUBLESHOOTING OHS/APACHE
  2. TROUBLESHOOTING WEBLOGIC/OACORE.OAFM
  3. TROUBLESHOOTING START/STOP
  4. TROUBLESHOOTING JDBC/DB CONNECTION
  5. TROUBLESHOOTING CONCURRENT MANAGERS
  6. TROUBLESHOOTING PATCHING
  7. TROUBLESHOOTING CLONING
  8. COMMON ISSUES
  9. ACTIVITY GUIDE: TROUBLESHOOTING & SCALABILITY