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

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

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