在Oracle iAS 10g中创建Report Server
2024-08-29 13:30:03
供稿：网友
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/[email protected]_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.
