Here are few more Interview questions for Oracle Application DBA’s and same can be used as 1Z0-233 Install Patch and Maintain Applications dump for certification.
These question are submitted by our reader Jaya Kumar, Working as a “Oracle Apps DBA” in Chennai for “Savant Technologies” (www.savantit.com) . If you wish to share question, script or any other useful information for Apps DBA’s then send it via Contact Us page on this site or send a mail to me at atul @ onLine Apps DBA .comQ. Explain Oracle Applications architecture – Components?
Application EBS (Forms, Reports, Concurrent Processing, Web, Admin, Disc)Q. Find application server version ?
Q. How will you find the Apache, forms, reports version in an EBS suite?
http –v – Apache
f60gen – Forms
ar60run – Reports
Q. Find jinitiator version?
Client side – Control panel
Server side – SID_hostname.xml (s_jinit_ver_)
Q. Whatis US directory in $AD_TOP or under various product TOP’s .
US directory is default language directory in Oracle Applications. If you have multiple language Installed in your Applications then you will see other language directories beside US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for arabic, simplifies chinese or spanish.
Q. Whats main concurrent Manager types.
ICM – Internal Concurrent Manager which manage concurrent Managers
Standard Managers – Which Manage processing of requests.
CRM – Conflict Resolution Managers , resolve conflicts in case of incompatibility.
Q. Where is Concurrent Manager log file location ?
By default standard location is $APPLCSF/$APPLLOG , in some cases it can go to $FND_TOP/log as well.
Q. List some ad utilities and their functions?
adadmin, adctrl, adpatch, adlicmgr, admrgpch, adsplice and adworker
Q. List out the modules related to oracle Apps DBA ?
FND – Application Object Library, AU – Application Utilities, AD – Application DBA
Q. What are profile options, what are various type of profile options ?
User, application, responsibility and site
Q. List some profile options with their function?
ICX: Session timeout, ICX: Forms Launcher, ICX: Limit Connect
Q. How will you take the forms trace?
Q. How you put Applications 11i in Maintenance mode ?
Use adadmin to change Maintenance mode is Oracle Apps. With AD.I you need to enable maintenance mode in order to apply apps patch via adpatch utility. If you don’t want to put apps in maintenance mode you can use adpatch options=hotpatch feature.
Q. What are the different types of oracle patches available ?
One-off, mini, diagnostics, cu, rup, language, help, platform specific, OS, OPatch,
Interoperability, family pack and maintenance pack.
Q. What are the different patch drivers available?
C driver, D driver, G driver and U driver.
Q. Explain the steps for applying apps patch and database patch ?
Q. What is autoconfig?
Q. How will you find the autoconfig is enabled?
Q. List out the following logfile locations?
Patch log, autoconfig log, reports output, reports log and Concurrent manager log.
Q. List out the important env files?
Appsora.env, appsSID_hostname.env, adovars.env, APPSSID_hostname
Q. How to enable diagnostics for oracle applications?
FND: Enable Diagnostics.. Tell about RDA and its use?
Q. Describe about Discoverer Configuration and Oracle 10g AS installation ?
So start sharing information which can be useful to others like scripts, document by clicking on Contact Us form or drop me a mail at atul @ onLine Apps DBA .com
Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.