This post covers Sneak Peek of Step by Step Hands-On Guides from our Oracle AppsDBA Training where you get to learn things like Architecture, Installation, File System, Start/Stop, Online Patching & ADOP, AD Utilities, AutoConfig, Cloning, Password Management, Concurrent Managers, Advanced Topics, Troubleshooting and much more.
Here’s the Quick Sneak Peek of What You will do on your Dedicated Machine for Oracle AppsDBA:
1. Lab Activity Guide I: EBS 12.2 Installation
We start with Oracle E-Business Suite Architecture: 3 Tier Architecture (Client Tier, Middle Tier and Database Tier) in AppsDBA Hands-On Training. In this lab activity guide, we learn how to Install Oracle AppsDBA (R12.2), Start/Stop AppsDBA services, and how to verify EBS URL.
We also cover issues encountered during installation and fix for those.
Note: You get dedicated machine on cloud as part of this Oracle Apps DBA Training where you install R12.2.0 that you later patch to 12.2.5
2. Lab Activity Guide II: EBS 12.2 Start/Stop
We then learn Start/Stop Services: Database and Application Tier services including how to troubleshoot or look for logs if you hit any errors in Oracle Apps (EBS) R12 Start-Up
3. Lab Activity Guide III: AD Utilities
AD (Application DBA)Utilities are a group of tools design to upgrade, maintain and patch application.
AD_TOP is a product in Application which is under directory APPL_TOP/ad/12.0.0. This top contains Utilities & program code which is very frequently used by DBA’s.
We look at one of the most commonly used AD task as Apps DBA Job.
4. Lab Activity Guide IV: Patching 12.2.5, 12.2.6, 12.2.8 using ADOP
We then learn about patching using ADOP utility and apply patches on Oracle EBS R12.2 instance, installed earlier as part of this training. Online Patching is supported by the capability of storing multiple application editions in the database, and the provision of a dual application tier file system. At any given point in time, one of these file systems is designated as run (part of the running system) and the other as Patch (either being patched or awaiting the start of the next patching cycle).
There are 5 Phases of ADOP(Application Database Online Patching):
5. Lab Activity Guide V: Cloning
Cloning is the act of creating an identical copy of an already existing Production Oracle Applications system.
Simply copying all of the components from source to target system does not provide us a working Oracle Applications system, there are various configuration files that must be changed & for this purpose we do Cloning.
Note: 70% of tie Apps DBAs Job is Patching, Autoconfig, and Cloning. If as part of Apps DBA Training, you do these 3 things then you can confidently find Job or work on Job
6. Lab Activity Guide VI: Concurrent Manager
The concurrent managers in the Oracle e-Business suite serve several important administrative functions. Foremost, the concurrent managers ensure that the applications are not overwhelmed with requests, and the second areas of functions are the management of batch processing and report generation.
Allows long-running, data-intensive programs to run simultaneously with online operations.
Internal Concurrent Manager: The ICM (Internal Concurrent Manager) controls all of the other concurrent managers.
Standard Manager: The Standard Manager accepts any and all requests. It has no predefined specialization rules and is active all the time. It is not recommended to add specialization rules to the standard manager as it can cause problems.
Conflict Resolution Manager: The Conflict Resolution Manager resolves conflicts, such as request incompatibilities.
7. Lab Activity Guide VII: AutoConfig
AutoConfig is tool/utility to reconfigure your Oracle Application configuration files using context (XML file) and template files.
Key AutoConfig configuration scripts on UNIX (command files on Windows) include:
adautocfg.sh – Wrapper script that passes the name of the specific environment context file to adconfig.sh. Located in <INST_TOP>/admin/scripts on the application tier, and <RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME> on the database tier.
adconfig.sh – Invoked by adautocfg.sh, this script is a wrapper for adconfig.pl. Located in <AD_TOP>/bin on the application tier, and <RDBMS_ORACLE_HOME>/appsutil/bin on the database tier.
adconfig.pl – Invoked by adconfig.sh, this Perl script calls the Java API to carry out the actual configuration tasks. Located in <AD_TOP>/bin on the application tier, and <RDBMS_ORACLE_HOME>/appsutil/bin on the database tier.
In addition to these configuration scripts, several additional AutoConfig scripts are used to help manage the Oracle E-Business Suite system
8. Lab Activity Guide VIII: Password Management
In a standard E-Business Suite environment, user passwords are stored and encrypted in the user’s records in the E-Business Suite’s FND_USER directory. You as an Apps DBA must know how to change password, both for end-user as well as service accounts like APPS, SYS, SYSTEM or Product Schema
9. Lab Activity Guide IX: Troubleshooting
We then learn a few troubleshooting things.
We also add a few bonuses that 100s of our students in AppsDBA training find useful.
Bonus 1. Activity Guide: Custom Top
Custom Applications are required if you are creating new forms, reports, etc.
This allows you to segregate your custom written files from the standard seeded functionality that Oracle Applications provide.
Customization can, therefore, be preserved when applying patches or upgrades to your environment.
Bonus 2. Activity Guide: EBS 12.1.3 Install
We learn how to install EBS 12.1.3, Start/Stop services, Access EBS URL, Verify Applied Patches etc.
Here is some of the reasons why our students think we are the best Oracle Training institute
- Live Instructor-led Online Sessions
- Unlimited FREE retake for next 1 Years
- Training Material with Hands-on Lab Exercises (11+ Activity guides + Bonus Guides)
- Recording of Live Interactive Session for Lifetime Access
- Dedicated Machines to Practice
- Email & WhatsApp Support
- Help in CV Preparation
- 100% Money Back Guarantee (If you attend sessions, practice and don’t get results, We’ll do full REFUND, check our refund policy)
K21 Academy Oracle AppsDBA Course Insight:
- (Blog) video-r12-2-installation-free-training
- (Blog) video-file-system-&-console
- (Blog) Video-oracle-apps-dba-r12-2-services-startstop
- (Blog) video-r12-2-patching-adop-free-training
- [Blog] ADOP Patching Q/A
Next Task For You
Begin your journey towards becoming an Apps DBA by joining our FREE Masterclass on How To Become an Oracle Apps DBA (R12) & Earn A Lot More In 2020.