This post discusses the Q/A & Review from the Day 1 of Oracle Apps DBA Training (R12.2)Install | Patch | Clone | Maintain Training Program. This will help you understand the basic concepts of Apps DBA Tasks & Architecture.
In this session, we covered Module 1: Architecture & Changes in Oracle E-Business R12.2 which includes the following Topics:
The Apps DBA Training Program available on the Membership Portal looks like the screenshot below. We encourage the trainees to go through the well-done recorded videos before attending the Live session so they can come up with their doubts & clear them during the session to make it more Interactive.
Oracle E-Business Suite (EBS) aka Apps or Applications is an integrated business application consisting of
- Enterprise Resource Planning (ERP)
- Human Resource Management System (HRMS)
- Customer Relationship Management (CRM)
- Supply Chain Management (SCM)
- Financial Management
- Advanced Procurement
- Service Management
- Project Portfolio Management
Here is a high-level overview of what we covered & the related Q/A:
Q/A Related to File System
EBS R12.2 File System:
- R12.2 has Dual File System.
- Run File system & Patch File System are identical.
- To Support Online Patching (ADOP)
- Single Non-Edition File System which has AD exe, PATCH_TOP
- Instance Top excludes Weblogic and OHS files.
- No support for Read Only APPL_TOP Access across Instances.
Q1: Why two file systems are needed in R12.2?
Ans. Creating and using the two file system allows one (run file system) to be a part of the running system while the other (patch file system) is either being patched or waiting to be patched during the next patching cycle.
Note: The file systems are designated File System 1 and File System 2 in Rapid Install. These are abbreviated to fs1 and fs2 respectively.
The two file systems are sometimes referred to as a dual file system, and swap roles at the end of each patching cycle. That is, the file system that has just been patched is put into use as a part of the running system (becoming the new run file system), and the previous run file system takes over the role of a patch file system (in readiness for the commencement of the next patching cycle).
Q/A Related to Concurrent Processing
Next, We discussed the Concurrent processing, Here is the high-level overview of what we covered & related FAQs.
Concurrent Manager service is a batch processing tool which provides scheduling and queuing functionality for background jobs and is used by most of the Oracle Applications Modules. It is a key service within the E-Business Suite which runs the user requests in the background, thus ensuring that the user can continue with other day-to-day tasks while the requested change/activity is carried out by the Concurrent Manager.
Some of the definitions are given below:
- Concurrent Programs: Programs can run concurrently with each other as well as with the other programs.
- Concurrent Request: Submit to run a concurrent program as a concurrent process.
- Concurrent Manager: Component of concurrent processing that monitors and runs requests without tying up your computer.
- Request Set: Collection of reports or programs you group together.
Phases of the Concurrent Request
Q2. Do programs/concurrent requests affect the performance of the overall system?
Ans: Yes, it will affect the performance if the program is resource intensive.
In Oracle Applications, concurrent processing executes the programs running in the background and the online operations simultaneously. As a System Administrator, you can manage when the programs are run and how many operating systems process. Oracle Applications devotes to running programs in the background.
Q3. Who can submit a concurrent request?
Ans: Anyone with access can submit a concurrent request.
Q4. Can a concurrent request be timed when Load on the system is minimum?
Ans: Yes, a concurrent request can be timed to run on a particular time of day to optimally use the system.
Q5. How do you decide what request to run as Concurrent request?
Ans: Any Request that takes more than 5 mins should be a concurrent request to make the best use of one’s time.
Q6. Explain BC4j?
Ans: The business components framework is a class library, in oracle.jbo.*, with built-in application functionality. Using the framework involves specializing base classes to introduce application-specific behavior, allowing the framework to coordinate many of the basic interactions between objects.
Q7. Is TIBCO same as FMW?
- The Business Platform – Fusion Middleware
Oracle Fusion Middleware is an enterprise business innovation platform which includes products like Business Intelligence, Business Process Management, Identity Management, Data Integration, Service-Oriented Architecture, and development tools i.e. Forms, Reports, Application Development Framework and Mobile Application Framework in JDeveloper. OFM provides enterprise and the Cloud solution to create and run intelligent business apps with maximum utilization of new generation’s h/w and s/w.
- TIBCO is a product catering to specific needs while FMW is an infrastructure spanning across 57+ products.
TIBCO BPM offers good tools to optimize process management.
For example, Decisions, allows you to model a complete logistics of business tasks by meeting all the expectations expected from a rules engine.
To conclude, it was a fantastic session and we got very good feedback.
- Oracle E-Business Suite (EBS) 12.2.8 Now Available: Documentation & Download Software
- Installing Oracle E-Business Suite? Look at new StartCD
- Oracle AppsDBA (R12.2): Step By Step Activity Guides
- Oracle AppsDBA (R12.2): Install | Patch | Clone | Maintain
- Oracle AppsDBA (R12) Advance Course