Home / APPS DBA / Oracle APPLICATION R12 Log File Locations

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

 

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleEBSConfig

Changing IP Address in an Oracle EBS R12 Environment

Changing IP Address in an Oracle EBS R12 Environment 1. First, Change the IP Address …

Leave a Reply