在Oracle 10g中創建Report Server
2024-08-29 13:36:51
供稿：網友
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.
