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

Thread: Oracle Applications R12 Log Files

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

    Oracle Applications R12 Log Files

    In R12, the log files are located in $LOG_HOME (which translates to $INST_TOP/logs)

    A. Component Wise Log Files for Startup Shutdown Errors / Troubleshooting:

    Concurrent Request related logs

    $LOG_HOME/appl/conc -> location for concurrent requests log and out files
    $LOG_HOME/appl/admin -> location for mid tier startup scripts log files

    Apache Logs (10.1.3 Oracle Home which is equivalent to iAS Oracle Home)

    $LOG_HOME/ora/10.1.3/Apache -> Location for Apache Error and Access log files
    $LOG_HOME/ora/10.1.3/j2ee -> location for j2ee related log files
    $LOG_HOME/ora/10.1.3/opmn -> location for opmn related log files

    Forms & Reports related logs (10.1.2 Oracle home which is equivalent to 806 Oracle Home)

    $LOG_HOME/ora/10.1.2/forms
    $LOG_HOME/ora/10.1.2/reports

    Listener log
    $LOG_HOME/ora/10.1.2/network


    B. Startup/Shutdown Log files for Application Tier in R12

    –Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt…
    $INST_TOP/appl/admin/log

    C. Log files related to cloning in R12

    Preclone log files in source instance
    i) Database Tier - /$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)

    ii) Application Tier - $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log)

    Clone log files in target instance

    Database Tier - $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log
    Apps Tier - $INST_TOP/log/ApplyAppsTier_.log

    D. Patching related log files in R12

    i) Application Tier adpatch log - $APPL_TOP/admin/$SID/log/
    ii) Developer (Developer/Forms & Reports 10.1.2) Patch - $ORACLE_HOME/.patch_storage
    iii) Web Server (Apache) patch - $IAS_ORACLE_HOME/.patch_storage
    iv) Database Tier opatch log - $ORACLE_HOME/.patch_storage

    E. Autoconfig related log files in R12
    i) Database Tier Autoconfig log :
    $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/adconfig.log
    $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/NetServiceHandler.log

    ii) Application Tier Autoconfig log - $INST_TOP/admin/log/$MMDDHHMM/adconfig.log

    Autoconfig context file location in R12 - $INST_TOP/appl/admin/$CONTEXT_NAME.xml

    F. Other log files in R12
    1) Database Tier
    1.1) Relink Log files :
    $ORACLE_HOME/appsutil/log/$CONTEXT_NAME /MMDDHHMM/ make_$MMDDHHMM.log

    1.2) Alert Log Files :
    $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log

    1.3) Network Logs :
    $ORACLE_HOME/network/admin/$SID.log

    1.4) OUI Logs :
    OUI Inventory Logs :
    $ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs

    2) Application Tier
    $ORACLE_HOME/j2ee/DevSuite/log
    $ORACLE_HOME/opmn/logs
    $ORACLE_HOME/network/logs

    Tech Stack Patch 10.1.3 (Web/HTTP Server)
    $IAS_ORACLE_HOME/j2ee/forms/logs
    $IAS_ORACLE_HOME/j2ee/oafm/logs
    $IAS_ORACLE_HOME/j2ee/oacore/logs
    $IAS_ORACLE_HOME/opmn/logs
    $IAS_ORACLE_HOME/network/log
    $INST_TOP/logs/ora/10.1.2
    $INST_TOP/logs/ora/10.1.3
    $INST_TOP/logs/appl/conc/log
    $INST_TOP/logs/appl/admin/log

+ 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 11i Components, Configuration Files and Log Files
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 10-29-2011, 07:52 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