četvrtak, 3. srpnja 2014.

Oracle Reports 10G: Windows registry REPORTS_PATH can be extended up to 1024 characters.

On some of test servers I usually use built in report server and to add more applications (paths where rdf's are) I extend REPORTS_PATH variable in registry. Problem is when more application accumulate there are more entries in registry variable.
Maximum is 1024 characters for REPORTS_PATH variables. When that point is reached new reports servers are created.

Procedure to create a report server (Oracle Forms and Reports services server, but can be used on all Oracle Midtier servers):


  • Open command prompt (elevated command prompt):

                           rwserver server=%server_name% start


  • Shut down the opmn:

                          %OracleMiddleTierHome%\opmn\bin\opmnctl stopall


  • Add new server target (command prompt will close automatically if everything is ok):

                           %OracleMiddleTierHome%\bin\addNewServerTarget.bat %server_name%

  • Open command prompt (elevated command prompt):
                          %OracleMiddleTierHome%\dcm\bin\dcmctl.bat updateconfig -ct opmn -v -d
                          %OracleMiddleTierHome%\ dcm\bin\dcmctl.bat resyncinstance -v -d


  • Start the opmn

                         %OracleMiddleTierHome%\opmn\bin\opmnctl startall


Add into the configuration source directory where reports are (use Enterpise manager) (I also sometimes change the number of engines):

                         %OracleMiddleTierHome%\reports\conf\rep_razees.conf

   <engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="2" minEngine="1" engLife="50" maxIdle="30" callbackTimeOut="90000">
      <property name="sourceDir" value="C:\ORACLE\APLI10\DS10G\RAZ_EES_RSRV"/>
      <!--property name="tempDir" value="your reports temp directory"/-->
      <!--property name="keepConnection" value="yes"/-->
   </engine>


Nema komentara:

Objavi komentar