Oracle Apps DBA Interview Questions part 9

80.   Why does a worker fail in Oracle Apps Patch and few scenarios in which it failed for you?
Apps Patch worker can fail in case it doesn't find expected data, object, files or anything which driver is trying to update/edit/modify. Possible symptoms may be underlying tables/objects are invalid, a prerequisite patch is missing, login information is incorrect, inconsistency in seed data.
81.   What is difference between mod_osso & mod_ose in Oracle HTTP Server?
mod_osso is Oracle Single Sign-On Module where as mod_ose is module for Oracle Servlet Engine.
82.   What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms?
Both the options will compile all the PL/SQL in the resultant .FMX, .PLX, or .MMX file but COMPILE_ALL=YES also changes the cached version in the source .FMB, .PLL, or .MMB file.
83.   What is ps -ef or ps command in Unix? for work ex < 1 yr
ps in unix/linux is a utility to find status of process. Used mainly to find if service/process is running or not.
84.   Find application server version?
FND_PRODUCT_GROUPS
85.   How will you find the Apache, forms, reports version in an EBS suite?
http –v – Apache
f60gen – Forms
ar60run – Reports
86.   Find jinitiator version?
Client side – Control panel
Server side – SID_hostname.xml (s_jinit_ver_)  
87.   List some ad utilities and their functions?
adadmin, adctrl, adpatch, adlicmgr, admrgpch, adsplice and adworker
88.   List out the modules related to oracle Apps DBA?
FND – Application Object Library, AU – Application Utilities, AD – Application DBA
89.   What are profile options, what are various types of profile options?
User, application, responsibility and site
90.   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.