erpSchools

Apps DBA online training course topics

Register for FREE Demo Session

1. Batch Starts from 13-Dec-2014
2. Only on Saturday & Sunday
3. Duration: 16 sessions and 3 hrs / session = 48 hours Register

Highlights

1) Best price in the market, just $399
2) We cover more number of topics than anyone else.
3) Includes online server access

  • Introduction to ERP and Oracle Applications

    • What is ERP
    • Popular vendors in ERP market
    • Oracle Applications as ERP
    • Prerequisites to learn apps dba
    • Different teams in oracle apps projects
    • Different versions in oracle apps
    • Roles and responsibilities of apps dba

  • Oracle Applications Architecture

    • What is node/service/server/tier
    • Oracle applications architecture model
    • Client tier
    • Middle tier or Application tier
    • database tier
    • Supported browsers
    • Single node Vs Multinode
    • What is Apache server
    • static pages Vs dynamic pages
    • Components of Apache server (Web listener, Servlet engine, OPMN)
    • Form server
    • what is applet
    • Forms desktop client
    • Socket vs servlet mode
    • Concurrent processing features
    • Workflow introduction

  • Installing R12 applications single/Multi node on OEL/RHEL

    • Performing prerequisite steps
    • Checking hardware requirements, memory requirements and cpu requirements.
    • Checking operating system requirements.
    • Checking kernel requirements.
    • Checking and installing required rpm’s.
    • Verifying hostnames.
    • Creating users and groups for installation
    • set up the stage area
    • Running rapidwiz from stage area to install oracle applications
    • Performing post installation steps

  • Apps file system structure

    • High level File system overview
    • APPL_TOP
    • COMMON_TOP
    • INST_TOP
    • 10.1.2 oracle home
    • 10.1.3 oracle home
    • Database oracle home
    • Core technology directories (AD,FND,AU,ADMIN,ALR,AK,XML)
    • Product directories
    • Starting and stopping scripts
    • The DBC file
    • Context Files
    • Configuration files
    • Log files
    • Environmental files

  • Starting and stopping application services

    • Sequence to start/stop application services
    • Performing health checks
    • Checking Form server status
    • Checking Apache server status
    • Checking Concurrent manager services
    • Concurrent managers dependency on database

  • Apps database layout

    • Different schemas in oracle application databases
    • Product schemas
    • special schemas
    • Front end users
    • code objects and data objects
    • apps/applsys schemas importance
    • sysadmin user
    • Tablespace model(OATM)

  • AD utilities:- adrelink, adident, adadmin

    • ntroduction to AD utilities
    • Finding file version using adident
    • Finding file versions using strings command
    • Linking executables using adrelink
    • Running adadmin
    • Various menus in adadmin

  • Oracle application cloning

    • Introduction to Oracle Applications Cloning
    • Why and When to clone Oracle Applications
    • Various options for cloning oracle applications.
    • What is adpreclone and adcfgclone 
    • Rapid clone (cloning with cold & hot backups).
    • Cloning with rman.
    • Cloning Methods
    • Post clone steps

  • Troubleshooting oracle application issues

    • Troubleshooting Autoconfig.
    • Troubleshooting Ad patch.
    • Troubleshooting Login issues.
    • Troubleshooting Cloning issues.
    • Troubleshooting concurrent manager issues.
    • Troubleshooting Apache server.
    • Troubleshooting Forms server.
    • Troubleshooting JVMS.

  • Tuning all layers of oracle applications

    • Tuning Concurrent managers
    • Cache size
    • Sleep cycle
    • Number of processes
    • Table reorg
    • Tuning Apache 
    • No of JVM\’s
    • JVM heap size
    • Tuning Form server
    • Socket vs. Servlet

  • Autoconfig

    • Introduction to Autoconfig
    • Context files(XML)
    • Context Editor(OAM)
    • Autoconfig scripts
    • Different phases of Autoconfig
    • Driver file, Template file, configuration files
    • Running Autoconfig in check mode
    • How to view ADX(check config) report
    • Running Autoconfig in DB and App Tiers.
    • Configuration and log files
    • Restoring(roll back) Autoconfig session
    • Running Autoconfig in phase wise  
    • Running Autoconfig on multinode environment
    • Running Autoconfig in parallel mode
    • Customizing Autoconfig environment
    • Finding templates for given configuration files and vice versa
    • adtmplreport tool
    • Rebuilding database Context file(xml)
    • Rebuilding application context file(XML)
    • Regenerating DBC file
    • Resolving Autoconfig version conflicts

  • Adpatch &Ad Merge patch

    • Introduction to applications patching
    • Introduction to Auto patch
    • Types of patches
    • Various tools to Apply Patch
    • How to check whether a patch is applied or not
    • Introduction to Patch driver file(u_PNO.drv)
    • C, D, G Drivers
    • Various tables related to Auto Patch
    • Running Auto patch in Test mode
    • Reviewing Autopatch log files
    • Running Auto  patch in Interactive mode
    • Reviewing worker log files
    • Running Auto  patch in Non Interactive mode
    • Applying online patch
    • Methods to reduce patch downtime
    • Applying prerequisite patch
    • Restarting a Failed adpatch session
    • Troubleshooting patch related issues.
    • Introduction to merge patch
    • Constraints to apply merge patch
    • Merging patches with different methods
    • Applying NLS patches

  • Techstack patching, adctrl, adsplice, license manager

    • Applying patches on Techstack homes
    • Linking Techstack homes
    • Checking worker status
    • Controlling workers using adctrl
    • Restarting failed workers
    • Quitting and skipping  workers
    • Adding off cycle product using adsplice
    • Checking products status

  • Apache configuration

    • Introduction about web services
    • Opmn managed components.                                 
    • Configuration files of apache.
    • BC4J & OC4J components.
    • Detailed explanation of JVM & HEAP size.
    • How to change number of jvms
    • How to increase Heap size of JVM
    • Checking JVM logs

  • OAM, PROFILES, FNDCPASS

    • Introduction to FNDCPASS
    • Changing Frontend user password
    • Changing product schemas password
    • Changing APPS/APPLSYS schemas password
    • what is profile
    • Setting profiles at different levels
    • Introduction to OAM
    • Checking applied patches from OAM
    • Checking Performance related metrics from OAM
    • Checking/changing context variables from OAM
    • Patch Wizard

  • Concurrent Managers

    • Sequence to start/stop concurrent managers
    • Important concurrent managers related tables
    • Checking concurrent managers status
    • What is concurrent program
    • What is concurrent request
    • What is concurrent manager
    • Different types of concurrent managers
    • Special managers
    • Request processing managers
    • Transactional managers
    • Custom managers
    • Different types of concurrent requests status
    • How to submit, hold, cancel, view, schedule concurrent request
    • Creating custom concurrent manager
    • Changing sleep cycle/Cache size/No of processes for concurrent managers
    • How to terminate/deactivate specific manager
    • Creating and assigning a work shift to manager
    • Defining incompatibilities
    • Defining specialization rules, combined rules
    • Purging concurrent managers history data
    • How to restart specific manager
    • output post processor managers importance
    • Changing concurrent request log/out files naming convention
    • How to enable/disable trace for a concurrent program
    • What is PCP and its advantages

  • Advanced Topologies

    • What is shared APPL_TOP
    • Shared APPL_TOP advantages
    • Running adutilities with shared APPL_TOP
    • What is SSO
    • What is SSL 
    • What is DMZ