Creating / deleting a reports server in OAS 10.1.2, integrated with EM/AS-console

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”

By | 2009-07-10T23:36:33+00:00 July 10th, 2009|Categories: App. Server|Tags: , |1 Comment

About the Author:

One Comment

  1. Ameya December 21, 2009 at 7:40 pm

    Thanks a ton…
    I am new to Oracle Application server Administration. I am a Weblogic Administrator and have been put up on a short-term project to setup the OAS and Oracle SSO for one of our new clients.
    This info is of a great help to me. No document of Oracle that I have browsed in the last few days contained this info.
    Thank you again
    – Ameya

Leave A Comment