(Continued from previous part...)

Whats is location of access_log file ?

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

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
Server version: Oracle HTTP Server Powered by Apache/1.3.19
Server built: Dec 6 2005 14:59:13 (iAS 1.0.2.2.2 rollup 5)

What is Location of Jserv configuration files ?

Jserv configuration files are located in $IAS_ORACLE_HOME /Apache/Jserv/etc .

What is plssql/database cache ?

In order to improve performance mod_pls (Apache component) caches some database content to file. This database/plssql cache is usually of type session and plsql cache
# session cache is used to store session information.
# plsql cache is used to store plsql cache i.e. used by mod_pls

Where is DATABASE/PLSSQL cache stored ?

PLSSQL and session cache are stored under $IAS_ORACLE_HOME/ Apache/modplsql/cache directory.

What is *.DBC file and whats is location of DBC file ?

DBC as name stands for is database connect descriptor file used to connect to database. This file by default located in $FND_TOP/secure directory also called as $FND_SECURE directory.

What is content of DBC file and why its important ?

DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses DBC file. Typical entry in DBC file is
GUEST_USER_PWD
APPS_JDBC_URL
DB_HOST

(Continued on next part...)