Forgot your password?    
+ Reply to Thread
Results 1 to 6 of 6

Thread: Understand Apache in Apps 11i environment

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120

    Understand Apache in Apps 11i environment

    Oracle Web Server or OHS is entry point in applications, It processes requests coming from network over Client. There is Web Listener listening for Web Requests. If request is for simple html page core Apace returns HTML page , and dependig on the type of request, it will be forwarded to respective module like mod_pls, mod_jserv.

    Start/Stop Web Server :
    All startup shutdown scripts in Oracle Applications 11i(11.5.10) are in $OAD_TOP/admin/script/$CONTEXT_NAME where
    OAD_TOP is also called as COMMON_TOP and CONTEXT_NAME is your SID_hostname

    Script to start/stop Web Server is adapcctl.sh where ad (application dba), apc(apache), ctl(control) and sh stands for shell script.
    adapcctl.sh calls apachectl (shell script in $IAS_ORACLE_HOME/Apache/Apache/bin) which in turn calls HTTPD (in same directory which is executable called http daemon)

    Apache Related Configuration Files :

    • Apache starts using configuration file httpd.conf (from $IAS_ORACLE_HOME/Apache/Apache/conf directory , this file calls other configuration file.
    When Apache starts , it starts with damon HTTP using httpd.conf (in Apache/Apache/conf) this is main configuration file which contain config parameters for Core Apache component(Few Important parameters are PidFile, Port, Listen, User, ServerAdmin, ServerName, DocumentRoot, ErrorLog, LogLevel, LogFormat, TransferLog, ErrorDocument , VirtualHost, SSLLog, SSLLogLevel, include, SSLCeritificateXXXX, RewriteEngine)

    • httpd.conf file calls jserv.conf (used for mod_jserv), oprocmgr.conf (oracle process manager), oracle_apache.conf (Oracle Custom Modules like mod_pls, mod_ossl, mod_osso..)

    • jserv.conf - available at $IAS_ORACLE_HOME/Apache/Jserv/etc . This file calls few properties files ( jserv.properties, viewer4i.properties, forms.properties, xmlsvcs.properties )

    • oprocmgr.conf - Used to configure and manage each remote apache Instances managed by local Apache Instance.

    • oracle_apache.conf - This configuration file under $IAS_ORACLE_HOME/ Apache/Apache /conf is used to configure Oracle built modules supplied with default Apache ( for eg. mod_plsql, oem, imeeting). This file calls other configuration files ( plsql.conf, immeting.conf, apps.conf)

    • plsql.conf - This file under $IAS_ORACLE_HOME/Apache/modplsql/cfg is used to configure pls (Plsql). This file defines to forward all requests like /pls/ to dedicated apache listener.

    • wdbsvr.app - This file under $IAS_ORACLE_HOME/Apache/modplsql/cfg. This file contain your dad (database Access Descriptor ) information like database connection description & apps user name & password.If you are changing apps password you use utility FNDCPASS and after changing password you have to manually change apps password in this file.
    This file is used by the mod_plsql enging to connect to the database.

    • Under iAS/Apache/Apache important directory/files are bin (executable, apachectl,httpd) ,conf ( httpd.conf, httpd_pls.conf, oracle_apache.conf ), logs (access_log, access_log_pls, error_log, error_log_pls, httpd.pid )

    • Under iAS/Apache/Jserv files/directory you want to know are etc(config files), logs(jvm,mod_jserv.log)

    • Under iAS/Apache/modplsql important bits are cache (cookie,plsql), cfg(wdbsvr.app , *.conf)


    Oracle Apps Web Server Troubleshooting :

    In order to troubleshoot any Apache problems , look at log file. All Oracle components have their own logs in respective directory. For Oracle Web Server (OHS/Apache) there are two places depending on type of issue , core apache/web server issues are recorded in

    • Main Apache and its logs are at $IAS_ORACLE_HOME/Apache/Apache/logs
    Where as anything related to Servlets, mod_jserv, JVM (Java Virtual Machine) should be in

    • mod_jserv for servlets & jvm issues and its logs are at $IAS_ORACLE_HOME/Apache/Jserv/ logs & jvm

    • LogLevel in httpd.conf Control the number of messages logged to the error_log. Possible values include: debug, info, notice, warn, error, crit, alert, emerg. (Helpful during troubleshooting).
    Will need to restart Apache after modifying this alue to take effect.
    Refer to : Enable-Logging-on-HTTP-Web-Server-Apache


    Some Important Parameters defined in httpd.conf

    • PidFile The file in which the server should record its process identification number when it starts.

    • Port This is the Port of the Web Cache. It is not used in Apps.

    • Listen The port to which the standalone server listens.

    • User/Group The name (or #number) of the user/group to run httpd as

    • ServerAdmin E-Mail address, where problems with the server should be e-mailed.

    • ServerName ServerName allows you to set a host name which is sent back to clients for your server if it's different than the one the program would get.

    • DocumentRoot The directory out of which you will serve your documents.

    • ErrorLog The location of the error log file.

    • LogLevel Control the number of messages logged to the error_log. Possible values include: debug, info, notice, warn, error, crit, alert, emerg. (Helpful during troubleshooting)

    • LogFormat Format of your access_log which records all users hitting your site.

    • TransferLog To implement Feature like rotatelog ( Logs will be rotated based on timestamp or size)

    • ErrorDocument Customizable error response in case oracle web server return http code 500 or 404

    • VirtualHost Used if you want to set Virtual Host for your Oracle Application Web Server.

    • SSLLog Used to record SSL logs ( If SSL Secured Socket Layer is configured with oracle applications web server)

    • SSLLogLevel Log Level of SSL logs, helpful in troubleshooting SSL issues with Oracle Web Server.

    • SSLCeritificateX If SSL is enabled on apps 11i , used to define ssl parameters, like certificate file.

    • RewriteEngine To define Redirects for your Oracle Apps Web Server.
    Last edited by Hemant; 12-13-2011 at 10:08 AM.

  2. #2
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43

    Cool Apache problem

    Hi
    I am trying to bounce apache but when i am giving ./adapcctl.sh stop its hanging and not stopping.
    I am able to stop it through apachectl in IAS_ORACLE_HOME/Apache/Apache/bin but not from ./adapcctl.sh.
    What would be the cause for this???

  3. #3
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43
    Any updates on this???

  4. #4
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    It could be a problem with the script(adapcctl.sh) or the JServ or PL/SQL Web listener.

    First try :
    Kill the apache and jvm processes ; Then make sure you remove the httpd_pls.pid and httpd.pid(in $IAS_ORACLE_HOME/Apache/Apache/logs);
    Then start and stop Apache using adapcctl.sh

    If that does not help , Second try :
    Shut down Apps services & Run autoconfig and check if the problem gets resolved.
    Autoconfig-Usage-on-11i

    If it does not resolve :
    You may also need to enable dugugging for Apache and Jserv and restart Apache , to know more on the problem.
    See the error_log and the error_log_pls (in $IAS_ORACLE_HOME/Apache/Apache/logs), and mod_jserv.log to see if there are any errors there.

  5. #5
    Oracle Administrator
    Join Date
    Oct 2011
    Location
    Venice
    Posts
    40

    Enable Apache Debug

    Debug Apache

    1. Shut the HTTP Server (Apache/iAS) down. - You can grep for the 'httpd' process to verify it is down
    2. Rename (or delete) the following files so we get a fresh copy of them:
    /Apache/Jserv/logs/jserv.log
    /Apache/Jserv/logs/mod_jserv.log
    /Apache/Jserv/logs/jvm (the whole directory if it exists)/Apache/Apache/logs/access_log*
    /Apache/Apache/logs/error_log
    /Apache/Apache/logs/error_log_pls (if it exists)

    Turn on debugging in the log files:

    3. Modify the $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.conf file.
    Search for the parameter: ApJServLogLevel notice
    Change the 'notice' to 'debug'

    4. Modify the $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties file. Search for the following section:

    log=false
    Change this to be log=true
    and Change log.channel=false
    To be: log.channel=true

    5. Modify the $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf file. Search for:
    LogLevel
    Set the LogLevel to 'debug' from its current value.

    6. Modify the $IAS_ORACLE_HOME/Apache/Apache/conf/httpd_pls.conf file (if it exists). Search for the following parameter
    LogLevelSet the LogLevel to 'debug' from its current value.

    7. In the zone.properties...- servlet.framework.initArgs=debuglevel=1

    8. Start the HTTP Server
    Cheers !
    pk.ora

  6. #6
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43

    Clearing cache in R12

    Step1: Log in and choose the Functional Administrator responsibility – then choose Home.

    Step2:Choose the Core Services Tab – then the Caching Framework Sub-Menu .

    Step3:Click Global Configuration’ from the left hand side menu that appears and – In the far right choose ‘Clear all Cache’ button

    Step4: A screen prompts and confirms that the action will clear all cache on the middle tier server – choose Yes.

    Step5: A confirmation message is displayed, confirming that all cache has been cleared across middle tiers.

+ Reply to Thread

Similar Threads

  1. Understand Create Controlfile statement while cloning
    By mdmasood in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 03-23-2012, 12:10 PM
  2. Issues regarding FULL GCs in JVMs and JVM crashing in 11.5.10 EBS environment
    By Chitiz in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 1
    Last Post: 02-29-2012, 03:45 PM
  3. Hi I am getting error in apache log in r12
    By deviilm17 in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 1
    Last Post: 11-17-2011, 06:40 PM
  4. Common Problems in Starting Apache
    By Amit in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 11-03-2011, 04:42 PM
  5. How to get a clean Autoconfig Environment
    By Amit in forum AD Utilities , Autoconfig , FND Utilities
    Replies: 0
    Last Post: 11-01-2011, 02:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics