Monday, May 19, 2014

Oracle Apps DBA Interview Questions part 2

1.       What is FNDSM?
FNDSM is executable & core component in GSM (Generic Service Management Framework). You start FNDSM services via APPS listener on all Nodes in Application Tier in E-Business Suite.
2.       What is iAS Patch ?
iAS Patch are patches released to fix bugs associated with IAS_ORACLE_HOME (Web Server Component) Usually these are shipped as Shell scripts & you apply iAS patches by executing Shell script.
 Explain Architecture of Oracle Apps 11i?
Apps 11i is Mutli Tier architecture with Desktop Tier (Client Tier), Middle Tier (Application Tier) and Database Tier.
3.       What are various components in Application/Middle Tier?
In Application Tier various components are Web Server, Forms Server, Reports Server, Concurrent Manager, Admin Server & Discoverer Server.
4.       What is APPL_TOP, COMN_TOP, ORA_TOP.....?
XXX_TOP is top level directory in Oracle Application 11i for respective Component.
5.       What is US directory in $AD_TOP or under various product TOP's?
US directory is default language directory in Oracle Applications. If you have multiple languages Installed in your Applications then you will see other languages directories besides US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for Arabic.
6.       What are the main concurrent Manager types?
ICM - Internal Concurrent Manager which manages concurrent managers
Standard Managers - Manages processing of requests
CRM - Conflict Resolution Managers, resolve conflicts in case of incompatibility
7.       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
8.       Where would I find .rf9 file, and what exactly it does?
These files are used during restart of a patch in case of patch failure because of some reason.
9.       Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored & why is it 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 tries to access forms, f60webmx picks up this file and based on this configuration file creates a forms session to user/client.
10.   What is multi node system?
Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. Typical example is database, Concurrent Manager on one machine and Forms Server, Web Server on second machine.

No comments:

Post a Comment