Oracle in-process report server is not configured after Application Server Cloning

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:Oracle in-process report server is not configured after Application Server Cloning 


Symptoms:


Cloning Forms and Reports and clone log file shows this message:
------------------------
[Thu Dec 31 10:41:05 2009 INFO] Final Status:
[Thu Dec 31 10:41:05 2009 INFO] ==============
[Thu Dec 31 10:41:05 2009 INFO] The clone operation completed successfully.

The error log file shows this:
------------------
[Thu Dec 31 10:39:39 2009 ERROR] Executing command - reportsCloning.bat D:\oracle\FR_AS Oracle_FR_AS Acmpsrvtr8 D:\ORACLE\FR_AS FR_AS acmpsrvtr4 encryptPasswd

But there are no real errors generated during clone operation.

Noticed that we do not have in-process report server in the cloned instance.


After Cloning Application Server Forms & Reports, in-Process Report Server is mis-configured

File : targets.xml
Observation :

<Target TYPE="oracle_repserv" NAME="FR_AS_8.Acmpsrvtr8.auh.police_Reports_Server:rep_acmpsrvtr3_FRHome" DISPLAY_NAME="Reports Server: rep_acmpsrvtr3_FRHome" VERSION="1.0" ON_HOST="Acmpsrvtr8.auh.police">
<Property NAME="IASInternalName" VALUE="rep_acmpsrvtr3_FRHome"/>
.
.
<Property NAME="Server" VALUE="rep_acmpsrvtr3_FRHome"/>
.
.
<Target TYPE="oracle_repserv" NAME="FR_AS_8.acmpsrvtr8.auh.police_Reports_Server:rep_Acmpsrvtr8_Oracle_FR_AS" DISPLAY_NAME="Reports Server: rep_Acmpsrvtr8_Oracle_FR_AS" VERSION="1.0" ON_HOST="Acmpsrvtr8.auh.police">
<Property NAME="IASInternalName" VALUE="rep_Acmpsrvtr8_Oracle_FR_AS"/>
.
.
<Property NAME="Server" VALUE="rep_Acmpsrvtr8_Oracle_FR_AS"/>


Solution:


1) Stop all the OPMN services and OEM of the Middle Tier of the cloned instance.
2) Open the "%ORACLE_HOME%\reports\conf\rwservlet.properties" file and change the following lines :

#SERVER_IN_PROCESS=YES
SERVER_IN_PROCESS=NO
.
.
#SERVER=In-Process Server Name
SERVER=Stand alone Report Server Name

as follows :

SERVER_IN_PROCESS=YES
#SERVER_IN_PROCESS=NO
.
.
SERVER=In-Process Report Server Name
#SERVER=Standalone Report Server Name

3) Open the "%ORACLE_HOME%\sysman\emd\targets.xml" file and delete the following lines :

<Target TYPE="oracle_repserv" NAME="FR_AS_8.Acmpsrvtr8.auh.police_Reports_Server:rep_acmpsrvtr3_FRHome" DISPLAY_NAME="Reports Server: rep_acmpsrvtr3_FRHome" VERSION="1.0" ON_HOST="Acmpsrvtr8.auh.police">
<Property NAME="IASInternalName" VALUE="rep_acmpsrvtr3_FRHome"/>
<Property NAME="Password" VALUE="a35d2627692e75f45a97b13cbff1eb7d3af05fbaf83e26b6b9a06e8ca962b15447dc2c62f5ee384f3811e1654a0047b138af78aa8781b658dd90d59623255e32cfe3725b01d022b0289bb300ca440a7a769546104559fd3b4be90602c640df1b9b8486fbf2bf3fc365fc48c26df92f81b1e0bd91fe5133379f2e14d57f50c680fcb865ba39493464f54aad196ea4c712208dcc1f976e860439312b241d448259df375e0a98d960ee5a10acc6528c1b1035d17ffb6bf4feb6563973b197a569625d9cbb8807a0398a5152ee67fa2406c11b354aa6115af0408ba479174e49b756dc04fc1a6c754f07006ba159f4d0ecc78b70679d1c666f351f31a6a76050b1511159de66611ed13aae6fbe50d8d78f368a98580152660f40ef0cc43147a43db337ab48c1cd58d410da4259753aeed03c2fccedf5add6b9b42811be7dc74962b378b53fe7bfa36759d0d97880cf75a272" ENCRYPTED="TRUE"/>
<Property NAME="Server" VALUE="rep_acmpsrvtr3_FRHome"/>
<Property NAME="Servlet" VALUE="http://Acmpsrvtr8.auh.police:7778/reports/rwservlet"/>
<Property NAME="UserName" VALUE="c49bef03053f5224cce1d06a952f80e9" ENCRYPTED="TRUE"/>
<Property NAME="OracleHome" VALUE="D:\oracle\FR_AS"/>
<Property NAME="host" VALUE="Acmpsrvtr8.auh.police"/>
<Property NAME="ElapsedTimeLimit" VALUE="3"/>
<Property NAME="startComponent" VALUE="FR_AS_8.acmpsrvtr8.auh.police_OC4J_BI_Forms"/>
<Property NAME="HTTPProtocol" VALUE="http"/>
<Property NAME="HTTPMachine" VALUE="Acmpsrvtr8.auh.police"/>
<Property NAME="HTTPPort" VALUE="7778"/>
<CompositeMembership>
<MemberOf TYPE="oracle_ias" NAME="FR_AS_8.acmpsrvtr8.auh.police" ASSOCIATION="null"/>
</CompositeMembership>
</Target>

4) Start all the OPMN services and OEM of the Middle Tier of the cloned instance.
5) Now check the In-Process Reports Server "rep_Acmpsrvtr8_Oracle_FR_AS" in OEM and it will be displayed properly.


Oracle Reports 10g Build    

Get Oracle Certifications for all Exams
Free Online Exams.com