数据库

本类阅读TOP10

·SQL语句导入导出大全
·SQL Server日期计算
·SQL语句导入导出大全
·SQL to Excel 的应用
·Oracle中password file的作用及说明
·MS SQLServer OLEDB分布式事务无法启动的一般解决方案
·sqlserver2000数据库置疑的解决方法
·一个比较实用的大数据量分页存储过程
·如何在正运行 SQL Server 7.0 的服务器之间传输登录和密码
·SQL中两台服务器间使用连接服务器

分类导航
VC语言Delphi
VB语言ASP
PerlJava
Script数据库
其他语言游戏开发
文件格式网站制作
软件工程.NET开发
在Oracle iAS 10g中创建Report Server

作者:未知 来源:月光软件站 加入时间:2005-2-28 月光软件站

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 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.




相关文章

相关软件