R12 - Various LogFiles Locations :
Startup/Shutdown Log files for Application Tier in R12
$LOG_HOME/appl/admin/log/
| Service | Logfile Name |
| TNS Listener Start/Stop log | adalnctl.txt |
| Fulfillment Server Start/Stop log | jtffmctl.txt |
| Oracle HTTP Server start/stop log | adapcctl.txt |
| Concurrent Managers and ICM start/stop log | adcmctl.txt |
| Forms OC4J start/stop log | adformsctl.txt |
| OACore OC4J start/stop log | adoacorectl.txtq |
| OAFM OC4J start/stop log | adoafmctl.txt |
| OPMN start/stop log | adopmnctl.txt |
Tech Stack 10.1.3 (Web/HTTP Server) Logs
| Log File Name | Log File Location |
| AD script log files (e.g.from adapcctl.sh) | $INST_TOP/logs/appl/admin/log |
| CM Log Files ($APPLCSF/$APPLLOG) | $INST_TOP/logs/appl/conc/log |
| AD tools log files (e.g. ADPATCH) | $APPL_CONFIG_HOME/admin/$TWO_TASK/log |
| OPMN Log Files (text and ODL) | $ORA_CONFIG_HOME/10.1.3/opmn/logs (may move to $INST_TOP/logs/10.1.3/opmn) |
| Apache Log Files (text and ODL) | $INST_TOP/logs/10.1.3/Apache/ |
| OC4J Log Files (text) | $INST_TOP/logs/10.1.3/j2ee/oacore/ |
| OC4J Log Files (ODL) | $INST_TOP/logs/10.1.3/j2ee/oacore/log/oacore_default_group_1/oc4j |
Log files related to cloning 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
-- 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
Patching 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
-- 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
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
-- $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
Other log files in R12
Database Tier
Relink Log files :
-- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME /MMDDHHMM/ make_$MMDDHHMM.log
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 Logs
OUI Inventory Logs :
-- $ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs
Application Tier
-- $ORACLE_HOME/j2ee/DevSuite/log
-- $ORACLE_HOME/opmn/logs
-- $ORACLE_HOME/network/logs
-- $ORACLE_HOME/opmn/logs
-- $ORACLE_HOME/network/logs
Posts
+ comments + 8 comments
[...] R12 various Log file locations… [...]
Hello Srikrishna
Thanks for the Info. Appreciate your effort in doing KT. :)
Small clarification about the alert log location in R12. I guess it depends on the database version in place.
If the database is 11g, the alert log is in $ORACLE_HOME/../../diag/rdbms///trace/ location.( or atleast something like that as the diagnostic top location is decided during the db install with ORACLE_BASE - if you chose advanced installation.)
Please correct me if wrong.
Best Regards
Sree
Sorry, I think the location was truncated in my update.
It was supposed to be $ORACLE_HOME/../../diag/rdbms/sid/SID/trace/
BR
Sree
Yes, You are right Harsha. The default installation of R12 comes with 10g and if R12 is using 11g database, it stores the trace files in DIAGNOSTIC_DEST value. This is the new parameter introduced in 11g database. This home stores all the logs and traces of all the oracle components like ASM, CRS, listener, DB at a single location unlike oracle 10g.
This is same as ADR home. The Automatic Diagnostic Repository (ADR) stores diagnostic data such as alter log, trace files, user and background dump files, and also new types of troubleshooting files such as Health Monitor reports, Incident packages, SQL test cases and Data repair records.
BTW, how are you Harsha?
Thanks
SRI
Hi Srikrishna.
Thanks for confirming.
Yeah. I am doing good. I thought you wouldn't remember me. How are you doing in ESD?
I have to admit your blog is very informative and helpful. Keep up the good work.
Regards
Sree Harsha
Thanks so much Harsha for your feedback and i also need your inputs to fine tune the articles.
Now i am not working with Oracle,but still in touch with all our oracle friends.Keep in touch.
Thanks
SRI
Hi,
Is there a way to change the log and output file destination of oracle applications/module.
By default, all are dumped to $APPLCSF/APPLLOG and $APPLCSF/APPLOUT.
I need to make it $APPLCSF/AR for Receivables reports log and output, $APPLCSF/AP for Payables.
Regards
Hi,
found it, remove the $APPLCSF in the context. But the destination will take the default TOP directory of the module.
regards
Post a Comment
Thank you for visiting our site and leaving your valuable comment.