Thursday, March 23, 2017

Log files In r12

Log files In r12


In r12, the log files are located in $INST_TOP/logs

Adpreclone Executable:

Database Tier:
cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

Application Tier:
cd $ADMIN_SCRIPTS_HOME

Adcfgclone Executable:

Database Tier:

cd $ORACLE_HOME/appsutil/clone/bin

Application Tier:

cd $COMMON_TOP/clone/bin

Cloning log files in R12:

adpreclone.pl logs are Located at:

On the database tier:
cd $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/StageDBTier_< timestamp >.log

On the application tier:
cd $INST_TOP/admin/log/StageAppsTier_< timestamp >.log

adcfgclone.pl logs are Located at:

On the database tier:
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_< timestamp >.log

On the application tier:
$INST_TOP/admin/log/ApplyAppsTier_< timestamp >.log

Logs for the adconfig are Located at:

On the database tier:
cd $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/< timestamp >/adconfig.log
cd $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/< timestamp >/NetServiceHandler.log

On the application tier:
cd $INST_TOP/admin/log/< timestamp >/adconfig.log
cd $INST_TOP/admin/log/< timestamp >/NetServiceHandler.log

logs for the admkappsutil.pl are Located at:

On the application tier:
cd $INST_TOP/admin/log/MakeAppsUtil_< timestamp >.log

Apache Logs:

(10.1.3 Oracle Home which is equivalent to iAS Oracle Home - Apache, OC4J and OPMN)

apache error and access Log files
cd $LOG_HOME/ora/10.1.3/Apache

j2ee Log files
cd $LOG_HOME/ora/10.1.3/j2ee      

opmn Log files
cd $LOG_HOME/ora/10.1.3/opmn      

Patch log files Location:
cd $APPL_TOP/admin/$SID/log/

Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location.

cd $APPLCSF/$APPLLOG or cd $LOG_HOME/appl/conc

ICM Log:
ls -lrt *$TWO_TASK*

SM Log:  
ls -lrt w*.mgr

CRM Log:
ls -lrt c*.mgr


ICM logs with query:

SELECT 'ICM_LOG_NAME=' || fcp.logfile_name FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id AND fcp.queue_application_id = fcq.application_id AND fcq.manager_type = '0' AND fcp.process_status_code = 'A';

startup scripts log files:
cd $LOG_HOME/appl/admin/log    

Forms & Reports Logs (10.1.2 Oracle home which is equivalent to 806 Oracle Home)

cd $LOG_HOME/ora/10.1.2/forms
cd $LOG_HOME/ora/10.1.2/reports

In 11i, the log files of concurrent manager, apache etc are at: $APPLCSF/$APPLLOG or $APACHE_TOP/Apache/logs

Database Tier Logs:
Alert Log File location:
cd $ORACLE_HOME/admin/$CONTEXT_NAME/diag/alert_$SID.log

alertlog with query:

select value from v$diag_info where name='Diag Alert';

OPMN log file location
$ORACLE_HOME/opmn/logs/ipm.log

Apache, Jserv, JVM log files locations:
cd $IAS_ORACLE_HOME/Apache/Apache/logs/ssl_engine_log
cd $IAS_ORACLE_HOME/Apache/Apache/logs/ssl_request_log
cd $IAS_ORACLE_HOME/Apache/Apache/logs/access_log
cd $IAS_ORACLE_HOME/Apache/Apache/logs/error_log
cd $IAS_ORACLE_HOME/Apache/JServ/logs

Worker Log file location:
$APPL_TOP/admin/PROD/log

AutoConfig log files location:

Application Tier:
cd $APPL_TOP/admin/SID_Hostname/log//DDMMTime/adconfig.log

Database Tier:
cd $ORACLE_HOME/appsutil/log/SID_Hostname/DDMMTime/adconfig.log

Error log file location:

Application Tier:
cd $APPL_TOP/admin/PROD/log

Database Tier:
cd $ORACLE_HOME/appsutil/log/$CONTEXT_NAME

No comments:

Post a Comment