Oracle Apps DBA Interview Questions and Answers
1) Describe the architecture of Oracle Applications?
Oracle Applications follow a 3 Tier architecture:
- Database Tier
- Middle Tier
- Desktop Tier
Database tier contains RDBMS database called as oracle database server.
Database tier stores all the data needed by oracle applications.
Middle tier or Application Tier containing various servers configured with listeners like web server, forms server, admin server, reports server.
Database server communicates with middle tier, doesn’t directly communicate with desktop tier.
Desktop tier contains client desktop where users access oracle applications through web browsers.
2) How do you delete a responsibility from oracle applications?
- Responsibility is a level of authority given to Oracle Applications users.
- It is a collection of requests, forms and menus attached to user.
- Records are used for monitoring and security purpose so we can’t disable responsibilities.
- However, responsibilities can be disabled by assigning an end date to the effective period.
- We can delete a responsibility from both backend and frontend
3) What are the components of Oracle Applications technology layer?
Oracle Applications technology layer comprises the following products:
- Oracle Applications DBA (AD)
- Oracle Applications object library (FND)
- Oracle Common Modules (AK)
- Oracle Applications Utilities (AU)
- Oracle Alert (ALR)
- Oracle Workflow (WF)
- Oracle Applications Framework (FWK)
- Oracle XML Publisher (XML)
4) How many Oracle Homes are there in Oracle Applications and what is the importance of each one of them?
Oracle Applications have three Oracle Homes:
- Oracle Home is an environment where oracle products run.
- Database Oracle Home in the database tier that acts as the Oracle Home for the Oracle database.
- Oracle Home in the application tier called as 8.0.6 Oracle Home. It is called the technology stack Oracle Home and used by forms, reports and discoverer.
- IAS Oracle Home, used by the Oracle HTTP Server (Web Listener).
- We can run multiple releases of same products simultaneously by using multiple oracle homes.
5) Can I enable real application clusters in the database tier along with oracle applications?
- Yes, real application clusters can also be configured with Oracle Applications
- RAC allows multiple instances to mount and open a single database.
- RAC requires shared disk storage and a dedicated network interconnect.
- When any one of the node fails, database services can be still available on remaining nodes.
- In that case, more than one instance of Oracle runs and the data file are stored at a central location accessible from the entire instance.
6) Where are Apache log files and configuration files stored and list each of them?
- Apache log files are stored in $IAS_ORACLE_HOME/Apache/Apache/logs.
- The log files are error_log, error_log_pls, access_log and access_log_pls.
- Apache configuration files are stored in $IAS_ORACLE_HOME/Apche/Apache/conf directory.
- The main configuration files are httpd.conf, apps.conf, httpd_pls.conf,oprocmgr.conf, and oracle_apache.conf.
7) How to recreate a DBC file and where is it located?
- Running Autoconfig will recreate the DBC file.
- DBC is a database connect descriptor file which stores database connection information used by application tier (web browsers) to connect to database.
- The file is located in FND_SECURE directory.
- you can also create the DBC file by running the script adgendbc.sh
- We can find the above script at $COMMON_TOP/admin/install directory.
8) List out the important configuration files in APPL_TOP?
Important configuration files available in the APPL_TOP are:
9) Which utility is used for changing the password of the application users and how it runs?
- The password of the application users can be changed using the FNDCPASS utility.
- You must have system and applications password for running FNDCPASS.
10) What are the scripts do you use while Apps cloning?
- A type of script that’s made a comeback in hot scripts is clone script.
- adpreclone.pl prepares the source system and adcfgclone.pl configures the target system.
- Both the scripts are located in $COMMON_TOP/admin/scripts/contextname directory.
- Adpreclone.pl collects information about the database.
- It also creates generic templates of files containing source specified hardcore values.
11) What is a patch and name some different types of patches?
- Patch is a program which fixes the bug.
There are 4 different types of patches:
- One-off patch:
- This is the simplest type of patch. It is created to resolve a particular problem.
- Mini pack Patch:
- It is a collection of one-off patches related to a particular module or product.
- Mini Pack version of module is denoted by Alphabetic characters.
- Family pack patch:
- This is a collection of mini pack patches in one family.
- Alphabetic characters denote the family pack version.
- Maintenance pack patch:
- This is a collection of family pack patches.
- Oracle Applications Release 11.5.10 is an example of Maintenance pack.
12) List out APPS 11i post installation steps?
- Shutdown all Oracle Application Processes.
- Apply Inter-Operability Patch(3830807).
- Apply Discoverer Patch(3170128).
- Re link all Oracle Applications executables.
- Finally, Restart Oracle Application Processes.
13) What are the contents of patch and drivers present in patching?
Contents of patch:
- Readme files
- Driver files
- Metadata files
- Replacement files
Drivers present in patching:
C driver - It copies all the files and links the executables.
D driver – It is responsible for running SQL scripts which updates the database.
G driver - It is responsible for generating forms, reports and message files.
U driver – It is a united driver containing all copy and database actions.
14) What do you do if patch fails?
- Evaluate log files to determine the cause of the error.
- Repair the cause of error.
- Now Restart Adpatch.
- Answer 'Yes' when adpatch asks if you want to continue the previous session.
- Adpatch starts from where it left off by skipping all completed jobs.
15) How can you reduce the downtime when you have to apply multiple patches?
- You can reduce the downtime by merging all the patches into one single patch using admergepatch (admrgpch) tool.
- You can also apply multiple patches one by one by choosing options nocompiledb, nocompilejsp, and nolink.
- Compilation of invalid objects, jsp’s and relinking can be skipped till the last patch is applied.
- In the last patch you can compile all of them and then relink.
- You can also choose the max number of workers which your CPU permits.
16)List out the Log Files created on running patch?
Running the patch creates the following log files:
Adpatch.log: Information about the patch run will be stored here.
Adpatch.lgi: It contains information about the which has been discarded by adpatch.log
For example, the files which has not been copied by the adpatch.
Adrelink.log: Relinking information performed by patch will be stored here.
Adworkxx.log: Workers log details will be stored here.
17) What are the important AD tables and define their importance?
AD_APPL_TOPS: It contains information about all APPL_TOP’s using the instance.
AD_BUGS: It stores information about all different bug fixes applied.
AD_PATCH_DRIVER_MINIPACKS: Mini_packs information will be stored here.
AD_PATCH_RUN_BUGS: It stores information about all applied and updated bug fixes.
AD_FILES: It stores information about files.
18) What is a view and how do you recreate a view which becomes invalid when you recreate a patch?
- View is used for accessing a particular portion of a table.
- A view is also called as virtual table.
- For recreating the view you can search for the view name in the SQL directory.
- We can recreate the views running scripts located in the Product top/patch/115/sql directory.
- Most views are recreated using sql script.
19) What things you do to reduce patch timing?
- Admrgpch utility is used for merging all the patches.
- Various adpatch options like nocompiledb or nocompilejsp are used for reducing patch timing.
- By Using defaults file.
- By using, staged APPL_TOP for upgradation.
- By increasing the batch size, this might result into negative results.
20) What are the main configuration files in web server (Apache)?
Main configuration files in Oracle Apps Web server are:
- Jserv and zone properties
21) What are GSM and FNDSM?
- GSM stands for Generic Service Management Framework.
- Oracle E-Business suite contains many services used to start at their own earlier, but managing these services are distributed across network.
- So, GSM is an extension of concurrent processing which manages all your services.
- With GSM all services are centrally managed.
- FNDSM is executable and core component in GSM.
22) What are cursor attributes?
- Cursor attributes are used to get information about the current status of your cursor.
Both explicit and implicit cursors have four attributes as shown:
FOUND - It Returns TRUE if record was fetched successfully, FALSE otherwise.
NOTFOUND - Returns TRUE if record was not fetched successfully, FALSE otherwise.
ROWCOUNT - Returns number of records fetched from cursor at that point in time.
ISOPEN - Returns TRUE if cursor is open, FALSE otherwise.
23) How to confirm if Apps Listener is up and running?
Execute the following commands:
If the listener is up, you will observe the following output:
- Services summary
- FNDFS has 1 service handler(s)
- FNDSM has 1 service handler(s)
24) What is Adadmin and why it is used?
- Adadmin (Ad administration) is used to perform a number of administrative tasks to maintain the Oracle Applications.
- For Oracle Applications to run smoothly Adadmin is used.
- Adadmin performs work at both database level and file system level.
- Application users are requested to provide all inputs at Adadmin prompt which displays various options from Adadmin menu.
- You can run non_interactive tasks and this is really useful for scheduling routine tasks that require no user intervention.
25) What are the adadmin activities that can be run in a parallel way?
- Recreate grants and synonyms.
- Compile APPS schema
- Maintain multiple reporting currencies schema.
- Convert to Multi-org.
- Generate message files.
- Generate form files.
- Generate report files.
26) What is copy driver (c driver) and what does it do?
- All the files in the patch are copied to APPL_TOP by C driver.
- It extracts all the appropriate files from c library.
- Oracle applications products are relinked by C driver.
- Regenerates the JAR files and compiles the Java server pages(JSP) files.
- Compares the files in the patch with the files in the $APPL_TOP.
- If all the files in the patch are of higher version, Adpatch copies all the files from patch to $APPL_TOP.
27) What are generate and unified driver and what does they do?
- Generate driver is named as g<patch number>.drv
- It regenerates all forms, reports and pl/sql libraries that have been affected by the patch.
- Unified driver is a combination of C,D, & G drivers.
- U driver is also named as u<patch_number>.drv
- It requires only a single execution of AutoPatch.
28) Explain about Forms server?
- Forms server is a component of Oracle Applications server which is used to deploy Forms applications across the web.
- It is previously called as Web Forms.
- It consists of Forms Listener, Runtime engine, Forms CGI.
- Forms listener manages connections and Runtime engine.
- Runtime engine contains Application logic, Data management and pl/sql engine.
- It is an optional entry point and used for Load balancing.
29) How do I change from socket to servlet mode and vice versa?
- First, you must login to Oracle Applications Manager
- Then you must navigate to sitemap, then find the Autoconfig.
- In Autoconfig you can able to change from socket mode to servlet mode and vice versa
- Run the autoconfig from backend and restart the forms server.
- Due to many advantages Forms servlet mode is preferred and is always recommended for web deployment.
30) What is JInitiator?
- It is a java virtual machine provided for running web based oracle forms applications inside a client web browser.
- It is implemented as a plug-in or ActiveX Object.
- It allows you to specify the use of Oracle-certified JVM instead of relying on default JVM provided by the browser.
- It is automatically downloaded to a client machine from the application server.
- Its installation and update is performed by standard plug-in mechanism provided by the browser.
31) What is the function of Oracle HTTP (Apache) server?
- Web listener accepts the Http requests coming from the client browsers and web server services the request.
- Apache server forwards advanced processing requests to the servlet engine.
- Servlet engine forwards this requests to database.
- If the Http request needs parsing a JSP file then web listener checks the nature of the request.
- It then contacts the Jserv to run a JSP.
- The JSP contacts the database for the information and returns a HTML page displayed in the web browser.
32) What kind of maintenance activities can be performed from admin server?
Following maintenance activities are performed from admin server:
- Applying the patches
- Maintaining Oracle Applications
- Applying the ad utilities
- Upgrading Oracle Applications
33) What is cloning and why is it required?
Cloning is the process of creating an identical copy of the Oracle application system.
It is required due to following reasons:
- Creating a test copy of your production system before upgrading.
- Moving an existing system to a different machine.
- To test some patches
- Creating a development copy of your environment to be used by the developers.
34) What are the files you need to copy from APPL_TOP for creating a clone application system?
- 806 ORACLE_HOME
- iAS ORACLE_HOME
35) What are the pre-upgrade steps that need to be taken for the up gradation of non_11i instance to 11.5.10?
- First, you need to take a complete backup of the application system.
- Run the TUMS utility
- Review the TUMS report
- Maintain the multilingual tables
- Rename the custom database objects
- Check attachment file upload directory
- You need to save the custom.pll