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

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

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

为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客户端上的，可在需要的时候安装。