Creating a reports server and integrate it with Enterprise Manager / iasconsole

Why:
- Under control of opmn (wil be automatically restarted)
- Visible and manageable under Enterprise Manager.

1. Create/start a new reports server : “$ORACLE_HOME/bin/rwserver.sh repproject
2. A small window will pop-up, showing that the reports server is starting up.
3. After it’s status is ready, stop this server.
4. Register this new reports server (you can do this also by hand, in the section of deleting this, you can also see what files you will have to update to insert or delete a reports server).

$ORACLE_HOME/bin/addNewServerTarget.sh repproject

The command addNewServerTarget.sh registers the reports server to OPMN and Enterprise Manager.

The following entry is added to $ORACLE_HOME/opmn/conf/opmn.xml (sorry for the layout) :

<ias-component id=”repproject” status=”enabled” id-matching=”false”>
<process-type id=”ReportsServer” module-id=”ReportsServices”>
<process-set id=”repproject” restart-on-death=”true” numprocs=”1″>
<environment>
<variable id=”PATH” value=”/home/ias10g/OraHome1/bin:/usr/bin:/usr/ccs/bin:/bin:/usr/kerberos/bin:/opt/IBMJava2-131/bin:/opt/IBMJava2-131/jre/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin”/>
</environment>
< module-data>
<category id=”general-parameters”>
<data id=”batch” value=”yes”/>
</category>
<category id=”restart-parameters”>
<data id=”reverseping-timeout” value=”120″/>
</category>
</module-data>
<dependencies>
<OID infrastructure=”true”/>
<database infrastructure-key=”portal”/>
<managed-process ias-component=”OC4J” process-type=”OC4J_BI_Forms” process-set=”default_island” autostart=”true”/>
<managed-process ias-component=”HTTP_Server” process-type=”HTTP_Server” process-set=”HTTP_Server” autostart=”true”/>
</dependencies>
<start timeout=”120″ retry=”3″/>
<stop timeout=”120″/>
<restart timeout=”120″/>
<ping timeout=”30″ interval=”30″/>
</process-set>
</process-type>
</ias-component>

5. Restart OPMN and all OPMN managed processes.

opmnctl stopall
opmnctl startall

This will start the Reports Server ‘repproject’ too.
The log entries for starting Reports Server through OPMN can be found in
/home/ias10g/OraHome1/opmn/logs/repproject~ReportsServer~la~1

6. The tag value restart-on-death=”true” is responsible to restart the Reports Server in case it crashes.
This may be set to “false” while troubleshooting Reports Server crash issues to prevent OPMN from
restarting the reports server.

———–//———-

How to delete this reports server.

Unfortunately, there’s no script to do that.

1. Remove the above mentioned config in opmn.xml.

2. Remove the config in targets.xml located under ORACLE_HOME/sysman/emd

<Target TYPE=”oracle_repserv” NAME=”<ias_instance_name>_Reports_Server: <reports_server_to_be_removed>” …>…</Target>

3.Update the changed configuration .
$ORACLE_HOME/dcm/bin/dcmctl updateconfig -ct opmn -v -d

4. Restart the Application Server Control Console
emctl stop iasconsole
emctl start iasconsole

5. Restart OPMN and all OPMN managed processes.

opmnctl stopall
opmnctl startall

—————————————–

Sources:

Note 260367.1 “Reports Integration with EM/AS”

Note 276810.1 “How to deregister REPORT SERVER 10g”