Oracle 12.2 Apps DBA

Course Available Modes : Classroom, Online & Recorded Sessions

Duration

​30 days
daily 80 minutes

Pre-Requisite

Oracle DBA

Course Fee

WDP ​Classroom - Rs. 15,000/- INR
Online - Rs. 30,000/- INR
Recordings - Rs. 20,000/- INR
About Trainer
Mr. Mark (OCP)
12 years of Apps DBA experience

​​He works as an Oracle Apps DBA Senior Consultant & Instructor having 12+ years of Real-time experience.

Course

Design
Oracle R12.2 APPS DBA course content is designed by merging multiple ORACLE Courses and Taught by Certified Trainer
•    R 12.2 Oracle Applications System Administrator Fundamentals
•    R 12.2 Install/Patch/Maintain Oracle E-Business Suite
 

Workforce Development Program

​WDP KIT  -  MAIN BENEFITS
​•  Course Completion Certificate from Oracle

•  25% Discount on Certification exam vouchers

•  50% Discount on student Self Test Software

​•  Course Material designed by Oracle Team
 

Course Content

​Introduction to ERP
  • Introduction to Enterprise Resource Planning (ERP)
  • Proprietary ERP Software
  • Origin of ERP

Introduction to Oracle E-Business Suite
  • Introduction to Oracle E-Business Suite as an ERP Solution,
  • Components / Product-Lines,
  • How Oracle Applications Works? And related Terminology.
 
Oracle Applications Architecture
  • Different Topologies in Oracle Applications
  • 3-Tier Architecture
  • Single Node Architecture
  • Multi Node Architecture
 
Installation of Oracle E-Business Suite R12
  • Systematic approach for Installing Oracle Apps 11i & R12 (Single Node & Multi Node)
  • Installation of Operating System
  • Pre-requisites configuration on OS before installing Apps 12.2
  • Installation of Oracle Apps 12.2.x (Vision,  Info on Fresh database Install, Upgrade mode Installation, Express Install )
  • Post steps after Apps installation
 
Oracle Applications File System layout
  • Deep Dive into Oracle Applications file systems  (FS1- Run file system, FS2- Patch file system, FS_NE - Non Editioned file system,  Shared APPL_TOP)
  • Deep Dive into Oracle Apps 12.2.x Database Layout (APPS, APPLSYS, APPLSYSPUB, APPS_NE, GUEST etc..)
 
Application Service Groups
  • Root (OPMN, Node Manager)
  • Admin (Admin Server)
  • Web Entry Point (HTTP)
  • Batch Processing Services
  • Other Services
 
Password Maintenance
  • Password Changing Activity in Oracle Applications 12.2.x (FNDCPASS, Weblogic Console, Weblogic Data source. APPS Password Encryption Info & dependency)
 
 
Autoconfig Engine
  • Context file
  • Driver files
  • template files
  • configuration files
  • context editor
  • Customizations using Autoconfig
  • Customization using autoconfig templates
 
HTTP Server changes in 12.2.x
  • HTTP Server and its Changed behavior in 12.2.x (Connection Redirection with mod_wl_ohs.conf, apps.conf, httpd.conf etc.,)
 
 
Managing concurrent programs
  • Lifecycle of Concurrent Requests, Request sets, Defining custom managers, Internal Monitor, Generic Service Manager, Transaction Managers)
  • Parallel Concurrent Processing(PCP) in 12.2.x
 
Profiles in 12.2.x
  • Working with Profile options in 12.2.x(Site Level, org level, resp level, server level, user level, hierarchy, visibility of profile options)
 
Change management in 12.2.x
  • Autoconfig, FMW Control or EM Console, Weblogic Admin Console, Context editor
 
Oracle Applications Manager (OAM)
  • System Management using OAM(OAM Dashboard, Sitemap, system monitoring, diagnostic tools in OAM)
 
APPS DBA Online Patching (ADOP)
  • Anatomy of a patch, Patch wizard
  • PREPARE- In depth of Prepare Phase
  • APPLY - In depth of Apply Phase with all options, HOT PATCH, DOWNTIME MODE
  • FINALIZE, CUTOVER , DUMMY CUTOVER, CLEANUP,PRECAUTIONS TO SPEEDUP CUTOVER,FINALIZE
  • Trouble shooting ADOP
 
Opatch Utility
  • Working with Patching tools (OPATCH, Smart Update (BSU) )
 
Apps Cloning in 12.2.x
  • Cloning Oracle applications in 12.2.x(Rapid clone)
  • Advanced Cloning options in 12.2.x (Single-Node Cloning, Multinode Cloning, Cloning issues/Fixes)
 
Troubleshooting & Tuning in APPS
  • Troubleshooting / Performance Tuning - (Proactive, Reactive Tuning, DB Tuning with parameters, Introduction to database statistics)
  • Wait-Events in Oracle Applications database, Troubleshooting a long running request in Oracle Applications 12.2.x)
  • Troubleshooting/Performance tuning Weblogic Managed Servers (OACORE, OAFM, FORMS_SERVER, Admin Server, Node Manager)
  • Troubleshooting/Performance Concurrent Manager, Gather stats

Upgrading Oracle Apps
  • Upgrade Oracle Applications from 12.2.0 to 12.2.4


​

PROGRAM FEATURES

  •         Included in Classroom Trainings        
  •            Included in Online Trainings         
  •            Included in Recorded Sessions          
<
>
​Classroom Live Sessions by Expert Trainer:
   -  Mr. Akal Singh is an Senior Oracle DBA consultant and Oracle
      Certified MASTER (OCM) Trainer having 17 years of experience,
      Handled above 500 batches in India and Asia Pacific region.
   -  Sessions by Mr. Akal Singh (OCM) with real-time examples
   -  ​Trainer always available to clarify your doubts and technical issues
 
Course Material:
   -  Courses and material designed by Experts
   -  We provide printed study material
   -  We provide printed step-by-step lab practice material
   -  Online Material for additional reading
​
Lab environment to Practice:
   -  Best Oracle DBA Institute with Certified Lab Assistance to assist you
​      during practice
   -  Labs Equipped with Best Infrastructure & dedicated systems to
​       practice
   -  Unlimited Lab accessibility
   -  Self checklist document to follow the course program

​
Vertical Divider
Oracle WDP Authorized Kit Benefits:
   -  Access to Authorized Course Material provided from ORACLE.
   -  Hands on practical lab experience on Oracle Software.
   -  Course Completion Certificate from Oracle.
       (which will be eligible for Oracle Certification Exams)
   -  Discounts on Oracle certification exams and Self Test Software
          -   25% discount on Oracle Certification Exam Vouchers            
          -   50% discount on student Self Test Software
​
Additional Benefits:
   -  Questionnaire after every topic to improve knowledge
   -  Online Daily Exams to build your confidence
   -  Online Weekly Technical Tests
   -  Individual attention and group discussions for Interview
​      preparation
   -  Guidance for Oracle Certification exams
   -  Resume Preparation
 
 
*  100% Placement Assistance
*  ​100% Satisfaction guaranteed
​Online Live Sessions by Expert Trainer:
   -  Mr. Akal Singh is an Senior Oracle DBA consultant and Oracle
      Certified MASTER (OCM) Trainer having 17 years of experience,
      Handled above 500 batches in India and Asia Pacific region.
   -  Sessions by Mr. Akal Singh (OCM) with real-time examples
   -  ​Trainer always available to clarify your doubts and technical issues
 
Course Material:
   -  Courses and material designed by Experts
   -  We provide printed study material
   -  We provide printed step-by-step lab practice material
   -  Online Material for additional reading
​
Lab environment to Practice:
   -  Best Oracle DBA Institute with Certified Lab Assistance to assist you 
​      during online practice
   -  CompleteTechnical assistance in building your self Lab environment in
​      your local system  ( recommended )
   -  On request we provide online lab environment too ( limited for
      2 months only, can be extended )
   -  Self checklist document to follow the course program
​
Vertical Divider
Oracle WDP Authorized Kit Benefits:
   -  Access to Authorized Course Material provided from ORACLE.
   -  Hands on practical lab experience on Oracle Software.
   -  Course Completion Certificate from Oracle.
       (which will be eligible for Oracle Certification Exams)
   -  Discounts on Oracle certification exams and Self Test Software
          -   25% discount on Oracle Certification Exam Vouchers            
          -   50% discount on student Self Test Software

Additional Benefits:
   -  Questionnaire after every topic to improve knowledge
   -  Online Daily Exams to build your confidence
   -  Online Weekly Technical Tests
   -  Individual attention and group discussions for Interview
​      preparation
   -  Guidance for Oracle Certification exams
   -  Resume Preparation
 
 
*  100% Placement Assistance
*  ​100% Satisfaction guaranteed
Recorded Sessions by Expert Trainer:
   -  Mr. Akal Singh is an Senior Oracle DBA consultant and Oracle
      Certified MASTER (OCM) Trainer having 17 years of experience,
      Handled above 500 batches in India and Asia Pacific region.
   -  Sessions by Mr. Akal Singh (OCM) with real-time examples
   -  ​You can clarify your doubts & technical Issues with Trainer thru email / phone / whatsapp
 
Course Material:
   -  Courses and material designed by Experts
   -  We provide study material (pdf)
   -  We provide you step-by-step lab practice material (pdf)
   -  Online Material for additional reading
​
Lab environment to Practice:
   -  Best Oracle DBA Institute with Certified Lab Assistance to assist you 
​      during online practice
   -  Complete Technical assistance in building your self Lab environment in
​      your local system  ( recommended )
   -  On request we provide online lab environment too ( limited for
      2 months only, can be extended )
   -  Self checklist document to follow the course program
Vertical Divider
Oracle WDP Authorized Kit Benefits:
   -  Access to Authorized Course Material provided from ORACLE.
   -  Hands on practical lab experience on Oracle Software.
   -  Course Completion Certificate from Oracle.
       (which will be eligible for Oracle Certification Exams)
   -  Discounts on Oracle certification exams and Self Test Software
          -   25% discount on Oracle Certification Exam Vouchers            
          -   50% discount on student Self Test Software

Additional Benefits:
   -  Questionnaire after every topic to improve knowledge
   -  Guidance for Oracle Certification exams
   -  Resume Preparation
 
 
*  100% Placement Assistance
*  ​100% Satisfaction guaranteed
Course Enquiry Form
STUDENT FEEDBACK
Course Reviews
Google Reviews
Vertical Divider
akswave-trainings.com  © 2014