Apps DBA Interview Questions

In my first post i am planning to share whith you some applicatiosn DBA querstions that i have gathered from various sources.
1.How many ORACLE HOME are Oracle Apps and whats significance of each ?
There are three $ORACLE_HOME in Oracle Apps, Two for Application Tier (Middle Tier) and One in Database Tier.
# ORACLE_HOME 1 : On Application Tier used to store 8.0.6 techstack software. This is used by forms, reports & discoverer. ORACLE_HOME should point to this ORACLE_HOME which applying Apps Patch.
# ORACLE_HOME 2: On Application Tier used by iAS (Web Server) techstack software. This is used by Web Listener & contains Apache.
# ORACLE_HOME 3: On Database Tier used by Database Software usually 8i,9i or 10g database.
2.What is forms server executable Name ?
f60srvm
3.Where is HTML Cache stored in Oracle Apps Server ?
Oracle HTML Cache is available at $COMMON_TOP/_pages for some previous versions you might find it in $OA_HTML/_pages
4.Where is plssql cache stored in Oracle Apps ?
Usually two type of cache session & plssql stored under $IAS_ORACLE_HOME/Apache/modplsql/cache
5.What is difference between adpatch & opatch ?
# adpatch is utility to apply oracle apps Patches whereas
# opatch is utility to apply database patches in Oracle apps Database
6.What is use of Apps listener ?
Apps Listener usually running on All Oracle Applications 11i Nodes with listener alias as APPS_$SID is mainly used for listening requests for services like FNDFS & FNDSM.
7.Where will you find forms configuration details apart from xml file ?
Forms configuration at time of startup is in script adfrmctl.sh and appsweb_$CONTEXT_NAME.cfg (defined by environment variable FORMS60_WEB_CONFIG_FILE) for forms client connection used each time a user initiates forms connection.
8.What is difference between ICM, Standard Managers & CRM in Concurrent Manager ?
# ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks & try to restart them. You can say it as administrator to other concurrent managers. It has other tasks as well.
# Standard Manager These are normal managers which control/action on the requests & does batch or single request processing.
# CRM acronym for Conflict Resolution Manager is used to resolve conflicts between managers & request. If a request is submitted whose execution is clashing or it is defined not to run while a particular type of request is running then such requests are actioned/assigned to CRM for Incompatibilities & Conflict resolution.
9.Where would i find .rf9 file, and what execatly it dose ?
These files are used during restart of patch in case of patch failure because of some reason.
10.What are different modes of forms in which you can start Forms Server and which one is default ?
You can start forms server in SOCKET or SERVLET by defualt Forms are configured to start in socket mode.
11.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.
12.What is .dbc file , where its stored , whats use of .dbc file ?
dbc as name says is database connect descriptor file which stores database connection information used by application tier to connect to database. This file is in directory $FND_TOP/secure also called as FND_SECURE
13.what is adident utility
adident utility in oracle apps is used to find version of any file . AD Identification.
for ex. “adident Header <filename>
14.What are main configuration files in Web Server (Apache) ?
# httpd.conf, apps.conf, oracle_apache.conf, httpd_pls.conf
# jserv.conf, ssp_init.txt, jserv.properties, zone.properties
# plsql.conf, wdbsvr.app, plsql.conf
15.Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored & why its used ?
This file is defined by environment variable FORMS60_WEB_CONFIG_FILE This is usually in directory $OA_HTML/bin on forms tier.
This file is used by any forms client session. When a user try to access forms , f60webmx picks up this file and based on this configuration file creates a forms session to user/client.
16.Where is applications start/stop scripts stored ?
applications start/stop scripts are in directory $COMMON_TOP/admin/scripts/$CONTEXT_NAME
17.Whats is difference between two env files in <CONTEXT>.env and APPS<CONTEXT>.env under $APPL_TOP ?
APPS<CONTEXT>.env is main environment file which inturn calls other environment files like <CONTEXT>.env under $APPL_TOP, <CONTEXT>.env under 806 ORACLE_HOME and custom<CONTEXT>.env for any Customized environment files.
18.What is your Oracle Apps 11i Webserver Version and how to find it ?
From 11.5.8 to 11.5.10 Webserver version is iAS 1.0.2.2.2, In order to find version under $IAS_ORACLE_HOME/Apache/Apache/bin execute ./httpd -version
./httpd -version
19.What is Web Listener ?
Web Listener is Web Server listener which is listening for web Services(HTTP) request. This listener is started by adapcctl.sh & defined by directive (Listen, Port) in httpd.conf for Web Server.
20.Can you run multiple sessions of ADPATCH concurrently
No
21.where can u find the applied patch details.
ad_bugs table or Applied Patches report from OAM.
22.Can you uninstall a patch.
No
More to follow..