Oracle Apps 11i DBA Interview Questions

Google
 
Web teachmeoracle.com
Home Overview Architecture Installation Patching Training Feedback
 
My Blog
WebServer
Concurrent
Autoconfig
Cloning
Training
Apps Interview Q's
Tuning
Contact Us
 
 
     If you want to submit any technical questions for oracle apps 11i which might be helpful for other's to understand applications Mail Me.    Q. What is access_log in Apache ?

access_log file keeps record of users accessing Oracle Apps 11i Webserver.

Typical entry in access_log is like

198.0.0.1 - - [25/Aug/2006 :03:15:13 +0100] "GET /OA_JAVA /oracle /forms /registry/Registry.dat HTTP/1.1" 200 4117
Which means client with IP 198.0.0.1 requested for file mentioned above on 25 Aug 2006 at 03:15 AM , 200 is status code returned by Apache which means page returned successfully (Status Code 302 means page redirected , 404 page not found, 500+ Internal Server error)
last digit 4117 in above entry of access_log means file size which is 4117 bytes. This file is quite useful in monitoring your Web Server.

Please note above format might defer on your system as this is dependent log_format in Apache configuration file ( httpd.conf)

    Q. 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

 Q. 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)

   
P.S. You can configure 10g Application Server as well with Oracle Apps 11i.

Best of luck for your interview. If you are not happy with quality of questions or want to submit 11i Apps Interview questions Mail Me.

  
Previous Page Next Page
 

Oracle Apps 11i | Oracle Portal | Collaboration Suite | My Blog
Copyright © teachmeoracle.com
This work is copyright protected, Copying content from this site is illegal