This blog post covers the Step-By-Step Activity Guides of the Oracle AppsDBA training program that you must perform to learn this course.
In our 6 weeks of Oracle AppsDBA Training, we cover the below Modules & step-by-step hands-on guides.
- Activity Guide I: EBS R12.2 Installation
- Activity Guide II: EBS Start/Stop
- Activity Guide III: AD Utilities
- Activity Guide IV: Patching in EBS R12
- Activity Guide V: Cloning in EBS R12
- Activity Guide VI: Concurrent Manager
- Activity Guide VII: AutoConfig
- Activity Guide VIII: Password Management
- Activity Guide IX: Troubleshooting
EBS Architecture Concepts:
It is a three-tier architecture:
- Client Tier
- Application Tier
- Database Tier
Read our blog to know more about the EBS Architecture.
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 a dedicated machine on our Server as part of this Oracle Apps DBA Training where you install R12.2.0 that you later patch to 12.2.5
To know about this, do check our blog post on EBS R12.2 Staging & Installation
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 tasks as Apps DBA Job.
4. Lab Activity Guide IV: Patching 12.2.9 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).
To more about patching, check our blog post on ADOP Patching in EBS R12.2
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.
Check more about cloning in our blog on Cloning: Basic Steps
Note: 70% of the 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 to request incompatibilities.
To know more about concurrent managers, check our blog post on Concurrent Managers: Overview & Concpets in EBS R12
7. Lab Activity Guide VII: AutoConfig
AutoConfig is a 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.
To know more about the Oracle EBS, check our blog on Oracle EBS Architecture.
- Recommended Browsers for Oracle E-Business Suite Release 12 [Doc ID 389422.1]
- Oracle E-Business Suite Release 12.2 Information Center (Doc ID 1581299.1)
- Oracle E-Business Suite Release 12.2.9 Readme (Doc ID 2495027.1)
- Oracle E-Business Suite 12.2.9 Now Available
- [Troubleshooting] Forms Issue: FRM-92050 failed to connect to server:forms/servlet
- Oracle E-Business Suite (EBS) 12.2.9 Now Available & Its Upgrade Steps
- Steps to download Oracle E-Business Suite R12 Software
- Oracle AppsDBA (R12.2) Training: Step by Step Activity Guides/Hands-On Lab Exercise
- Oracle AppsDBA (R12.2): Install | Patch | Clone | Maintain
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) .