参考网站如下
https://help.fanruan.com/finereport/doc-view-304.html
若使用 Oracle 数据库,在定义数据连接时,将原来的 URL 改成:jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =IP1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST =IP2)(PORT = 1521))(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = 数据库名)))
示例1:在 192.168.100.168 和 192.168.100.170 机器上都拥有数据库名为 orcl10g,那么数据连接的 URL 就改成:jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.100.168)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.100.170)(PORT = 1521))(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl10g)))即可。
如果是kettle连接报错,则不需要填写主机名称,端口号改成-1即可
示例2:在 env.finedevelop.com对应55602 端口拥有一个数据库 initfantlam,同时对应 55502 端口也拥有一个数据库 initfantlam,那么数据库连接的就改成:
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =env.finedevelop.com)(PORT = 55602))(ADDRESS = (PROTOCOL = TCP)(HOST =env.finedevelop.com)(PORT = 55502))(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = initfantlam)))即可。