Sunday, August 10, 2025

Oracle Database & Applications R12.2 Log file locations

Many times, we forget the path for the log files since there are too many. 
Below is the list of frequently used log files which can help us out in our day to day activities. 

Database Alert Log Files :

$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log

Database Network Logs :

$ORACLE_HOME/network/admin/$SID.log

Database OUI Inventory Logs :

$ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs

Database Tier opatch log : 

$ORACLE_HOME/.patch_storage

Database Tier Relink Log files :

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

Log files for start/stop of application services from $ADMIN_SCRIPTS_HOME

$LOG_HOME/appl/admin/log

Log/Out files for Concurrent programs/managers

Log files: $APPLCSF/$APPLLOG (or $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/log)
Out files: $APPLCSF/$APPLOUT (or $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/out)

Log files for OPMN and OHS processes

$IAS_ORACLE_HOME/instances/<ohs_instance>/diagnostics/logs

Log files for Autoconfig process

On Applicaion Tier: $INST_TOP/admin/log/<MMDDhhmm>
On Database Tier: $ORACLE_HOME/appsutil/log/<CONTEXT_NAME>/<MMDDhhmm>

Log file for Weblogic Node Manager

Log file is generated by Node Manager and contains data for all domains that are controlled by Node Manager on a given physical machine.

$FMW_HOME/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log

Log file for Weblogic Oracle Management Service log file

Initial settings AdminServer and Domain level information is written in this log file

$EBS_DOMAIN_HOME/sysman/log

Log files for managed server processes initiated through Weblogic

Stdout and stderr messages generated by the server instance (server instances like forms, oafm, oacore etc) at NOTICE severity level or higher are written by Weblogic Node Manager to below directory.

$EBS_DOMAIN_HOME/servers/<server_name>/logs/<server_name>.log
$EBS_DOMAIN_HOME/servers/<server_name>/logs/<server_name>.out

Log files file Online patching (adop)

$ADOP_LOG_HOME/<adop_session_id>/<date>_<time>/<phase>
or
$NE_BASE/EBSapps/log/adop/<adop_session_id>/<date>_<time>/<phase>

This log directory will contain patch logs, patch worker logs and other patch related log files created for specific purposes.

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/admin/log/ StageAppsTier_MMDDHHMM.log
  • Clone log files in target instance
Database Tier – $ORACLE_HOME/appsutil/log/

Application Tier – $INST_TOP/admin/log/



Oracle Database & Applications R12.2 Log file locations

Many times, we forget the path for the log files since there are too many.  Below is the list of frequently used log files which can help us...