Tuesday, October 26, 2010

Configuration and deletion Oracle report server

As i started blogging few days back i have done some activities long back those activities m posting for you..

Now we will disscuss about how to configure report server in oracle Application server 10g.
We already have in-built report server but some client needs seprate report server for their application.
I came accross the same requirement few months back.

Here i am posting configuration and deletion of report server in oracle application server.


REPORT SERVER INSTALLATION for 10g:

Before installation stop all opmnctl services and

Then go through the cmd

E:\orabi\bin>addnewservertarget.bat servername

Servername whatever name you want, according you for example: samba

After that what we have to do update the dcmctl.bat file
Why this is so because this file will update the previous server and permit to add new target.
For this how to do there is cmd

E:\orabi\dcm\bin\dcmctl.bat updateconfig –ct opmn –v –d

It will create new server samba with .conf extension and you can see while open to it
By E:\orabi\report\conf\samba.conf

If you want to create instance synchronously, see next cmd

E:\orabi\dcm\bin\dcmctl.bat resyncinstance -v -d

Start the opmn services: opmn startall

Then check the status

You will see no. of instance what you have been created earlier
How many servers/instance are running on application server.
Afterthat open the samba.conf and do some changes
Put this code in comment like this way

< !--security id="rwSec" class="oracle.reports.server.RWSecurity">
< property name="securityUserid" value="tyKAUY845QnJ4GymcUvVwFjmIX0EZy6JDFeaf4mScBswXC9PiMkf86WKPq+DKuupojsfKr1fOcJwzVgaGFN0e0Smu1YPcHtzVwQjeEDc/+5h0n0qdlljjRPO7J6uLinuxAx8MaKeE3v+LyJlWPBuEgD91BDmzYWt3TjPvtpJfU0LlH/BxFyo18wlVfZNzeMojC3fOr84" confidential="yes" encrypted="yes"/>






Why we do this change:

This one time changes will gives better performance no need to change each and every time. it is related to SSO(Single Sign-On)
Above all cmd are configured the report server.






Following steps are for deleting report server from oracle application server configuration :


Steps for deleting report server:

Step 1: stop opmn
Step 2: stop EM console
Step 3: take a backup of opmn.xml
Step 4: Open opmn.xml.. there must be a entry related to your reports server. carefully delete that whole tag.
Step 5: Then do opmnctl validate opmn.xml to validate your opmn.xml.
Step 6: take a backup of targets.xml.
Step 7: open targets.xml.. There must be a entry for your reports server in that. Delete that whole tag from there.
Step 8: start opmn
Step 9: start EM Console.

No comments:

Post a Comment