Tuesday, 2 July 2013

Oracle Application Administration Question

As salamo alaikum wa rahmatullah,

Where are Apache log files located, and what are these files?
ans) Apache log files are stored in $IAS_ORACLE_HOME/Apache/Apache/logs. The log files are error_log,error_log_pls,access_log and access_log_pls.

Where are Apache configuration files stored and what are the important Apache configuration files?
ans) Apache configuration files are stored in  $IAS_ORACLE_HOME/Apache/Apache/conf directory.The main configuration files are httpd.conf,apps.conf,httpd_pls.conf,oprocmgr.conf, and oracle_apache.conf.

How do i know which file - httpd.conf or httpds.conf is being used by Apache?
ans) The same can be determined by examining the script apachectl  which is located at $IAS_TOP/Apache/Apache/bin. it is internally  called by the script adapcctl.sh which is located at the script 
location. In the script apachectl, there is a variable httpd defined, which points to either the httpd or the httpds executable. if the httpd varaible in the apachectl script calls httpd, Apache configuration depends on httpd.conf. if the apachectl script calls httpds, Apache configuration depends on httpds.conf.

In case of a shared APPL_TOP, where do i see the configuration files adn log files for the Apache?
ans) In case of the a shared APPL_TOP, the techstach home is shared across all the different server so all the Apache and Jserv configuration files are stored in $IAS_CONFIG_HOME directory.There will be a separate $IAS_CONFIG_HOME directory for each node of the application system.

I have done a couple of customizations in apps.conf, jserv.properties but each time i run the autoconfig it is overwriting the customizations.what do i do?
ans) To overcome this problem, go to the $FND_TOP/admin/template directory. There also, you will see all those configuration files. Make a directory custom in the $FND_TOP/admin/template directory and copy all the files where you want to do the customization from $FND_TOP/admin/template to $FND_TOP/admin/template/custom and do the customizationin the files in custom directory. Now run autoconfig. To explain this, let take an example, Say you want to do some customization in the apps.conf file. The usual location of the apps.conf file is $IAS_ORACLE_HOME/Apache/Apache/conf. The same file 
is alos available in the $FND_TOP/admin/template directory. Copy the apps.conf file from  $FND_TOP/admin/template directory to custom directory. Make all teh customizations in the apps.conf file in the custom directory. Now run autoconfig.The customizations will now be read from the files in custom directory.

where are jserv configuration files stored?
ans)Jserv configuration files are stored in $IAS_ORACLE_HOME/Apache/Jserv/etc.

What are the important configuration files which are used for making Apache run along with Jserv?
ans)$APACHE_TOP/Apache/conf/httpd.conf (or httpds.conf, depending on yuor platform)
Whereas $APACHE_TOP refers to the $IAS_ORACLE_HOME/Apache directory.

Where are Jserv log fileslocated?
ans)The Jserv files are located in the $IAS_ORACLE_HOME/Apache/Jserv/log directory and in the format 

Wher are JVM log files located?
ans)The JVM log files are located in the $IAS_ORACLE_HOME/Apache/Jserv/log/jvm directory.

How do i check the version of Apache?
ans)The version of the same can be checked using the command $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v.

When i login to the Oracle Applications from the PHP based  applications, login page simply hangs. What approach should i follow for the debugging?
ans)If the login page hangs, the first step would be to check the Apache log files. Go to the Apache log directory and check for the access_log and error_log. You will get some information there. If you are not able to find anything then check for the Jserv logs from there you will get some infomation.Also,check the logs of the JVM. Try to analyze all the errors that you are getting from log files and try to fix them. Still if you are not able to debug anything then do an AOL diagnostics test wich will tell you where the issue is. You can also enable debug for Apache, Jserv if you are not getting any pointer from the logs.

How do i enable debug for Apache?
ans)Edit the hpptd.conf/httpds.conf file to enable debug for apache. Find the following section in the apache configuration file and set the LogLevel to debug. you may want to make a backup of thsi file before you edit. Now Apache log files will be written with the debug information. You also need to bounce the Apache after the making the changes.

How do i enable debug for Jserv?
ans)Edit the jserv.conf to enable debug for the Jserv module. Find the following section in jserv.conf and set the LogLevel to debug. Also, edit the jserv.properties to enable debug for the java portion of the Apache jserv find the following section in jserv.properties and set 
log=true, log.channle=true. You also need to bounce the apache after making the changes. Now log files will be written with the debug infomation.

How can i launch AOL diagnostics test?
ans) The AOL diagnostics test can be launched using the following URL.http(s)://<host><domain>:<port>/OA_HTML/jsp/fnd/aoljtest.jsp It prompts for the database hostname,SID,port names, apps userid and apps password. In case of RAC environments, you have to give the JDBC URL.

How do i know about the location of JDBC URL?
ans)The JDBC URL is there in the DBC file in the $FND_TOP/secure directory.Open the file and you will get the JDBC URL from there.

How do I test whether my DBC file is valid or not?
ans)you can check the validity of the DBC file using the AdminAppServer utility. Run the following command 
->javaoracle.apps.fnd.security.AdminAppServer appsun/appspw STATUS DBC=[path to dbc]/[dbc_name].dbc
This should return STATUS:VALID

I have accidentally deleted DBC file of my status of the DBC file is invalid, how do i recreate the same?
ans) Run Autoconfig. It will recreate the DBC file else you can also create the same by running the script adgendbc.sh located at $COMMON_TOP/admin/install directory.

What is plsql cache and what is its importance?
ans)The mod_pls component of the Apache caches some database content to file.The plsql cache also known as database cache is of the type session and plsql cache.The session cache is used to store the session information and the plsql cache is used to store the plsql cache which is used by mod_pls. It is stored in the $IAS_ORACLE_HOME/Apache/modplsql/cache directory.

How do i enable PL/SQL logging?
ans)Edit the file wdbsvr.app which is usually found in $ORACLE_HOME/Apache/modplsql/cfg/ and set the following two parameters -
debugModules=all and LogingLevel=Debug

What is admin server?
ans)The admin server is that node of the $APPL_TOP from which all the maintenance activities for Oracle Applications are performed.

What kind of maintenance activities can be performed from admin server?
ans) The following maintenance activities can be performed from admin server.
-> Applying the Patches
-> Maintaining Oracle Applications
-> Applying the ad utilities
-> Upgrading Oracle Application

Does admin server also have a process like Apache and Forms server?
ans)No, the admin server doesn't have an operating system process like Apache or Forms server. It is basically a node of the APPL_TOP.

What is concurrent processing server?
ans)When an Oracle Application user submits a request to run a program, it's called concurrent requests. Concurrent Manager are the programs responsible for running the concurrent requests.Concurrent requests are processed from concurrent processing server.

Mohammad Shahnawaz
Oracle's Passion


  1. Very helpful question and answer. keep continue posting.
    Thank you