The Oracle Apps DBA training at Skillzcafe provides guaranteed placement in 6 months with real-time projects at your convenient time. We offer the best Oracle Apps DBA training online with content designed from beginner to advanced levels.
• 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
Module 2
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
Module 3
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
Module 4
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
Module 5
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
Module 6
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)
Module 7
AD utilities:- adrelink, adident, adadmin
• Introduction to AD utilities
• Finding file version using adident
• Finding file versions using strings command
• Linking executables using adrelink
• Running adadmin
• Various menus in adadmin
Module 8
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
• 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
Module 11
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
Module 12
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
• 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
Module 14
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
Module 15
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
Module 16
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 hist
Module 17
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
Request more information
Shreya Apps DBA
Overall it's a great course- I got placed at Navisite with the package of 6.5 Lacs.
Mohit Associate DBA
Outside the extensive course curriculum, love the mock interviews. Got placed with 5.25 LPA