Oracle APPLICATION R12 Log File Locations

APPS R12 LOG FILE LOCATIONS

Log files are useful in troubleshooting issues in Oracle Applications. Below is the given list of Log file location in Oracle Applications for Startup/Shutdown, Cloning, Patching, DataBase & Apps Listener and various components in ORACLE  Apps R12/11i:

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

Instance Top is new TOP added in R12

Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt…

• $INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web)

• $INST_TOP/apps/$CONTEXT_NAME/logs/ora/ (10.1.2 & 10.1.3)
• $INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp]
• $INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/opmn/ (OC4J~…,oa*,opmn.log)
• $INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.2/network/ (listener log)
• $INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log (CM log files)

2. Cloning Log files in R12

Preclone log files  in source instance

Database Tier

• $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)

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/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log

3. Patch related log files in R12

Application Tier adpatch log

• $APPL_TOP/admin/$SID/log/

Developer (Developer/Forms & Reports 10.1.2) Patch

• $ORACLE_HOME/.patch_storage

Web Server (Apache) patch

• $IAS_ORACLE_HOME/.patch_storage

Database Tier opatch log

• $ORACLE_HOME/.patch_storage

4. Autoconfig related log files in R12

Database Tier Autoconfig log :

• $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/adconfig.log
• $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/NetServiceHandler.log

Application Tier Autoconfig log –

• $INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log

Autoconfig context file location in R12 –

• $INST_TOP/apps/$CONTEXT_NAME/appl/admin/$CONTEXT_NAME.xml

5. Other log files in R12

1.Database Tier

•  Relink Log files :
• $ORACLE_HOME/appsutil/log/$CONTEXT_NAME /MMDDHHMM/ make_$MMDDHHMM.log
• Alert Log Files
• $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
• Network Logs :
• $ORACLE_HOME/network/admin/$SID.log
• 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