| Startup/shutdown | Apps tier services are started and stopped frequently and we must know logfiles when troubleshooting startup/shutdown issues. | $INST_TOP/logs/appl/admin/log | $INST_TOP/logs/appl/admin/log |
| Apache | OHS being part of opmn in r12.1 has continued in r12.2. Logfile locations for troubleshooting have been changed | $INST_TOP/logs/ora/10.1.3/Apache/error_log[timestamp] $INST_TOP/logs/ora/10.1.3/opmn/HTTP_Server~1.log |
$IAS_ORACLE_HOME/instances/*/diagnostics/logs/OHS/*/*log* |
| OPMN | Logfile locations for r12.1 and r12.2 have been changed | $INST_TOP/logs/ora/10.1.3/opmn/opmn* | $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OPMN/opmn/* |
| Oacore | oacore in r12.1 is oc4j component and part of 10gAS. However, in r12.2, oacore is now a managed server for weblogic server | $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore*/ $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore*/ $LOG_HOME/ora/10.1.3/opmn/oacore*/oacorestd.err $LOG_HOME/ora/10.1.3/opmn/oacore*/oacorestd.out |
oacore logfile - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oacore_server1/logs/oacore_server1.log oacore out file - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oacore_server1/logs/oacore_server1.out oacore diagnostic log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oacore_server1/logs/oacore_server1-diagnostic.log |
| forms | form in r12.1 is oc4j component and part of 10gAS. However, in r12.2, form is now a managed server for weblogic server | $LOG_HOME/ora/10.1.3/j2ee/forms/forms*/ $LOG_HOME/ora/10.1.3/j2ee/forms/forms*/ $LOG_HOME/ora/10.1.3/opmn/forms*/formsstd.err $LOG_HOME/ora/10.1.3/opmn/forms*/formsstd.out |
form server log -
$FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms_server1/logs/forms_server1.log form server access log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms_server1/logs/access.log form server out file - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms_server1/logs/forms_server1.out form server diagnostic log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms_server1/logs/forms_server1-diagnostic.log forms-c4ws_server1 log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms-c4ws_server1/logs/forms-c4ws_server1.log forms-c4ws_server1 out file - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms-c4ws_server1/logs/forms-c4ws_server1.out forms-c4ws_server1 diagnostic log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms-c4ws_server1/logs/forms-c4ws_server1-diagnostic.log |
| oafm | oafm in r12.1 is oc4j component and part of 10gAS. However, in r12.2, oafm is now a managed server for weblogic server | $LOG_HOME/ora/10.1.3/j2ee/oafm/forms*/ $LOG_HOME/ora/10.1.3/j2ee/oafm/forms*/ $LOG_HOME/ora/10.1.3/opmn/oafm*/oafmstd.err $LOG_HOME/ora/10.1.3/opmn/oafm*/oafmstd.out |
oafm logfile -
$FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oafm_server1/logs/oafm_server1.log oafm outfile - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oafm_server1/logs/oafm_server1.out oafm diagnostic log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oafm_server1/logs/oafm_server1-diagnostic.log |
| CM Logfile location | CM manager logs are present under $APPLCSG/APPLLOG in both r12.1 and r12.2 | $APPLCSF/$APPLLOG –LOG files $APPLCSF/$APPLOUT—Out files $APPLCSF/$APPLLOG/*mgr – Manager log files. $APPLCSF/$APPLLOG/FNDSM* --Fndsm log file $APPLCSF/$APPLLOG/<instance_name>* --ICM log file $APPLCSF/$APPLLOG/*opp* --OPP log file |
$APPLCSF/$APPLLOG –LOG files $APPLCSF/$APPLOUT—Out files $APPLCSF/$APPLLOG/*mgr – Manager log files. $APPLCSF/$APPLLOG/FNDSM* --Fndsm log file $APPLCSF/$APPLLOG/<instance_name>* --ICM log file $APPLCSF/$APPLLOG/*opp* --OPP log file |
| Patching logs | In r12.1 we have adpatch utility that facilitates patching for ebs, for other components, developer home, webserver and database, opatch is used. In r12.2 however, we have adop utility to apply patches and logfile location has changed to $NE_BASE | Application Tier adpatch log – $APPL_TOP/admin/$SID/log/ Developer (Developer/Forms & Reports 10.1.2) Patch – $ORACLE_HOME/.patch_storage Web Server (Apache) patch – $IAS_ORACLE_HOME/.patch_storage Database Tier opatch log – $ORACLE_HOME/.patch_storage |
Application Tier adop
log – $NE_BASE/EBSapps/log/adop, WORKER log file location : $NE_BASE/EBSapps/log/adop/<adop_session_id>/apply_<no>/context_name/<patch_no>/log/ AUTO skip log path : $NE_BASE/EBSapps/log/adop/<adop_session_id>/apply_<no>/context_name/<patch_no>/log/autoskip.log Patch log location : $NE_BASE/EBSapps/log/adop/<adop_session_id>/apply_<no>/context_name/<patch_no>/u<patch>.log OHS- $ORACLE_HOME/.patch_storage FMW_HOME – -log option to store log of bsu.sh Database Tier opatch log – $ORACLE_HOME/.patch_storage |
| Apps listener | $LOG_HOME/ora/10.1.2/network/ |
$LOG_HOME/ora/10.1.2/network/ |
|
| Autoconfig Logs | autoconfig historical run and logs have same location in both releases | $INST_TOP/admin/log | $INST_TOP/admin/log |
| Adadmin logs | Different locations for adadmin as logs in ebs r12.2 have moved to NE_BASE | $APPL_TOP/admin/<SID>/log | $NE_BASE/EBSapps/log/adadmin/log |
| Other Logs in r12.2 | Few more logs worth noting in ebs r12.2 | NA | Nodemanager Log files PATH $IAS_ORACLE_HOME/../wlserver_10.3/common/nodemanager Admin Server logfiles path $EBS_DOMAIN_HOME/servers/AdminServer/logs/*log* |
Defragment workflow related tables in r12 References- 1. How to Reorganize Workflow Tables? (Doc ID 388672.1) 2. EBS Workflow (WF) Analyzer (Doc ID 1369938.1) Points to Remember – Some workflow tables are associated to queues so that it is necessary to use the advance queuing instructions to reorganize them. For tables other than queue tables, please refer to different notes created by RDBMS team to reorganize tables. This activity depends on the RDBMS version. Defragment tables in workflow r12 Verify tables are not associated to queues – SQL> select queue_table from dba_queue_tables 2 where queue_table like '%WF%'; QUEUE_TABLE ------------------------------ WF_CONTROL WF_DEFERRED WF_DEFERRED_TABLE_M WF_ERROR WF_IN WF_INBOUND_TABLE WF_JAVA_DEFERRED WF_JAVA_ERROR WF_JMS_IN WF_JMS_JMS_OUT WF_JMS_OUT WF_NOTIFICATION_IN WF...
Good info, but pls adjust the QR code, Live Feed, views sections to make visible the content properly..
ReplyDeleteThanks