Posts Tagged ‘log file’

Oracle Apps R12.2.2 Log file location and Environment Variables

November 2, 2016 Leave a comment

I have compiled the name and location of all the log files in Oracle EBS 12.2.2. As a DBA, I find it quite handy when you need to do some troubleshooting with a definite timeline.

Oracle Apps R12.2.2 Log file location

Also below is the frequently used and very useful environment variables that comes handy often.

<shows which file edition you are using, run or patch>

$ echo $RUN_BASE
<shows an absolute path to run file system>

$ echo $PATCH_BASE
<shows an absolute path to patch file system>

$ echo $NE_BASE
<shows an 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>

<Online patching Specific Log Directory. Equivalent to $NE_BASE/EBSapps/log/adop>
<FMW Web Tier Home Directory>

echo $FMW_HOME
<FMW home>

< 10.1.2 ORACLE_HOME>

<Source for information populating template files (autoconfig)>

<WLS Deployment of Oracle E-Business Suite 12.2 Domain (instance specific)>

<Shell scripts to control processes associated to the Applications Instance>

<Oracle E-Business Suite 12.2 FMW Deployment directory>

$ echo $RW
<10.1.2 reports directory>

$ echo $HOSTNAME
<hostname without domain name>

<to get the EBS version>

And the most important part is for setting up the right environment don’t directly hard code the RUN environment .env file in the .profile of OS user as online patching switches the filesystem from RUN to PATCH and vice versa and it can really create confusion.
Instead use EBSapps.env environment file (created under BASE directory) with ‘RUN’ as argument. It will automatically find which file system (fs1 or fs2) is currently RUN file system and lay out the correct environment.

For example, in our case base directory is ‘/<TWO_TASK>/applmgr’

. /<TWO_TASK>/applmgr/EBSapps.env RUN

E-Business Suite Environment Information
RUN File System : /<TWO_TASK>/applmgr/fs2/EBSapps/appl
PATCH File System : /<TWO_TASK>/applmgr/fs1/EBSapps/appl
Non-Editioned File System : /<TWO_TASK>/applmgr/fs_ne
DB Host: Service/SID: <TWO_TASK>
Sourcing the RUN File System …

Hope this helps. Happy learning!!!

-Anand M

Log file location in Oracle application 11i

Below is the ready reckoner for the location of various log files in Oracle apps 11i. This is very much helpful when troubleshooting any issue

  • Database Tier
    • Alert Log File – $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
    • Trace file – $ORACLE_HOME/admin/SID_Hostname/udump
    • Autoconfig Log file – $ORACLE_HOME/appsutil/log/SID_Hostname/DDMMTime/adconfig.log
  • Application Tier
    • Autoconfig Log file             – $APPL_TOP/admin/SID_Hostname/log/DDMMTime/adconfig.log
    • Start/Stop script log files  – $COMMON_TOP/admin/log/CONTEXT_NAME/<mmddhhmi.log>
    • Concurrent log file              – $APPLCSF/$APPLLOG
    • Patch Log file                      – $APPL_TOP/admin/<SID>/log
    • Worker Log file                   – $APPL_TOP/admin/<SID>/log
    • Apache Log file                   – $IAS_ORACLE_HOME/Apache/Apache/logs/
    • Jserv log File                       – $IAS_ORACLE_HOME/Apache/Jserv/logs/
    • JVM Log File                       – $IAS_ORACLE_HOME/Apache/Jserv/logs/jvm
    • ICM log file                          – $APPLCSF/$APPLLOG/
    • Workflow Mailer log file      – $APPLCSF/$APPLLOG/FNDCPGSC*.txt
Categories: Oracle Apps Tags: ,