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

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

六、RWMS 安装

按照rwms的ig安装

6.1) RWMS DB 安装

6.1.1）创建OFA目录

su – oracle

ORACLE_BASE=/d01/app/oracle

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

ORACLE_SID=rwms

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

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

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

export RWMS_STAGEDIR

NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_LANG

cd $ORACLE_BASE/oradata

mkdir $ORACLE_BASE/oradata/rwms

mkdir $ORACLE_BASE/admin/rwms

mkdir $ORACLE_BASE/admin/rwms/adump

mkdir $ORACLE_BASE/admin/rwms/bdump

mkdir $ORACLE_BASE/admin/rwms/cdump

mkdir $ORACLE_BASE/admin/rwms/udump

mkdir $ORACLE_BASE/admin/rwms/dpdump

mkdir $ORACLE_BASE/admin/rwms/pfile

mkdir $ORACLE_BASE/admin/rwms/arch

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

更改正确的路径和Dbname:

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

vi $RWMS_STAGEDIR/create_db/crdb1.sql

vi $RWMS_STAGEDIR/create_db/crdb2.sql

vi $RWMS_STAGEDIR/create_db/crdb3.sql

vi $RWMS_STAGEDIR/create_db/create_rwms_tablespaces.sql

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

spool xdb_protocol.log

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

spool off

@$ORACLE_HOME/rdbms/admin/utlrp.sql

重新运行可以。

创建Schema:

sqlplus ‘/as sysdba’

create role developer;

create role wms_user;

cd $RWMS_STAGEDIR/utility

sqlplus ‘/as sysdba’

@create_user.sql

@rwms_owner_grants.sql

创建RIB对象

sqlplus ‘/as sysdba’

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "SYSTEM"

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "RETEK_DATA"

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "RETEK_INDEX"

ALTER USER "RWMS13DEV" QUOTA UNLIMITED ON "LOB_DATA"

cd $RWMS_STAGEDIR/rib_objects/ddl

sqlplus rwms13dev/********

@rib13ddl.sql

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

sqlplus ‘/as sysdba’

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

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

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

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

cd $RWMS_STAGEDIR/rib_objects/db_objects/130

sqlplus rwms13dev/********

Sql>@InstallAndCompileAllRibOracleObjects.sql

创建rwms对象：

cd $RWMS_STAGEDIR/types/130

sqlplus rwms13dev/********

@rwms13type.sql

cd $RWMS_STAGEDIR/ddl

sqlplus rwms13dev/********

@rwms13.sql

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

sqlplus ‘/as sysdba’

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

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

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

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

再次运行rwms13.sql

cd $RWMS_STAGEDIR/triggers/130

sqlplus rwms13dev/********

@rwms13trg.sql

cd $RWMS_STAGEDIR/db_objects/130

sqlplus rwms13dev/********

@rwms13dbo.sql

cd $RWMS_STAGEDIR/utility

sqlplus rwms13dev/********

@inv_obj_comp.sql

插入初始化数据：

cd $RWMS_STAGEDIR/data/130

sqlplus rwms13dev/********

@create_base_data.sql

升级到1301:

cd $RWMS_STAGEDIR/dbcs/1301

sqlplus rwms13dev/********

@patch1301dbcs.sql

cd $RWMS_STAGEDIR/db_objects/1301

sqlplus rwms13dev/********

@patch1301rwms.sql

cd $RWMS_STAGEDIR/data/1301

sqlplus rwms13dev/********

@patch1301ctl.sql

cd $RWMS_STAGEDIR/utility

sqlplus rwms13dev/********

@inv_obj_comp.sql

升级到1302：

cd $RWMS_STAGEDIR/rib_objects/db_objects/1302

sqlplus rwms13dev/********

Sql>@InstallAndCompileAllRibOracleObjects.sql

cd $RWMS_STAGEDIR/types/1302

sqlplus rwms13dev/********

Sql>@patch1302types.sql

cd $RWMS_STAGEDIR/dbcs/1302

sqlplus rwms13dev/********

Sql>@patch1302dbcs.sql

cd $RWMS_STAGEDIR/db_objects/1302

sqlplus rwms13dev/********

Sql>@patch1302rwms.sql

cd $RWMS_STAGEDIR/utility

sqlplus rwms13dev/********

@inv_obj_comp.sql

cd $RWMS_STAGEDIR/data/1302

sqlplus rwms13dev/********

Sql>@base_reports_parameters.sql

Sql>@I18N_main_script.sql

升级到13.1

cd $RWMS_STAGEDIR/rib_objects/db_objects/131

sqlplus rwms13dev/********

Sql>@InstallAndCompileAllRibOracleObjects.sql

cd $RWMS_STAGEDIR/types/131

sqlplus rwms13dev/********

Sql>@patch131types.sql

cd $RWMS_STAGEDIR/dbcs/131

sqlplus rwms13dev/********

Sql>@patch131dbcs.sql

cd $RWMS_STAGEDIR/triggers/131

sqlplus rwms13dev/********

Sql>@patch131trg.sql

cd $RWMS_STAGEDIR/db_objects/131

sqlplus rwms13dev/********

Sql>@patch131rwms.sql

cd $RWMS_STAGEDIR/utility

sqlplus rwms13dev/********

@inv_obj_comp.sql

cd $RWMS_STAGEDIR/data/131

sqlplus rwms13dev/********

Sql>

@base_copyright_info.sql

@base_currency.sql

@base_item_master.sql

@13.1_main_script.sql

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

6.2) RWMS APP 安装

6.2.1 准备环境变量：

设置环境变量：

su – oracle

INSTALL_DIR=/d01/app/retail_apps

Export INSTALL_DIR

cd $INSTALL_DIR

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

cd $INSTALL_DIR/rwms

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

rm -fR $INSTALL_DIR/forms_scripts

ORACLE_HOME=/d01/app/oracle/OraHome_1

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

export ORACLE_HOME PATH

ORACLE_SID=rwms

export ORACLE_SID

NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_LANG

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

export CLASSPATH

FORMS_BUILDER_CLASSPATH=$CLASSPATH

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

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

TK_UNKNOWN=$ORACLE_HOME/guicommon/tk/admin

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

export FORMS_BUILDER_CLASSPATH FORMS_PATH TK_UNKNOWN UP

在tnsnames.ora中添加rwms

允许xserver链接

su – root

xhost +

确认数据库已经启动

编译pll：

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

cd $INSTALL_DIR/rwms/forms/bin/

forms.pll.sh

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

cd $INSTALL_DIR/rwms/forms/bin/

forms.fmb.sh

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

cd $INSTALL_DIR/rwms/forms/bin/

menus.mmb.sh

rm -f *.mmb

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

安装帮助：

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

启动FormServer

$ORACLE_HOME/opmn/bin/opmnctl startall

$ORACLE_HOME/bin/emctl start iasconsole

为RWMS配置AppServer:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

mkdir /d01/app/retail_apps/rwms/temp

mkdir /d01/app/retail_apps/rwms/reptemp

mkdir /d01/app/retail_apps/rwms/web_html

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

添加内容：

Listen 7878

<VirtualHost *:7878>

ServerName retek13.hand-china.com

ServerAlias retek13.hand-china.com.*

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

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

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

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

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

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

</VirtualHost>

编辑env文件：

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

vi $ORACLE_HOME/forms/server/rwms.env

添加：

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

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

ORACLE_RWMS_RWSERVER=reports/rwservlet

ORACLE_RWMS_REPORTS_SERVER=rwms_reports_server+envid=rwms

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

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

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

NLS_DATE_FORMAT=DD-MON-RR

NLS_LANG=AMERICAN_AMERICA.UTF8

FORMS_REJECT_GO_DISABLED_ITEM=FALSE

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

配置formsweb.cfg …尚未开始。

添加

[rwms]

envfile=rwms.env

width=950

height=685

form=logon_scr.fmx

separateFrame=true

lookAndFeel=Oracle

colorScheme=swan

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

baseHTMLjinitiator=basejpi.htm

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

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

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

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

[rwms_hh]

envfile=rwms.env

width=100%

height=100%

form=hh_intro_s.fmx

separateFrame=false

lookAndFeel=Oracle

colorScheme=swan

Logo=false

background=false

ShowMenuBar=false

ShowStatusBar=false

baseHTML=base.htm

baseHTMLjinitiator=basejpi.htm

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

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

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

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

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

splashScreen=false

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

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

[rwms_tm]

envfile=rwms.env

width=100%

height=100%

form=tm_intro_s.fmx

separateFrame=false

lookAndFeel=Oracle

Logo=false

background=false

ShowMenuBar=false

ShowStatusBar=false

baseHTML=base.htm

baseHTMLjinitiator=basejpi.htm

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

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

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

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

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

splashScreen=false

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

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

[rwms_wr]

envfile=rwms.env

width=100%

height=100%

form=wr_intro_s.fmx

separateFrame=false

lookAndFeel=Oracle

colorScheme=swan

Logo=false

background=false

ShowMenuBar=false

ShowStatusBar=false

baseHTML=base.htm

baseHTMLjinitiator=basejpi.htm

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

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

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

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

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

splashScreen=false

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

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

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

vi $ORACLE_HOME/reports/conf/rwms_reports_server.conf

添加：

<environment id="rwms">

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

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

</environment>

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

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

更改值如下：

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

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

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

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

重启FormServer:

停止FormServer

$ORACLE_HOME/bin/emctl stop iasconsole

$ORACLE_HOME/opmn/bin/opmnctl stopall

启动FormServer

$ORACLE_HOME/opmn/bin/opmnctl startall

$ORACLE_HOME/bin/emctl start iasconsole

测试：

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

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