Logfiles In Oracle Applicaitons
Log files are useful in troubleshooting issues in Oracle Applications. Here is the list of Log file location in Oracle Applications for various kinds of tasks
To locate Alert Log Files :
SQL> Select value from V$DIAG_INFO where name=’Diag Alert’;
Network Logs :
$ORACLE_HOME/network/admin/$SID.log
Cloning Log files :
Adpreclone :
i) Apps Tier and Database Tier:
$ORACLE_HOME/appsutil/scripts/context_name
$ADMIN_SCRIPTS_HOME
Adcfgclone :
i) Apps Tier and Database Tier:
$ORACLE_HOME/appsutil/clone/bin
$COMMON_TOP/clone/bin
Preclone (adpreclone.pl) log files in source instance
i) Database Tier:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/
(StageDBTier_<time>.log)
ii) Apps Tier:
$INST_TOP/apps/$CONTEXT_NAME/admin/log/
(StageAppsTier_<time>.log)
Post-Clone (Adcfgclone.pl) log files in target instance
i) Database Tier:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/
ApplyDBTier_<time>.log
ii) Apps Tier:
$INST_TOP/apps/$CONTEXT_NAME/admin/log/
ApplyAppsTier_<time>.log
Patching log files :
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
Autoconfig log files :
$ORACLE_HOME/appsutil/scripts/context_name
$ADMIN_SCRIPTS_HOME
On the database tier:
RDBMS $ORACLE_HOME/appsutil/log/<context>/
<timestamp>/adconfig.log
<timestamp>/NetServiceHandler.log
On the application tier:
$INST_TOP/admin/log/<timestamp>/
adconfig.log
NetServiceHandler.log
Startup/Shutdown scripts:
$COMMON_TOP/admin/scripts/context_name (11i)
$ADMIN_SCRIPTS_HOME (R12)
Startup/Shutdown Log files :
i) Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt… :
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log
or
$LOG_HOME/appl/admin/log
ii) Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web) :
R12Apps Installation Logs:
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
APPS LOG FILE and File LOCATION
$LOG_HOME= $INST_TOP/logs
Apache Logs in R12
Access Log : $LOG_HOME/ora/10.1.3/Apache
Error Log : $LOG_HOME/ora/10.1.3/Apache
Concurrent Manager logs and out files in R12
$INST_TOP/logs/appl/conc
OR
$LOG_HOME/appl/conc
Note : There are four directory on these locations :
Inbound
Outbound
Log
Out
Forms and Reports related logs (10.1.2 O_H in R12 is equivalent to 806 O_H in 11..5.10.2)
Forms log file : $LOG_HOME/ora/10.1.2/forms
Reports Log file : $LOG_HOME/ora/10.1.2/reports
OPMN Log Files
$INST_TOP/logs/ora/10.1.3/opmn
OC4J Log Files (Text)
$INST_TOP/logs/ora/10.1.3/j2ee/oacore/
OC4J Log Files (ODL)
$INST_TOP/logs/ora/10.1.3/j2ee/oacore/log/oacore_default_group
SSL CERTIFICATES
$INST_TOP/certs
/Apache/ewallet.p12
/opmn/cwallet.sso
/opmn/ewallet.p12
Certs is the default directory for SSL or any other certificate files
used by this instance. To use a centrally staged certificate, change
the appropriate context file and run autoconfig
AD Scripts log files (adstrall,adstpall)
$INST_TOP/logs/appl/admin/log
AD tools log files (adpatch,actrl)
$APPL_CONFIG_HOME/admin/$TWO_TASK/log
name will be APPSSID_HOSTNAME.env e.g APPSPROD_DEMO.env
Application startup & shutdown scripts Location :
$INST_TOP/admin/scripts
or
$ADMIN_SCRIPTS_HOME
$ADMIN_SCRIPTS_HOME
Applicaton context file i.e .xml file : $INST_TOP/appl/admin/
e.g SID_HOSTNAME.xml
adpreclone.pl script location : $INST_TOP/admin/scripts
adcfgclone.pl script location : $COMMON_TOP/clone/bin
Database log file and File Location
adpreclone.pl script location : $RDBMS_O_H/appsutil/scripts/SID_HOSTNAME
adcfgclone.pl script location : $RDBMS_O_H/appsutil/clone/bin
Database listener and database startup and shutdown scripts :
$RDBMS_O_H/appsutil/scripts/SID_HOSTNAME
Database alert.log file location in 11g:
$O_H/admin/SID_HOSTNAME/diag/rdbms/sid/sid/trace
alertlog file format alter_sid.log
All .sql scripts location :
RDBMSO_H/rdbms/admin
Parameter file location i.e Init.ora or pfile or spfile file :
$RDBMS_O_H/dbs
Adpatch Log file / Worker log file / adpatch informative log file i.e adpatch.lgi
$APPL_TOP/admin/SID/log/ e.g SID=PROD
Forms.fmb Location : $AU_TOP/forms/US/
(All fmb’s reside in AU_TOP/forms/US)
R12.2. Startup and Shutdown Procedure
Node Manager
$adnodemgrctl.sh start Enter Weblogic Admin Password:
Weblogic Admin Server
$adadminsrvctl.sh start Enter Weblogic Admin Password:
Application Listener
$adalnctl.sh start
Oracle Process Manager
$adopmnctl.sh start
Apache Services
$adapcctl.sh start
Managed Server for OACORE Services
$admanagedsrvctl.sh start oacore_server1 Enter Weblogic Admin Password:
Managed Server for FormsServices
$admanagedsrvctl.sh start forms_server1 Enter Weblogic Admin Password:
Managed Server for Fusion MiddleWare Services
$admanagedsrvctl.sh start oafm_server1 Enter Weblogic Admin Password:
Managed Server for Forms web Services
$admanagedsrvctl.sh start forms-c4ws_server1 Enter Weblogic Admin Password:
Concurrent Manager Service
$adcmctl.sh start apps/apps
Fullfillment Serer Services
$jtffmctl.sh start
Individual Components: Application(Middle Tier)
$ADMIN_SCRIPTS_HOME
When we want to stop all application services using script adstpall.sh , we provide apps password in R12.1.3.But in R12.2 it will ask weblogic admin password in addition to bring down to all services .
No comments:
Post a Comment