Thursday, November 5, 2009

How to Enable Tracing for Oracle Report Server

Report Server is the most toughest part in Oracle Application Server to manage, in terms of the load for concurrent users. It's configuration is pretty much straight forward, but when errors in report appear, and you bang your head and keep restarting the report server in vain, then tracing might help you to locate the error, or enable Oracle Support to get more in-depth information:

Edit rwservlet.properties from ORACLE_HOME/reports/conf folder as below
from
#TRACEOPTS=TRACE_ALL
#TRACEFILE=rwservlet.trc
#TRACEMODE=TRACE_REPLACE
to
TRACEOPTS=TRACE_ALL
TRACEFILE=rwservlet.trc
TRACEMODE=TRACE_REPLACE

5.Edit .conf file in ORACLE_HOME/reports/conf folder as below
from

to
< trace traceOpts="trace_all" traceMode="trace_append"/>

6.Restart the server,reproduce the problem and inspect all the files from ORACLE_HOME/reports/logs folder.

1 comment:

mirzajee said...

Excellent!! very informative indeed! thanks for sharing ur precious experience..:)