首页 > 数据库 > Oracle > 正文

在Oracle iAS 10g中创建Report Server

2024-08-29 13:48:20
字体:
来源:转载
供稿:网友

  
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.

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表