Wednesday, 5 February 2014

Application Files Location

Installation log files Location:
DB Tier
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME
APPs Tier
$APPL_TOP/admin/$CONTEXT_NAME/log
Apache Server:-
Apache Server


Configuration File
$IAS_ORACLE_HOME/Apache/Apache/conf
httpd.conf ==> main configuration file (to identify port number also)
httpd_pls.conf ==> plsql integration in the web server
apps.conf ==> used to define aliases in URL access
oracle_appache.conf==> used to include other configuration files
$INST_TOP/ora/10.1.3/Apache/Apache/conf

httpd.conf
apps.conf
oracle_appache.conf

Log file
$IAS_ORACLE_HOME/Apache/Apache/logs
access_log
error_log
$LOG_HOME/ora/10.1.3/Apache
Status check
ps –ef|grep –i  <SID> |grep –i  Apache
netstat  –a |grep   <webport number>
ps –ef|grep httpd

Version check
$IAS_ORACLE_HOME/Apache/Apache/conf
httpd  -v ==> to find the version of Apache version

Jserver
$IAS_ORACLE_HOME/Apache/Jserv/etc
jserv.conf ==> used to configure jvm’s
jserv.properties ==>used to set the properties of oacore jvm
jserv_restrict.properties
zone.properties
$IAS_ORACLE_HOME/Apache/Jserv/conf
jserv.secret.key ==> jserv configuration file.
$IAS_ORACLE_HOME/Apache/Jserv/logs
mod_jserv.log
There is no Jserver replaced by OACORE
Script & log
$COMMON_TOP/admin/scripts/<context name>
adapcctl.sh [start/stop/status]
$COMMON_TOP/admin/logs/<context name>
adapcctl.txt ==> is log file for Apache script

Apps password
$IAS_ORACLE_HOME/Apache/modplsql/cfg
wdbsvr.app==> this file contains your dad (database Access descriptor) information like database connection description & apps username and password in text.

plug-in
$IAS_ORACLE_HOME/Apache/jdk/jre/plugin/i386/ns610-gcc32

Plug-in version check
ps –ef|grep sun_plugin_version $CONTEXT_FILE

Common Problems in Starting Apache
Could not bind port (Port already in Use)
Found .pid file (When Apache starts it creates .pid file in logs directory and when you shutdown apache it cleans this .pid file so if this file is already there then Apache will not start. Fix: Simply move this file
Mobile is enabled in zone.properties disable it if you are not using it.
If there is no error messages in error_log or error_log_pls then there might be issues in starting Jserv component of web server ( which caters Java requests by mod_jserv)
FORM Server


Configuration File
$COMMON_TOP/html/bin
apps.cfg
appsweb_<context name>.cfg==> main configuration file for form server
$FND_TOP/resource/
appsweb_<context name>.cfg

Scripts
COMMON_TOP/admin/scripts/<Context name>
adfmctl.sh ==>  starts form server listener process
adfmsctl.sh ==> starts forms Metrics client
adfmcctl.sh ==>

Process identifications
ps  -ef|grep f60
ps –ef|grep f60srvm ==> forms server
ps –ef|grep f60webmx ==> forms Runtime Client

Application profile names
1. icx: forms launcher
2.Forms Run time parameter

Trouble Shooting
1. Check whether FORMS60_MAPPING in $APPL_TOP/SID.env is set to correct URL or not.
2. Check whether server Port, server Name and domain Name are correctly set in
3.Configuration errors in $COMMON_TOP/html/bin/appsweb_SID_Hostname.cfg file.




Report Server

Configuration file
$ORACLE_HOME
report60_server
Log file
$ORACLE_HOME/report60/server
REP60_<SID>.log
CGIcmd.dat
Scripts
COMMON_TOP/admin/scripts/<context name>
adrepctl.sh [start/stop]
Process identification
ps –ef|grep rwmts60
Trouble shooting
Check password in CGIcmd.dat (ORACLE_HOME/report60/server)
& Display variable in ORACLE_HOME/report60_server, DISPLAY
variable in Jserv/etc as well



Discover Server

Configuration
Code generator:-
It means form binaries (.fmb) are convert to the form executables (.fmx)
Syntax:
$ f60gen MODULE=<XXX.fmb> USERID=<apps user name>/<apps password>
               OUTPUT_FILE=<location of fmx file>
In R12
$frmcmp_batch Module=FNDFMFUN.fmb Module_Type=FORM  userid=apps/apps Output_File=/u01/applravi/apps/apps_st/appl/fnd/12.0.0/forms/US/FNDFMFUN.fmx
Concurrent Managers:
These are used to run Reports.
Concurrent Manager is a background process which manages the concurrent Requests.
Types of Concurrent Managers
ICM (Internal Concurrent Managers)
SM (Standard Manager)
CRM (Conflict Resolution Manager)
ICM: This is the master manager because it was monitoring the other concurrent managers.
The main function of the ICM are to startup and shutdown the individual concurrent managers, and reset the other managers.
SM: This was also be a master concurrent manager because it was run any reports and batch jobs that have not been to run in any specific product manager.
CRM: To check concurrent program definition for incompatibility rules. (to resolve incompatibilities)
Tuning the ICM:
The ICM performance is affected by 3 important oracle parameters. They are
  • PMON cycle: This is the number of sleep cycles that the ICM waits between the time it checks for concurrent managers failures, which defaults 20.
  • Queue Size: The queue size is the number of PMON cycles that the ICM waits between checking for disabled or new concurrent managers. Default queue size is ‘1’.
  • Sleep Time: The sleep time parameter indicates the seconds that the ICM should waits between checking for requests that waiting to run. Default sleep time is 60 seconds.
$FND_TOP/sql

afcmstat.sql
Displays all the defined managers, their maximum capacity, pids and their status
afimchk.sql
Display the status of ICM and PMON method in effect, the ICM’s log file, and determines if the concurrent manager monitor is running.
afcmcreq.sql
How to trace concurrent program:-



A. Startup/Shutdown Log files for Application Tier in R12
i) Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt… :
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log
ii) Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web) :
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/ (10.1.2 & 10.1.3)
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp]
$INST_TOP/apps/$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)
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log (CM log files)
B. Log files related to cloning in R12
=======================================
Preclone (adpreclone.pl) log files in source instance
i) Database Tier-$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_.log)
ii) Apps Tier – $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_.log)
Post-Clone (Adcfgclone.pl) log files in target instance
i) Database Tier- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log
ii) Apps Tier – $INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log
If your clone on DB Tier fails while running txkConfigDBOcm.pl ( Check metalink note – 415020.1)
During clone step on DB Tier it prompts for “Target System base directory for source homes” and during this you have to give like /base_install_dir like ../../r12 and not oracle home like ../../r12/db/tech_st_10.2.0
C. Patching related log files in R12
======================================
i) Application Tier– adpatch log – $APPL_TOP/admin//log/
ii) Developer (Developer/Forms & Reports 10.1.2) Patch – $ORACLE_HOME/.patch_storage
iii) Web Server (Apache) patch – $IAS_ORACLE_HOME/.patch_storage
iv) Database Tier opatch log – $RDBMS_ORACLE_HOME/.patch_storage
D. Autoconfig related log files in R12
========================================
i) Database Tier Autoconfig log :
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log
ii) Application Tier Autoconfig log -
$INST_TOP/apps/$CONTEXT_NAME/admin/log//adconfig.log
. R12 Installation Logs
==========================
Database Tier Installation logs:
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_.log
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_.log
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log
$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log
Application Tier Installation logs :
$INST_TOP/logs/.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log
$INST_TOP/logs/ora/10.1.2/install/make_.log
$INST_TOP/logs/ora/10.1.3/install/make_.log
$INST_TOP/admin/log/ApplyAppsTechStack.log
$INST_TOP/admin/log/ohclone.log
$APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppltop_.log
$APPL_TOP/admin/$CONTEXT_NAME/log//adconfig.log
$APPL_TOP/admin/$CONTEXT_NAME/log//NetServiceHandler.log
Inventory Registration logs :
/logs/cloneActions.log
/logs/oraInstall.log
/logs/silentInstall.log
F. Other log files in R12
=========================
1) Database Tier
How to find location of Install, Autoconfig, Patching , Clone and other logs in R12 [ID 804603.1]
ADPATCH:
Patch Drivers:
A patch may contain one or more driver files.
A patch contains one single
Put it database in Maintenance Mode:



Applying the ADPATCH:-
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)