Quantcast
OracleBrains.Com header image 2

Removing Report Server in Middle Tier

January 9th, 2008 by Rajender Singh · 2 Comments

Example, I have following report server (highlighted) which I need to delete.

Blog Image 1

Assume %OMH% is Oracle Middle Tier Home

Go to %OMH% /sysman/emd

Open file targets.xml for editing.

Check for <Target> tag where its attribute “NAME” should matches as follows:

“<ias_instance_name>_Reports_Server: <reports_server_to_be_removed>”

In our example it is oracleas.dbserver _Reports_anand

Where

“oracleas.dbserver” is ias_instance_name

“anand” is reports server name

Select from Starting Tag <Target..> to ending tag </Target> and delete selected lines.

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

</Target>

Blog Image 2

Save and Close targets.xml file.

Now go to %OMH%/dcm/bin

Give following commands to update and resync console with new configuration:

1. dcmctl updateconfig -ct opmn -v -d
2. dcmctl resyncinstance -v -d

Once done without any error, go to %OMH%/bin

Give following commands to restart the console:

1. emctl stop iasconsole
2. emctl start iasconsole

That’s it, Report Server is removed now!
Blog Image 3


Tags: Oracle Reports

2 responses so far ↓

  • 1 MPanpozhilpaavalan // Jan 16, 2008 at 2:27 am

    Thanks for the wonderful followup.
    It really helped me a lot in understanding how a wrongly configured reports server can be removed.
    It also removed my misconception that a reportsserver can be removed just like how you can delete an oc4j.

    Thanks a lot for this wonderful document.

  • 2 Rajender Singh // Jan 16, 2008 at 9:26 pm

    You are welcome!

Leave a Comment