pentaho54部署到oralce11g-ok

下载社区版的几个文件：Pentaho5.4部署到oralce11g解压：biserver-ce进入biserver-ce目录，运行start-pentaho.bat脚本，启动用户端服务器，访问地址：访问用户admin/password访问成功表示系统环境没有问题。F:\pentaho\biserver-ce-5.1.0.0-752\biserver-ce\data\oracle10g下有ORACLE建库脚本，需要自己修改，这里提供已经改好的：创建oracle的表空间，用户等：通过oracle的PL/SQL执行脚本，记得执行脚本时，登录PL/SQL需要切换登录用户。PentahoBIServer有两个功能性的数据库（除了案例的数据库）——theHibernatedatabaseandtheQuartzdatabase.A、TheHibernatedatabase的功能是负责PentahoBIServer的内容储存和运行；B、TheQuartzdatabase的功能是负责PentahoBISolution计划任务的调度管理；1.执行以上脚本。2.oracle11g使用ojdbc6.jar，oracle10用ojdbc14.jar包，放到biserver-ce\tomcat\lib目录下，oraclejdbc驱动包，并要重启bi服务器3.完成后，修改对应的配置文件指向新的数据库即可：测试连接：ok修改JDBC相关配置文件进入目录biserver-ce\pentaho-solutions\system下A、修改applicationContext-spring-security-jdbc.properties配置文件：#ThefullyqualifiedJavaclassnameoftheJDBCdrivertobeused#datasource.driver.classname=org.hsqldb.jdbcDriverdatasource.driver.classname=oracle.jdbc.driver.OracleDriver#TheconnectionURLtobepassedtoourJDBCdrivertoestablishaconnection#datasource.url=jdbc:hsqldb:hsql://localhost:9002/userdbdatasource.url=jdbc:oracle:thin:@192.168.11.7:1521:orahb#TheconnectionusernametobepassedtoourJDBCdrivertoestablishaconnectiondatasource.username=orahb#TheconnectionpasswordtobepassedtoourJDBCdrivertoestablishaconnectiondatasource.password=tktk_58a1A#TheSQLquerythatwillbeusedtovalidateconnectionsfromthispoolbeforereturningthemtothecaller.#ThisquerymustbeanSELECTstatementthatreturnsatleastonerow.#HSQLDB:SELECT1FROMINFORMATION_SCHEMA.SYSTEM_USERS#MySQL,H2,MS-SQL,POSTGRESQL,SQLite:SELECT1#ORACLE:SELECT1FROMDUALdatasource.validation.query=SELECT1FROMDUALB、修改applicationContext-spring-security-hibernate.properties配置文件：#jdbc.driver=org.hsqldb.jdbcDriverjdbc.driver=oracle.jdbc.driver.OracleDriver#jdbc.url=jdbc:hsqldb:hsql://localhost:9001/hibernatejdbc.url=jdbc:oracle:thin:@192.168.11.7:1521:orahbjdbc.username=hibuserjdbc.password=passwordhibernate.dialect=org.hibernate.dialect.HSQLDialectC、修改F:\pentaho\biserver-ce-5.4\biserver-ce\pentaho-solutions\system\hibernate目录下oracle10g.hibernate.cfg.xml配置文件：propertyname=connection.driver_classoracle.jdbc.driver.OracleDriver/propertypropertyname=connection.urljdbc:oracle:thin:@192.168.11.7:1521:orahb/propertypropertyname=dialectorg.hibernate.dialect.Oracle10gDialect/propertyD、修改hibernate-settings.xml配置文件:config-filesystem/hibernate/oracle10g.hibernate.cfg.xml/config-fileE、修改\pentaho\biserver-ce-5.1.0.0-752\biserver-ce\tomcat\webapps\pentaho\META-INF目录context.xml配置文件：?xmlversion=1.0encoding=UTF-8?Contextpath=/pentahodocbase=webapps/pentaho/Resourcename=jdbc/Hibernateauth=Containertype=javax.sql.DataSourcefactory=org.apache.commons.dbcp.BasicDataSourceFactorymaxActive=20maxIdle=5maxWait=10000username=hibuserpassword=passworddriverClassName=oracle.jdbc.driver.OracleDriverurl=jdbc:oracle:thin:@192.168.11.7:1521:orahbvalidationQuery=selectcount(*)fromdual/Resourcename=jdbc/Quartzauth=Containertype=javax.sql.DataSourcefactory=org.apache.commons.dbcp.BasicDataSourceFactorymaxActive=20maxIdle=5maxWait=10000username=pentaho_userpassword=passworddriverClassName=oracle.jdbc.driver.OracleDriverurl=jdbc:oracle:thin:@192.168.11.7:1521:orahbvalidationQuery=selectcount(*)fromdual//ContextF、修改\pentaho\biserver-ce\tomcat\webapps\pentaho\WEB-INF目录web.xml配置文件：注释掉这行：!--listenerlistener-classorg.pentaho.platform.web.http.context.HsqldbStartupListener/listener-class/listener--G、修改F:\pentaho\biserver-ce\tomcat\conf\Catalina\localhost目录pentaho.xml配置文件：?xmlversion=1.0encoding=UTF-8?Contextpath=/pentahodocbase=webapps/pentaho/Resourcename=jdbc/Hibernateauth=Containertype=javax.sql.DataSourcefactory=org.apache.commons.dbcp.BasicDataSourceFactorymaxActive=20maxIdle=5maxWait=10000username=hibuserpassword=passworddriverClassName=oracle.jdbc.driver.OracleDriverurl=jdbc:oracle:thin:@192.168.11.7:1521:orahbvalidationQuery=selectcount(*)fromdual/Resourcename=jdbc/Quartzauth=Containertype=javax.sql.DataSourcefactory=org.apache.commons.dbcp.BasicDataSourceFactorymaxActive=20maxIdle=5maxWait=10000username=pentaho_userpassword=passworddriverClassName=oracle.jdbc.driver.OracleDriverurl=jdbc:oracle:thin:@192.168.11.7:1521:orahbvalidationQuery=selectcount(*)fromdual//Context启动start-pentaho.bat如果能正常访问则配置完成，报道则查看报错的地方是不是有设置错误的再处理。错误：启动错误：ThefollowingerrorsweredetectedOneormoresystemlistenersfailed.ThesearesetinthesystemListeners.xml.org.pentaho.platform.api.engine.PentahoSystemException:PentahoSystem.ERROR_0014-Errorwhiletryingtoexecutestartupsequencefororg.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListenerPleaseseetheserverconsoleformoredetailsoneacherrordetected.解决方法：注释掉运行成功。