Enable Oracle Forms Tracing and Output as HTML

This trick allow individual end user to enable server tracing from browser end. Just need to append 2 parameters into the URL to enable session tracing

Example: hostname is iccs.hp.com:80, and Forms name is iccs

http://iccs.hp.com/forms/frmservlet?config=iccs&record=forms&tracegroup=0-98,100-199

Following trace file will be immediately created in Oracle Application Server Middle-Tier

cd $ORACLE_HOME/forms/trace

ls -l forms_*.trc

Assume the generated name is forms_9440.trc, uses following steps to generated it as HTML file, because the file is a binary file

export CLASSPATH=$ORACLE_HOME/forms/java/frmxlate.jar

$ORACLE_HOME/jdk/bin/java oracle.forms.diagnostics.Xlate datafile=forms_9440.trc outputfile=forms_9440.html outputclass=WriteOutHTML

Download the file to your PC and view it

Split log file in Oracle Application Server 9i, 10g

Oracle Application Server's OC4J engine is using Orion technology. So following are some ways to split the log files for ease of support

http://www.orionserver.com/docs/access-log-format.html
http://www.trivadis.com/uploads/tx_cabagdownloadarea/TVD_OC4J_access_log_040202DE_EN_01.pdf
http://www.di.unipi.it/~ghelli/didattica/bdl/A97329_03/web.902/a95878/deployme.htm
http://download-uk.oracle.com/docs/cd/B25221_04/web.1013/b14432/website.htm

Broken job in Portal 10.1.4 wwsrc_event_q_mgmt.propagate

In Portal database, with Portal version 10.1.4.0.0, it will create a broken job wwsrc_event_q_mgmt.propagate, owner is portal, interval as sysdate + 5/ (24 * 60).

This is a job that created in this version upon upgrade from Portal version 10.1.2.0.2, or 10.1.2.0.0. It suppose to be used by Enterprise Search Engines, but not implemented. Oracle purposely disabled this job during upgrade.

This is a known bug documented in Oracle Metalink Doc ID 393873.1