MYSQL网站制作之在Oracle iAS 10g中创立Report Server
RDBMS并非没有局限性。它们难以扩展,需要大量的资源来配置和维护,比如时间、硬件和人力。同样,它们往往遵循峰值性能模型,这就要求系统按照峰值容量来配置可用性,而不考虑典型的数据使用情况。oracle|server|创立1.rwserver-installrep01
2.In“Service”,starttherep01servertocreatetheconffile.
3.Open<oracle_home>eportsconfep01.conf
4.Addpathinfomation,envinfomation,suchas:
<?xmlversion=1.0encoding=ISO-8859-1?>
<!DOCTYPEserverPUBLIC"-//OracleCorp.//DTDReportsServerConfiguration//EN""file:/C:/Oracle/ias/reports/dtd/rwserverconf.dtd">
<serverversion="9.0.4">
<!--compatibleversion="6i"/-->
<cacheclass="oracle.reports.cache.RWCache">
<propertyname="cacheSize"value="50"/>
<!--propertyname="cacheDir"value="yourcachedirectory"/-->
<!--propertyname="maxCacheFileNumber"value="maxnumberofcachefiles"/-->
<!--propertyname="ignoreParameters"value="parameternamestobeignoredinconstructingcachekey,separatedbycomma,"/-->
</cache>
<!--Pleasedonotchangetheidforreportsengine.-->
<!--Theclassspecifiesbelowissubclassof_EngineClassImplBaseandimplementsEngineInterface.-->
<engineid="rwEng"class="oracle.reports.engine.EngineImpl"initEngine="1"maxEngine="1"minEngine="0"engLife="50"maxIdle="30"callbackTimeOut="60000">
<propertyname="sourceDir"value="c:geo;C:WINDOWSFonts"/>
<propertyname="tempDir"value="c:geo"/>
<propertyname="defaultEnvId"value="zhs"/>
<!--propertyname="sourceDir"value="yourreportssourcedirectory"/-->
<!--propertyname="tempDir"value="yourreportstempdirectory"/-->
<!--propertyname="keepConnection"value="yes"/-->
</engine>
<engineid="rwURLEng"class="oracle.reports.urlengine.URLEngineImpl"initEngine="1"maxEngine="1"minEngine="0"engLife="50"maxIdle="30"callbackTimeOut="60000"/>
<!--securityid="rwSec"class="oracle.reports.server.RWSecurity">
<propertyname="securityUserid"value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%"confidential="yes"encrypted="no"/>
<propertyname="oidEntity"value="%REPORTS_OID_ENTITY%"/>
</security-->
<!--destinationdestype="oraclePortal"class="oracle.reports.server.DesOraclePortal">
<propertyname="portalUserid"value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%"confidential="yes"encrypted="no"/>
</destination-->
<destinationdestype="ftp"class="oracle.reports.plugin.destination.ftp.DesFTP">
<!--propertyname="proxy"value="proxyinfo.xml"/-->
</destination>
<destinationdestype="WebDav"class="oracle.reports.plugin.destination.webdav.DesWebDAV">
<!--propertyname="proxy"value="proxyinfo.xml"/-->
</destination>
<jobjobType="report"engineId="rwEng"/>
<jobjobType="rwurl"engineId="rwURLEng"/>
<notificationid="mailNotify"class="oracle.reports.server.MailNotify">
<propertyname="succnotefile"value="succnote.txt"/>
<propertyname="failnotefile"value="failnote.txt"/>
</notification>
<!--notificationid="wfNotify"class="oracle.reports.server.WorkflowNotify">
<propertyname="connStr"value="%WF_DB_USERNAME%/%WF_DB_PASSWORD%@%WF_DB_TNSNAME%"confidential="yes"encrypted="no"/>
</notification-->
<logoption="noJob"/>
<!--jobStatusRepositoryclass="oracle.reports.server.JobRepositoryDB">
<propertyname="repositoryConn"value="repo_db_username/repo_db_password@repo_db_tnsname"confidential="yes"encrypted="no"/>
</jobStatusRepository-->
<!--tracetraceOpts="trace_all"/-->
<connectionmaxConnect="20"idleTimeOut="15">
<orbClientid="RWClient"publicKeyFile="clientpub.key"/>
<!--clusterpublicKeyFile="serverpub.key"privateKeyFile="serverpri.key"/-->
<clusterpublicKeyFile="C:Oracleiaseportsjlibcpub.key"privateKeyFile="C:Oracleiaseportsjlibcpriv.key"/>
</connection>
<environmentid="UTF8">
<envVariablename="NLS_LANG"value="AMERICAN_AMERICA.UTF8"/>
</environment>
<environmentid="zhs">
<envVariablename="NLS_LANG"value="SIMPLIFIEDCHINESE_CHINA.ZHS16GBK"/>
</environment>
<queuemaxQueueSize="1000"/>
<!--
ThevalueoftheidentifierelementisencryptedandisoftheformSERVERACCESSKEY_USER/SERVERACCESSKEY_PASSWORD
SERVERACCESSKEY_USERandSERVERACCESSKEY_PASSWORDin<server>.confandtargets.xml
fileshouldmatchforReportsEMpagestodisplaydatacorrectly.
Correspondingentriesofusernameandpasswordintargets.xml:
<PropertyNAME="Password"VALUE="SERVERACCESSKEY_PASSWORD"ENCRYPTED="FALSE"/>
<PropertyNAME="UserName"VALUE="SERVERACCESSKEY_USER"ENCRYPTED="FALSE"/>
-->
<identifierconfidential="yes"encrypted="yes">ZgZCDkywAUaHwMnb+A6YTggUUX59oOtnJJa6PYd9OXatoaPoa8xDLsPnlpoUKC/SjBYPJfpRUj0A///GoA4Sp/7AwgEhpn6w0YNLDmAqcsix6VRFJ58opHMEBm0H8ieBFVQT5QB6ozKmY5nRv8IpVvaYEEcO+vYxf44MmuzLKfG0vEmtFFlYRHtjtjcG/UPecKzYVcwmMkDCGUyQqiO5a46iVxBWkG8yXnrj4IbETU+JybmAcde0TGjx+25LL5UXHTs0Q3IEJsyk7tFB7yfuppCrEx9meAZg83LbxLZ++135DZT4gMUW5Nggb91QaI+oDk0GNdpecrKJxS8MGa8i91yCqzgRInDNVGOKXQQL4QBVvVZzFAwCVtyRC50gm0i+zDwNlkdaoKndNMoKqjKHYJ5rGQ6VFnrxrAGy3vSeekPhPiths/Cd8YzV49mXlTnjUmlkGFkXe0ku</identifier>
<!--pluginParamname="mailServer">%MAILSERVER_NAME%</pluginParam-->
<!--pluginParamname="proxy"type="file">proxyinfo.xml</pluginParam-->
<pluginParamname="xmlpds"type="file">xmlpds.conf</pluginParam>
<pluginParamname="jdbcpds"type="file">jdbcpds.conf</pluginParam>
<pluginParamname="textpds"type="file">textpds.conf</pluginParam>
</server>
5.Modifytnsnames.oratoincludeatnsnamepointtotargetdatabase
6.Modify<oracle_home>ias oolsuifont.alitoinclude
Arial="SIMFANG.TTF"inthesection
7.restartthereportserver
8.setthereportserverinapplicationtopointtothisreportserver(rep01)
9.printreport
10.inBrowser,type/reports/rwservlet/showjobs?server=rep01">http://<webserver>/reports/rwservlet/showjobs?server=rep01,inthisstep,youcanseethereportjobjustprinted.
Sofar,thereportserveriscreatedsuccessfully.
BTW,intheaboverep01.cluster2.conffile,theresalinebeginingwith<cluster
Thisisusedwhenthereportserverisamemeberofthespecifiedcluster.
解决方案提供商应记住DBaaS通常仅仅是解决方案的一部分。客户之所以与他们的解决方案提供商协同工作,不仅是因为他们出售的产品,而且还因为他们所提供的服务。 groupby子句可以将查询结果分组,并返回行的汇总信息Oracle按照groupby子句中指定的表达式的值分组查询结果。 where子句的作用是在对查询结果进行分组前,将不符合where条件的行去掉,即在分组之前过滤数据,条件中不能包含聚组函数,使用where条件显示特定的行。 XML字段类型更好的解决了XML数据的操作。XQuery确实不错,但是个人对其没好感。(CSDN的开发者应该是相当的熟了!) 其中最有名的应该是row_number了。这个终于解决了用临时表生成序列号的历史,而且SQLServer2005的row_number比Oracle的更先进。因为它把Orderby集成到了一起,不用像Oracle那样还要用子查询进行封装。 一个是把SQL语句写到客户端,可以使用DataSet进行加工; Mirror可以算是SQLServer的Dataguard了。但是能不能被大伙用起来就不知道了。 至于淘汰的问题,只能说在你的项目周期之内,微软应该都不会倒闭。 我是新手,正在学习数据库和操作系统,深感理论的泛广,唯有一步一步来,但是又感觉时间不够,收集了很多资料却总是没能认真的看完,希望有一个讨论板块,大家共同解决,共同分享,共同努力
页:
[1]