Log files are useful in troubleshooting issues in Oracle Applications. Here is the list of Log files location in Oracle Applications for Startup/Shutdown, Cloning, Patching, DB & Apps Listener and various components in Apps R12. Every Oracle Apps DBA should know the locations of all the important file listed below:
The log files are located in $LOG_HOME ($INST_TOP/logs) in Oracle Applications R12
CONTEXT_FILE= $INST_TOP/appl/admin/SID_HOSTNAME.xml
DBC File Location:
$INST_TOP/appl/fnd/12.0.0/secure/SID.dbc
or
$FND_SECURE
adautocfg.sh (Autoconfig) file Location:
$INST_TOP/admin/scripts/adautocfg.sh
or
$ADMIN_SCRIPT_HOME
Startup/Shutdown Scripts and Log files for Application Tier in R12:
====================================================================
Applications Services Startup/Shutdown Scripts:
/apps/inst/apps/$CONTEXT_NAME/admin/scripts
or
$ cd $ADMIN_SCRIPT_HOME
Startup/Shutdown logs:
/apps/inst/apps/$CONTEXT_NAME/logs/appl/admin/log
Startup/Shutdown error message related to Tech Stack (10.1.2, 10.1.3 forms/reports/web):
$INST_TOP/appl/$CONTEXT_NAME/logs/ora/ (10.1.2 & 10.1.3)
$INST_TOP/appl/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp]
$INST_TOP/appl/$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)
Concurrent Manager Logfile:
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log
or
$APPLCSF
Files related to cloning in R12:
==================================
Location of adpreclone.pl:
/apps/inst/apps/$CONTEXT_NAME/admin/scripts
or
$ADMIN_SCRIPT_HOME
Preclone log files in source instance:
i) Database Tier:-
$ cd $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)
ii) Application Tier:-
$ cd $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log)
Clone log files in target instance:
The log files are located in $LOG_HOME ($INST_TOP/logs) in Oracle Applications R12
Important Files Location:
Context File location:CONTEXT_FILE= $INST_TOP/appl/admin/SID_HOSTNAME.xml
DBC File Location:
$INST_TOP/appl/fnd/12.0.0/secure/SID.dbc
or
$FND_SECURE
adautocfg.sh (Autoconfig) file Location:
$INST_TOP/admin/scripts/adautocfg.sh
or
$ADMIN_SCRIPT_HOME
Startup/Shutdown Scripts and Log files for Application Tier in R12:
====================================================================
Applications Services Startup/Shutdown Scripts:
/apps/inst/apps/$CONTEXT_NAME/admin/scripts
or
$ cd $ADMIN_SCRIPT_HOME
Startup/Shutdown logs:
/apps/inst/apps/$CONTEXT_NAME/logs/appl/admin/log
Startup/Shutdown error message related to Tech Stack (10.1.2, 10.1.3 forms/reports/web):
$INST_TOP/appl/$CONTEXT_NAME/logs/ora/ (10.1.2 & 10.1.3)
$INST_TOP/appl/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp]
$INST_TOP/appl/$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)
Concurrent Manager Logfile:
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log
or
$APPLCSF
Files related to cloning in R12:
==================================
Location of adpreclone.pl:
/apps/inst/apps/$CONTEXT_NAME/admin/scripts
or
$ADMIN_SCRIPT_HOME
Preclone log files in source instance:
i) Database Tier:-
$ cd $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)
ii) Application Tier:-
$ cd $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log)
Clone log files in target instance:
Database Tier:-
$ cd $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log
Apps Tier:-
$ cd $INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log
Patching related log files in R12:
======================================
Application Tier adpatch logs:-
$ cd $APPL_TOP/admin/$SID/log/
Database Tier opatch logs:-
$ cd $ORACLE_HOME/.patch_storage
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
Other log files in R12:
=========================
1) Database Tier:
Relink Log files:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME /MMDDHHMM/ make_$MMDDHHMM.log
Alert Log Files :
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
Network Logs :
$ORACLE_HOME/network/admin/$SID.log
OUI Inventory Logs :
$ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs
Database Tier Scripts in R12:
==============================
Database startup shutdown Scripts:
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh
Database Listener Start/Stop:
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh
or alternatively you can use
lsnrctl startstop listener_name (For Database Listener)
$ cd $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log
Apps Tier:-
$ cd $INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log
Patching related log files in R12:
======================================
Application Tier adpatch logs:-
$ cd $APPL_TOP/admin/$SID/log/
Database Tier opatch logs:-
$ cd $ORACLE_HOME/.patch_storage
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
Other log files in R12:
=========================
1) Database Tier:
Relink Log files:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME /MMDDHHMM/ make_$MMDDHHMM.log
Alert Log Files :
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
Network Logs :
$ORACLE_HOME/network/admin/$SID.log
OUI Inventory Logs :
$ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs
Database Tier Scripts in R12:
==============================
Database startup shutdown Scripts:
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh
Database Listener Start/Stop:
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh
or alternatively you can use
lsnrctl startstop listener_name (For Database Listener)
sqlplus “/as sysdba”
SQL> startup shutdown immediat (FOR DATABASE)
Middle/Application Tier Scripts in R12:
=======================================
Scripts Related to Start/Stop Applications Services are located
$INST_TOP/admin/scripts
or
$ cd $ADMIN_SCRIPT_HOME
i) adstrtal.sh
Master script to start all components/services of middle tier or application tier.
This script will use Service Control API to start all services which are enabled after
checking them in context file (SID_HOSTNAME.xml or CONTEXT_NAME.xml)
ii) adstpall.sh
Master script to stop all components/services of middle tier or application tier.
iii) adalnctl.sh
Script to start / stop apps listener (FNDFS and FNDFS). This listener will file will be in 10.1.2 ORACLE_HOME (i.e. Forms & Reports Home) listener.ora file will be in $INST_TOP/apps/$CONTEXT_NAME/ora/10.1.2/network/admin directory
(Mostly similar to one in 11i with only change in ORACLE_HOME i.e. from 8.0.6 to 10.1.2 )
iv) adapcctl.sh
Script to start/stop Web Server or Oracle HTTP Server. This script uses opmn (Oracle Process Manager and Notification Server) with syntax similar to opmnctl [startstop]proc ohs like opmnctl stopproc ohs .
(In 11i this script directly used to call apachectl executable but now calls opmnctl which in turn calls apachectl. In 11i web server oracle home was 1.0.2.2.2 but in R12 its 10.1.3)
v) adcmctl.sh
Script to start/stop concurrent manager, Similar to one in 11i. (This script in turn calls startmgr.sh )
vi) adformsctl.sh
Script to start / stop Forms OC4J from 10.1.3 Oracle_Home. This script will also use opmnctl to start/stop Forms OC4J like
opmnctl stopproc type=oc4j instancename=forms
vii) adformsrvctl.sh
This script is used only if you wish to start forms in socket mode. Default forms connect method in R12 is servlet. If started this will start frmsrv executable from 10.1.2 Oracle_Home in Apps R12
viii) adoacorectl.sh
This script will start/stop oacore OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to adapcctl & adformsctl) to start oacore instance of OC4J like
SQL> startup shutdown immediat (FOR DATABASE)
Middle/Application Tier Scripts in R12:
=======================================
Scripts Related to Start/Stop Applications Services are located
$INST_TOP/admin/scripts
or
$ cd $ADMIN_SCRIPT_HOME
i) adstrtal.sh
Master script to start all components/services of middle tier or application tier.
This script will use Service Control API to start all services which are enabled after
checking them in context file (SID_HOSTNAME.xml or CONTEXT_NAME.xml)
ii) adstpall.sh
Master script to stop all components/services of middle tier or application tier.
iii) adalnctl.sh
Script to start / stop apps listener (FNDFS and FNDFS). This listener will file will be in 10.1.2 ORACLE_HOME (i.e. Forms & Reports Home) listener.ora file will be in $INST_TOP/apps/$CONTEXT_NAME/ora/10.1.2/network/admin directory
(Mostly similar to one in 11i with only change in ORACLE_HOME i.e. from 8.0.6 to 10.1.2 )
iv) adapcctl.sh
Script to start/stop Web Server or Oracle HTTP Server. This script uses opmn (Oracle Process Manager and Notification Server) with syntax similar to opmnctl [startstop]proc ohs like opmnctl stopproc ohs .
(In 11i this script directly used to call apachectl executable but now calls opmnctl which in turn calls apachectl. In 11i web server oracle home was 1.0.2.2.2 but in R12 its 10.1.3)
v) adcmctl.sh
Script to start/stop concurrent manager, Similar to one in 11i. (This script in turn calls startmgr.sh )
vi) adformsctl.sh
Script to start / stop Forms OC4J from 10.1.3 Oracle_Home. This script will also use opmnctl to start/stop Forms OC4J like
opmnctl stopproc type=oc4j instancename=forms
vii) adformsrvctl.sh
This script is used only if you wish to start forms in socket mode. Default forms connect method in R12 is servlet. If started this will start frmsrv executable from 10.1.2 Oracle_Home in Apps R12
viii) adoacorectl.sh
This script will start/stop oacore OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to adapcctl & adformsctl) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oacore
ix) adoafmctl.sh
This script will start/stop oafm OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to above) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oafm
x) adopmnctl.sh
This script will start/stop opmn service in 10.1.3 Oracle_Home. opmn will control all services in 10.1.3 Oracle_Home like web server or various oc4j instances. If any services are stopped bnormally opmn will/should start them automatically.
xi) jtffmctl.sh
This script will be used to start/stop one to one fulfilment server.
xii) mwactl.sh
To start / stop mwa telnet server where mwa is mobile application.
Reference:
How to find location of Install, Autoconfig, Patching , Clone and other logs in R12 [ID 804603.1]
Oracle Application Server Diagnostic Tools and Log Files in Applications Release 12 [ID 454178.1]
Oracle Applications System Administrator’s Guide
If I missed any important log file name/location, drop a line via comment
See also
adadmin
Purge obsolete workflow runtime data
Conucurrent Manager 11i
Oracle Application Interview Questions and Answers
Access Oracle Applications from Linux client
Patching
ix) adoafmctl.sh
This script will start/stop oafm OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to above) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oafm
x) adopmnctl.sh
This script will start/stop opmn service in 10.1.3 Oracle_Home. opmn will control all services in 10.1.3 Oracle_Home like web server or various oc4j instances. If any services are stopped bnormally opmn will/should start them automatically.
xi) jtffmctl.sh
This script will be used to start/stop one to one fulfilment server.
xii) mwactl.sh
To start / stop mwa telnet server where mwa is mobile application.
Reference:
How to find location of Install, Autoconfig, Patching , Clone and other logs in R12 [ID 804603.1]
Oracle Application Server Diagnostic Tools and Log Files in Applications Release 12 [ID 454178.1]
Oracle Applications System Administrator’s Guide
If I missed any important log file name/location, drop a line via comment
See also
adadmin
Purge obsolete workflow runtime data
Conucurrent Manager 11i
Oracle Application Interview Questions and Answers
Access Oracle Applications from Linux client
Patching
No comments:
Post a Comment
Ask your Questions....