首页 > RETEK13.1, 零售智能, 默认 > ARI 13.1 Demo 安装日志

ARI 13.1 Demo 安装日志

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

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

五、ARI 安装

5.1 DB object 安装

-----------------------------------------------------------------

创建 Tablespace :

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

vi create_ari_tablespaces.sql

更改数据文件的绝对路径

-------------------------------------------------------------------------------------

--- Script: create_ari_tablespaces.sql

--- Execute as: sysdba

--- Note: Before running this script:

--- Modify <datafile_path> values.

--- Modify datafile storage parameters and sizes as needed

----------------------------------------------------------------------------------

spool create_ari_tablespaces.log

CREATE TABLESPACE ARI_INDEX

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

AUTOEXTEND ON NEXT 100M MAXSIZE 2000M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT MANUAL

;

CREATE TABLESPACE ARI_DATA

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

AUTOEXTEND ON NEXT 100M MAXSIZE 2000M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT MANUAL

;

spool off

Exit

-----------------------------------------------------------------------------------------------------------------------------------------

su - oracle

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

ORACLE_SID=retl

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

NLS_LANG=AMERICAN_AMERICA.UTF8

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH NLS_LANG

sqlplus '/as sysdba'

Sql>@create_ari_tablespaces.sql;

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

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

sqlplus '/as sysdba'

Sql>@create_master_schema_user.sql;

Schema 输入:ARI131M

Sql>@create_gen_schema_user.sql

Schema 输入: ARI131G

创建database object

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

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

Sql>@ari13.sql

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

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

Sql>@ari13dbo.sql

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

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

Sql>@inv_obj_comp.sql

创建 ARI Data

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

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

Sql>@ari13ctl.sql

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

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

Sql>@base_form_menu_elements.sql;

创建语言数据

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

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

Sql>@base_form_menu_elements_langs_zhs.sql;

Alter ARI Data

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

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

Sql>@mts_realm.sql;

Sql>@mts_parm_type.sql;

SQL>@mts_parm.sql

SQL>@update_group_lookup.sql

Create Generated Schema Synonyms

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

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

Sql>@generated_syns.sql

Create User Synonyms

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

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

Sql>@user_syns.sql

--------------------------------------------

警告:缺少 user_syns.sql 文件 。

5.2 Application Server 层 安装

-----------------------------------------------------------------

su - oracle

mkdir /d01/app/retail_apps/ari

cd /d01/app/retail_apps/ari

unzip ari131appserver.zip

设置环境变量:

INSTALL_DIR=/d01/app/retail_apps/ari

Export INSTALL_DIR

ORACLE_HOME=/d01/app/oracle/OraHome_1

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

export ORACLE_HOME PATH

ORACLE_SID=retl

export ORACLE_SID

NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_LANG

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

export CLASSPATH

FORMS_BUILDER_CLASSPATH=$CLASSPATH

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

TK_UNKNOWN=$ORACLE_HOME/guicommon/tk/admin

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

export FORMS_BUILDER_CLASSPATH FORMS_PATH TK_UNKNOWN UP

允许xserver链接

su - root

xhost +

启动数据库

另起一个session 启动数据库

编译:

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

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

cd $INSTALL_DIR/forms/bin/

pll2plx10gr2_ari

rm -f *.plx

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

fmb2fmx10gr2_fm

rm -f fm_*.fmx

Fmb2fmx10gr2

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

do PROGNAME=`echo $PROG`

rm $PROGNAME

done

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

mmb2mmx10gr2

rm -f *.mmb

为ARI配置Appserver:

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

vi ari.env

添加如下变量:

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

NLS_DATE_FORMAT=DD-MON-RR

FORMS_USERNAME_CASESENSITIVE=1

NLS_LANG=AMERICAN_AMERICA.UTF8

FORMS_USERNAME_CASESENSITIVE=1

FORMS_REJECT_GO_DISABLED_ITEM=FALSE

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

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

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

cd $ORACLE_HOME/forms/server

cp formsweb.cfg formsweb.cfg.bak_before_ari

vi formsweb.cfg 添加:

[ari]

envfile=ari.env

width=850

height=585

separateFrame=true

form=arimstr.fmx

lookAndFeel=Oracle

colorScheme=swan

baseHTMLjinitiator=basejpi.htm

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

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

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

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

配置帮助文件:

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

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

添加别名:

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

运行测试:

启动FormServer

$ORACLE_HOME/opmn/bin/opmnctl startall

$ORACLE_HOME/bin/emctl start iasconsole

测试

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

clip_image001

clip_image002

为ARI配置OCM:

cd $ORACLE_HOME/retail_inventory

vi oracle_retail_ARIApp.properties

添加如下两行:

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

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

安装Ari导入导出工具:

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

 

 

关于作者:

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

 

 

对本文的评价:

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

 

 

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