Saturday, July 16, 2011

How to Debug Enabled on 11i & R12

When we used to send debug details to oracle support for troubleshooting, we have to perform the following for enable and collect debug information from HTTP, OC4J and OPMN services of R12.

Run the following script on all middle tiers as the application file system owner. A file named after the servername and date will be created in every server under the /tmp directory. Upload the resulting zip file from every server to your service request on Metalink.
zip -r /tmp/`uname -n`_`date +%m%d%y.%H%M`_iAS_CONFIG.zip \
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf \
$ORA_CONFIG_HOME/10.1.3/config \
$INST_TOP/pids/10.1.3/Apache \
$ORA_CONFIG_HOME/10.1.3/j2ee/ \
$ORA_CONFIG_HOME/10.1.3/javacache/admin \
$ORA_CONFIG_HOME/10.1.3/network/admin \
$ORA_CONFIG_HOME/10.1.3/opmn

First of all, need to shutdown the http server, oc4j and opmn services, for that:
cd $ADMIN_SCRIPTS_HOME
$adapcctl.sh stop
$adoacorectl.sh stop
$adformsctl.sh stop
$adoafmctl.sh stop
$adopmnctl.sh stop

Then need to take the backup existing log files for safe custody.
$LOG_HOME/ora/10.1.3/Apache
$LOG_HOME/ora/10.1.3/j2ee
$LOG_HOME/ora/10.1.3/opmn

1. Enable http ODL logging

Edit httpd.conf file, add the following to the end of file $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf

OraLogMode oracle
OraLogSeverity TRACE:32
OraLogDir $LOG_HOME/ora/10.1.3/Apache/oracle
Please use the full path to $LOG_HOME e.g.
OraLogDir = /u01/inst/apps/JCB_atg/logs/ora/10.1.3/Apache/oracle

Warning: the log.xml file created by the http ODL log can get very large.
Diligence must be taken to monitor this file and maintain its size under the 2GB limit which when exceeded can cause issues with login

2. Increase OC4J logging for oacore

edit j2ee-logging.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/j2ee-logging.xml



3. Increase OC4J logging for forms

edit j2ee-logging.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/j2ee/forms/config/j2ee-logging.xml



edit orion-web.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml

debug_mode
true

4. Increase OPMN Logging

edit opmn.xml adjust the following in file:
$ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml



Startup the http server, oc4j and opmn

Reproduce the issue

Access the following urls and inform support if the url was successful or unsuccessful:

http://.:/OA_HTML/ServletPing
http://.:/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE
http://.:
http://.:/OA_HTML/jsp/fnd/aoljtest.jsp
http://.:/OA_MEDIA/FNDLOGOL.gif
http://.:/forms/frmservlet
http://:/OA_HTML/fndvald.jsp?username=sysadmin&password=

Run this inventory script and upload the html output

$ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -outfile=$APPLTMP/Report_Inventory.html

Shutdown the http server, oc4j and opmn

Run these commands to zip up the required log files:

zip -r /tmp/`uname -n`_`date +%m%d%y.%H%M`_iAS_HTTP.zip $LOG_HOME/ora/10.1.3/Apache/*log* $LOG_HOME/ora/10.1.3/Apache/*lock* $LOG_HOME/ora/10.1.3/Apache/oracle $INST_TOP/pids/10.1.3/Apache
zip -r /tmp/`uname -n`_`date +%m%d%y.%H%M`_iAS_OC4J.zip $LOG_HOME/ora/10.1.3/j2ee/ $LOG_HOME/appl/rgf/*log*
zip -r /tmp/`uname -n`_`date +%m%d%y.%H%M`_iAS_OPMN.zip $LOG_HOME/appl/admin/log/ $LOG_HOME/ora/10.1.3/opmn/

The commands will create zip files in the /tmp directory named after the server name and date. Please now run the following script to compile the 3 zip files into 1 zip. Upload the resulting zip file to the associated service request.

zip -r /tmp/`uname -n`_`date +%m%d%y.%H%M`_iAS_Debug.zip /tmp/*zip*

Finally, revert the changes and re-start the services


Note : Information gathered from "Oracleajidba"

No comments:

Post a Comment