Monday, November 23, 2015

Logfiles In Oracle Applicaitons

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

Apps Environment file Location : $APPL_TOP
name will be APPSSID_HOSTNAME.env e.g APPSPROD_DEMO.env

Application startup & shutdown scripts Location :

$INST_TOP/admin/scripts
or
$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