pentaho5.4部署到oralce11g-ok

下载社区版的几个文件：

Pe nt a h o5.4 部署到o ra l ce 11g

解压：b i s er v er -c e 进入b i s er v er -c e 目录，运行s t ar t -pen t ah o .ba t 脚本，启动用户端服务器，访问地址：h tt p ://l o c a l h o s t:8080/pen t ah o 访问用户admin/password 访问成功表示系统环境没有问题。 F:\pen t ah o \b i s er v er -c e -5.1.0.0-752\b i s er v er -c e \d a t a \o ra c l e10g 下有O R A C L E 建库脚本，需要自己修改，这里提供已经改好的： 创建oracle 的表空间，用户等：通过oracle 的PL/SQL 执行脚本，记得执行脚本时，登录PL/SQL 需要切换登录用户。

PentahoBIServer 有两个功能性的数据库（除了案例的数据库）——theHibernatedatabaseandtheQuartz d a t aba s e .

A 、TheHibernatedatabase 的功能是负责PentahoBIServer 的内容储存和运行；

B 、

TheQuartzdatabase 的功能是负责PentahoBI S o l u ti o n 计划任务的调度管理；

1.执行以上脚本。

2. oracle11g 使用ojdbc6.jar ，oracle10用o j d b c 14.j ar 包，放到b i s er v er -c e \t o m c a t \li b 目录下，o ra c l e j d b c 驱动包，并要重启bi 服务器

3.

完成后，修改对应的配置文件指向新的数据库即可：

测试连接：ok

修改J D B C相关配置文件

进入目录b i s er v er-c e\pen t ah o-s o l u ti o n s\s y s t em下

A、修改app li c a ti o n Co n t e xt-s pr i n g-s e c ur it y-j d b c.pr o per ti e s配置文件：

# The fully qualified Java class name of the JDBC driver to be used

#datasource.driver.classname=org.hsqldb.jdbcDriver

datasource.driver.classname=oracle.jdbc.driver.OracleDriver

# The connection URL to be passed to our JDBC driver to establish a connection

#datasource.url=jdbc:hsqldb:hsql://localhost:9002/userdb

datasource.url=jdbc:oracle:thin:@192.168.11.7:1521:orahb

# The connection username to be passed to our JDBC driver to establish a connection

https://www.wendangku.net/doc/2418971898.html,ername=orahb

# The connection password to be passed to our JDBC driver to establish a connection

datasource.password=tktk_58a1A

# The SQL query that will be used to validate connections from this pool before returning them to the caller.

# This query must be an SELECT statement that returns at least one row.

# HSQLDB: SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS

# MySQL, H2, MS-SQL, POSTGRESQL, SQLite: SELECT 1

# ORACLE: SELECT 1 FROM DUAL

datasource.validation.query=SELECT 1 FROM DUAL

B、修改app li c a ti o n Co n t e xt-s pr i n g-s e c ur it y-h i berna t e.pr o per ti e s配置文件：

#jdbc.driver=org.hsqldb.jdbcDriver

jdbc.driver=oracle.jdbc.driver.OracleDriver

#jdbc.url=jdbc:hsqldb:hsql://localhost:9001/hibernate

jdbc.url=jdbc:oracle:thin:@192.168.11.7:1521:orahb

https://www.wendangku.net/doc/2418971898.html,ername=hibuser

jdbc.password=password

hibernate.dialect=org.hibernate.dialect.HSQLDialect

C、修改F:\pen t ah o\b i s er v er-c e-5.4\b i s er v er-c e\pen t ah o-s o l u ti o n s\s y s t em\h i berna t e目录下o ra c l e10g.h i berna t e.c f g.x m l

配置文件：

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@192.168.11.7:1521:orahb

org.hibernate.dialect.Oracle10gDialect

D、修改h i berna t e-s e tti n gs.x m l配置文件:

s y s t em/h i berna t e/o ra c l e10g.h i berna t e.c f g.x m l

E、修改\pen t ah o\b i s er v er-c e-5.1.0.0-752\b i s er v er-c e\t o m c a t\w ebapp s\pen t ah o\M E TA-I N F目录c o n t e xt.x m l配置文件：

factory="https://www.wendangku.net/doc/2418971898.html,mons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"

maxWait="10000" username="hibuser" password="password"

driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@192.168.11.7:1521:orahb"

validationQuery="select count(*) from dual" />

factory="https://www.wendangku.net/doc/2418971898.html,mons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"

maxWait="10000" username="pentaho_user" password="password"

driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@192.168.11.7:1521:orahb"

validationQuery="select count(*) from dual"/>

F、修改\pen t ah o\b i s er v er-c e\t o m c a t\w ebapp s\pen t ah o\W EB-I N F目录w eb.x m l配置文件：

注释掉这行：

G、修改F:\pen t ah o\b i s er v er-c e\t o m c a t\c o nf\C a t a li na\l o c a l h o s t目录pen t ah o.x m l配置文件：

factory="https://www.wendangku.net/doc/2418971898.html,mons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"

maxWait="10000" username="hibuser" password="password"

driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@192.168.11.7:1521:orahb"

validationQuery="select count(*) from dual" />

factory="https://www.wendangku.net/doc/2418971898.html,mons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"

maxWait="10000" username="pentaho_user" password="password"

driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@192.168.11.7:1521:orahb"

validationQuery="select count(*) from dual"/>

启动s t ar t-pen t ah o.ba t如果能正常访问则配置完成，报道则查看报错的地方是不是有设置错误的再处理。

错误：启动错误：

The following errors were detected

One or more system listeners failed. These are set in the systemListeners.xml.

org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener

Please see the server console for more details on each error detected.

解决方法：注释掉

运行成功。