LogFile Location in R12

Finding Oracle Concurrent Request Log Files:
Concurrent Requests Log And Out Files
$LOG_HOME/APPL/CONC/log
$LOG_HOME/APPL/CONC/out

Mid Tier Startup Scripts Log Files
$LOG_HOME/APPL/ADMIN

Startup/Shutdown error message text files
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log



Finding Oracle Apache Log Files:
Apache Error and Access log files
$LOG_HOME/ora/10.1.3/apache

J2EE related log files
$LOG_HOME/ora/10.1.3/j2ee

OPMN related log files
$LOG_HOME/ora/10.1.3/opmn


Finding Forms & Reports Log Files:
Forms related log files
$LOG_HOME/ora/10.1.2/forms

Reports related log files
$LOG_HOME/ora/10.1.2/reports


Finding Oracle Alert Log Files:
$ORACLE_HOME/admin/$CONTEXT_NAME/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace

Finding Oracle Cloning Related Log Files:
These are pre-cloned log files in source instance
Database Tier
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(STAGEDBTIER_MMDDHHMM.log)
Application Tier
$INST_TOP/apps/$CONTEXT_NAME/admin/log/(STAGEAPPSTIER_MMDDHHMM.log)

These are cloned log files in target instance
Database Tier
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/APPLDBTIER_ .log
Application Tier
$INST_TOP/apps/$CONTEXT_NAME/admin/log/APPLYAPPSTIER_ .log



find *.xml -mtime +100 -print -exec rm {} \;

Note that there are spaces between rm, {}, and \;
Explanation

• The first argument is the path to the files. This can be a path, a directory, or a wildcard as in the example above. I would recommend using the full path, and make sure that you run the command without the exec rm to make sure you are getting the right results.
• The second argument, -mtime, is used to specify the number of days old that the file is. If you enter +5, it will find files older than 5 days.
•  The third argument, -print, will print the file which are been deleted.
• The fourth argument, -exec, allows you to pass in a command such as rm. The {} \; at the end is required to end the command.