当前位置导航:炫浪网>>网络学院>>编程开发>>Oracle教程

在Oracle 10g中创建Report Server


  1. rwserver -install rep01
  
  2. In “Service”, start the rep01 server to create the conf file.
  
  3. Open <oracle_home>\reports\conf\rep01.conf
  
  4. Add path infomation , env infomation, such as :
  
  <?xml version = '1.0' encoding = 'ISO-8859-1'?>
  <!DOCTYPE server PUBLIC "-//Oracle Corp.//DTD Reports Server Configuration //EN" "file:/C:/Oracle/ias/reports/dtd/rwserverconf.dtd">
  <server version="9.0.4">
  <!--compatible version="6i"/-->
  <cache class="oracle.reports.cache.RWCache">
  <property name="cacheSize" value="50"/>
  <!--property name="cacheDir" value="your cache directory"/-->
  <!--property name="maxCacheFileNumber" value="max number of cache files"/-->
  <!--property name="ignoreParameters" value="parameter names to be ignored in constructing cache key, separated by comma ','"/-->
  </cache>
  <!--Please do not change the id for reports engine.-->
  <!--The class specifies below is subclass of _EngineClassImplBase and implements EngineInterface.-->
  <engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000">
  <property name="sourceDir" value="c:\geo;C:\WINDOWS\Fonts"/>
  <property name="tempDir" value="c:\geo"/>
  <property name="defaultEnvId" value="zhs"/>
  <!--property name="sourceDir" value="your reports source directory"/-->
  <!--property name="tempDir" value="your reports temp directory"/-->
  <!--property name="keepConnection" value="yes"/-->
  </engine>
  <engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000"/>
  <!--security id="rwSec" class="oracle.reports.server.RWSecurity">
  <property name="securityUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>
  <property name="oidEntity" value="%REPORTS_OID_ENTITY%"/>
  </security-->
  <!--destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">
  <property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>
  </destination-->
  <destination destype="ftp" class="oracle.reports.plugin.destination.ftp.DesFTP">
  <!--property name="proxy" value="proxyinfo.xml"/-->
  </destination>
  <destination destype="WebDav" class="oracle.reports.plugin.destination.webdav.DesWebDAV">
  <!--property name="proxy" value="proxyinfo.xml"/-->
  </destination>
  <job jobType="report" engineId="rwEng"/>
  <job jobType="rwurl" engineId="rwURLEng"/>
  <notification id="mailNotify" class="oracle.reports.server.MailNotify">
  <property name="succnotefile" value="succnote.txt"/>
  <property name="failnotefile" value="failnote.txt"/>
  </notification>
  <!--notification id="wfNotify" class="oracle.reports.server.WorkflowNotify">
  <property name="connStr" value="%WF_DB_USERNAME%/%WF_DB_PASSWORD%@%WF_DB_TNSNAME%" confidential="yes" encrypted="no"/>
  </notification-->
  <log option="noJob"/>
  <!--jobStatusRepository class="oracle.reports.server.JobRepositoryDB">
  <property name="repositoryConn" value="repo_db_username/repo_db_password@repo_db_tnsname" confidential="yes" encrypted="no"/>
  </jobStatusRepository-->
  <!--trace traceOpts="trace_all"/-->
  <connection maxConnect="20" idleTimeOut="15">
  <orbClient id="RWClient" publicKeyFile="clientpub.key"/>
  <!--cluster publicKeyFile="serverpub.key" privateKeyFile="serverpri.key"/-->
  <cluster publicKeyFile="C:\Oracle\ias\reports\jlib\cpub.key" privateKeyFile="C:\Oracle\ias\reports\jlib\cpriv.key"/>
  </connection>
  <environment id="UTF8">
  <envVariable name="NLS_LANG" value="AMERICAN_AMERICA.UTF8"/>
  </environment>
  <environment id="zhs">
  <envVariable name="NLS_LANG" value="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"/>
  </environment>
  
  <queue maxQueueSize="1000"/>
  <!--
  The value of the 'identifier' element is encrypted and is of the form SERVERACCESSKEY_USER/SERVERACCESSKEY_PASSWORD
  
  SERVERACCESSKEY_USER and SERVERACCESSKEY_PASSWORD in <server>.conf and targets.xml
  file should match for Reports EM pages to display data correctly.
  
  Corresponding entries of username and password in targets.xml:
  <Property NAME="Password" VALUE="SERVERACCESSKEY_PASSWORD" ENCRYPTED="FALSE"/>
  <Property NAME="UserName" VALUE="SERVERACCESSKEY_USER" ENCRYPTED="FALSE"/>
  -->
  <identifier confidential="yes" encrypted="yes">ZgZCDkywAUaHwMnb+A6YTggUUX59oOtnJJa6PYd9OXatoaPoa8xDLsPnlpoUKC/SjBYPJfpRUj0A///GoA4Sp/7AwgEhpn6w0YNLDmAqcsix6VRFJ58opHMEBm0H8ieBFVQT5QB6ozKmY5nRv8IpVvaYEEcO+vYxf44MmuzLKfG0vEmtFFlYRHtjtjcG/UPecKzYVcwmMkDCGUyQqiO5a46iVxBWkG8yXnrj4IbETU+JybmAcde0TGjx+25LL5UXHTs0Q3IEJsyk7tFB7yfuppCrEx9meAZg83LbxLZ++135DZT4gMUW5Nggb91QaI+oDk0GNdpecrKJxS8MGa8i91yCqzgRInDNVGOKXQQL4QBVvVZzFAwCVtyRC50gm0i+zDwNlkdaoKndNMoKqjKHYJ5rGQ6VFnrxrAGy3vSeekPhPiths/Cd8YzV49mXlTnjUmlkGFkXe0ku</identifier>
  <!--pluginParam name="mailServer">%MAILSERVER_NAME%</pluginParam-->
  <!--pluginParam name="proxy" type="file">proxyinfo.xml</pluginParam-->
  <pluginParam name="xmlpds" type="file">xmlpds.conf</pluginParam>
  <pluginParam name="jdbcpds" type="file">jdbcpds.conf</pluginParam>
  <pluginParam name="textpds" type="file">textpds.conf</pluginParam>
  </server>
  
  5. Modify tnsnames.ora to include a tns name point to target database
  
  6. Modify <oracle_home>\ias\tools\uifont.ali to include
  Arial = "SIMFANG.TTF"  in the [ PDF:Subset ] section
  
  7. restart the report server
  
  8. set the report server in application to point to this report server(rep01)
  
  9. print report
  
  10. in Browser, type /reports/rwservlet/showjobs?server=rep01">http://<webserver>/reports/rwservlet/showjobs?server=rep01 , in this step, you can see the report job just printed.
  
  So far, the report server is created successfully.
  
  BTW, in the above rep01.cluster2.conf file, there's a line begining with <cluster
  This is used when the report server is a memeber of the specified cluster.
相关内容
赞助商链接