Contact Premier Online Trainings Today
Premier Online Trainings

Oracle Apps DBA - Log files location and environment variables in Oracle apps

Date Added: 09 Oct.2019 Date Updated: 10 Oct.2019 Oracle Apps DBA Full Blog

Log files location and environment variables in oracle apps 11i, R12.1 and R12.2

Below are some of the important Operating system level environment variables  related to R12.2.

Set the environment 
Source <EBS install base>/EBSapps.env run
 
$ echo $FILE_EDITION
<shows which file edition you are using, run or patch>
 
$ echo $RUN_BASE
<shows absolute path to run file system>
 
$ echo $PATCH_BASE
<shows absolute path to patch file system>
 
$ echo $NE_BASE
<shows absolute path to non-edition file system>
 
$ echo $APPL_TOP_NE
<non-editioned appl_top path. Equivalent to $NE_BASE/EBSapps/appl>
 
$ echo $LOG_HOME
<Application Instance Specific Log Directory>
 
$ echo $ADOP_LOG_HOME
<Online patching Specific Log Directory. Equivalent to $NE_BASE/EBSapps/log/adop>
 
$ echo $IAS_ORACLE_HOME
<FMW Web Tier Home Directory>
 
$ echo $ORACLE_HOME
< 10.1.2 ORACLE_HOME>
 
$ echo $CONTEXT_FILE
<Source for information populating template files (autoconfig)>
 
$ echo $EBS_DOMAIN_HOME
<WLS Deployment of Oracle E-Business Suite 12.2 Domain (instance specific)>
 
$ echo $ADMIN_SCRIPTS_HOME
<Shell scripts to control processes associated to the Applications Instance>
 
$ echo $EBS_ORACLE_HOME
<Oracle E-Business Suite 12.2 FMW Deployment directory>
 
$ echo $RW
<10.1.2 reports directory>
 
$ echo $HOSTNAME
<hostname without domain name>
 
$ echo $APPS_VERSION
<to get the EBS version>
 
check the services status
 
$ ps -ef | grep "NodeManager"
$ ps -ef | grep "weblogic.Name=AdminServer"
$ ps -ef | grep "weblogic.Name=forms-c4ws_server"
$ ps -ef | grep "weblogic.Name=forms_server"
$ ps -ef | grep "weblogic.Name=oafm_server"
$ ps -ef | grep "weblogic.Name=oacore_server"
 
 
11i Common Logfile location
 
Database Tier Logs are
Alert Log File location:
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
 
Trace file location:
$ORACLE_HOME/admin/$CONTEXT_NAME/udump
 
Database Tier:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/DDMMTime/adconfig.log
 
Application Tier Logs
Start/Stop script log files location:
$COMMON_TOP/admin/log/$CONTEXT_NAME/
 
Apache, Jserv, JVM log files locations:
$IAS_ORACLE_HOME/Apache/Apache/logs/ssl_engine_log
$IAS_ORACLE_HOME/Apache/Apache/logs/ssl_request_log
$IAS_ORACLE_HOME/Apache/Apache/logs/access_log
$IAS_ORACLE_HOME/Apache/Apache/logs/error_log
$IAS_ORACLE_HOME/Apache/JServ/logs
 
Concurrent log file location:
$APPLCSF  or $/$APPLLOG( if $APPLCSF is unset)
 
Patch log file location:
$APPL_TOP/admin/$TWO_TASK/log
 
Worker Log file location:
$APPL_TOP/admin/$TWO_TASK/log
 
AutoConfig log files location:
Application Tier:
$APPL_TOP/admin/$CONTEXT_NAME/log//DDMMTime/adconfig.log
 
R12.0/R12.1 Common Logfiles location
The log files are located in $LOG_HOME ($INST_TOP/logs) in  Oracle Applications R12
 
Database Tier
Alert Log File location:
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
 
Trace file location:
$ORACLE_HOME/admin/SID_Hostname/udump
 
Logs for the adpreclone.pl are located:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/StageDBTier_< timestamp >.log
 
Logs for the adcfgclone.pl are located:
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_< timestamp >.log
 
Logs for the adconfig are located:
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/< timestamp >/adconfig.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/< timestamp >/NetServiceHandler.log
 
Application Tier
Apache Logs (10.1.3 Oracle Home which is equivalent to iAS Oracle Home - Apache, OC4J and OPMN)
$LOG_HOME/ora/10.1.3/Apache - > Location for Apache Error and Access log files
$LOG_HOME/ora/10.1.3/j2ee - > location for j2ee related log files
$LOG_HOME/ora/10.1.3/opmn - > location for opmn related log files
 
Forms & Reports related logs (10.1.2 Oracle home which is equivalent to 806 Oracle Home)
$LOG_HOME/ora/10.1.2/forms
$LOG_HOME/ora/10.1.2/reports
 
Startup/Shutdown Log files location:
$INST_TOP/logs/appl/admin/log
 
Patch log files location:
$APPL_TOP/admin/$TWO_TASK/log/
 
Logs for the adpreclone.pl are located:
$INST_TOP/admin/log/StageAppsTier_< timestamp >.log
 
Where the logs for the admkappsutil.pl are located?
$INST_TOP/admin/log/MakeAppsUtil_< timestamp >.log
 
Logs for the adcfgclone.pl are located:
$INST_TOP/admin/log/ApplyAppsTier_< timestamp >.log
.
Logs for the adconfig are located:
$INST_TOP/admin/log/< timestamp >/adconfig.log
$INST_TOP/admin/log/< timestamp >/NetServiceHandler.log
 
R12.2 Common Logfiles location
Many  log files are located in $LOG_HOME ($INST_TOP/logs) in  Oracle Applications R12.2
 
Database Tier
Alert Log File location:
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
 
Trace file location:
$ORACLE_HOME/admin/SID_Hostname/udump
 
Logs for the adpreclone.pl are located:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/StageDBTier_< timestamp >.log
 
Logs for the adcfgclone.pl are located:
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_< timestamp >.log
 
Logs for the adconfig are located:
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/< timestamp >/adconfig.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/< timestamp >/NetServiceHandler.log
 
Application Tier
 
R12.2 has Fusion Middleware Stack
Log files for OPMN and OHS processes:
$IAS_ORACLE_HOME/ instances/ <ohs_instance>/diagnostics/logs/OPMN
$IAS_ORACLE_HOME/ instances/ <ohs_instance>/diagnostics/logs/OHS
 
Log files for weblogic node manager:
$FMW_HOME/ wlserver_10.3/ common/ nodemanager/ nmHome1/ nodemanager.log
 
LogFiles for Weblogic Admin/Managed Servers
$EBS_DOMAIN_HOME/ servers/ <server_name>/logs/
 
Forms & Reports related logs (10.1.2 Oracle home which is equivalent to 806 Oracle Home)
$LOG_HOME/ora/10.1.2/forms
$LOG_HOME/ora/10.1.2/reports
 
Startup/Shutdown Log files location:
$INST_TOP/logs/appl/admin/log
 
ADOP Patch log files location:
$NE_BASE/ EBSapps/ log/adop/<adop_session_id>/<phase>_<date>_<time>/<context_name>/log
 
Logs for the adpreclone.pl are located:
$INST_TOP/admin/log/StageAppsTier_< timestamp >.log
 
Where the logs for the admkappsutil.pl are located?
$INST_TOP/admin/log/MakeAppsUtil_< timestamp >.log
 
Logs for the adcfgclone.pl are located:
$COMMON_TOP/clone/bin/CloneContext_*.log
 
Logs for the adconfig are located:
$INST_TOP/admin/log/< timestamp >/adconfig.log
$INST_TOP/admin/log/< timestamp >/NetServiceHandler.log
 
Concurrent Manager Logfiles
$NE_BASE/ inst/<CONTEXT_NAME>/logs/appl/conc/log
$NE_BASE/ inst/<CONTEXT_NAME>/logs/appl/conc/out