How to find log files locations in 11i and R12


The following log files location could help you to find-out issues and errors from your application 11i instance.

Database Tier Logs are

Alert Log File location:
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log

Trace file location:
$ORACLE_HOME/admin/SID_Hostname/udump

Application Tier Logs

Start/Stop script log files location:
$COMMON_TOP/admin/log/CONTEXT_NAME/

OPMN log file location
$ORACLE_HOME/opmn/logs/ipm.log

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:
$APPL_TOP/admin/PROD/log or $APPLLOG/$APPLCSF

Patch log file location:
$APPL_TOP/admin/PROD/log

Worker Log file location:
$APPL_TOP/admin/PROD/log

AutoConfig log files location:
Application Tier:
$APPL_TOP/admin/SID_Hostname/log//DDMMTime/adconfig.log

Database Tier:
$ORACLE_HOME/appsutil/log/SID_Hostname/DDMMTime/adconfig.log

Error log file location:
Application Tier:
$APPL_TOP/admin/PROD/log

Database Tier :
$ORACLE_HOME/appsutil/log/SID_Hostname




In Oracle Applications R12, the log files are located in $LOG_HOME (which translates to $INST_TOP/logs)
Below list of log file locations could be helpful for you:

Concurrent Reqeust related logs
$LOG_HOME/appl/conc - > location for concurrent requests log and out files
$LOG_HOME/appl/admin - > location for mid tier startup scripts log files

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/apps/$CONTEXT_NAME/logs/appl/admin/log

Patch log files location:
$APPL_TOP/admin/$SID/log/

Clone and AutoConfig log files location in Oracle E-Business Suite Release 12 

Logs for the adpreclone.pl are located: 
On the database tier: 
RDBMS $ORACLE_HOME/appsutil/log/< context >/StageDBTier_< timestamp >.log

On the application tier: 
$INST_TOP/admin/log/StageAppsTier_< timestamp >.log

Where the logs for the admkappsutil.pl are located? 
On the application tier: 
$INST_TOP/admin/log/MakeAppsUtil_< timestamp >.log

Logs for the adcfgclone.pl are located:


On the database tier: 
RDBMS $ORACLE_HOME/appsutil/log/< context >/ApplyDBTier_< timestamp >.log

On the application tier: 
$INST_TOP/admin/log/ApplyAppsTier_< timestamp >.log
.
Logs for the adconfig are located: 

On the database tier: 
RDBMS $ORACLE_HOME/appsutil/log/< context >/< timestamp >/adconfig.log
RDBMS $ORACLE_HOME/appsutil/log/< context >/< timestamp >/NetServiceHandler.log

On the application tier: 
$INST_TOP/admin/log/< timestamp >/adconfig.log
$INST_TOP/admin/log/< timestamp >/NetServiceHandler.log

What is the Location of Autoconfig  logfile ?


Autoconfig log files will be stored in this directory
$APPL_TOP/admin/$CONTEXTFILE/<timestamp>/log/adconfig.log.log


Eg: $APPL_TOP/admin/SID_Hostname/log//DDMMTime/adconfig.log

Where to find the adpatch log files ?


Patch log files will be stored in this directory
$APPL_TOP/admin/$SID/log like adpatchXXX.log

Where to find the Apps 11i JVM logs ?

JVM log location is defined in java.sh ( found in $IAS_ORACLE_HOME/Apache/Apache/bin) Oracle Apps 11i JVM log file directory is defined by parameter JVMLOGDIR ( $IAS_ORACLE_HOME/Apache/Jserv/logs/jvm ) and log file are defined by STDOUTLOG & STDERRLOG. Example of JVM log files are

    OACoreGroup.0.stderr ,OACoreGroup.0.stdout, DiscoGroup.0.stdout, DiscoGroup.0.stderr, XmlSvcsGrp.0.stderr, XmlSvcsGrp.0.stdout

- where 0 denotes first JVM & if  1 denotes second JVM. stderr records error encountered in JVM & stdout records other information like GC(Gargbage Collecter).

What is *.dbc file and what is the location of dbc file ?



 DBC as name stands for is database connect descriptor file used to connect to database.

DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses DBC file.

This file by default located in $FND_TOP/secure directory also called as $FND_SECURE directory.

Typical entry in DBC file is:

GUEST_USER_PWD
APPS_JDBC_URL
DB_HOST

Whats is the location of access_log file ?


access_log file by default is located in $IAS_ORACLE_HOME/ Apache/Apache/logs. Location of this file is defined in httpd.conf by patameter CustomLog or TransferLog.

What are the restart files? and its location?


 These files contains the previous session info about AD utilities like... adadmin.. Location is $APPL_TOP\admin\sid\restart\*.rf9

Where is  appsweb.cfg or appsweb_$CONTEXT.cfg files are stored and why it’s used?



 This file is defined by environment variable FORMS60_WEB_CONFIG_FILE This is usually in directory $OA_HTML/bin on forms tier.

This file is used by any forms client session. When a user try to access forms, f60webmx picks up this file and based on this configuration file creates a forms session to user/client.

What is the naming conventions for concurrent request log,out files and manager log files


Log file :
                l<request id>.req


Output files:

                 o<request id>.out


Where are the managers logfiles goes:

Similar to concurrent requset output and log,
the concurrent manager does also generate some files and typical naming convention are as below:

ICM logfile: Default is std.mgr, can be changed with the mgrname

    Concurrent manager log: w<XXXXXX>.mgr
    Transaction manager log: t<XXXXXX>.mgr
    Conflict Resolution manager log: c<XXXXXX>.mgr

Where: <XXXXXX> is the concurrent process id of the manager.

If APPLCSF is not set where is the location of concurrent Requests ?

If we not set the APPLCSF location for concurrent Requests . Here it will store in Product top

i.e $PRODUCT_TOP/log/


Where is the location of log file of ICM if APPLCSF is not set.

$FND_TOP/log/

How can we find the log & out files of concurrent Requests?
or
 what is the location of log & out files of concurrent Requests?

From Back end :
Log file Locations:  $APPLCSF/$APPLLOG
Out File Locations: $APPLCSF/$APPLOUT

Each log file and out file related to each request is identified with that request id.

From Front End:
Navigate to System Administrator --> Concurrent-->Requests-->find [button]
Log file: Click on view log button
Out file : Click on view output button

Using SQL:
Connect to sqlplus as 'apps' user
SQL>@$FNS_TOP/sql/afcmcreq.sql

Then it will promts for the request id . By using this we can view only log files.

Some of the Directory Structure and File Locations


Directories
-----------

APPL_TOP    :  Where the  Apps files reside.
                 (/m03/db1/appltop)
COMMON_TOP  :  Where the  common files  resides
       (/m03/db1/commontop)
806    :  Forms , Reports run time engine
(/m02/db1/806)
IAS         :  Webserver and Front-end connectivity enginge
(/m02/db1/ias)

Environment Variables

----------------------

DB TIER

-------

[oracle@srvr33 bin]$ echo $ORACLE_HOME

/m01/db2/rdbms

APPS TIER

----------

[applmgr@srvr33 db2]$ echo $APPL_TOP

/m03/db2/appltop

[applmgr@srvr33 db2]$ echo $COMMON_TOP

/m03/db2/commtop

[applmgr@srvr33 appltop]$ echo $ORACLE_HOME

/m02/db2/806

[applmgr@srvr33 appltop]$ echo $IAS_ORACLE_HOME

/m02/db2/ias

[applmgr@srvr33 appltop]$ echo $JAVA_TOP

/m03/db2/commtop/java

[applmgr@srvr33 appltop]$ echo $APPLCSF

/m03/db2/commtop/admin

[applmgr@srvr33 appltop]$ echo $AD_TOP

/m03/db2/appltop/ad/11.5.0

[applmgr@srvr33 appltop]$ echo $FND_TOP

/m03/db2/appltop/fnd/11.5.0

Apps Version  DB version

-------------  ----------

11.5.9    9.2.0.3

11.5.10.0  9.2.0.5

11.5.10.2  9.2.0.6

12.0.0.0  10g

Admin  Scripts Location

------------------------

Apps Tier

---------

/m03/db2/commtop/admin/scripts/db2_srvr33

ls -l|awk '{print $9}'

adalnctl.sh

adautocfg.sh

adcmctl.sh

addisctl.sh

adexecsql.pl

adpreclone.pl

adrepctl.sh

adstpall.sh

adstrtal.sh

gsmstart.sh

DB Tier

-------

/m01/db2/rdbms/appsutil/scripts/db2_srvr33

  ls -l|awk '{print $9}'

adautocfg.sh

adchknls.pl

addbctl.sh

addlnctl.sh

adexecsql.pl

adlsnodes.sh

adpreclone.pl

adstopdb.sql

adstrtdb.sql