MES Install for solaris

keelee

这个系统的安装分两个部分：db，和ap
所以我们现在先讲DB的部分，
由于我们FW要装的是2.51版本的，原厂说最好是installer在Solaris8上，一旦出了问题也比较好debug，那我们就开始吧
第一部分：Installing Oracle9.2
   请参看：http://www.cublog.cn/u/9710/?u=http://www.cublog.cn/u/9710/showart.php?id=66346

在Oracle9.2安装好了之后，还有一个非常关键的步骤，就是创建tablespace:
-- By Oracle Suggestion : datafile size will follow the rule 2048*N MByte
-- NOTE : user must chnage '&CONFIND_TBSP_filename' as physical location and filename
--        ex. '/disk1/Oracle/OraHome1/oradata/ora817/prod/CONFIND_TBSP.dbf'
--
--
-- Default User Tablespace
create tablespace FWREP datafile '/u01/oradata/TEDB01/FWREP_01.dbf' size 4096M;
--
-- Customized Tablespace
create tablespace FWPROD datafile '/u01/oradata/TEDB01/FWPROD_01.dbf' size 4096M;
--
-- Configuration Tables
create tablespace CONFIND_TBSP datafile '/u01/oradata/TEDB01/CONFIND_TBSP_01.dbf' size 4096M;
create tablespace CONFTBL_TBSP datafile '/u01/oradata/TEDB01/CONFTBL_TBSP_01.dbf' size  4096M;      
--
-- EDC/SPC Tables
create tablespace EDCSPCIND_TBSP datafile '/u01/oradata/TEDB01/EDCSPCIND_TBSP_01.dbf' size 4096M;  
create tablespace EDCSPCTBL_TBSP datafile '/u01/oradata/TEDB01/EDCSPCTBL_TBSP_01.dbf' size 4096M;
alter tablespace EDCSPCIND_TBSP add datafile '/u01/oradata/TEDB01/EDCSPCIND_TBSP_02.dbf' size 4096M;
alter tablespace EDCSPCTBL_TBSP add datafile '/u01/oradata/TEDB01/EDCSPCTBL_TBSP_02.dbf' size 4096M;
--
-- EQP Tables
create tablespace EQHSTIND_TBSP datafile '/u01/oradata/TEDB01/EQHSTIND_TBSP_01.dbf' size 4096M;     
create tablespace EQHSTTBL_TBSP datafile '/u01/oradata/TEDB01/EQHSTTBL_TBSP_01.dbf' size 4096M;
alter tablespace EQHSTIND_TBSP add datafile '/u01/oradata/TEDB01/EQHSTIND_TBSP_02.dbf' size 4096M;
alter tablespace EQHSTTBL_TBSP add datafile '/u01/oradata/TEDB01/EQHSTTBL_TBSP_02.dbf' size 4096M;
--
-- WIP Configuration Tables
create tablespace WPCONFIND_TBSP datafile '/u01/oradata/TEDB01/WPCONFIND_TBSP_01.dbf' size 2048M;
create tablespace WPCONFTBL_TBSP datafile '/u01/oradata/TEDB01/WPCONFTBL_TBSP_01.dbf' size 2048M;   
--
-- WIP Transactions Tables
create tablespace WPHSTIND_TBSP datafile '/u01/oradata/TEDB01/WPHSTIND_TBSP_01.dbf' size 4096M;   
alter tablespace WPHSTIND_TBSP add datafile '/u01/oradata/TEDB01/WPHSTIND_TBSP_02.dbf' size 4096M;
-
create tablespace WPHSTIND_TBSP01 datafile '/u01/oradata/TEDB01/WPHSTIND_TBSP01_01.dbf' size 4096M;
alter tablespace WPHSTIND_TBSP01 add datafile '/u01/oradata/TEDB01/WPHSTIND_TBSP01_02.dbf' size 4096M;
--
create tablespace WPHSTIND_TBSP02 datafile '/u01/oradata/TEDB01/WPHSTIND_TBSP02_01.dbf' size 4096M;
alter tablespace WPHSTIND_TBSP02 add datafile '/u01/oradata/TEDB01/WPHSTIND_TBSP02_02.dbf' size 4096M;
--
create tablespace WPHSTIND_TBSP03 datafile '/u01/oradata/TEDB01/WPHSTIND_TBSP03_01.dbf' size 4096M;
alter tablespace WPHSTIND_TBSP03 add datafile '/u01/oradata/TEDB01/WPHSTIND_TBSP03_02.dbf' size 4096M;
--
create tablespace WPHSTTBL_TBSP datafile '/u01/oradata/TEDB01/WPHSTTBL_TBSP_01.dbf' size 4096M;     
alter tablespace WPHSTTBL_TBSP add datafile '/u01/oradata/TEDB01/WPHSTTBL_TBSP_02.dbf' size 4096M;
--
create tablespace WPHSTTBL_TBSP01 datafile '/u01/oradata/TEDB01/WPHSTTBL_TBSP01_01.dbf' size 4096M;
alter tablespace WPHSTTBL_TBSP01 add datafile '/u01/oradata/TEDB01/WPHSTTBL_TBSP01_02.dbf' size 4096M;
--
create tablespace WPHSTTBL_TBSP02 datafile '/u01/oradata/TEDB01/WPHSTTBL_TBSP02_01.dbf' size 4096M;
alter tablespace WPHSTTBL_TBSP02 add datafile '/u01/oradata/TEDB01/WPHSTTBL_TBSP02_02.dbf' size 4096M;
--
create tablespace WPHSTTBL_TBSP03 datafile '/u01/oradata/TEDB01/WPHSTTBL_TBSP03_01.dbf' size 4096M;
alter tablespace WPHSTTBL_TBSP03 add datafile '/u01/oradata/TEDB01/WPHSTTBL_TBSP03_02.dbf' size 4096M;

第二部分：installation Fw（MES　ＡＰ）

1. FW server installation kits

将安装文件ＦＴＰ　 /u03/fw251ap

1.1.1view content of tar file

# tar  tvf  FP251SOL.TAR

1.1.2解压缩软件
# tar xvf FP251SOL.TAR

2. Start Server Installation

a. Fw Server Installation

3. define CELLwork environment

# CELLworks=/export/home/u01/fw251ap;export CELLworks
#
# echo $CELLworks
/u01/fw251ap


4. link FACTORYworks include files and library

# ln -s $CELLworks/FASTech/SDT/include/CELLworks /usr/include
# ln -s $CELLworks/FASTech/SDT/lib/* /usr/lib


5. 设定tcp/udp  port

   dmbxd 5001/tcp
   dmbxd 5001/udp
   
6. start installation

# $CELLworks/FASTech/etc/srr.install

Installing SRR kernel device driver from '/u01/fw251ap'...

--- Using srr5.8-64

The SRR device driver is installed.
The SRR device driver is loaded into the kernel.
Started CELLworks nameserve
Started CELLworks dmbxd
Started CELLworks pcmbxd


-------------------------------------------------------------------------------------------------------
[ Create FW Administration User ]

fwadmin  -      C Shell    - Create Home Directory

check ....

#
# passwd fwadmin
#


#useradd -d /export/home/fwprod -g oinstall  -s /bin/csh -m fwprod

#useradd -d /export/home/aaa -g staff -G colin -s /bin/csh -m aaa


1. configure oracle environment

TEDB01% pg .init_oracle
setenv ORACLE_BASE /export/home/u01/oracle
setenv ORACLE_SID  MESDEV
setenv ORACLE_HOME /export/home/u01/oracle/product/9.2.0
TEDB01%

TEDB01% source .init_oracle

TEDB01% env|grep ORACLE
ORACLE_BASE=/u01/oracle
ORACLE_SID=dbTEDB01
ORACLE_HOME=/u01/oracle/product/9.2.0
TEDB01%

add oracle configuration in .cshrc script

TEDB01% pg .cshrc
# @(#)cshrc 1.11 89/11/29 SMI
umask 022
set path=(/bin /usr/bin /usr/ucb /etc .)
if ( $?prompt ) then
        set history=32
endif

# edit by remaerd       2005.1.19
# initial oracle environment
source ~/.init_oracle
set path = ( $path $ORACLE_HOME/bin )

2. FW application

eidt [ .login ] script
# edit by remaerd,      2005.1.19
# add FWorks Environment
setenv  CELLworks       /export/home/u01/fw251ap
source ~/FwPrepEnv

make changes on FwPrepEnv file

#                   Set default name for the FACTORYworks MBX
setenv FWMBX        fw_mbx_fwadmin
#                   Set default name for the FACTORYworks trace
setenv FWTRACE      fw_trc_fwadmin
#                   Use HOSTNAME and user ID, other options possible ...
setenv FWCLIENT     "$HOSTNAME".`id | tr '(=)' '   ' | awk '{print $2}'`.fwadmin
#

-------------------------------------------------------------------------------------------------------
[ Configure Oracle Database ]

1. check Tablespace

SQL>
SQL> select TABLESPACE_NAME, sum ( BYTES/(1024*1024) ) MB
  2  from dba_free_space group by TABLESPACE_NAME;

SQL>

2. check tablespace location

SQL>
SQL> select FILE_NAME from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
10 rows selected.




3. Create DB User for FW

SQL>
SQL> create user fwadmin identified by fwadmin default tablespace FWORKS temporary tablespace temp;

User created.

SQL>
SQL>
SQL> grant dba, connect, resource to fwadmin;

Grant succeeded.

4. Create FW DB Schema

TEDB01% dbutil -u fwadmin -p fwadmin -s dbTEDB01 -c ALL
dbutil: creating all tables...
dbutil: successfully created tables for ALM, CAR, CAT, EDC, EQP, MDL, OPR, PRP, WIP
TEDB01%

5. initiaalize FW Table data

TEDB01% pwd
/export/home/fwadmin
TEDB01% cd $FWORKS
TEDB01% cd etc
TEDB01% ls *init*
EDCinit.sql  MDLinit.sql  PRPinit.sql  WIPinit.sql
EQPinit.sql  OPRinit.sql  USRinit.sql

6．启动应用
[ Start FW Application Server ]

6.1. start message bus (MBX)

TEDB01% mbx -n $FWMBX &
[1] 4263
TEDB01%
TEDB01%
TEDB01% name_list -c

  Name                                       PID   Class
--------                                    ----- -------
fw_mbx_fwadmin                              04263 mbx

1 Name(s) Registered


6．2. Start FW Servers

TEDB01% FwStartSrv

TEDB01% ps
   PID TTY      TIME CMD
  4456 pts/2    0:00 CATsrv
  4620 pts/2    0:00 PRPsrv
  4371 pts/2    0:00 CELLman
  4263 pts/2    0:00 mbx
  4319 pts/2    0:00 TIMEsrv
  4417 pts/2    0:00 PCMBXsrv
  4497 pts/2    0:00 EQPsrv
  4538 pts/2    0:00 OPRsrv
  4579 pts/2    0:00 MDLsrv
  4661 pts/2    0:01 WIPsrv
TEDB01%

-------------------------------------------------------------------------------------------------------
[ Modeling ]

6.3. setup DISPLAY

TEDB01% setenv DISPLAY 10.51.40.38:0.0

TEDB01% FwStartCli IDE

.......

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

[ Create working environment ]
1. Unix environment

TEDB01% cp /export/home/fwadmin/.cshrc .
TEDB01% cp /export/home/fwadmin/.login .
TEDB01% cp /export/home/fwadmin/.init_oracle .
TEDB01% cp /export/home/fwadmin/FwPrepEnv .

6.4. oracle user schema

$ sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jan 19 13:42:52 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>
SQL>
SQL> connect / as sysdba;
Connected.
SQL>
SQL>
SQL>
SQL> create user remaerd identified by remaerd default tablespace FWORKS temporary tablespace temp;

User created.

SQL> grant connect, resource, dba to remaerd;

Grant succeeded.

SQL>

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






本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/9710/showart_91456.html