商云方的技术博客 (沪ICP备14046774号-1)

===============================================================================

九、RSL 安装

9.1 RSL Appserver 安装

9.1.1 确认ReIM 所在数据库已经启动

若未启动，设置环境变量启动之

su – root

Xhost+

su – oracle

ORACLE_BASE=/d01/app/oracle

ORACLE_HOME=/d01/app/oracle/product/11.1.0/db_1

ORACLE_SID=retl

PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH:

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

RMS_STAGEDIR=/d01/stage/retail/rms/rms

export RMS_STAGEDIR

NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_LANG

sqlplus ‘/as sysdba’

Sql> startup

8.1.2 启动OAS 10.1.3.4

ORACLE_HOME=/d01/app/oracle/product/10.1.3.1/OracleAS_2

PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH:

export export ORACLE_HOME PATH

$ORACLE_HOME/opmn/bin/opmnctl startall

进入oas控制台，http://retek13.hand-china.com:2000/em

As Instance name : retekas2

Oc4jadmin 密码： ********1

创建instance和group

$ORACLE_HOME/bin/createinstance -instanceName rsl-oc4j -groupName rsl_group

密码：********1

启动oc4j

$ORACLE_HOME/opmn/bin/opmnctl @cluster startproc ias-component=rsl_group

设置JAVA_HOME环境变量：

JAVA_HOME=$ORACLE_HOME/jdk

export JAVA_HOME

cd /d01/stage/retail/rpm/RSL1310forRMS

./rsl-installer.sh

RMS 13 JDBC URL: jdbc:oracle:oci:@retl

RMS 13 schema: RMS13DEV

oc4jAdmin密码设置为：********1

配置logging:

cd $ORACLE_HOME/j2ee/rsl-oc4j/config

cp j2ee-logging.xml j2ee-logging.xml.bak_bf_rsl

vi j2ee-logging.xml

在 <logging_configuration> tag后 输入：:

<logging_properties>

<property name=’java.util.logging.FileHandler.formatter’ value=’java.util.logging.SimpleFormatter’/>

<property name=’java.util.logging.FileHandler.pattern’ value=’%ORACLE_HOME%/j2ee/<oc4j-instance-name>/log/rsl.log’/>

</logging_properties>

在 <log_handlers> tag 后输入：

<log_handler name=’rsl-log-handler’ class=’java.util.logging.FileHandler’>

<property name=’path’ value=’%ORACLE_HOME%/j2ee/%OPMN_PROC_TYPE%/log/%OPMN_PROC_TYPE%_%OPMN_PROC_SET%_%OPMN_PROC_INDEX%/oc4j’/>

<property name=’maxFileSize’ value=’10485760’/>

<property name=’maxLogSize’ value=’104857600’/>

<property name=’encoding’ value=’UTF-8’/>

<property name=’supplementalAttributes’ value=’J2EE_APP.name,J2EE_MODULE.name,WEBSERVICE.name,WEBSERVICE_PORT.name’/>

</log_handler>

在 <logger> tag 后输入：

<logger name=’oracle.retail’ level=’INFO’ useParentHandlers=’false’>

<handler name=’rsl-log-handler’/>

</logger>

<logger name=’com.retek’ level=’INFO’ useParentHandlers=’false’>

<handler name=’rsl-log-handler’/>

</logger>

重启动oc4j

$ORACLE_HOME/opmn/bin/opmnctl @cluster stopproc ias-component=rsl_group

$ORACLE_HOME/opmn/bin/opmnctl @cluster startproc ias-component=rsl_group

改变log层次：

登录，按照ig上的操作

http://retek13.hand-china.com:2000/em

===============================================================================

十、RPM 安装

10.1 RPM DB 安装

在安装rms的时候已经完成RPM的db object的安装

10.2 RPM Appserver 安装

10.2.1 确认RPM 所在数据库已经启动

若未启动，设置环境变量启动之

su – root

Xhost+

su – oracle

ORACLE_BASE=/d01/app/oracle

ORACLE_HOME=/d01/app/oracle/product/11.1.0/db_1

ORACLE_SID=retl

PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH:

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

RMS_STAGEDIR=/d01/stage/retail/rms/rms

export RMS_STAGEDIR

NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_LANG

sqlplus ‘/as sysdba’

Sql> startup

10.2.2 启动OAS 10.1.3.4

ORACLE_HOME=/d01/app/oracle/product/10.1.3.1/OracleAS_2

PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH:

export export ORACLE_HOME PATH

$ORACLE_HOME/opmn/bin/opmnctl startall

进入oas控制台，http://retek13.hand-china.com:2000/em

As Instance name : retekas2

Oc4jadmin 密码： ********1

创建instance和group

$ORACLE_HOME/bin/createinstance -instanceName rpm_oc4j -groupName rpm_group

密码设置为：********1

启动oc4j:

$ORACLE_HOME/opmn/bin/opmnctl @cluster startproc ias-component=rpm_group

配置Apache 支持JNLP:

cp $ORACLE_HOME/Apache/Apache/conf/mime.types $ORACLE_HOME/Apache/Apache/conf/mime.types.bak_bf_rpm

vi $ORACLE_HOME/Apache/Apache/conf/mime.types

添加：

application/x-java-jnlp-file jnlp

重启 httpServer:

$ORACLE_HOME/opmn/bin/opmnctl restartproc process-type=HTTP_Server

下载 hibernate2.jar version 2.1.8,存放于：$INSTALL_DIR/rpm/application/hibernate(/d01/stage/retail/rpm/rpm/application/hibernate)

http://www.hibernate.org

设置JAVA_HOME环境变量：

JAVA_HOME=$ORACLE_HOME/jdk

export JAVA_HOME

cd /d01/stage/retail/rpm/rpm/application

./install.sh

RPM/RMS 13 JDBC URL: jdbc:oracle:oci:@retl

RPM/RMS 13 schema: RMS13DEV

RMS 13 schema owner: RMS13DEV

Loging Module 选择 xml , 在rpm的部署目录下编辑user_rpm.xml来添加用户。

给客户端配置jar签名：

$JAVA_HOME/bin/keytool -genkey -alias foo

[oracle@retek13 application]$ $JAVA_HOME/bin/keytool -genkey -alias foo

Enter keystore password: ********

What is your first and last name?

[Unknown]: jack

What is the name of your organizational unit?

[Unknown]: hand

What is the name of your organization?

[Unknown]: hand

What is the name of your City or Locality?

[Unknown]: shanghai

What is the name of your State or Province?

[Unknown]: shanghai

What is the two-letter country code for this unit?

[Unknown]: cn

Is CN=jack, OU=hand, O=hand, L=shanghai, ST=shanghai, C=cn correct?

[no]: yes

Enter key password for <foo>

(RETURN if same as keystore password):

[oracle@retek13 application]$

cd $ORACLE_HOME/j2ee/rpm_oc4j/applications/rpm13/JnlpLaunchServlet/lib

$JAVA_HOME/bin/jarsigner rpm_client_config.jar foo

安装测试：

http://retek13.hand-china.com:2000/rpm-client/launch?template=rpm_jnlp_template.vm

用户参见：/d01/app/oracle/product/10.1.3.1/OracleAS_2/j2ee/rpm_oc4j/applications/rpm13/conf/retek/user_rsm.xml

登录后任务是空的，select * from rpm_task 也是空的，难道rpm初始化数据未执行？

查：file:///d01/stage/retail/rms/rms/dbschema/build.xml 中有一章是insert rpm data的：经检查这些脚本insert的数据都存在，证明这些脚本是被正确执行的。

select * from rsm_user_role

select * from rsm_role

显示只有 Alain.Frecon 被赋予管理员角色，无其他用户被分配角色。

所以用：Alain.Frecon登录

有内容，正常：