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

Thread: How to perform Applications 11i Health Check

  1. #1

    Red face How to perform Applications 11i Health Check

    As Oracle Apps DBA / Sysadmin you Apply patches & restart servives or make some configuration changes in applications 11i before releasing Instance to Application Users you wish to check if all components in E-Business Suite 11i are working fine. Here is list of components you should check apart from your custom services.

    1. Check Web Server is Up : Check in browser http://hostname.domainname: port where hostname.domain name is Machine Name on which Web Server(OHS) is running. If you are using load balancer or Proxy Server in front of Web Server it will be loadbalancer / Proxy Server Name. Port is port on which Web Server is Listening. It is defined in $IAS_ORACLE_HOME /Apache /Apache /conf /httpd.conf , If you can't access this check error_log at $IAS_ORACLE_HOME /Apache /Apache/ logs

    2. Check Jserv is Up : Check if you can access OAM (Oracle Application Manager) page. http://hostname.domainname: port_num...m/oam/oamLogin If you can't access login screen for OAM, check logs at

    3. Check mod_pls is working fine : http://hostname.domainname: port/pls/$SID so if you installed vision instance with SID as VIS11I your SID here is VIS11II this sometime in documents also called as TWO_TASK. You should see output from procedure FND_WEB.PING . If not check that -
    A) database listener is Up
    B) GUEST User is not end dated & password is correct.
    C) dbc (database connect descriptor) file is corerct at $FND_TOP/secure
    D) apps password is correct in wdbsvr.app at $IAS_ORACLE_HOME/Apache/modplsql/cfg

    4. Login to Application : Login to application with Application User to confirm login is working fine , if not check mod_pls for any issues.

    5. Check Form Server is working : Click on any Core Responsibility like "System Administrator", If you are facing any problem opening form Applet
    A) Check jinitiator is installed, if not do you have access to install jinitiator
    B) Try clearing cache from jinitiator
    C) Check forms server parameters are configured properly in appsweb_$CONTEXT_NAME.cfg
    D) Check if form server listener is Up : netstat -an | grep form_server_port

    6. Check Concurrent Manager is Up & Running : Select "Administer Concurrent Manager" & check if "Actual" & "Target" are same. If not check $SID_MM_DD.mgr at $APPLCSF/$APPLLOG.

    7. Check Reports can display properly : Change "Active Users" reports output from "Text file" to "PDF" from Define Concurrent Request Screen. Submit Active Users request & click on Output , check if you can se report in PDF format. If you encounter error like REP-3000 Oracle Toolkit , issue is with DISPLAY.

    8. Check Apps Listener is Up : Apps listener is different from database listener, Apps Listener is used for various purpose one is to check output & log files in concurrent requests. Check if apps listener is fine by clicking on log file & output file for Active Users request you submitted in Step 7 on previous page. If you encounter any issues while trying to access Log & Output file issue might be with Oracle Apps Listener. Check if adalnctl.sh (where ad is apps dba, aln is apps listener and ctl is control) on application tier started successfully. If yes then check this query (select logfile_name, logfile_node_name, outfile_name, outfile_node_name from fnd_concurrent_requests where request_id=[your request id number].

    9. Check if Workflow is Up : Login to OAM (Oracle Application Manager) using url mentioned in step. After login, On top right of page from "Nevigate to" select "Workflow Manager" from drop down menu and click on GO button. Check "Notification Mailers" is Up .

    10. Check if Discoverer 4i is Up : There are two type of discoverer 4i
    Discoverer Viewer - Check http://yourhostname: port/discoverer4i/viewer
    Discoverer Plus Check http://yourhostname:port/discwb4/htm...sh/welcome.htm

    11. Custom applications : Any custom application configured with oracle apps 11i, oem any other monitoring software.


    Regards
    Sandeep
    Last edited by sandeep.singh; 04-23-2012 at 09:20 AM.

+ Reply to Thread

Similar Threads

  1. Oracle 11g Health Checks.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 01-31-2012, 04:17 PM
  2. Health Check script for Oracle RAC Database
    By Amit in forum RAC Concepts and Administration
    Replies: 0
    Last Post: 11-03-2011, 12:41 PM
  3. Health Check script for RAC DB
    By Amit in forum Database Scripts
    Replies: 0
    Last Post: 11-03-2011, 12:41 PM

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