Wednesday, April 13, 2011

How to move In-Process Reports Server to default standalone under OPMN and EM control?



Hello everyone,

Today we will discuss about , "How to move In-Process Reports Server to default standalone under OPMN and EM control?"

The In-process reports server is a child of OC4J_BI_FORMS and requires restart of application to restart reports server.
Can the reports server:
1)  be standalone and still have the same name,
2)  be able to be started independently by OPMN and EM,
3)  and still be the default reports server so that the "server=" parameter can be omitted from the URL? 

This post will give the steps to accomplish this.

Solution

To implement, do the following:
This applies to Unix and Windows. Only Unix traversing is shown in this note.

Step 1. Stop opmn.
$ cd $ORACLE_HOME/opmn/bin
$ opmnctl stopall

Step 2. Stop EM console.
$ cd $ORACLE_HOME/bin
$ emctl stop iasconsole


Step 3. Edit the $ORACLE_HOME/reports/conf/rwservlet.properties file:

From
SERVER_IN_PROCESS=YES
To
SERVER_IN_PROCESS=NO


Step 4. Note the in the rwservlet.properties file the value for SERVER=<somename>.
The SERVER parameter defines the "default" reports server names when server=.. is omitted from URL.

Step 5. Make a backup of $ORACLE_HOME/sysman/emd/targets.xml.


Step 6. Delete the existing in-process report server entries from the targets.xml file:
<Target TYPE="oracle_repserv" NAME="localAS.localhost_Reports_Server:<somename>" DISPLAY_NAME="Reports Server: <somename>" VERSION="1.0" ON_HOST="localhost">
.....
</Target>


Step 7. Add the report server to opmn.xml and targets.xml fles using addnewservertarget.sh or addnewservertarget.bat:
$ cd $ORACLE_HOME/bin/
$ addNewServerTarget.sh <somename>   <= this is the name from step 4


Step 8. Restart opmn.
$ cd $ORACLE_HOME/opmn/bin
$ opmnctl startall

Step 9.
Verify that report server is an ias-component.
$ opmnctl status
- Look for the report server name in the first column.


Step 10. Restart EM console.
$ cd $ORACLE_HOME/bin
$ emctl start iasconsole

To start and stop the ONLY reports server from OPMN use the following command:
$ cd $ORACLE_HOME/opmn/bin
$ opmnctl startproc ias-component=<somename>
$ opmnctl stopproc ias-component=<somename>
 
NOTE:
If using namingService for reports server discovery, then Dependancy need to be added to new entry in OPMN.XML
1. Edit the new opmn.xml and add the following to the repserv tag:

FROM

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

TO

<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"/>
<managed-process ias-component="namingservice" process-type="namingservice"
process-set="namingservice" autostart="true"/>
</dependencies>


I hope this will help you in such scenarios..

Regards,
Ajinkya Vichare
ajinkya-vichare.blogspot.com

8 comments:

  1. Doing a gr8 job out here my frnd..! keep up the excellent work.
    cheers.
    Lammeki

    ReplyDelete
  2. @Lammeki Thank you for reviewing my blogs...

    Hope my blogs help you in troubles...

    Enjoyy Working with Middleware technology...

    Regards,
    Ajinkya
    ajinkya.vichare.blogspot.com

    ReplyDelete
  3. I stumbled on this post researching whether to use in-process server vs standalone. It seems to me that in-process server would be better: more modern architecture, no separate start/stop scripts, and better security. This post is over a year old, so I wonder if you have any new insight into which is better, at least under 11g?
    Thanks,
    Debi

    ReplyDelete
    Replies
    1. Sure Debi...

      Will update post on requested topic very soon..

      Thank you for reviewing my blog and your suggestion will always welcome..

      Regards,
      Ajinkya

      ajinkya-vichare.blogspot.com

      Delete
  4. Hi ,
    Had killed the report server component but the status still shows as below:

    opmnctl status | head
    ---------------------------------+--------------------+---------+---------
    ias-component | process-type | pid | status
    ---------------------------------+--------------------+---------+---------
    emagent_pfrdinst_1 | EMAGENT | 136318~ | Alive
    ReportsServer_djap22_pfrdinst_1 | ReportsServerComp~ | 2556500 | Stop
    forms | FormsRuntime | 270665~ | Alive
    forms | FormsRuntime | 486932~ | Alive

    When i try to start the report server component It just hangs & does nothing.
    Can you please help/suggest

    ReplyDelete
    Replies
    1. Hi prakash,

      Best Wishes..@@@

      Kindly let me know the scenario where your reports server gets hungs.

      Also if you have any logs which generated on server.

      One scenario you can check as below :

      1) login to Em console
      2) Stop report server (either that server is in stop state or N/A state )
      3) Start same report server again from console.

      You can write me for further help on middlewaresolution1@gmail.com

      You can also drop me report server logs if you have any,,

      Regards,
      Ajinkya Vichare

      Delete
  5. Hi, we have using in-process report in my client. but some times we are facing cross report connection. suppose end user executing one report but its is showing another report information. please advice how to resolve the porblem.

    ReplyDelete
    Replies
    1. Hi,

      Best Wishes..@@@
      I think you need to check from application side for pointing of your report from form.

      Are you facing this issue with specific reports or this is same behavior for all reports.

      Regards,
      Ajinkya Vichare

      Delete