OracleBrains.Com header image 2

Creating New Report Server in Middle Tier

August 4th, 2007 by Rajender Singh · 15 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

15 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 https://oraclebrains.com/?p=155 on how to remove report server.

    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,

  • 5 ELAN // May 26, 2008 at 8:10 pm

    I DONT KNOW HOW TO CREATE A NEW REPORTS SERVER IN ORACLE REPORTS 10G. THE NAME I AM TRYING TO CREATE IS REP10G

  • 6 ELAN // May 26, 2008 at 8:42 pm

    i want to create another oracle reports server instance
    plz give me clear explanation

  • 7 Rajender Singh // May 27, 2008 at 12:31 am

    Hi Elan,

    Just follow the step given in this post.

    Whatever I have give above in this post is tested.

    To confirm at your side, you can follow the above steps and create new report server in development machine.

    Thanks & Regards,

    Rajender

  • 8 Ahmed // May 27, 2008 at 9:27 pm

    Really thanks, you are the best
    I got what I am searching for
    with full details and more than what I was expecting

    really thanks
    an keep it up
    you are the best

  • 9 Rajender Singh // May 28, 2008 at 10:48 am

    Thanks Ahmed!

  • 10 Debashis Pattanayak // Aug 7, 2008 at 10:45 pm

    While going with the following steps a me ssage comes at step 1 please refer to installation manual.

  • 11 Debashis Pattanayak // Aug 7, 2008 at 11:24 pm

    Actually let me tell u that i have database and application server is on Linux and oracle forms in Windows 2003 Server.So how can i configure the report server please confirm me.

    please try to answer immediately.

  • 12 Rajender Singh // Aug 8, 2008 at 9:20 am

    Hi Debashis,

    Just want to check out what you mean that application server is on Linux and Oracle Forms are in Windows 2003 Server.

    By right Oracle Forms and Report Services run as a component of the Oracle Application Server.

    That why I just want to check out what exactly your architecture is?

    Thanks & Regards,

    Raj

    P.S Thanks guys for all your appreciation and comments.

  • 13 Debashis Pattanayak // Aug 8, 2008 at 11:58 am

    i mean to say that my oracle database server and application server is installed on Linux and i am accessing those two through another machine which have oracle forms and reports by configuring its TNS Listner.
    My first question is :
    Where will i configure the Reports Server in Linux machine or the machine which is equiped with oracle forms and reports?
    next
    Let me tell u that the your first configuration step is successful on my PC which has oracle forms and reports service but i am unable to run the second step.
    Please reply boss, I m in a big trouble.
    and one more thing Mr. Rajesh can u please tell me what is jobs in Queue and active engine.
    Thanks for Reply.

  • 14 Tithi Das // Aug 15, 2008 at 1:14 am

    Hi. I have an application server with an in-process reports server. I am running two applications on that application server. One application has some long running reports. So I created a stand alone reports server and want the long running reports to use the stand alone report server. But it is not working. Please help.

    As soon as I start two different reports from the two different apps, I get the message 41213 - unable to connect to the report server and the report which takes a short time comes up but the long running report stays in the report server queue pending and never finishes.

    Thanks in advance for your help.

  • 15 Samir // Sep 3, 2008 at 7:09 pm

    i want to create another oracle reports server instance but i have the error message in the 1st step:
    “le point d’entrée de procédure psoasyn dans la bibliothèque de liens dynamiques orapls10.dll”
    in french version.

Leave a Comment