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

Thread: Oracle Applications 11i Components, Configuration Files and Log Files

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Oracle Applications 11i Components, Configuration Files and Log Files

    ORACLE APPS COMPONENT DETAILS
    ================================================== =

    1) ComponentName : Apache
    ================================================== =

    Configuration file path :

    $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf - Main Configuration File
    $IAS_ORACLE_HOME/Apache/Apache/conf/httpd_pls.conf - pls (plsql) integration in web server
    $IAS_ORACLE_HOME/Apache/Apache/conf/apps.conf - used to define aliases used in URL access
    $IAS_ORACLE_HOME/Apache/Apache/conf/oracle_apache.conf - used to include other configuration files

    Log file path : $APACHE_TOP/Apache/logs

    Startup Script file path
    $COMMON_TOP/admin/scripts/SID_HOST/adapcctl.sh start

    Shutdown Script file path
    $COMMON_TOP/admin/scripts/SID_HOST/adapcctl.sh stop

    Process Identification method
    ps -ef|grep - i <sid>|grep - i Apache
    ps -ef|grep - i <sid>|grep - i httpd

    netstat -a|grep <webport#>

    Application Profile Names

    Application Framework Agent / Applications Web Agent / Apps servlet Agent / JTF_BIS_OA_HTML / TCF:HOST

    Troubleshooting tips

    Check the log file error_log , access_log
    Check for correct port# in httpd.conf & httpd_pls.conf
    Check all config files in $APACHE_TOP/Apache/conf for any entries
    pointing to source and replace with target
    Parameters httpd.conf: Timeout
    httpd.conf: KeepAliveTimeout
    httpd.conf: SSLSessionCacheTimeout

    2) Component Name : Concurrent Manager
    ================================================== =

    Requires tnsnames.ora, listener.ora,
    <HOSTNAME>_<SID>_ifile.ora (for PCP) in $TNS_ADMIN directory.

    Also looks for tnsnames.ora in
    $IAS_ORACLE_HOME/Apache/network/admin/<SID>_<HOSTNAME> directory.

    Log file path : $APPLCSF/$APPLLOG

    Startup Script file path
    adcmctl.sh start apps/<passwd> in $SCRIPT_TOP
    (SCRIPT_TOP=$COMMON_TOP/admin/scripts/<SID>_<HOSTNAME>)

    Shutdown Script file path
    adcmctl.sh stop apps/<passwd> in $SCRIPT_TOP
    (SCRIPT_TOP=$COMMON_TOP/admin/scripts/<SID>_<HOSTNAME>)

    Process Identification method
    ps -eaf | grep <apuser> | grep FND
    ps -eaf | grep <apuser> | grep FNDLIBR = Standard and Internal Manager
    (should spawn multiple FND processes)

    ps -eaf | grep <apuser> | grep FNDSM = Service Manager
    ps -eaf | grep <apuser> | grep FNDCRM = Conflict Resolution Manager


    3) Component Name : Discoverer 4i
    ================================================== =

    Configuration file path
    #-------------Discoverer configuration files (details of ports and IP
    addresses)-------------------------
    $ORACLE_HOME/discwb4/discwb.sh
    $ORACLE_HOME/discwb4/util/pref.txt
    $ORACLE_HOME/vbroker/bin/gatekeeper.properties
    $APACHE_TOP/Apache/htdocs/discwb4/applet/gatekeeper.properties

    #-------------Discoverer components registration files
    $ORACLE_HOME/discwb4/util/applypreferences.sh
    $ORACLE_HOME/discwb4/util/registerosaagent.sh
    $ORACLE_HOME/discwb4/util/registeroad.sh
    $ORACLE_HOME/discwb4/util/registerlocator.sh
    $ORACLE_HOME/discwb4/util/registerall.sh
    $ORACLE_HOME/discwb4/util/unregisterlocator.sh
    $ORACLE_HOME/discwb4/util/unregisteroad.sh
    $ORACLE_HOME/discwb4/util/unregisterosaagent.sh
    $ORACLE_HOME/discwb4/util/unregisterall.sh
    #--------------Registered components detail
    files----------------------------------------------------------------
    $ORACLE_HOME/vbroker/adm/impl_dir/impl_rep~
    $ORACLE_HOME/vborker/adm/impl_dir/impl_rep
    $IAS_ORACLE_HOME/Apache/Apache/htdocs/discwb4/applet/gatekeeper.ior
    $IAS_ORACLE_HOME/Apache/Apache/htdocs/discwb4/applet/locator.ior
    Log file path $ORACLE_HOME/discwb4/util/oad.log
    $ORACLE_HOME/discwb4/util/osaagent.log
    $ORACLE_HOME/discwb4/util/locator.log
    $ORACLE_HOME/discwb4/util/error.txt
    $ORACLE_HOME/discwb4/util/diag.log
    $APACHE_TOP/Apache/htdocs/discwb4/applet/gatekeeper.log

    Startup Script file path

    $ORACLE_HOME/discwb4/util/startosaagent.sh
    $ORACLE_HOME/discwb4/util/startoad.sh
    $ORACLE_HOME/discwb4/util/startlocator.sh
    $ORACLE_HOME/discwb4/util/startgatekeeper.sh
    $ORACLE_HOME/discwb4/util/startall.sh

    Shutdown Script file path
    $ORACLE_HOME/discwb4/util/stopgatekeeper.sh
    $ORACLE_HOME/discwb4/util/stoplocator.sh
    $ORACLE_HOME/discwb4/util/stopoad.sh
    $ORACLE_HOME/discwb4/util/stoposaagent.sh
    $ORACLE_HOME/discwb4/util/stopall.sh

    Process Identification method

    ps -ef|grep vbroker
    netstat -a|grep 10508
    netstat -a|grep 10552
    $ORACLE_HOME/discwb4/util/checkdiscoverer.sh
    $ORACLE_HOME/discwb4/oadutil list
    $ORACLE_HOME/discwb4/osfind

    Application Profile Names
    ICX: Discoverer Launcher
    ICX: Discoverer Viewer Launcher
    ICX: Discoverer use Viewer
    ICX: Discoverer Default End User Layer Schema Prefix

    Troubleshooting tips
    1.Check the Log files
    2.Commonly issues are with the dbc file or tnsnames.ora

    4) Component Name : FORMS
    ================================================== =

    Configuration file path

    1.$COMMON_TOP/html/bin/appsweb_SID_Hostname.cfg. = main configuration file for Forms Server
    2.$FND_TOP/resource/appsweb_SID_Hostname.cfg.

    Check the configuration file name in SID.env file under APPL_TOP dir.

    Log file path : Log files are under $COMMON_TOP/admin/log/SID_Hostname/

    Startup Script file path
    1.Start Forms Server Listener process
    $COMMON_TOP/admin/scripts/SID_Hostname/adfrmctl.sh start.
    2.Start Forms Metrics Client
    $COMMON_TOP/admin/scripts/SID_Hostname/adfmcctl.sh start.
    3.Start Forms Metrics Server
    $COMMON_TOP/admin/scripts/SID_Hostname/adfmsctl.sh start.

    Shutdown Script file path
    1.Stop Forms Server Listener process
    $COMMON_TOP/admin/scripts/SID_Hostname/adfrmctl.sh stop.
    2.Stop Forms Metrics Client
    $COMMON_TOP/admin/scripts/SID_Hostname/adfmcctl.sh stop.
    3.Stop Forms Metrics Server
    $COMMON_TOP/admin/scripts/SID_Hostname/adfmsctl.sh stop.

    Process Identification method
    ps -ef |grep f60 ,
    ps -ef |grep f60srvm = Forms Server
    ps -ef |grep f60webmx = Forms Runtime Client

    Application Profile Names

    1.ICX: Forms Launcher.
    2.Forms Runtime Parameter.

    Troubleshooti ngtips
    1.Check whether FORMS60_MAPPING in $APPL_TOP/SID.env is set to correct URL or not.
    2.Check whether serverPort,serverName and domainName are correctly set in
    3.Configuration errors in $COMMON_TOP/html/bin/appsweb_SID_Hostname.cfg file.

    5) Component Name : Reports Server
    ================================================== =


    Configuration file path : $ORACLE_HOME/reports60_server
    Log file path : $ORACLE_HOME/report60/server/REP60_<SID>.log

    Startup Script file path
    $SCRIPT_TOP/adrepctl.sh start

    Shutdown Script file path
    SCRIPT_TOP/adrepctl.sh stop

    Process Identification method
    ps -ef |grep rwmts60

    Application Profile Names
    ICX: Report Launcher Troubleshooting tips

    Check password in CGIcmd.dat (ORACLE_HOME/report60/server)
    & Display variable in ORACLE_HOME/report60_server, DISPLAY
    variable in Jserv/etc as well

    6) Component Name : Jserv/Jsp
    ================================================== =

    Name Configuration file path
    $APACHE_TOP/Jserv/etc/jserv.conf = Used to configure the jvms
    jserv.properties = Used to set the properties of the oacore JVM
    jserv_restrict.properties
    $APACHE_TOP/Apache/conf/oprocmgr.conf
    Log file path $APACHE_TOP/Jserv/logs & $APACHE_TOP/Jserv/logs/jvm

    Startup Script file path (same script as Apache)
    $SCRIPT_TOP/adapcctl.sh start

    Shutdown Script file path
    $SCRIPT_TOP/adapcctl.sh stop

    Process Identification method
    netstat -an | grep <port mentioned in oprocmgr.conf>

    Application Profile Names
    Apps Servlet Agent,Applications JSP Agent,OTS: JSP Details from OTS

    Troubleshooting tips
    Check <Apache Home Page URL>/servlets/Hello, Apache Log files , Jserv log files and
    configuration files mentioned above.

    7) Component Name : Workflow
    ================================================== =

    Configuration file path
    OAM for Java based Notification Mailer and in older version C based Notif Mailer $FND_TOP/resource/wfmail.cfg

    Log file path $APPLCSF/$APPLLOG (ls -ltr FNDCP*.txt ie FNDCPGSC* and check for last 2 files)
    Startup Script file path : Starts with OAM
    Shutdown Script file path : Stops with OAM

    Process Identification method
    1. Checking sendmail : telnet <hostname> smtp or ps -ef | grep sendmail
    2. Checking imap: telnet
    <hostname> imap
    3. Workflow starts with Concurrent Manager so needs to check
    Concurrent Manager logs
    Application

    Profile Names
    Two tables needs to be checked for workflow :
    1. wf_systems table: select name, display_name from wf_systems;
    2. wf_agents table: select address from wf_agents;
    3. OAM displays status information of Workflow Components from FND_SVC_COMPONENTS

    Troubleshooting tips
    Check the Log File
    Check the 3 CM related Workflow processes
    Check the Agent Status and Notif Mailer Properties
    Test Sendmail and IMAP
    Check WF related Requests shuold be scheduled

+ Reply to Thread

Similar Threads

  1. Relocate Database Files
    By devesh_ocp in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 04-24-2012, 10:58 PM
  2. Administering .dbc Files
    By pkumar in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 02-29-2012, 06:42 AM
  3. Oracle Database Online Redo Log Files Management.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 01-13-2012, 10:40 PM
  4. Log Files for Troubleshooting Oracle RAC issues
    By Hemant in forum RAC Performance,LoadBalancing,TAF,FAN,Troubleshooting
    Replies: 0
    Last Post: 12-15-2011, 06:16 PM
  5. Oracle Applications R12 Log Files
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 10-29-2011, 08:38 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