Author: Jim Kerry
Log files are useful in troubleshooting issues in Oracle Applications. No matter whatever approach you follow but the task of finding Oracle log files is common to all database administrators. Finding Oracle Log files in prior versions of Oracle database was quite easy as you could easily find it in $APPLCSF/$APPLLOG or $APACHE_TOP/APACHE/LOGS directories.
You can use below command to view information on log files:
SELECT * FROM V$LOG;
You can find the location of Oracle log files by doing a cd to $ ORACLE _HOME and finding files with .log extension.
However when we talk about Oracle 11i databases then things becomes a bit difficult. I am working on Oracle 11i and the task of finding Oracle log files in Oracle R12 proved to be havoc for me and unfortunately I had to spend lots of time in getting a clue of where I can find oracle log files. This is because in Oracle R12 the Oracle log files does not exist any more at its older location rather you will find them in $LOG_HOME that translates to $INST_TOP/LOGS. All log files except ADCONFIG are placed here.
Finding Oracle Concurrent Request Log Files:
Location |
Description |
$LOG_HOME/APPL/CONC |
Concurrent Requests Log And Out Files |
$LOG_HOME/APPL/ADMIN |
Mid Tier Startup Scripts Log Files |
$INST_TOP/APPS/$CONTEXT_NAME/LOGS/APPL/ADMIN/LOG |
Startup/Shutdown error message text files |
Finding Oracle Apache Log Files:
Location |
Description |
Comment |
$LOG_HOME/ORA/10.1.3/APACHE |
Apache Error and Access log files |
10.1.3 Oracle Home corresponds to iAS Oracle Home. |
$LOG_HOME/ORA/10.1.3/J2EE |
J2EE related log files |
$LOG_HOME/ORA/10.1.3/OPMN |
OPMN related log files |
Finding Forms & Reports Log Files:
Location |
Description |
Comment |
$LOG_HOME/ORA/10.1.2/FORMS |
Forms related log files |
10.1.2 Oracle Home corresponds to 806 Oracle Home |
$LOG_HOME/ORA/10.1.2/REPORTS |
Reports related log files |
Finding Oracle Alert Log Files:
Location |
$ORACLE_HOME/ADMIN/$CONTEXT_NAME/BDUMP/ALERT_$SID.LOG |
Finding Oracle Network Log Files:
Location |
$ORACLE_HOME/NETWORK/ADMIN/$SID.LOG |
Finding Oracle Cloning Related Log Files:
Location |
Description |
Comment |
/$ORACLE_HOME/APPSUTIL/LOG/$CONTEXT_NAME/(STAGEDBTIER_MMDDHHMM.LOG) |
Database Tier |
These are pre-cloned log files in source instance |
$INST_TOP/APPS/$CONTEXT_NAME/ADMIN/LOG/ (STAGEAPPSTIER_MMDDHHMM.LOG) |
Application Tier |
$ORACLE_HOME/APPSUTIL/LOG/$CONTEXT_NAME/APPLYDBTIER_ .LOG |
Database Tier |
These are cloned log files in target instance |
$INST_TOP/APPS/$CONTEXT_NAME/ADMIN/LOG/APPLYAPPSTIER_ .LOG |
Application Tier |
Finding Patching Related Log Files:
Location |
Description |
$APPL_TOP/ADMIN/$SID/LOG/ |
Application Tier ADPATCH log |
$ORACLE_HOME/.PATCH_STORAGE |
Developer/Forms and Reports 10.1.2 |
$IAS_ORACLE_HOME/.PATCH_STORAGE |
Web Server /Apache patch |
$ORACLE_HOME/.PATCH_STORAGE |
Database Tier OPATCH log |
Finding Autoconfig Related Log Files:
Location |
Description |
$ORACLE_HOME/APPSUTIL/LOG/$CONTEXT_NAME/MMDDHHMM/ADCONFIG.LOG |
Database Tier |
$ORACLE_HOME/APPSUTIL/LOG/$CONTEXT_NAME/MMDDHHMM/NETSERVICEHANDLER.LOG |
$INST_TOP/APPS/$CONTEXT_NAME/ADMIN/LOG/$MMDDHHMM/ADCONFIG.LOG |
Application Tier |
$INST_TOP/APPS/$CONTEXT_NAME/APPL/ADMIN/$CONTEXT_NAME.XML |
Autoconfig context file |
Finding Oracle Relink Log Files:
Location |
$ORACLE_HOME/APPSUTIL/LOG/$CONTEXT_NAME /MMDDHHMM/ MAKE_$MMDDHHMM.LOG |
Finding Oracle OUI Log Files:
Location |
$ORACLE_HOME/ADMIN/OUI/$CONTEXT_NAME/ORAINVENTORY/LOGS |
More Oracle Articles, Database Articles and DBA Tips
Database Security: Step by step guideline
Oracle – SQL: Performance Boost with Collections
Inside Oracle Temporary Tablespace!!
Identify the root causes of Poor Oracle Performance!!
Inside Oracle 11g Adaptive Cursor Sharing Feature!!
|
