Creating/Removing Report Server in Application server

Creating New Report Server in Middle Tier

Development team needed a new report server instance in middle tier, in process

 of doing so they came up with following observation and steps:

Assume %OMH% is Oracle Middle Tier Home

To create new report server instance:

Open command prompt:

C:\>rwserver server=%newreportserver_name% start

Shut down the opmn:

C:\>%OMH%\opmn\bin\opmnctl stopall

Add new server target to opmn.xlm

C:\>%OMH%\bin\addNewServerTarget.bat %newreportserver_name%

The DOS window will close automatically.

Open command prompt again:

Update the config with new settings

C:\>%OMH%\dcm\bin\dcmctl.bat updateconfig -ct opmn -v -d

C:\>%OMH%\ dcm\bin\dcmctl.bat resyncinstance -v -d

Removing Report Server in Middle Tier

Start the opmn

C:\>%OMH%\opmn\bin\opmnctl startall

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>