首页 > RETEK13.1, 商品管理, 默认 > RMS 13.1 Demo安装日志

RMS 13.1 Demo安装日志

2010年12月31日 admin 发表评论 阅读评论

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

三、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的安装文件确实漏了一个文件,但其他文件都没有漏;

clip_image001

在我的安装日志中,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

clip_image002

安装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的安装还是要方便很多。

clip_image003

clip_image004

安装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

安装

clip_image005

clip_image006

clip_image007

按Exit 后,自动启动OCM的安装:

clip_image008

clip_image009

安装日志文件在:/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

clip_image010

 

 

关于作者:

昵称:admin
档案信息:商云方 (yunfang.shang@hand-china.com), HAND技术服务中心
联系方式:你可以通过syfvb@hotmail.com联系作者
点击查看admin发表过的所有文章...
本文永久链接: http://blog.retailsolution.cn/archives/2629

 

 

对本文的评价:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

 

 

分类: RETEK13.1, 商品管理, 默认 标签:
  1. 本文目前尚无任何评论.
  1. 本文目前尚无任何 trackbacks 和 pingbacks.
您必须在 登录 后才能发布评论.