DBA > Interview Resource

Oracle DBA Interview questions and Answers

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16 

(Continued from previous part...)

What is ADSPLICE UTILITY ?

ADSPLICE UTILITY in oracle apps is utility to add a new product.


How can you licence a product after installation ?

You can use ad utility adlicmgr to licence product in Oracle Apps.


What is MRC ? What you do as Apps DBA for MRC ?

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. How to enable MRC coming soon...


What is access_log in apache , what entries are recored in access_log ? Where is default location of thsi file ?

access_log in Oracle Application Server records all users accessing oracle applications 11i. This file location is defined in httpd.conf with default location at $IAS_ORACLE_HOME/Apache/Apache/logs. Entries in this file is defined by directive LogFormat in httpd.conf Typical entry in access_log is
198.0.0.1 - - [10/Sep/2006:18:37:17 +0100] "POST /OA_HTML/OA.jsp?.... HTTP/1.1" 200 28035
where 200 is HTTP status code and last digits 28035 is bytes dowloaded as this page(Size of page)


Where is Jserv configuration files stored ?

Jserv configuration files are stored in $IAS_ORACLE_HOME/Apache/Jserv/etc


Where is applications start/stop scripts stored ?

applications start/stop scripts are in directory $COMMON_TOP/admin/scripts/$CONTEXT_NAME


What are main configuration files in Web Server (Apache) ?

Main configuration files in Oracle Apps Web Server are
# 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

(Continued on next part...)

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16