Wednesday, November 24, 2010

Apps and Database LOG FILE LOCATION

APPS LOG FILE and File LOCATION

$LOG_HOME= $INST_TOP/logs

Apache Logs in R12

Access Log :  $INST_TOP/logs/ora/10.1.3/Apache/ or $LOG_HOME/ora/10.1.3/Apache
Error Log    :  $INST_TOP/logs/ora/10.1.3/Apache/ or $LOG_HOME/ora/10.1.3/Apache

Concurrent Manager logs and out files in R12

$INST_TOP/logs/appl/conc
OR $LOG_HOME/appl/conc

Forms and Reports related logs (10.1.2 O_H in R12 is equivalent to 806 O_H in 11..5.10.2)

Forms log file    :  $LOG_HOME/ora/10.1.2/forms
Reports Log file :  $LOG_HOME/ora/10.1.2/reports

Startup scripts log file Location

$LOG_HOME/appl/admin

Adpatch Log file / Worker log file / adpatch informative log file i.e adpatch.lgi

$APPL_TOP/admin/SID/log/    e.g SID=PROD

Forms.fmb  Location : $AU_TOP/forms/US/
(All fmb's reside in AU_TOP/forms/US)

Apps Environment file Location : $APPL_TOP
name will be APPSSID_HOSTNAME.env e.g APPSPROD_DEMO.env

Application startup & shutdown scripts Location : $INST_TOP/admin/scripts

Applicaton context file i.e .xml file : $INST_TOP/appl/admin/
e.g SID_HOSTNAME.xml

adpreclone.pl script location     : $INST_TOP/admin/scripts
adcfgclone.pl script location      : $COMMON_TOP/clone/bin


Database log file and File Location

adpreclone.pl script location     : $RDBMS_O_H/appsutil/scripts/SID_HOSTNAME
adcfgclone.pl script location      : $RDBMS_O_H/appsutil/clone/bin

Database listener and database startup and shutdown scripts :

$RDBMS_O_H/appsutil/scripts/SID_HOSTNAME

Database alert.log file location in 11g:

$O_H/admin/SID_HOSTNAME/diag/rdbms/sid/sid/trace
alertlog file format  alter_sid.log

All .sql scripts location :

RDBMSO_H/rdbms/admin

Parameter file location i.e Init.ora or pfile or spfile file :

$RDBMS_O_H/dbs

No comments:

Post a Comment