Oracle APPLICATION R12 Log File Locations
![Oracle APPLICATION R12 Log File Locations](https://syedsaadali.com/wp-content/uploads/2023/05/SyedSaadAli_ACE_linkedin-e1685600570483.png)
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