Monday, May 19, 2014

Oracle Apps DBA Interview Questions part 4

21.   What is access_log in apache, what entries are recorded in access_log? Where is the default location of this file?
access_log in Oracle Application Server records all users accessing oracle applications 11i. Its file location is defined in httpd.conf with default location at $IAS_ORACLE_HOME/Apache/Apache/logs.
22.   Where is Jserv configuration files stored?
Jserv configuration files are stored in $IAS_ORACLE_HOME/Apache/Jserv/etc.
23.   Where is applications start/stop scripts stored?
Applications start/stop scripts are in directory $COMMON_TOP/admin/scripts/$CONTEXT_NAME
24.   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
25.   How to check if Apps 11i System is Autoconfig enabled?
Under $AD_TOP/bin check for file adcfginfo.sh and if this exists use adcfginfo.sh contextfile=<CONTEXT> show=enabled
If this file is not there, look for any configuration file under APPL_TOP if system is Autoconfig enabled then you will see entry like
# AutoConfig automatically generates this file. It will be read and.......
26.   How to check if Oracle Apps 11i System is Rapid Clone enabled?
For system to be Rapid Clone enabled, it should be Autoconfig enabled. You should have Rapid Clone Patches applied.
27.   What is the difference between two env files in <CONTEXT>.env and APPS<CONTEXT>.env under $APPL_TOP?
APPS<CONTEXT>.env is main environment file which in turn calls other environment files like <CONTEXT>.env under $APPL_TOP
28.   What is your Oracle Apps 11i Webserver Version and how to find it?
In order to find version under IAS_ORACLE_HOME/Apache/Apache/bin
Execute ./httpd -version
29.   What is plssql database cache?
In order to improve performance mod_pls (Apache component) caches some database content to file. This plsql cache is used to store session information. plsql cache is used to store plsql cache i.e. used by mod_pls

No comments:

Post a Comment