Oracle Application Interview Questions and Answers

page -1

1:  What is *.dbc file and what is location of dbc file ?
A:  dbc as name stands for is database connect descriptor file used to connect to database.
DBC file is quite important as whenever Java or any other program like forms want to connect to
database it uses DBC file.
This file by default located in $FND_TOP/secure directory also called as $FND_SECURE directory.
Typical entry in DBC file is:
GUEST_USER_PWD
APPS_JDBC_URL
DB_HOST
2: Whats is location of access_log file ?
A: access_log file by default is located in $IAS_ORACLE_HOME/ Apache/Apache/logs. Location of
this file is defined in httpd.conf by patameter CustomLog or TransferLog.

3: Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored and why it’s used?
A: 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.

4: How to compile an Oracle Reports file ?
A: Utility adrepgen is used to compile Reports. Synatx is given below
adrepgen userid=apps\ source = $PRODUCT_TOP\srw\filename.rdf dest=$PRODUCT_TOP\srw
\filename.rdf stype=rdffile dtype=rdffile logfile=x.log overwrite=yes batch=yes dunit=character

5: What is dev60cgi & f60cgi ?
A: cgi stands for Common Gateway Interface and these are Script Alias in Oracle Apps used to access
forms server. Usually Form Server access directly via http://hostname:port/dev60cgi/f60cgi
(http://hostname:port/dev60cgi/f60cgi)

6:  How to check number of forms users at any time ?
A: Forms Connections initiate f60webmx connections so you can use
ps -ef | grep f60webmx | wc –l

7: Can you clone from multi node system to single node system & vice versa ?
A: Yes.

8. Whats things you do to reduce patch timing?
A: * Merging patches via admrgpch
* Use various adpatch options like nocompiledb or nocompilejsp
* Use defaults file
* Staged APPL_TOP during upgrades
* Increase batch size (Might result into negative )

9: adident utility is used for what?
A: adident utility in oracle apps is used to find version of any file. AD Identification.

10: Why appsutil directory under Database ORACLE_HOME used for?
A:  All the template files, startup scripts , XML files are maintained here.

11: How to create User in Oracle Applications 11i? Can you delete a User?
A: New User can be created using security-->Define-->User menu. No,
user cannot be deleted but can be end-dated.

12: What is wdbsvr.app file used for? What's full path of this file? What's significance of this file?
A : The wdbsvr.app is used by mod_plsql component of Apache to connect to database. The File is located at $IAS_ORACLE_HOME/Apache/modplsql/cfg .

13: Where would i find .rf9 file, and what execatly it does?
A : These files are used during restart of patch in case of patch failure because of some reason.

14: How can you licence a product after installation?
A : By using adutility adlicmgr to licence product in Oracle Apps.

15: What is MRC? What you do to enable MRC in Apps?
A : MRC also called as "Multiple Reporting Currency" in oracle Apps.
Default you have currency in US Dollars but if your organization operating books are in other currency then you as apps dba need to enable MRC in Apps.

<<Page-2>>