Oracle EBS R12 log files (Patch, Clone, Startup/Shutdown)

To troubleshoot issues in Oracle Applications log files are useful.

List of log file location for Startup / Shutdown in Oracle EBS R12 are: -

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

Instance Top is new TOP added in R12. Oracle Applications/E-Business Suite Release 12 introduces a new concept of a top-level directory for an Applications Instance which is known as Instance Home and is denoted the environment variable $INST_TOP.

Instance Home contains all the config files, log files, SSL certificates etc.

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

—–
If your clone on DB Tier fails while running txkConfigDBOcm.pl 

(Check metalink note - 415020.1)
During clone step on DB Tier it prompts for 

“Target System base directory for source homes” 

and during this you have to give like  

/base_install_dir like ../../r12 and not oracle home like ../../r12/db/tech_st_10.2.0
—–

3. Patch related Log files for Application Tier 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

4. Autoconfig related Log files for Application Tier 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/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log

iii) Autoconfig context file location in R12 

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

5. Installation Log files for  R12

Database Tier Installation

RDBMS 

# $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/.log

# $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_.log

# $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log

# $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_.log

# $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log

# $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_.log

# $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_.log

# $ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log

# $ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log


Application Tier Installation

# $INST_TOP/logs/.log 
 

# $APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log
 
# $INST_TOP/logs/ora/10.1.2/install/make_.log 

# $INST_TOP/logs/ora/10.1.3/install/make_.log 

# $INST_TOP/admin/log/ApplyAppsTechStack.log

# $INST_TOP/admin/log/ohclone.log 

# $APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log 

# $APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppltop_.log

# $APPL_TOP/admin/$CONTEXT_NAME/log//adconfig.log 

# $APPL_TOP/admin/$CONTEXT_NAME/log//NetServiceHandler.log  


Inventory Registration:

# $Global Inventory/logs/cloneActions.log

# $Global Inventory/logs/oraInstall.log 

# $Global Inventory/logs/silentInstall.log

6. 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

Regards,

Sukhwinder Singh

.