In-Process Reports Server

From time to time I am receiving questions concerning the Oracle In-Process Reports Server which come by default with the configuration of Oracle Forms & Reports.

Mainly the questions are, how can start or stop the In-Process Reports Server or how to disable the default In-Process Reports Server completely?

Start and Stop of the In-Process Reports Server

To start, simple open a Browser and point to http://<your_server_name>:<Port_of_ManagedServerReports>/reports/rwservlet/startserver

To stop just use http://<your_server_name>:<Port_of_ManagedServerReports>/reports/rwservlet/stopserver

Disable the In-Process Reports Server

In order to completely disable the default In-Process Reports Server, you have to edit the rwservlet.properties file, which is located under $DOMAIN_HOME/config/fmwconfig/servers/<Name_ManagedServerReports>/applications/reports_12.2.1/configuration

#
# Align the line from
<inprocess>yes</inprocess>
# to
<inprocess>no</inprocess>

After that restart the ManagedServer for Reports and you are done.

In Oracle Reports 11.x Releases, you can disable the default In-Process Reports Server via the Enterprise Manager Fusion Middleware Control under the Reports Menu. 

But in Oracle Reports 12.x the management of Reports is no longer available within the Enterprise Manager Fusion Middleware Control, so you will have to do it manually directly in the rwservlet.properties file.

Read More

Reports 10.1.2. and SuSE Enterprise Linux 10

Original posted 11th Sept 2007:

Officially the Oracle AS 10.1.2 is not yet certified with SLES 10 and therefor Reports 10.1.2. is not certified. Nevertheless the Oracle AS 10.1.2 is installable on SLES 10, but if you try to run a Report you are receiving an error.

The corresponding logfile $ORACLE_HOME/opmn/logs/OC4J~OC4J_BI_Forms~default_island~1 shows following error stack:

• java.lang.UnsatisfiedLinkError:
       /u00/app/oracle/product/as-fr-10.1.2/lib/librwu.so:
  /usr/X11R6/lib/libXm.so.2: undefined symbol: _Xsetlocale

To resolve this problem perform following steps:

1. su - root
2. cd /usr/X11R6/lib
3. mv -f libXm.so.2 libXm.so.2.backup
4. ln -s libXm.so.3 libXm.so.2

After that stop and restart the OC4J Instance OC4J_BI_Forms as oracle user:

1. opmnctl stopproc process-type=OC4J_BI_Forms
2. opmnctl startproc process-type=OC4J_BI_Forms

Now you can run Oracle Reports under SLES 10, but please note, that at the moment Oracle AS 10.1.2 is not yet certified with SLES 10!

Read More