Saturday, July 18, 2009

How to find location of Install, Autoconfig, Patching , Clone and other logs in R12

Log files are useful in troubleshooting issues in Oracle Applications.
Here is the list of Log file location in Oracle Applications for Startup/Shutdown, Cloning, Patching, DB & Apps Listener and various components in Apps R12/12i:

Note:Instance top ($INST_TOP) is new directory added in R12 to keep the log files ,Startup/stop scripts for the application tier

A. Startup/Shutdown Log files for Application Tier in R12 =========================================================

i) Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt… :

$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

ii) Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web) :

$INST_TOP/apps/$CONTEXT_NAME/logs/ora/ (10.1.2 & 10.1.3) $INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp] $INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/opmn/ (OC4J~…, oa*, opmn.log)$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.2/network/ (listener log) $INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log (CM log files)

B. Log files related to cloning in R12
=======================================
Preclone (adpreclone.pl) log files in source instance

i) Database Tier-$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_
ii) Apps Tier - $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_
Post-Clone (Adcfgclone.pl) log files in target instance
i) Database Tier- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_
ii) Apps Tier - $INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_

If your clone on DB Tier fails while running txkConfigDBOcm.pl ( Check metalink note - 415020.1) During clone step on DB Tier it prompts for “Target System base directory for source homes” and during this you have to give like /base_install_dir like ../../r12 and not oracle home like ../../r12/db/tech_st_10.2.0 C.

Patching related log files in R12
======================================
i) Application Tier-- adpatch log - $APPL_TOP/admin//log/
ii) Developer (Developer/Forms & Reports 10.1.2) Patch - $ORACLE_HOME/.patch_storage
iii) Web Server (Apache) patch - $IAS_ORACLE_HOME/.patch_storage
iv) Database Tier opatch log - $RDBMS_ORACLE_HOME/.patch_storage


D. Autoconfig related log files in R12
========================================
i) Database Tier Autoconfig log : $ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log $ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log
ii) Application Tier Autoconfig log -
$INST_TOP/apps/$CONTEXT_NAME/admin/log//adconfig.log

E. R12 Installation Logs
==========================
Database Tier Installation logs:

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log

Application Tier Installation logs :

$INST_TOP/logs/.log $APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log $INST_TOP/logs/ora/10.1.2/install/make_.log $INST_TOP/logs/ora/10.1.3/install/make_.log $INST_TOP/admin/log/ApplyAppsTechStack.log $INST_TOP/admin/log/ohclone.log $APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log $APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppltop_.log $APPL_TOP/admin/$CONTEXT_NAME/log//adconfig.log $APPL_TOP/admin/$CONTEXT_NAME/log//NetServiceHandler.log
Inventory Registration logs : /logs/cloneActions.log /logs/oraInstall.log /logs/silentInstall.log


F. Other log files in R12 =========================
1) Database Tier
1.1) Relink Log files : $ORACLE_HOME/appsutil/log/$CONTEXT_NAME // make.log
1.2) Alert Log Files : $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
1.3) Network Logs : $ORACLE_HOME/network/admin/$SID.log
1.4) OUI Inventory Logs : $ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs

No comments: