Quantcast
OracleBrains.Com header image 2

Creating New Report Server in Middle Tier

August 4th, 2007 by Rajender Singh · 4 Comments

Today our 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

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

Things to keep in mind:

Do NOT register the inprocess (aka in-process) server (ie. rep_) as it is already registered with the Enterprise Manager Console website and OPMN. Doing so will cause problems. The inprocess server is not intended to be viewed and/or stopped/started from command-line or opmnctl.

You must start or stop a Reports Server registered with Oracle Enterprise Manager 10g only through Oracle Enterprise Manager 10g/OPMN. OPMN automatically restarts Reports Server if it stops responding for some reason. On Windows, OPMN itself is run as a Windows service.
Beginning with Oracle Reports 10g Release 2 (10.1.2), running Reports Server as a Windows service is no longer supported (rwserver -install server_name). As a result, the related command line keywords INSTALL and UNINSTALL are also obsolete. If you start or stop a Reports Server that is managed by OPMN running as a Windows service or through the command line, you may face the following issues:
• The Reports Server’s status will not be reflected accurately in Oracle Enterprise Manager 10g.
• Oracle Enterprise Manager 10g may display errors when starting or stopping the Reports Server.


Tags: Oracle Reports

4 responses so far ↓

  • 1 MPanpozhilpaavalan // Jan 9, 2008 at 1:23 pm

    How do i remove a wrongly configured report server from the Oracle Application server 10gr2 in a redhad linux box.Please help me on this critical issue????

  • 2 Rajender Singh // Jan 9, 2008 at 3:54 pm

    Check out following new blog entry

    http://www.oraclebrains.com/?p=155

    Regards

  • 3 Miguel // Feb 20, 2008 at 10:51 pm

    How i create the new report server in linux.

    Thx,

  • 4 Miguel // Feb 21, 2008 at 6:48 am

    Hi, i already created the second report server (linux), but both report servers have the same components (OC4J_BI_Forms). How I change the OC4J component in the new Report Server to a new OC4J.

    PS I already create the New OC4j with the forms.ear and report.ear deployments.

    Thx,

Leave a Comment