2010年12月 – Jack.Shang的技术博客

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

配置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>

</logging_properties>

在 <log_handlers> tag 后输入：

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

</log_handler>

在 <logger> tag 后输入：

</logger>

</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层次：

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登录

有内容，正常：

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

安装测试：

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

备注：这个登录用户在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

select * from IM_USER_AUTHORIZATION

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>

$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

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

安装测试：

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

SELECT * FROM ALC_USERS

输入用户名：RETEK

密码：retek

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

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>

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

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

select * from dms_user

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

为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

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

为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

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

RMS 13.1 Demo安装日志

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

三、RMS安装

3.1）RMS DB安装

3.1.1) partition 策略设置：我们这里安装开发环境，不需要（注意正式环境是需要做的）

3.1.2）创建OFA目录

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

cd $ORACLE_BASE/oradata

mkdir $ORACLE_BASE/oradata/retl

mkdir $ORACLE_BASE/admin/retl

mkdir $ORACLE_BASE/admin/retl/adump

mkdir $ORACLE_BASE/admin/retl/bdump

mkdir $ORACLE_BASE/admin/retl/cdump

mkdir $ORACLE_BASE/admin/retl/udump

mkdir $ORACLE_BASE/admin/retl/dpdump

mkdir $ORACLE_BASE/admin/retl/pfile

mkdir $ORACLE_BASE/admin/retl/arch

mkdir $ORACLE_BASE/utlfile

3.3.3) 创建数据库

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

export RMS_STAGEDIR

cp $RMS_STAGEDIR/dbschema/dbscripts_rms/create_db/init111.ora $ORACLE_HOME/dbs/initretl.ora

更改正确的路径和Dbname:

vi $ORACLE_HOME/dbs/initretl.ora

vi $RMS_STAGEDIR/dbschema/dbscripts_rms/create_db/crdb1.utf8.sql

vi $RMS_STAGEDIR/dbschema/dbscripts_rms/create_db/crdb2.sql

vi $RMS_STAGEDIR/dbschema/dbscripts_rms/create_db/crdb3.sql

vi $RMS_STAGEDIR/dbschema/dbscripts_rms/create_db/create_rms_tablespaces.sql

Sqlplus 运行上述脚本

sqlplus ‘/as sysdba’

创建schema: rms13dev

密码：********

创建schema:alloc13dev

密码：********

安装rms schema

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

./runinstall

可能遇到的错误：

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/dbc_scripts中的sql执行是会出错，错误在：

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/error

1、dbc_system_option.err

这个错误是因为要删除某些约束对象不存在而引发的ora错误，因为dbc_system_option.sql中有句话whenerver error exit ;导致退出，实际上此错误可忽略，可把这句话注释掉，再次运行./runinstall ，选择继续模式，而不要选择重新来过的模式。

改正后重新运行，还会再次卡在dbc_system_option.sql ,但看错误log实际已经执行完毕，因此把dbc_system_option.err删除后再次运行./runinstall即可。

2、dbc_deal_head.err

这个错误要根据实际的错误文件提示去解决：

缺类型定义：TABLE_COLUMN_REC

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "TABLE_COLUMN_REC"

定义文件在：/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/table_column_rec.sql

把这个文件单独运行后再继续可以过。

3、dbc_salweek_c_daily.err

缺类型定义：TABLE_CONSTRAINT_REC 和 TABLE_CONSTRAINT_TBL

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "TABLE_CONSTRAINT_REC"

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/table_constraint_rec.sql

把找到的sql 单独执行以下即可：sqlplus rms13dev/********@retl ….

4、dbc_item_master.sql

这个文件得手动这行了，要增加一个字段 CATCH_WEIGHT_TYPE varchar2(1) ，另外把已经成功执行的部分去掉，重复执行DDL语句是过不去的。

手工执行完毕后，把.err文件删除，然后resume

5、dbc_repl_attr_upd_hist.err

表 REPL_ATTR_UPD_HIST 不存在。

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l " REPL_ATTR_UPD_HIST"

表定义在： /d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.0.1/rms/dbcs/0300_repl_attr_upd_hist.sql

6、dbc_tsf_head.err

TABLE_INDEX_TBL 类型定义不存在

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "TABLE_INDEX_TBL"

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/table_index_rec.sql

7、0207_shipment.err

把 0207_shipment.sql中的 whenever sqlerror exit 去掉，把.err 文件删除， resume

把下面2句话去掉,resume

ALTER TABLE SHIPMENT DROP COLUMN BILL_TO_LOC_TYPE

ALTER TABLE SHIPMENT DROP COLUMN MATCH_LOCATION

8、0217_mv_currency_conversion_rates.err

报MV不存在，措施：把这段话注释掉。

–DROP MATERIALIZED VIEW MV_CURRENCY_CONVERSION_RATES;

9、c7636420_form_elements_langs_supvwedt.err

外键约束错误，item=LI_DELIVERY_POLICY 在表form_elements中不存在。

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "LI_DELIVERY_POLICY"

记录在下面的sql中存在：先后手工执行下面3个文件：

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/data/form_menu_elements/supvwedt_fmb.xml.sql

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/control_script/c7636420_form_elements_supvwedt.sql

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/control_script/c7636420_form_elements_langs_supvwedt.sql

单独执行上面的SQL后 resume

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "FINAL_DEST_IND"

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.0.2/rms/data/c7259107_form_elements.sql 中有这个字段的定义，单独执行其中的一条insert语句。

再次resume

10、c7636420_nav_access.err

System_options 表中缺少 INVC_MATCH_IND

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "INVC_MATCH_IND"

Bug: 在/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/dbc_script/dbc_system_options.sql 中已经没有这个字段，但SYSTEM_OPTIONS_SQL.pls这个package中还用这个字段，

CREATE OR REPLACE PACKAGE SYSTEM_OPTIONS_SQL

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "CREATE OR REPLACE PACKAGE SYSTEM_OPTIONS_SQL"

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/db_objects/syoptns.pls 中应用了INVC_MATCH_IND 但

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.0.2/rms/db_objects/syoptns.pls 中已经不再引用 INVC_MATCH_IND

而在13.1 patch中没有syoptns.pls ,在log中看13.0.2已经成功运行，正是怪啊。。。。

手工运行

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.0.2/rms/db_objects/syoptns.pls

Resume

11、c7636420_navigate.err

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "REPLENISHMENT"

外键约束错误，所需的外键内容在： /d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.0.2/rms/data/c7259107_nav_folder_base.sql

综合前面若干错误，可判断13.0.1 和13.0.2 中的脚本未执行。虽然log显示已执行。这是为什么呢？

打开最早的log 可以看到：虽然ant运行了13.0.2 ,但是都未成功，相当于未运行，原因是13.0.2 使用了相对路径，而执行ant的程序不再13.0.2目录下。13.0.1也是这个问题。

SP2-0310: unable to open file "13.0.2/rms/data/c7429959_dba_policies.sql

这实际上是bug , 解决方案：

删除rms13dev,alloc13dev 用户，重新解压缩rms db 安装包，到patch目录下去运行安装程序。

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

@$RMS_STAGEDIR/dbschema/dbscripts_rms/utility/create_user.sql

@$RMS_STAGEDIR/dbschema/dbscripts_rms/allocation/utility/create_user.sql

cd /d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch

/d01/stage/retail/rms/rms/dbschema/install.sh

这个方法不行，依然不通。换方法，直接更改 patch中的

rmsdbstart.sql

reimdbstart.sql

allocdbstart.sql

allocuserdbstart.sql

把相对路径更改为绝对路径。

@@替换成

@@$RMS_STAGEDIR/dbschema/dbscripts_rms/required_patches/mom-dbpatch/

再次运行安装，这次13.0.1, 13.0.2 都安进去了，当然还有部分程序编译有问题。

但如下错误还是出现：

1、dbc_deal_head.err 还是出现了。按老方法改后resume

2、dbc_salweek_c_daily.err

TABLE_CONSTRAINT_REC 类型的定义不存在，按老方法改后resume

3、dbc_tsfhead.err 按老方法改后resume

4、c7636420_form_elements_langs_supvwedt.err

从 /d01/stage/retail/rms/rms/dbschema/dbscripts_rms/data/form_menu_elements/supvwedt_fmb.xml.sql 中找到这句话，单独执行后resume

INSERT INTO form_elements (FM_NAME, block_name, item_name, item_type, sub_item_name, default_label_prompt, default_access_key, base_ind) VALUES (

‘FM_SUPVWEDT’,’B_SUPS’,

‘LI_DELIVERY_POLICY’,’List Item’, ‘NONE’,

‘Delivery Policy’, NULL, ‘Y’

);

5、13.1 patch的rpm/error下面出现错误：

因为还存在无效对象，不让过

select * from user_objects where status !=’VALID’; 有71个无效对象。

5.1 LIKE_ITEM_SQL 缺类型定义 OBJ_TAX_INFO_TBL OBJ_TAX_INFO_REC

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "OBJ_TAX_INFO_TBL"

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l " OBJ_TAX_INFO_REC"

先后运行下面3个sql来创建这两个类型定义：

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/objtaxinfotype.sql

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/objtaxinfotypebody.sql

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/objtaxinfotypetbl.sql

再编译所有无效对象，然后再次查询

select * from user_objects where status !=’VALID’; 有41个无效对象

5.2 RMSAIASUB_SUPPLIER_VALIDATE 缺少类型定义：RIB_SupplierColRef_REC

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "RIB_SupplierColRef_REC"

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/SupplierColRef.sql

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "RIB_SupplierRef_TBL"

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/SupplierColRef.sql

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.0.2/rms/rib/db_objects/SupplierCollectionRef.sql

这些类型定义的sql在运行的时候报"object has been deleted" ,仔细看代码中的内容名称都被加上了双引号，把部分双引号去掉可以编译成功。

5.3 OBJ_CC_COST_EVENT_TBL 定义不存在

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "OBJ_CC_COST_EVENT_TBL"

find /d01/stage/retail/rms/rms -type f -mount |xargs fgrep -l "OBJ_CC_COST_EVENT_REC"

找不到，在google, metalink均找不到。

find /d01/stage/retail -type f -mount |xargs fgrep -l "OBJ_ISCL_SUPP_HIER_CHG_TBL"

find /d01/stage/retail -type f -mount |xargs fgrep -l "OBJ_TEMPL_RELN_EVENT_TBL"

find /d01/stage/retail -type f -mount |xargs fgrep -l "RIB_InvReqItem_REC"

find /d01/stage/retail -type f -mount |xargs fgrep -l OBJ_ELC_COST_EVENT_TBL

这些类型定义不存在，且也找不到在哪里。

OBJ_PP_COST_EVENT_TBL

OBJ_DEAL_PASSTHRU_EVENT_TBL

OBJ_TEMPL_RELN_EVENT_TBL

OBJ_SC_COST_EVENT_TBL

OBJ_ISCL_SUPP_HIER_CHG_TBL

OBJ_ELC_COST_EVENT_TBL

"RIB_ReportLocRef_REC"

"RIB_ReportLocDesc_REC"

"RIB_SupplierColDesc_REC"

这些文件可以在如下目录找到：

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/obj_elc_cost_event.sql

find /d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects -type f -mount |xargs fgrep -l OBJ_ELC_COST_EVENT_TBL

find /d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects -type f -mount |xargs fgrep -l obj_elc_cost_event_tbl

字符串查找区分大小写，按小写找可以找到：

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_invReqitem_REC

找不到，在rms的rib目录下也找不到，从独立的RIB安装包中查找，也找不到

但在。。中有：

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/rib_objects/db_objects/invReqDesc.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l "RIB_InvReqItem_REC"

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_InvReqItem_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/InvReqDesc.sql

都可以找到；是大小写的原因；

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_InvReqItem_REC

CREATE_ORD_TSF_SQL 编译错误:原因引用 RIB_InvReqItem_REC 类型的时候多了一个参数, 实际原因是RIB类型不是13.1最新的，解决方法更新到13.1最新的RIB类型定义。

RMSMFM_STORE 编译错误:原因引用 RIB_StoreDesc_REC 类型的时候多了一个参数,实际原因是RIB类型不是13.1最新的，解决方法更新到13.1最新的RIB类型定义。

find /d01/stage/retail -type f -mount |xargs fgrep -l RMSMFM_STORE

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_ReportLocRef_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/ReportLocRef.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_ExtOfReportLocRef_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/ExtOfReportLocRef.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_ReportLocDesc_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/ReportLocDesc.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_SupplierColDesc_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/SupplierColDesc.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_Addr_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/SupplierDesc.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l item_rec

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/obj_item_tab_rec.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_XItmSupCtyMfrDesc_TBL

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_DeliverySlotDesc_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/DeliverySlotDesc.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_DeliverySlotRef_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/DeliverySlotRef.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_ItemSupCtyMfrDesc_TBL

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/ItemDesc.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_ItemSupCtyMfrRef_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/ItemSupCtyMfrRef.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_XItemSupCtyMfrRef_TBL

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/XItemRef.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_XStoreDesc_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/XStoreDesc.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_ItemLocVirtRepl_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/ItemLocDesc.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_LocPODesc_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/LocPODesc.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_TsfDesc_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/TsfDesc.sql

find /d01/stage/retail -type f -mount |xargs fgrep -l RIB_StoreDesc_REC

/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/StoreDesc.sql

把找到的这些SQL再运行一次，可解决所有的无效对象问题。

上述SQL中，除/ExtOfReportLocRef.sql在/d01/stage/retail/rms/rms/dbschema/dbscripts_rms/required_patches/mom-dbpatch/13.1/rms/objects/InstallAndCompileAllRibOracleObjects.sql中不存在，其他都有，也即Oralcle的安装文件确实漏了一个文件，但其他文件都没有漏；

在我的安装日志中，InstallAndCompileAllRibOracleObjects.sql是现实已经被执行的，但实际上这里面的很多文件未被执行；

下次安装再出现无效对象的话，建议再次运行这个文件即可。

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

总结：无效对象出现的原因都是因为13.1中的package 需要的很多在13.1中新增或者变更的RIB 相关的TYPE定义不一致，原因是13.1中的RIB相关的TYPE定义未执行；但看log是现实已成功执行。所以需要在比较是否安装文件中的安装SQL漏掉了这几个子SQL;

再次执行安装，选择resume方式，安装成功；

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

cd $RMS_STAGEDIR\dbschema

./install.sh

安装rms batch

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

Ig 里面使用oretail用户安装，我这里为简单起见，统一使用oracle用户（前面的application server安装也全部是是使用oracle用户的）

batch属于数据库节点的安装

su – root

Xhost+

su – oracle

cd /d01/stage/retail/rms

unzip rms13batch.zip

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

先把数据库启了：

Lsnrctl start

Sqlplus ‘/as sysdba’

SQL>startup

准备安装目标目录：

mkdir /d01/app/retail_apps

mkdir /d01/app/retail_apps/rms

mkdir /d01/app/retail_apps/rms/batch

安装：

cd $RMS_STAGEDIR/batch

./install.sh

缺少demo_rdbms.mk文件，从另一个服务器相同版本的拷贝一个过来。

安装过程中需要输入一些参数，这些参数从rms schema的安装日志中获取： rms-install-dbschema.201012211630.log

/*************

The RMS database schema has been installed successfully.

The ReIM database tables have been installed in the RMS13DEV@retl RMS schema.

This is the database user that should be used by the ReIM application.

The following values should be used in the Invoice Matching application installer:

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

ReIM/RMS 13 schema: RMS13DEV

RMS 13 schema owner: RMS13DEV

The Allocation database tables have been installed in the RMS13DEV@retl RMS schema.

The following values should be used in the Allocation application installer:

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

Allocation schema: ALLOC13DEV

RMS 13 schema: RMS13DEV

****************/

安装过程比较快，大约7分钟吧，R13比R12的安装还是要方便很多。

安装rms application Server

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

Ig 里面使用oretail用户安装，我这里为简单起见，统一使用oracle用户（前面的application server安装也全部是是使用oracle用户的）

ORACLE_HOME=/d01/app/oracle/OraHome_1

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

export ORACLE_HOME PATH

ORACLE_SID=retl

export ORACLE_SID

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

export RMS_STAGEDIR

NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_LANG

cp $ORACLE_HOME/guicommon/tk/admin/Tk2Motif.rgb $ORACLE_HOME/guicommon/tk/admin/Tk2Motif.rgb_ORIG

vi $ORACLE_HOME/guicommon/tk/admin/Tk2Motif.rgb

更改：

Tk2Motif*fontMapCs: iso8859-2=UTF8

mkdir /d01/app/retail_apps/rms/appserver

vi $ORACLE_HOME/network/admin/tnsnames.ora, 添加：

retl =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = retek13.hand-china.com)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = retl)

)

安装：

cd /d01/stage/retail/rms

unzip rms13application.zip

备注：rms131apppatch.zip中文件没有rms13application.zip 中的文件新

启动FormServer:

$ORACLE_HOME/opmn/bin/opmnctl startall

$ORACLE_HOME/bin/emctl start iasconsole

http://retek13.hand-china.com:1156

登录后，创建一个oc4j instance :rms_help_instance , 创建后把这个实例启动，该instance 默认的管理员是admin, 密码请改成********1

执行安装。。待续。。。

cd $RMS_STAGEDIR/application

./install.sh

安装

按Exit 后，自动启动OCM的安装：

安装日志文件在：/d01/app/retail_apps/rms/appserver/base/log 目录下

PostInstall 的配置：

1）备份

cp /d01/app/oracle/OraHome_1/Apache/Apache/conf/httpd.conf /d01/app/oracle/OraHome_1/Apache/Apache/conf/httpd.conf.ori_bak

cp /d01/app/oracle/OraHome_1/forms/java/oracle/forms/registry/Registry.dat /d01/app/oracle/OraHome_1/forms/java/oracle/forms/registry/Registry.dat_ori_bak

cp /d01/app/oracle/OraHome_1/forms/server/formsweb.cfg /d01/app/oracle/OraHome_1/forms/server/formsweb.cfg_ori_bak

cp /d01/app/oracle/OraHome_1/forms/admin/resource/US/fmrweb.res /d01/app/oracle/OraHome_1/forms/admin/resource/US/fmrweb.res_ori_bak

cp /d01/app/oracle/OraHome_1/forms/admin/resource/US/fmrweb_utf8.res /d01/app/oracle/OraHome_1/forms/admin/resource/US/fmrweb_utf8.res_ori_bak

cd /d01/app/retail_apps/rms/appserver/post

cp -R * /d01/app/oracle/OraHome_1

重启服务：

$ORACLE_HOME/bin/emctl stop iasconsole

$ORACLE_HOME/opmn/bin/opmnctl stopall

$ORACLE_HOME/opmn/bin/opmnctl startall

$ORACLE_HOME/bin/emctl start iasconsole

测试 rms application Server

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

根据 Oracle Retail Merchandising Installation Test Cases For Version 13.0 [ID 559560.1] 提供的testcase进行测试

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

Orecle Retail(Retek) 13.1 Demo TechBase安装日志

下载Oracle Linux 5.5: 必须从www.oracle.com ->Download -> Server 进入，会引导你进入edelivery (直接进edelivery 是没有linux下载入口的）

下载Database 11g 11.1.0.7 : 先从edelivery下载11.1.0.6 ,再去Metalink下载11.1.0.7的patch.

下载Application Server 10.1.2.0.2 Form and Report Service : 从edelivery的Oracle Development Tools 入口进去找

Application Server 10.1.2.3 : Patchset 5983622

下载BI Publiser Server: 从edelivery 的BI 入口进入下载。

RMS 文档： http://download.oracle.com/docs/cd/E12448_01/rms/docset.html

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

一、DB（11.1.0.7）安装：

Stage: OracleRetailR13.1\Datebase11g_X64

1.1）根据 oracle database 11g quick install guider b32285.pdf 进行db 安装 11.1.0.6

备注：如果安装OEL 5.5 那么rpm只要再额外安装sysstat即可。

安装过程中的密码设置：********

数据库管理访问：https://retek13.hand-china.com:1158/em

1.2）根据README.htm 安装 11g Release 1 (11.1.0.7) Patch Set 1 for Linux x86-64

ORACLE_BASE=/d01/app/oracle

ORACLE_SID=orcl

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

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

export export ORACLE_HOME ORACLE_SID PATH

1.3）启停数据库

停止：

su – oracle

设置环境变量

停止dbconsole: $ emctl stop dbconsole (可选)

停止 lsn : $ lsnrctl stop [listener_name]

停止实例（web 界面或者 sqlplus)

启动：

su – oracle

设置环境变量

启动 lsn : $ lsnrctl start [listener_name]

启动dbconsole: $ emctl start dbconsole

启动实例（web 界面或者 sqlplus)

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

二、AS 安装：

Stage: OracleRetailR13.1\OracleAS\

2.1) FormServer & ReportServer 10.1.2.3 安装

2.1.1）根据 B25260-01 中的AS Install Guider 安装10.1.2.0.2 ( B24489-01.zip)

默认情况下，AS 10gR2 不能在OEL5.x上安装，需要打patch ,才能在此平台上安装，参考[ID 564174.1]

DISPLAY=:0.0

export DISPLAY

./runInstaller PREREQ_CONFIG_LOCATION=/d01/stage/OracleAS/formserver/10.1.2.0.2/prereq -paramFile /d01/stage/OracleAS/formserver/10.1.2.0.2/oraparam.ini

中文环境安装有字体问题，切换到英文环境安装：

Ias_admin password : ********1

Form Server 安装成功后的信息：

see the following URL to access the Oracle Enterprise Manager 10g Application Server Control Console :

http://retek13.hand-china.com:1156

The following information is available in:

/d01/app/oracle/OraHome_1/install/setupinfo.txt

Oracle Application Server 10g 10.1.2.0.2 Usernames and Default password information: Please refer to the Oracle Application Server 10g Administrator Guide for more information.

Install Type: Oracle Application Server Forms and Reports Services

Configured Components: Oracle HTTP Server, OracleAS 10g Containers for J2EE, OracleAS 10g Web Cache, OracleAS 10g Reports Services, OracleAS 10g Forms Services

Use the following URL to access the Oracle HTTP Server and the Welcome Page:

http://retek13.hand-china.com:7777

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

Use the following URL to access the Oracle Enterprise Manager Application Server Control:

http://retek13.hand-china.com:1156

Instance Name: rmsappsvr.retek13.hand-china.com

User: ias_admin

Psw:********1

2.1.2）安装 p5983622_10123_LINUX.zip 升级到10.1.2.3 (根据patch的Readme)

ORACLE_HOME=/d01/app/oracle/OraHome_1

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

export ORACLE_HOME PATH

su – oracle

linux32 bash

ORACLE_HOME=/d01/app/oracle/OraHome_1

export ORACLE_HOME

$ORACLE_HOME/bin/emctl stop iasconsole

$ORACLE_HOME/opmn/bin/opmnctl stopall

安装过程中会报错

查log 有如下错误：

— message in installation logs

/usr/bin/ld: skipping incompatible $ORACLE_HOME/lib//libiplsn.a when searching for -liplsn

/usr/bin/ld: skipping incompatible $ORACLE_HOME/lib/libiplsn.a when searching for -liplsn

/usr/bin/ld: cannot find -liplsn

查Metalink没有解决方法，查google有如下解决方法：

原因：env_forms.mk 中有些调用gcc的地方漏加 -m32 参数。

解决方法：

1) Don’t quit current installation

2) Edit $ORACLE_HOME/forms/lib/env_forms.mk

比如这些地方：（在这里列举的不全，请用 /gcc查找修改每一处）

LINK=$(PURECMDS) gcc $(LDFLAGS) $(COMPSOBJS) -m32

SOSD_FORMS_LDSHARED=/usr/bin/gcc -m32 -o $@ -z text -shared

SOSD_FORMS_LDSHARED_SO=/usr/bin/gcc -m32 -o $@ -z muldefs -shared -$(LDPATHFLAG)$(LIBHOME)

cd $ORACLE_HOME/forms/lib

make -f ins_forms.mk install

3) Retry installation

上述错误解决后，安装就正常了。

2.2） Oracle Application Server Oc4j J2ee&Web Server 10gR3 安装

2.2.1）Oracle Application Server 10.1.3.1 安装（soa_linux_x86_101310_disk1.cpio）

10.1.3.1 在OEL 5.x _X86_64上安装也需要更改预安装检查参数，则可以在metalink上找patch[ID 790943.1】提出在OEL 5.x 上能安装SOA 10.1.3.1 。对应的预安装patch 为：p6339508_101310_Linux-x86-64.zip ，按此note安装。

为了不与以前安装的Application Server端口冲突，更改参数：更改 staticports.ini 中的端口参数（从2000开始）

su – oracle

linux32 bash

cd /d01/stage/OracleAS/10.1.3.1

./runInstaller PREREQ_CONFIG_LOCATION=/d01/stage/OracleAS/10.1.3.1/prereq -paramFile /d01/stage/OracleAS/10.1.3.1/oraparam.ini

linux32 bash

cd /d01/stage/OracleAS/10.1.3.0

./runInstaller PREREQ_CONFIG_LOCATION=/d01/stage/OracleAS/10.1.3.0/prereq -paramFile /d01/stage/OracleAS/10.1.3.0/oraparam.ini

备注：如果出现错误提示：

Error in writing to directory /tmp/OraInstall2010-08-30_05-03-38PM. Please ensure that this directory is writable and has atleast 60 MB of disk space. Installation cannot continue.

: Success

无法安装。请检查预安装patch是否正确，有的时候用错了，因为param.ini不匹配，导致文件指向错误，会出现这种错误提示。

先创建3个Schema: ORAWSM,ORABPEL,ORAESB 密码都是********;

As Instance name : retekas2

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

Default Oc4j instance name :home

安装完成后的信息：

Access the Welcome page:

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

Access Oracle Enterprise manager 10g Application Server Contral:

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

停止服务：

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 stopall

2.2.2）Oracle Application Server 10.1.3.4 Patch 安装(ias_linux_x86_101340.zip)

xhost +

su – oracle

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

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

export export ORACLE_HOME ORACLE_SID PATH

cd /d01/stage/OracleAS/Disk1

linux32 bash

./runInstaller

2.3) BI Publisher Server 安装

xhost +

su – oracle

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

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

export export ORACLE_HOME ORACLE_SID PATH

cd /d01/stage/OracleAS/RH_Linux/Oracle_Business_Intelligence_Publisher_Standalone

linux32 bash

./runInstaller

选择 Advanced Install type

安装完成后的信息：

The installation of Oracle BI Publisher 10.1.3.4.1 was successful.

These instructions are located in:

/d01/app/oracle/product/10.1.3.1/BIPHome_1/BI_Publisher_readme.txt

At the end of this installation BI Publisher will be started.

You may access it at the following URL:

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

Username: Administrator

Password: Administrator

启停服务是受OracleAS_2控制的。

我需要更改ip, 从192.168.15.10 -> 192.168.1.10

IP更改完成，服务器重启后，DB,AS均未受影响。很简单！

Oracle Retail （Retek）13.1 产品安装顺序

Enterprise Installation Order (此顺序在Retek各产品的Installtion guide中的最后一章中均有描述)

1. Oracle Retail Merchandising System (RMS), Oracle Retail Trade Management(RTM), Oracle Retail Sales Audit (ReSA) Oracle Retail Service Layer (RSL)

2. Oracle Retail Extract, Transform, Load (RETL)

3. Oracle Retail Active Retail Intelligence (ARI)

4. Oracle Retail Warehouse Management System (RWMS)

5. Oracle Retail Allocation

6. Oracle Retail Invoice Matching (ReIM)

7. Oracle Retail Price Management (RPM)

8. During installation of RPM, you are asked for the RIBforRPM

Note:

provider URL. Since RIB is installed after RPM, make a note of the

URL you enter. If you need to change the RIBforRPM provider URL

after you install RIB, you can do so by editing the jndi_provider.xml

file.

9. Oracle Retail Central Office (ORCO)

10. Oracle Retail Back Office (ORBO) or Back Office with Labels and Tags (ORLAT)

11. Oracle Retail Store Inventory Management (SIM)

12. Oracle Retail Predictive Application Server (RPAS)

13. Oracle Retail Merchandise Financial Planning (MFP)

14. Oracle Retail Size Profile Optimization (SPO)

15. Oracle Retail Assortment Planning (AP)

16. Oracle Retail Item Planning (IP)

17. Oracle Retail Item Planning configured for COE (IPCOE)

18. Oracle Retail Advanced Inventory Planning (AIP)

19. Oracle Retail Integration Bus (RIB)

20. Oracle Retail Point-of-Service (ORPOS)

21. Orace Retail Mobile Point-of-Service (ORMPOS)

22. Oracle Retail Analytics Applications

23. Oracle Retail Data Warehouse (RDW)

24. Oracle Retail Workspace (ORW)

在13.1版本中ReSA,RTM 均包含在RMS中

2010年十二月
一	二	三	四	五	六	日
« 9月				1月 »
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31