EBS 11i and R12 configuration and environment file locations
File
|
Oracle Apps 11i
|
Oracle Apps R12
|
Environment Source file
|
$APPL_TOP/APPSORA.env
|
$APPL_TOP/APPS<$CONTEXT_NAME>.env
|
Context File (Middle tier)
|
$APPL_TOP/admin/$TWO_TASK.xml
|
$INST_TOP/appl/admin/$CONTEXT_NAME.xml
|
tnsnames.ora (OH)
|
$ORACLE_HOME/network/admin/<$CONTEXT_NAME >
|
$INST_TOP/ora/10.1.2/network/admin
|
listener.ora
|
$ORACLE_HOME/network/admin/<$CONTEXT_NAME >
|
$INST_TOP/ora/10.1.2/network/admin
|
appsweb.cfg
|
$OA_HTML/bin
|
$INST_TOP/ora/10.1.2/forms/server
|
tnsnames.ora (Apache)
|
$IAS_ORACLE_HOME/network/admin/<$CONTEXT_NAME >
|
$INST_TOP/ora/10.1.3/network/admin
|
jsev.properties
|
$IAS_ORACLE_HOME/Apache/Jserv/etc
|
$INST_TOP/ora/10.1.3/opmn/conf/opmn.xml
|
httpd.conf
|
$IAS_ORACLE_HOME/Apache/Apache/conf
|
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf
|
apps.conf
|
$IAS_ORACLE_HOME/Apache/Apache/conf
|
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf
|
formservlet.ini
|
$IAS_ORACLE_HOME/Apache/Jserv/etc
|
$ORACLE_HOME/forms/server/default.env
|
topfile.txt
|
$APPL_TOP/admin
|
$APPL_CONFIG_HOME/admin
|
adovars.env
|
$APPL_TOP/admin
|
$APPL_CONFIG_HOME/admin
|
adjborg2.txt
|
$APPL_TOP/admin
|
$APPL_CONFIG_HOME/admin
|
SSL Certificates
|
$COMMON_TOP/admin/certs
|
$INST_TOP/certs
|
AD scripts logs
|
$COMMON_TOP/admin/log/<$CONTEXT_NAME >
|
$LOG_HOME/appl/admin/log
|
Concurrent Request logs
|
$APPLCSF
|
$APPLCSF
|
Workflow mailer log
|
$APPLCSF/$APPLLOG/FNDCPGSC*.txt
|
$APPLCSF/$APPLLOG/FNDCPGSC*.txt
|
Apache logs
|
$IAS_ORACLE_HOME/Apache/Apache/logs
|
$LOG_HOME/ora/10.1.3/Apache
|
Jserv logs
|
$IAS_ORACLE_HOME/Apache/Jserv/logs
|
$LOG_HOME/ora/10.1.3/j2ee
|
javacache.log
|
$COMMON_TOP/rgf/<SID_hostname>
|
$LOG_HOME/appl/rgf
|
A. Startup/Shutdown Log files for Application Tier in R12
Instance Top is new TOP added in R12
–Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt…
$INST_TOP/logs/appl/admin/log
–Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web)
$INST_TOP/logs/ora/ (10.1.2 & 10.1.3)
$INST_TOP/logs/ora/10.1.3/Apache/error_log[timestamp]
$INST_TOP/logs/ora/10.1.3/opmn/ (OC4J~…, oa*, opmn.log)
$INST_TOP/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 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)
Clone log files in target instance
Database Tier – $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log
Apps Tier – $INST_TOP/admin/log/ApplyAppsTier_.log
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/$SID/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 – $ORACLE_HOME/.patch_storage
D. Autoconfig related log files in R12
i) Database Tier Autoconfig log :
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/adconfig.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/NetServiceHandler.log
ii) Application Tier Autoconfig log : $INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log
Autoconfig context file location in R12 – $INST_TOP/apps/$CONTEXT_NAME/appl/admin/$CONTEXT_NAME.xml
E. R12 Installation Logs
Database Tier Installation
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
$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:
$Global Inventory/logs/cloneActions.log
$Global Inventory/logs/oraInstall.log
$Global Inventory/logs/silentInstall.log
F. Other log files in R12
1) Database Tier
1.1) Relink Log files :
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME /MMDDHHMM/ make_$MMDDHHMM.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 Logs :
OUI Inventory Logs :
$ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs
2) Application Tier
$ORACLE_HOME/j2ee/DevSuite/log
$ORACLE_HOME/opmn/logs
$ORACLE_HOME/network/logs
Tech Stack Patch 10.1.3 (Web/HTTP Server)
$IAS_ORACLE_HOME/j2ee/forms/logs
$IAS_ORACLE_HOME/j2ee/oafm/logs
$IAS_ORACLE_HOME/j2ee/oacore/logs
$IAS_ORACLE_HOME/opmn/logs
$IAS_ORACLE_HOME/network/log
$INST_TOP/logs/ora/10.1.2
$INST_TOP/logs/ora/10.1.3
$INST_TOP/logs/appl/conc/log
$INST_TOP/logs/appl/admin/log
