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
Doing a gr8 job out here my frnd..! keep up the excellent work.
ReplyDeletecheers.
Lammeki
@Lammeki Thank you for reviewing my blogs...
ReplyDeleteHope my blogs help you in troubles...
Enjoyy Working with Middleware technology...
Regards,
Ajinkya
ajinkya.vichare.blogspot.com
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?
ReplyDeleteThanks,
Debi
Sure Debi...
DeleteWill 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
Hi ,
ReplyDeleteHad 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
Hi prakash,
DeleteBest 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
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.
ReplyDeleteHi,
DeleteBest 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