您的位置:首页技术文章
文章详情页

在Oracle iAS 10g中创建Report Server

浏览:52日期:2023-11-16 08:54:04
1. rwserver -install rep012. In “Service”, start the rep01 server to create the conf file.3. Open <Oracle_home>reportsconfrep01.conf4. 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 initEngine='1' maxEngine='1' minEngine='0' engLife='50' maxIdle='30' callbackTimeOut='60000'> <property name='sourceDir' value='c:geo;C:WINDOWSFonts'/> <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 initEngine='1' maxEngine='1' minEngine='0' engLife='50' maxIdle='30' callbackTimeOut='60000'/> <!--security 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 class='oracle.reports.server.MailNotify'> <property name='succnotefile' value='succnote.txt'/> <property name='failnotefile' value='failnote.txt'/> </notification> <!--notification 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 publicKeyFile='clientpub.key'/> <!--cluster publicKeyFile='serverpub.key' privateKeyFile='serverpri.key'/--> <cluster publicKeyFile='C:Oracleiasreportsjlibcpub.key' privateKeyFile='C:Oracleiasreportsjlibcpriv.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 database6. Modify <oracle_home>iastoolsuifont.ali to include Arial = 'SIMFANG.TTF';in the [ PDF:Subset ] section7. restart the report server8. 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.
标签: Oracle 数据库