ORACLE
APPS COMPONENT DETAILS
1)
ComponentName : Apache
---------------------------------------------------------------------
Configuration
file path :
$IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf
- Main Configuration File
$IAS_ORACLE_HOME/Apache/Apache/conf/httpd_pls.conf
- pls (plsql) integration in web server
$IAS_ORACLE_HOME/Apache/Apache/conf/apps.conf
- used to define aliases used in URL access
$IAS_ORACLE_HOME/Apache/Apache/conf/oracle_apache.conf
- used to include other configuration files
Log
file path : $APACHE_TOP/Apache/logs
Startup
Script file path
$COMMON_TOP/admin/scripts/SID_HOST/adapcctl.sh
start
Shutdown
Script file path
$COMMON_TOP/admin/scripts/SID_HOST/adapcctl.sh
stop
Process
Identification method
ps
-ef|grep - i <sid>|grep - i Apache
ps
-ef|grep - i <sid>|grep - i httpd
netstat
-a|grep <webport#>
Application
Profile Names
Application
Framework Agent / Applications Web Agent / Apps servlet Agent / JTF_BIS_OA_HTML
/ TCF:HOST
Troubleshooting
tips
Check
the log file error_log , access_log
Check
for correct port# in httpd.conf & httpd_pls.conf
Check
all config files in $APACHE_TOP/Apache/conf for any entries
pointing
to source and replace with target
Parameters
httpd.conf: Timeout
httpd.conf:
KeepAliveTimeout
httpd.conf:
SSLSessionCacheTimeout
2)
Component Name : Concurrent Manager
--------------------------------------------------------------------------------
Requires
tnsnames.ora, listener.ora,
<HOSTNAME>_<SID>_ifile.ora
(for PCP) in $TNS_ADMIN directory.
Also
looks for tnsnames.ora in
$IAS_ORACLE_HOME/Apache/network/admin/<SID>_<HOSTNAME>
directory.
Log
file path : $APPLCSF/$APPLLOG
Startup
Script file path
adcmctl.sh
start apps/<passwd> in $SCRIPT_TOP
(SCRIPT_TOP=$COMMON_TOP/admin/scripts/<SID>_<HOSTNAME>)
Shutdown
Script file path
adcmctl.sh
stop apps/<passwd> in $SCRIPT_TOP
(SCRIPT_TOP=$COMMON_TOP/admin/scripts/<SID>_<HOSTNAME>)
Process
Identification method
ps
-eaf | grep <apuser> | grep FND
ps
-eaf | grep <apuser> | grep FNDLIBR = Standard and Internal Manager
(should
spawn multiple FND processes)
ps
-eaf | grep <apuser> | grep FNDSM = Service Manager
ps
-eaf | grep <apuser> | grep FNDCRM = Conflict Resolution Manager
3)
Component Name : Discoverer 4i
-----------------------------------------------------------------------------------
Configuration
file path
#-------------Discoverer
configuration files (details of ports and IP
addresses)-------------------------
$ORACLE_HOME/discwb4/discwb.sh
$ORACLE_HOME/discwb4/util/pref.txt
$ORACLE_HOME/vbroker/bin/gatekeeper.properties
$APACHE_TOP/Apache/htdocs/discwb4/applet/gatekeeper.properties
#-------------Discoverer
components registration files
$ORACLE_HOME/discwb4/util/applypreferences.sh
$ORACLE_HOME/discwb4/util/registerosaagent.sh
$ORACLE_HOME/discwb4/util/registeroad.sh
$ORACLE_HOME/discwb4/util/registerlocator.sh
$ORACLE_HOME/discwb4/util/registerall.sh
$ORACLE_HOME/discwb4/util/unregisterlocator.sh
$ORACLE_HOME/discwb4/util/unregisteroad.sh
$ORACLE_HOME/discwb4/util/unregisterosaagent.sh
$ORACLE_HOME/discwb4/util/unregisterall.sh
#--------------Registered
components detail
files----------------------------------------------------------------
$ORACLE_HOME/vbroker/adm/impl_dir/impl_rep~
$ORACLE_HOME/vborker/adm/impl_dir/impl_rep
$IAS_ORACLE_HOME/Apache/Apache/htdocs/discwb4/applet/gatekeeper.ior
$IAS_ORACLE_HOME/Apache/Apache/htdocs/discwb4/applet/locator.ior
Log
file path $ORACLE_HOME/discwb4/util/oad.log
$ORACLE_HOME/discwb4/util/osaagent.log
$ORACLE_HOME/discwb4/util/locator.log
$ORACLE_HOME/discwb4/util/error.txt
$ORACLE_HOME/discwb4/util/diag.log
$APACHE_TOP/Apache/htdocs/discwb4/applet/gatekeeper.log
Startup
Script file path
$ORACLE_HOME/discwb4/util/startosaagent.sh
$ORACLE_HOME/discwb4/util/startoad.sh
$ORACLE_HOME/discwb4/util/startlocator.sh
$ORACLE_HOME/discwb4/util/startgatekeeper.sh
$ORACLE_HOME/discwb4/util/startall.sh
Shutdown
Script file path
$ORACLE_HOME/discwb4/util/stopgatekeeper.sh
$ORACLE_HOME/discwb4/util/stoplocator.sh
$ORACLE_HOME/discwb4/util/stopoad.sh
$ORACLE_HOME/discwb4/util/stoposaagent.sh
$ORACLE_HOME/discwb4/util/stopall.sh
Process
Identification method
ps
-ef|grep vbroker
netstat
-a|grep 10508
netstat
-a|grep 10552
$ORACLE_HOME/discwb4/util/checkdiscoverer.sh
$ORACLE_HOME/discwb4/oadutil
list
$ORACLE_HOME/discwb4/osfind
Application
Profile Names
ICX:
Discoverer Launcher
ICX:
Discoverer Viewer Launcher
ICX:
Discoverer use Viewer
ICX:
Discoverer Default End User Layer Schema Prefix
Troubleshooting
tips
1.Check
the Log files
2.Commonly
issues are with the dbc file or tnsnames.ora
4)
Component Name : FORMS
----------------------------------------------------------------------------
Configuration
file path
1.$COMMON_TOP/html/bin/appsweb_SID_Hostname.cfg.
= main configuration file for Forms Server
2.$FND_TOP/resource/appsweb_SID_Hostname.cfg.
Check
the configuration file name in SID.env file under APPL_TOP dir.
Log
file path : Log files are under $COMMON_TOP/admin/log/SID_Hostname/
Startup
Script file path
1.Start
Forms Server Listener process
$COMMON_TOP/admin/scripts/SID_Hostname/adfrmctl.sh
start.
2.Start
Forms Metrics Client
$COMMON_TOP/admin/scripts/SID_Hostname/adfmcctl.sh
start.
3.Start
Forms Metrics Server
$COMMON_TOP/admin/scripts/SID_Hostname/adfmsctl.sh
start.
Shutdown
Script file path
1.Stop
Forms Server Listener process
$COMMON_TOP/admin/scripts/SID_Hostname/adfrmctl.sh
stop.
2.Stop
Forms Metrics Client
$COMMON_TOP/admin/scripts/SID_Hostname/adfmcctl.sh
stop.
3.Stop
Forms Metrics Server
$COMMON_TOP/admin/scripts/SID_Hostname/adfmsctl.sh
stop.
Process
Identification method
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
Runtime Parameter.
Troubleshooti
ngtips
1.Check
whether FORMS60_MAPPING in $APPL_TOP/SID.env is set to correct URL or not.
2.Check
whether serverPort,serverName and domainName are correctly set in
3.Configuration
errors in $COMMON_TOP/html/bin/appsweb_SID_Hostname.cfg file.
5)
Component Name : Reports Server
---------------------------------------------------------------------------------------
Configuration
file path : $ORACLE_HOME/reports60_server
Log
file path : $ORACLE_HOME/report60/server/REP60_<SID>.log
Startup
Script file path
$SCRIPT_TOP/adrepctl.sh
start
Shutdown
Script file path
SCRIPT_TOP/adrepctl.sh
stop
Process
Identification method
ps
-ef |grep rwmts60
Application
Profile Names
ICX:
Report Launcher Troubleshooting tips
Check
password in CGIcmd.dat (ORACLE_HOME/report60/server)
&
Display variable in ORACLE_HOME/report60_server, DISPLAY
variable
in Jserv/etc as well
6)
Component Name : Jserv/Jsp
---------------------------------------------------------------------------------
Name
Configuration file path
$APACHE_TOP/Jserv/etc/jserv.conf
= Used to configure the jvms
jserv.properties
= Used to set the properties of the oacore JVM
jserv_restrict.properties
$APACHE_TOP/Apache/conf/oprocmgr.conf
Log
file path $APACHE_TOP/Jserv/logs & $APACHE_TOP/Jserv/logs/jvm
Startup
Script file path (same script as Apache)
$SCRIPT_TOP/adapcctl.sh
start
Shutdown
Script file path
$SCRIPT_TOP/adapcctl.sh
stop
Process
Identification method
netstat
-an | grep <port mentioned in oprocmgr.conf>
Application
Profile Names
Apps
Servlet Agent,Applications JSP Agent,OTS: JSP Details from OTS
Troubleshooting
tips
Check
<Apache Home Page URL>/servlets/Hello, Apache Log files , Jserv log files
and
configuration
files mentioned above.
7)
Component Name : Workflow
-----------------------------------------------------------------------------
Configuration
file path
OAM
for Java based Notification Mailer and in older version C based Notif Mailer
$FND_TOP/resource/wfmail.cfg
Log
file path $APPLCSF/$APPLLOG (ls -ltr FNDCP*.txt ie FNDCPGSC* and check for last
2 files)
Startup
Script file path : Starts with OAM
Shutdown
Script file path : Stops with OAM
Process
Identification method
1.
Checking sendmail : telnet <hostname> smtp or ps -ef | grep sendmail
2.
Checking imap: telnet
<hostname>
imap
3.
Workflow starts with Concurrent Manager so needs to check
Concurrent
Manager logs
Application
Profile
Names
Two
tables needs to be checked for workflow :
1.
wf_systems table: select name, display_name from wf_systems;
2.
wf_agents table: select address from wf_agents;
3.
OAM displays status information of Workflow Components from FND_SVC_COMPONENTS
Troubleshooting
tips
Check
the Log File
Check
the 3 CM related Workflow processes
Check
the Agent Status and Notif Mailer Properties
Test
Sendmail and IMAP
Check
WF related Requests shuold be scheduled
