在Oracle10g中创建ReportServer
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.