RPM 13.1 Demo 安装日志

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

九、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

clip_image001

配置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来添加用户。

clip_image002

给客户端配置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

clip_image003

用户参见:/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登录

clip_image004

有内容,正常:

clip_image005

ReIM 13.1 Demo 安装日志

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

八、ReIM 安装

8.1 ReIM DB 安装

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

8.2 ReIM Appserver 安装

8.2.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.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 reim_oc4j -groupName reim_group

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

启动oc4j:

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

设置JAVA_HOME环境变量:

JAVA_HOME=$ORACLE_HOME/jdk

export JAVA_HOME

cd /d01/stage/retail/reim/reim/application

./install.sh

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

ReIM/RMS 13 schema: RMS13DEV

RMS 13 schema owner: RMS13DEV

clip_image001

安装测试:

http://retek13.hand-china.com:2000/reim/index.jsp

clip_image002

备注:这个登录用户在ig中也未提到,利用数据库session跟踪效果不好,查源代码可知其用户信息存放于:IM_USER_AUTHORIZATION 表中。

反编译:/d01/app/oracle/product/10.1.3.1/OracleAS_2/j2ee/reim_oc4j/applications/reim13/reim13/WEB-INF/classes/com/retek/reim/db/ImUserAuthorizationAccess.class

clip_image003

select * from IM_USER_AUTHORIZATION

clip_image004

ALLOC 13.1 Demo 安装日志

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

七、ALLOC 安装

7.1 Alloc DB 安装

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

Allocation schema: ALLOC13DEV

密码:*********

7.2 Alloc Appserver 安装

7.2.1 确认alloc所在数据库已经启动

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

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

7.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 alloc_oc4j -groupName alloc_group

密码输入:*********1

cp $ORACLE_HOME/opmn/conf/opmn.xml $ORACLE_HOME/opmn/conf/opmn.xml.bak_bf_alloc

vi $ORACLE_HOME/opmn/conf/opmn.xml

设置语言环境

<process-type id="alloc_oc4j" module-id="OC4J" status="enabled">

<environment>

<variable id="LANG" value="en_US" />

</environment>

$ORACLE_HOME/opmn/bin/opmnctl reload

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

JAVA_HOME=$ORACLE_HOME/jdk

export JAVA_HOME

cp /d01/app/oracle/OraHome_1/network/admin/tnsnames.ora /d01/app/oracle/product/10.1.3.1/OracleAS_2/network/admin/

cd /d01/stage/retail/alloc/alloc/application

./install.sh

输入:

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

Allocation schema: ALLOC13DEV

RMS 13 schema: RMS13DEV

需要rpm_oc4j

application name: rpm13

clip_image001

alloc安装完成后会自动启动一个ocm的安装,此安装在最后一步向oracle的configuration manager server 注册时因为超时而失败。

clip_image002

安装测试:

http://retek13.hand-china.com:2000/alloc/index.jsp

clip_image003

SELECT * FROM ALC_USERS

输入用户名:RETEK

密码:retek

clip_image004

RWMS 13.1 Demo 安装日志

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

六、RWMS 安装

按照rwms的ig安装

6.1) RWMS DB 安装

6.1.1)创建OFA目录

su – oracle

ORACLE_BASE=/d01/app/oracle

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

ORACLE_SID=rwms

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

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

RWMS_STAGEDIR=/d01/stage/retail/rwms/dbserverunix

export RWMS_STAGEDIR

NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_LANG

cd $ORACLE_BASE/oradata

mkdir $ORACLE_BASE/oradata/rwms

mkdir $ORACLE_BASE/admin/rwms

mkdir $ORACLE_BASE/admin/rwms/adump

mkdir $ORACLE_BASE/admin/rwms/bdump

mkdir $ORACLE_BASE/admin/rwms/cdump

mkdir $ORACLE_BASE/admin/rwms/udump

mkdir $ORACLE_BASE/admin/rwms/dpdump

mkdir $ORACLE_BASE/admin/rwms/pfile

mkdir $ORACLE_BASE/admin/rwms/arch

cp $RWMS_STAGEDIR/create_db/init102_release.ora $ORACLE_HOME/dbs/initrwms.ora

更改正确的路径和Dbname:

vi $ORACLE_HOME/dbs/initrwms.ora (ok)

vi $RWMS_STAGEDIR/create_db/crdb1.sql

vi $RWMS_STAGEDIR/create_db/crdb2.sql

vi $RWMS_STAGEDIR/create_db/crdb3.sql

vi $RWMS_STAGEDIR/create_db/create_rwms_tablespaces.sql

运行crdb3.sql时, xdb_protocol.log 中有错误,原因是执行到某个操作时,报告不能分配share pool; 因为我把默认的sga参数都调整到原来的一半了,原来的SGA是1G,我调整到了512M ,特别是share pool也被我从350M 调整到了175M,在安装过程中出现了share pool不够用的情况,Action ,调大share pool 到原来的350M,其他依然是原来的一半,重启数据库后继续:

spool xdb_protocol.log

@$ORACLE_HOME/rdbms/admin/catqm.sql change_on_install SYSAUX TEMP;

spool off

@$ORACLE_HOME/rdbms/admin/utlrp.sql

重新运行可以。

创建Schema:

sqlplus ‘/as sysdba’

create role developer;

create role wms_user;

cd $RWMS_STAGEDIR/utility

sqlplus ‘/as sysdba’

@create_user.sql

@rwms_owner_grants.sql

创建RIB对象

sqlplus ‘/as sysdba’

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "SYSTEM"

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "RETEK_DATA"

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "RETEK_INDEX"

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "LOB_DATA"

cd $RWMS_STAGEDIR/rib_objects/ddl

sqlplus rwms13dev/********

@rib13ddl.sql

log显示很多表创建失败,主要是对DATA_MEDIUM , DATA_LARGE表空间无权限

sqlplus ‘/as sysdba’

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "DATA_MEDIUM";

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "INDEX_MEDIUM";

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "DATA_LARGE";

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "INDEX_LARGE";

cd $RWMS_STAGEDIR/rib_objects/db_objects/130

sqlplus rwms13dev/********

Sql>@InstallAndCompileAllRibOracleObjects.sql

创建rwms对象:

cd $RWMS_STAGEDIR/types/130

sqlplus rwms13dev/********

@rwms13type.sql

cd $RWMS_STAGEDIR/ddl

sqlplus rwms13dev/********

@rwms13.sql

log显示很多表创建失败,主要是对DATA_MEDIUM , DATA_LARGE表空间无权限

sqlplus ‘/as sysdba’

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "DATA_MEDIUM";

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "INDEX_MEDIUM";

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "DATA_LARGE";

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "INDEX_LARGE";

再次运行rwms13.sql

cd $RWMS_STAGEDIR/triggers/130

sqlplus rwms13dev/********

@rwms13trg.sql

cd $RWMS_STAGEDIR/db_objects/130

sqlplus rwms13dev/********

@rwms13dbo.sql

cd $RWMS_STAGEDIR/utility

sqlplus rwms13dev/********

@inv_obj_comp.sql

插入初始化数据:

cd $RWMS_STAGEDIR/data/130

sqlplus rwms13dev/********

@create_base_data.sql

升级到1301:

cd $RWMS_STAGEDIR/dbcs/1301

sqlplus rwms13dev/********

@patch1301dbcs.sql

cd $RWMS_STAGEDIR/db_objects/1301

sqlplus rwms13dev/********

@patch1301rwms.sql

cd $RWMS_STAGEDIR/data/1301

sqlplus rwms13dev/********

@patch1301ctl.sql

cd $RWMS_STAGEDIR/utility

sqlplus rwms13dev/********

@inv_obj_comp.sql

升级到1302:

cd $RWMS_STAGEDIR/rib_objects/db_objects/1302

sqlplus rwms13dev/********

Sql>@InstallAndCompileAllRibOracleObjects.sql

cd $RWMS_STAGEDIR/types/1302

sqlplus rwms13dev/********

Sql>@patch1302types.sql

cd $RWMS_STAGEDIR/dbcs/1302

sqlplus rwms13dev/********

Sql>@patch1302dbcs.sql

cd $RWMS_STAGEDIR/db_objects/1302

sqlplus rwms13dev/********

Sql>@patch1302rwms.sql

cd $RWMS_STAGEDIR/utility

sqlplus rwms13dev/********

@inv_obj_comp.sql

cd $RWMS_STAGEDIR/data/1302

sqlplus rwms13dev/********

Sql>@base_reports_parameters.sql

Sql>@I18N_main_script.sql

升级到13.1

cd $RWMS_STAGEDIR/rib_objects/db_objects/131

sqlplus rwms13dev/********

Sql>@InstallAndCompileAllRibOracleObjects.sql

cd $RWMS_STAGEDIR/types/131

sqlplus rwms13dev/********

Sql>@patch131types.sql

cd $RWMS_STAGEDIR/dbcs/131

sqlplus rwms13dev/********

Sql>@patch131dbcs.sql

cd $RWMS_STAGEDIR/triggers/131

sqlplus rwms13dev/********

Sql>@patch131trg.sql

cd $RWMS_STAGEDIR/db_objects/131

sqlplus rwms13dev/********

Sql>@patch131rwms.sql

cd $RWMS_STAGEDIR/utility

sqlplus rwms13dev/********

@inv_obj_comp.sql

cd $RWMS_STAGEDIR/data/131

sqlplus rwms13dev/********

Sql>

@base_copyright_info.sql

@base_currency.sql

@base_item_master.sql

@13.1_main_script.sql

————————————————————————————-

6.2) RWMS APP 安装

6.2.1 准备环境变量:

设置环境变量:

su – oracle

INSTALL_DIR=/d01/app/retail_apps

Export INSTALL_DIR

cd $INSTALL_DIR

cp -R /d01/stage/retail/rwms/appserverunix/* .

cd $INSTALL_DIR/rwms

cp -R $INSTALL_DIR/forms_scripts $INSTALL_DIR/rwms/

rm -fR $INSTALL_DIR/forms_scripts

ORACLE_HOME=/d01/app/oracle/OraHome_1

PATH=$ORACLE_HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/dcm/bin:$INSTALL_DIR/rwms/forms_scripts:$PATH

export ORACLE_HOME PATH

ORACLE_SID=rwms

export ORACLE_SID

NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_LANG

CLASSPATH=$ORACLE_HOME/jlib/importer:$ORACLE_HOME/jlib/debugger.jar:$ORACLE_HOME/jlib/utj.jar:$ORACLE_HOME/jlib/ewt3.jar:$ORACLE_HOME/jlib/share.jar:$ORACLE_HOME/jlib/dfc.jar:$ORACLE_HOME/jlib/help4.jar:$ORACLE_HOME/jlib/oracle_ice.jar:$ORACLE_HOME/jlib/jewt4.jar

export CLASSPATH

FORMS_BUILDER_CLASSPATH=$CLASSPATH

FORMS_PATH=$INSTALL_DIR/rwms/forms/bin:$ORACLE_HOME/forms

REPORTS_PATH=$INSTALL_DIR/rwms/reports/bin:$ORACLE_HOME/forms

TK_UNKNOWN=$ORACLE_HOME/guicommon/tk/admin

UP=rwms13dev/********@rwms

export FORMS_BUILDER_CLASSPATH FORMS_PATH TK_UNKNOWN UP

在tnsnames.ora中添加rwms

允许xserver链接

su – root

xhost +

确认数据库已经启动

编译pll:

cp $INSTALL_DIR/rwms/forms/src/*.pll $INSTALL_DIR/rwms/forms/bin/

cd $INSTALL_DIR/rwms/forms/bin/

forms.pll.sh

cp $INSTALL_DIR/rwms/forms/src/*.fmb $INSTALL_DIR/rwms/forms/bin/

cd $INSTALL_DIR/rwms/forms/bin/

forms.fmb.sh

cp $INSTALL_DIR/rwms/forms/src/*.mmb $INSTALL_DIR/rwms/forms/bin/

cd $INSTALL_DIR/rwms/forms/bin/

menus.mmb.sh

rm -f *.mmb

cp $INSTALL_DIR/rwms/reports/bin/label.prt $INSTALL_DIR/rwms/extras/

安装帮助:

启动ias,创建一个oc4j实例:rwms_help_instance,把rwms-help.war部署上去。

启动FormServer

$ORACLE_HOME/opmn/bin/opmnctl startall

$ORACLE_HOME/bin/emctl start iasconsole

为RWMS配置AppServer:

cp $ORACLE_HOME/forms/admin/resource/US/fmrweb.res $ORACLE_HOME/forms/server/rwms_key_mapping.res

vi $ORACLE_HOME/forms/server/rwms_key_mapping.res (把ig中的键盘映射内容拷贝进去)

9 : 0 : "Tab" : 1 : "Next Field"

9 : 1 : "Shift+Tab" : 2 : "Previous Field"

85 : 2 : "Ctrl+U" : 3 : "Clear Field"

38 : 0 : "Up" : 6 : "Up"

80 : 2 : "Ctrl+P" : 6 : "Up"

40 : 0 : "Down" : 7 : "Down"

76 : 2 : "Ctrl+L" : 7 : "Down"

33 : 0 : "PageUp" : 12 : "Scroll Up"

34 : 0 : "PageDown" : 13 : "Scroll Down"

69 : 2 : "Ctrl+E" : 22 : "Edit"

10 : 0 : "Return" : 27 : "Return"

81 : 2 : "Ctrl+Q" : 32 : "Exit"

112 : 2 : "Ctrl+k" : 35 : "Show Keys"

49 : 2 : "Ctrl+1" : 83 : "F1"

50 : 2 : "Crtl+2" : 84 : "F2"

51 : 2 : "Ctrl+3" : 85 : "F3"

52 : 2 : "Ctrl+4" : 86 : "F4"

53 : 2 : "Ctrl+5" : 87 : "F5"

54 : 2 : "Ctrl+6" : 88 : "F6"

55 : 2 : "Ctrl+7" : 89 : "F7"

56 : 2 : "Ctrl+8" : 90 : "F8"

57 : 2 : "Ctrl+9" : 91 : "F9"

27 : 0 : "Esc" : 82 : "F10"

86 : 1 : "Shift+V" : 29 : "List of Values"

cp $ORACLE_HOME/Apache/Apache/conf/httpd.conf $ORACLE_HOME/Apache/Apache/conf/httpd.conf.bak_bf_rwms

mkdir /d01/app/retail_apps/rwms/temp

mkdir /d01/app/retail_apps/rwms/reptemp

mkdir /d01/app/retail_apps/rwms/web_html

vi $ORACLE_HOME/Apache/Apache/conf/httpd.conf

添加内容:

Listen 7878

<VirtualHost *:7878>

ServerName retek13.hand-china.com

ServerAlias retek13.hand-china.com.*

DocumentRoot "/d01/app/oracle/OraHome_1/Apache/Apache/htdocs"

Alias /web_html/ "/d01/app/retail_apps/rwms/web_html/"

Alias /web_gif/ "/d01/app/retail_apps/rwms/web_gif/"

Alias /temp/ "/d01/app/retail_apps/rwms/temp/"

Alias /rwms_reptemp/ "/d01/app/retail_apps/rwms/reptemp/"

Alias /rf_launch_value/ "/d01/app/retail_apps/rwms/rf_launch/"

</VirtualHost>

编辑env文件:

cp $ORACLE_HOME/forms/server/default.env $ORACLE_HOME/forms/server/rwms.env

vi $ORACLE_HOME/forms/server/rwms.env

添加:

FORMS_PATH=/d01/app/retail_apps/rwms/forms/bin:$ORACLE_HOME/forms

ORACLE_RWMS_REPORTS_HOST=http://retek13.hand-china.com:7878/

ORACLE_RWMS_RWSERVER=reports/rwservlet

ORACLE_RWMS_REPORTS_SERVER=rwms_reports_server+envid=rwms

REPORTS_TEMP=/d01/app/retail_apps/rwms/reptemp

REPORTS_PATH=/d01/app/retail_apps/rwms/reports/bin:$ORACLE_HOME/forms

ORACLE_RWMS_EXTRAS_PATH=/d01/app/retail_apps/rwms/extras

NLS_DATE_FORMAT=DD-MON-RR

NLS_LANG=AMERICAN_AMERICA.UTF8

FORMS_REJECT_GO_DISABLED_ITEM=FALSE

备注:<report_server>究竟该填写什么,ig中讲得不清楚。

配置formsweb.cfg …尚未开始。

添加

[rwms]

envfile=rwms.env

width=950

height=685

form=logon_scr.fmx

separateFrame=true

lookAndFeel=Oracle

colorScheme=swan

userid=rwms13dev/********@rwms

baseHTMLjinitiator=basejpi.htm

jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html

jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA

jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06

jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06

[rwms_hh]

envfile=rwms.env

width=100%

height=100%

form=hh_intro_s.fmx

separateFrame=false

lookAndFeel=Oracle

colorScheme=swan

Logo=false

background=false

ShowMenuBar=false

ShowStatusBar=false

baseHTML=base.htm

baseHTMLjinitiator=basejpi.htm

jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html

jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA

jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06

jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06

otherparams=term=/d01/app/oracle/OraHome_1/forms/server/key_mapping.res usesdi=YES

splashScreen=false

HTMLbodyAttrs=scroll=”no” topmargin=”0”leftmargin=”0” marginheight=”0” marginwidth=”0”onload=”window.moveTo(0,0);”

userid=rwms13dev/********@rwms

[rwms_tm]

envfile=rwms.env

width=100%

height=100%

form=tm_intro_s.fmx

separateFrame=false

lookAndFeel=Oracle

Logo=false

background=false

ShowMenuBar=false

ShowStatusBar=false

baseHTML=base.htm

baseHTMLjinitiator=basejpi.htm

jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html

jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA

jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06

jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06

otherparams=term=/d01/app/oracle/OraHome_1/forms/server/rwms_key_mapping.res usesdi=YES

splashScreen=false

HTMLbodyAttrs=scroll=”no” topmargin=”0” leftmargin=”0” marginheight=”0” marginwidth=”0” onload=”window.moveTo(0,0);”

userid=rwms13dev/********@rwms

[rwms_wr]

envfile=rwms.env

width=100%

height=100%

form=wr_intro_s.fmx

separateFrame=false

lookAndFeel=Oracle

colorScheme=swan

Logo=false

background=false

ShowMenuBar=false

ShowStatusBar=false

baseHTML=base.htm

baseHTMLjinitiator=basejpi.htm

jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html

jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA

jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06

jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06

otherparams=term=/d01/app/oracle/OraHome_1/forms/server/rwms_key_mapping.res usesdi=YES

splashScreen=false

HTMLbodyAttrs=scroll=”no” topmargin=”0”leftmargin=”0” marginheight=”0” marginwidth=”0”onload=”window.moveTo(0,0);”

userid=rwms13dev/********@rwms

cp $ORACLE_HOME/reports/conf/rep_retek13_oracleas1.conf $ORACLE_HOME/reports/conf/rwms_reports_server.conf

vi $ORACLE_HOME/reports/conf/rwms_reports_server.conf

添加:

<environment id="rwms">

<envVariable name="REPORTS_PATH" value="/d01/app/retail_apps/rwms/reports/bin"/>

<envVariable name="NLS_LANG" value="AMERICAN_AMERICA.UTF8"/>

</environment>

cp $ORACLE_HOME/reports/conf/rwms_reports_server.conf $ORACLE_HOME/forms/server/

vi /d01/app/retail_apps/rwms/rf_launch/rwms_rf_menu.htm

更改值如下:

var hh_device = "http://retek13.hand-china.com:7878/forms/frmservlet?config=rwms_hh";

var tm_device = "http://retek13.hand-china.com:7878/forms/frmservlet?config=rwms_tm";

var wr_device = "http://retek13.hand-china.com:7878/forms/frmservlet?config=rwms_wr";

var exit_script ="http://retek13.hand-china.com:7878/rf_launch_value/close.htm";

重启FormServer:

停止FormServer

$ORACLE_HOME/bin/emctl stop iasconsole

$ORACLE_HOME/opmn/bin/opmnctl stopall

启动FormServer

$ORACLE_HOME/opmn/bin/opmnctl startall

$ORACLE_HOME/bin/emctl start iasconsole

测试:

http://retek13.hand-china.com:7878/forms/frmservlet?config=rwms

clip_image001

IG 中讲的登录用户信息是错误的,通过跟踪session的sql可以知道正确的用户存放于dms_user表中,可以从这张表获取用户信息。

select * from dms_user

clip_image002

———————————————————————————————–

为rwms配置ocm

vi $ORACLE_HOME/retail_inventory/oracle_retail_ARIApp.properties

添加如下两行:

rmsappsvr.retek13.hand-china.com.rwms+RWMS_INSTALL_DATE=2010-12-30 11:38:10

rmsappsvr.retek13.hand-china.com.rwms+RWMS_VERSION=13.1.0

ARI 13.1 Demo 安装日志

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

五、ARI 安装

5.1 DB object 安装

—————————————————————–

创建 Tablespace :

cd /d01/stage/retail/ari/dbserverunix/create_db

vi create_ari_tablespaces.sql

更改数据文件的绝对路径

————————————————————————————-

— Script: create_ari_tablespaces.sql

— Execute as: sysdba

— Note: Before running this script:

— Modify <datafile_path> values.

— Modify datafile storage parameters and sizes as needed

———————————————————————————-

spool create_ari_tablespaces.log

CREATE TABLESPACE ARI_INDEX

DATAFILE ‘/d01/app/oracle/oradata/retl/ari_index01.dbf’ SIZE 500M

AUTOEXTEND ON NEXT 100M MAXSIZE 2000M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT MANUAL

;

CREATE TABLESPACE ARI_DATA

DATAFILE ‘/d01/app/oracle/oradata/retl/ari_data01.dbf’ SIZE 500M

AUTOEXTEND ON NEXT 100M MAXSIZE 2000M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT MANUAL

;

spool off

Exit

—————————————————————————————————————————————–

su – oracle

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

ORACLE_SID=retl

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

NLS_LANG=AMERICAN_AMERICA.UTF8

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH NLS_LANG

sqlplus ‘/as sysdba’

Sql>@create_ari_tablespaces.sql;

创建Schema (密码都设置为********)

cd /d01/stage/retail/ari/dbserverunix/utility

sqlplus ‘/as sysdba’

Sql>@create_master_schema_user.sql;

Schema 输入:ARI131M

Sql>@create_gen_schema_user.sql

Schema 输入: ARI131G

创建database object

cd /d01/stage/retail/ari/dbserverunix/ddl

sqlplus ari131m/********@retl

Sql>@ari13.sql

cd /d01/stage/retail/ari/dbserverunix/db_objects

sqlplus ari131m/********@retl

Sql>@ari13dbo.sql

cd /d01/stage/retail/ari/dbserverunix/utility

sqlplus ari131m/********@retl

Sql>@inv_obj_comp.sql

创建 ARI Data

cd /d01/stage/retail/ari/dbserverunix/data

sqlplus ari131m/********@retl

Sql>@ari13ctl.sql

cd /d01/stage/retail/ari/dbserverunix/data/forms_menu_elements

sqlplus ari131m/********@retl

Sql>@base_form_menu_elements.sql;

创建语言数据

cd /d01/stage/retail/ari/dbserverunix/data/forms_menu_elements

sqlplus ari131m/********@retl

Sql>@base_form_menu_elements_langs_zhs.sql;

Alter ARI Data

cd /d01/stage/retail/ari/interface/MTS_Support

sqlplus ari131m/********@retl

Sql>@mts_realm.sql;

Sql>@mts_parm_type.sql;

SQL>@mts_parm.sql

SQL>@update_group_lookup.sql

Create Generated Schema Synonyms

cd /d01/stage/retail/ari/dbserverunix/utility

sqlplus ari131g/********@retl

Sql>@generated_syns.sql

Create User Synonyms

cd /d01/stage/retail/ari/dbserverunix/utility

sqlplus ari131m/********@retl

Sql>@user_syns.sql

——————————————–

警告:缺少 user_syns.sql 文件 。

5.2 Application Server 层 安装

—————————————————————–

su – oracle

mkdir /d01/app/retail_apps/ari

cd /d01/app/retail_apps/ari

unzip ari131appserver.zip

设置环境变量:

INSTALL_DIR=/d01/app/retail_apps/ari

Export INSTALL_DIR

ORACLE_HOME=/d01/app/oracle/OraHome_1

PATH=$ORACLE_HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/dcm/bin:$INSTALL_DIR/forms10gr2_scripts:$PATH

export ORACLE_HOME PATH

ORACLE_SID=retl

export ORACLE_SID

NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_LANG

CLASSPATH=$ORACLE_HOME/jlib/importer:$ORACLE_HOME/jlib/debugger.jar:$ORACLE_HOME/jlib/utj.jar:$ORACLE_HOME/jlib/ewt3.jar:$ORACLE_HOME/jlib/share.jar:$ORACLE_HOME/jlib/dfc.jar:$ORACLE_HOME/jlib/help4.jar:$ORACLE_HOME/jlib/oracle_ice.jar:$ORACLE_HOME/jlib/jewt4.jar

export CLASSPATH

FORMS_BUILDER_CLASSPATH=$CLASSPATH

FORMS_PATH=$INSTALL_DIR/forms/bin:$INSTALL_DIR/forms/src:$ORACLE_HOME/forms

TK_UNKNOWN=$ORACLE_HOME/guicommon/tk/admin

UP=ari131m/********@retl

export FORMS_BUILDER_CLASSPATH FORMS_PATH TK_UNKNOWN UP

允许xserver链接

su – root

xhost +

启动数据库

另起一个session 启动数据库

编译:

这里注意:不能按照安装文档的说法把文件从src目录拷贝到bin目录,否则会出现错误 FRM-30312: Failed to compile the library. 错误。

原因是frm_cmp.sh 试图从原目录中拷贝fmb文件到当前执行编译命令的目录,冲突了。

cd $INSTALL_DIR/forms/bin/

pll2plx10gr2_ari

rm -f *.plx

cp $INSTALL_DIR/forms/src/*.fmb $INSTALL_DIR/forms/bin/

fmb2fmx10gr2_fm

rm -f fm_*.fmx

Fmb2fmx10gr2

for PROG in `ls *.fmb | grep -v fm_`

do PROGNAME=`echo $PROG`

rm $PROGNAME

done

cp $INSTALL_DIR/forms/src/*.mmb $INSTALL_DIR/forms/bin/

mmb2mmx10gr2

rm -f *.mmb

为ARI配置Appserver:

cp $ORACLE_HOME/forms/server/default.env $ORACLE_HOME/forms/server/ari.env

vi ari.env

添加如下变量:

FORMS_PATH=/d01/app/retail_apps/ari/forms/bin:/d01/app/oracle/OraHome_1/forms

NLS_DATE_FORMAT=DD-MON-RR

FORMS_USERNAME_CASESENSITIVE=1

NLS_LANG=AMERICAN_AMERICA.UTF8

FORMS_USERNAME_CASESENSITIVE=1

FORMS_REJECT_GO_DISABLED_ITEM=FALSE

sqlplus ari131m/********@retl

Sql>Update ari_language set webhelp_server=’http://retek13.hand-china.com:7777′

Vmware host无ip地址时,对guest机器中数据库的访问会变慢;

cd $ORACLE_HOME/forms/server

cp formsweb.cfg formsweb.cfg.bak_before_ari

vi formsweb.cfg 添加:

[ari]

envfile=ari.env

width=850

height=585

separateFrame=true

form=arimstr.fmx

lookAndFeel=Oracle

colorScheme=swan

baseHTMLjinitiator=basejpi.htm

jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html

jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA

jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06

jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06

配置帮助文件:

cp $ORACLE_HOME/Apache/Apache/conf/httpd.conf $ORACLE_HOME/Apache/Apache/conf/httpd.conf.bak_bf_ari

vi $ORACLE_HOME/Apache/Apache/conf/httpd.conf

添加别名:

Alias /english/ “/d01/app/retail_apps/ari/web_html/WebHelp”

运行测试:

启动FormServer

$ORACLE_HOME/opmn/bin/opmnctl startall

$ORACLE_HOME/bin/emctl start iasconsole

测试

http://retek13.hand-china.com:7777/forms/frmservlet?config=ari

clip_image001

clip_image002

为ARI配置OCM:

cd $ORACLE_HOME/retail_inventory

vi oracle_retail_ARIApp.properties

添加如下两行:

rmsappsvr.retek13.hand-china.com.ari13inst1+ARI_INSTALL_DATE=2010-12-28 11:38:10

rmsappsvr.retek13.hand-china.com.ari13inst1+ARI_VERSION=13.1.0

安装Ari导入导出工具:

ariiet131.exe 安装windows客户端上的,可在需要的时候安装。

RETL 13.1 Demo 安装日志

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

四、RETL安装

按照 retl的developer guider安装

su – oracle

准备安装目标目录:

mkdir /d01/app/retail_apps/retl

解压缩安装介质到stage目录后进入Stage目录:

cd /d01/stage/retail/alloc/rfx-13.1

./install.sh

安装过程很简单:

—————————————-

[oracle@retek13 rfx-13.1]$ ./install.sh

Enter directory for RETL software:

—> \c

/d01/app/retail_apps/retl

Is this the correct directory for the install? y or n

RFX_HOME: /d01/app/retail_apps/retl

—> \c

y

Creating install directory in /d01/app/retail_apps/retl …

Copying Library Files…

Copying Sample Files…

Copying Executables…

Copying Config File…

Successful completion of RETL Install

To complete the RETL setup and installation:

1) Place the following in a .kshrc/ .profile to retain setup variables:

RFX_HOME=/d01/app/retail_apps/retl

PATH=/d01/app/retail_apps/retl/bin:$PATH

export RFX_HOME PATH

2) Be sure to verify any additional environment setup as per the "Setup" section

of the Programmers Guide.

3) Verify the installation by running the following command:

$RFX_HOME/bin/verify_retl

——————————————-

执行验证:

$RFX_HOME/bin/verify_retl

报java例外,

Exception in thread "main" java.lang.ClassFormatError: com.retek.retl.base.RETL (unrecognized class file version)

at java.lang.VMClassLoader.defineClass(libgcj.so.7rh)

原因:操作系统自带的java 是1.4版本的,13.1的retl要求1.6的jdk,下载一个:

http://java.sun.com/javase/index.jsp

JAVA_HOME=/d01/jdk1.6.0_23

export JAVA_HOME

RFX_HOME=/d01/app/retail_apps/retl

export RFX_HOME

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

ORACLE_SID=retl

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

NLS_LANG=AMERICAN_AMERICA.UTF8

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH NLS_LANG

再次运行验证

$RFX_HOME/bin/verify_retl

[oracle@retek13 bin]$ $RFX_HOME/bin/verify_retl

Checking RETL Environment…passed!

Checking RETL binary…passed!

Running samples…failed!

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

RETL Installation is faulty! One or more tests failed in the samples directory.\n See /tmp/verifyretl-3558.log for failed tests

If tests have failed due to unexpected reasons, please contact support.

Please correct this problem and run the following line to verify

your installation is correct:

verify_retl

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

More /tmp/verifyretl-3558.log

[oracle@retek13 bin]$ more /tmp/verifyretl-8212.log

[ binop] [ Passed ]!

[ export] [ Passed ]!

[ fieldmod] [ Passed ]!

[ filter] [ **FAILED** ] – 1 failure(s).

[ funnel] [ **FAILED** ] – 1 failure(s).

[ generator] [ Passed ]!

[ import] [ Passed ]!

[ retl-training] [ Passed ]!

[ sort] [ **FAILED** ] – 1 failure(s).

[ verify_db] [ Passed ]!

———————————————

filter 测试失败,进入

cd /d01/app/retail_apps/retl/samples/filter

查看 out3.txt 可知 gsort 可执行文件未找到,这个文件在 /d01/app/retail_apps/retl/bin目录下是个链接,执行同目录下的gsort.Linux, 这个文件不存在; 在RETL的安装文档中讲到 retl的gsort 应链接到linux本身的sort程序,所以还要执行:

rm -f $RFX_HOME/bin/gsort

ln -s /bin/sort $RFX_HOME/bin/gsort

再次测试通过

[oracle@retek13 retl]$ $RFX_HOME/bin/verify_retl

Checking RETL Environment…passed!

Checking RETL binary…passed!

Running samples…/d01/app/retail_apps/retl/samples

passed!

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

WARNING : RETL was not verified with a database. If database support

is required in the future, please run the following:

verify_retl -do

Congratulations! Your RETL environment and installation passed all tests

See the programmer’s guide for more information about how to further test

your database installation (if applicable).

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

Exiting…saving output in /tmp/verifyretl-25217.log

For Oracle的测试也是成功的:

[oracle@retek13 retl]$ $RFX_HOME/bin/verify_retl -do

Checking RETL Environment…found ORACLE environment…passed!

Checking RETL binary…passed!

Running samples…/d01/app/retail_apps/retl/samples

passed!

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

Congratulations! Your RETL environment and installation passed all tests

See the programmer’s guide for more information about how to further test

your database installation (if applicable).

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

Exiting…saving output in /tmp/verifyretl-26003.log

总结:

运行RETL前先设置环境变量:

su – oracle

JAVA_HOME=/d01/jdk1.6.0_23

export JAVA_HOME

RFX_HOME=/d01/app/retail_apps/retl

export RFX_HOME

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

ORACLE_SID=retl

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

NLS_LANG=AMERICAN_AMERICA.UTF8

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH NLS_LANG