ilog7环境搭建(windows平台)
所需软件:
jdk1.5
oracle10g
plsql
weblogic10
ilog7rts与res共用ilog一个库。一、在oracle中创建ilog表空间,用户并赋权
create tablespace ilog
datafile 'F:\oracle\product\10.2.0\oradata\ilog\ilog.def' size 100M
autoextend on next 100M maxsize unlimited logging
extent management local autoallocate
segment space management auto;
-- Create the user
create user ilog
identified by "ilog"
default tablespace ilog
temporary tablespace TEMP
profile DEFAULT
quota unlimited on ilog;
-- Grant/Revoke role privileges
grant connect to ILOG;
grant resource to ILOG;
-- Grant/Revoke system privileges
grant create any index to ILOG;
grant create any sequence to ILOG;
grant create any table to ILOG;
grant create any view to ILOG;
grant drop any index to ILOG;
grant drop any sequence to ILOG;
grant drop any table to ILOG;
grant drop any view to ILOG;
grant select any sequence to ILOG;
grant select any table to ILOG;
grant unlimited tablespace to ILOG;
grant update any table to ILOG;二、部署rts
登陆weblogic
1、建数据源 JNDI:
jdbc/ilogDataSource2、用户、组
user password add to group
rtsAdmin rtsAdmin rtsAdministrator, rtsInstaller
rtsConfig rtsConfig rtsConfigManager
rtsUser rtsUser rtsUser3、修改teamserver配置文件,使之匹配
teamserver工程中WEB-INF目录中,找到extended-faces-config.xml
username ? weblogic控制台的登录用户名
password ? weblogic控制台的username对应的密码
host ? weblogic所在机器IP,一般为localhost
port ? 部署rts的 weblogic的端口号
4、上传jrulesteamserver-WL10.ear
5、teamserver初始化设置
登陆rts
数据库脚本生成
启动RTS应用,使用管理员用户登录teamserver。进入安装tab页。选择配置数据库。点击生成sql,勾选执行sql脚本。点击运行。
设置组
Definiter,Tester,Approver
设置持久性语言环境
zh
设置配置参数
参数 teamserver.oracleDataBaseDomainProvider
值 teamserver.oracleDataBaseDomainProvider
参数 teamserver.controller.class
值 permissiontuning.WorkflowSessionController
三、部署res
1、数据源 JNDI: jdbc/resdatasource
2、用户、组
user password add to group
resAdmin resAdmin resAdministrators,resMonitors,resDeployers, Administrators
resMonito resMonitor resMonitors
resDeployer resDeployer resDeployers
3、上传{IBM\WebSphereILOGJRules701Zh\executionserver\applicationservers\WebLogic10 目录下jrules-res-management-WL10.ear和jrules-res-xu-WL10.rar两个文件,在weblogic控制台中部署者两个文件
4、数据库脚本生成
找到{IBM}\WebSphereILOGJRules701Zh\executionserver\databases下的schema_oracle.sql和schema_oracle_plsql.sql脚本,在PLSQL中加以执行即可完成相BRES执行所需数据库支持的配置