IStreamDDS软件安装示例.doc

IStream DDS软件安装示例 IStream DDS软件安装示例详细介绍DDS软件安装的所有步骤九桥软件2010/8/3目录1.一对一安装示例21.1环境介绍21.2源端安装31.3目标端安装121.4源端发启首次同步，以及全同步192.一对二安装示例212.1环境介绍212.2源端安装：212.3目标一端安装：302.4目标端二安装：372.5启动软件，并执行，首次同步和增量同量373.二对一安装示例453.1环境介绍453.2源端一安装463.3源端二安装553.4目标端数据库：643.5源端一发起首次同步，与增量同步：71安装示例说明本文档以DDS 2.13.1版本软件为例子完整的演示了软件一对一，一对二，二对一得配置过程，其中一对一方式可衍生为一对多及多对一和一对一对一，一对二方式可衍生为一对多，二对一方式可衍生为多对一方式。本示例只按步骤说明，具体参数配置的含义请在DDS软件安装详解文档中查询。1. 一对一安装示例此种方式为DDS软件最基本配置方式，可按照此方法，将系统连接为一对多，多对一，一对一对一。优点：每套软件都自成体系，互不影响。缺点：软件需管理的套数增多。当一台主机安装套数较，会增加很多主机不必要的压力。注意：当配置为一对一对一方式同步时，全同步的顺序应该是先同步完第一套，再开始同步第二套，不然对中间主机压力较大。1.1环境介绍源端操作系统版本: Linux readhat AS 4.7 数据库版本: oracle 10.2.1数据库为单机非归档模式目标端操作系统版本: Linux readhat AS 4.7数据库版本:oracle 10.2.1数据库为单机非归档模式符号”-”为解释说明蓝色为可选操作红色为注意操作1.2源端安装1.2.1源端创建操作系统用户（可不创建，使用oracle用户只需修改参数文件）rootlinux158 # id oracleuid=501(oracle) gid=502(oinstall) groups=502(oinstall),501(dba)rootlinux158 # useradd -g oinstall -G dba dds -在操作系统上创建DDS软件管理用户rootlinux158 # passwd dds -创建dds用户密码Changing password for user dds.New UNIX password: BAD PASSWORD: its WAY too shortRetype new UNIX password: passwd: all authentication tokens updated successfully.rootlinux158 # id ddsuid=502(dds) gid=502(oinstall) groups=502(oinstall),501(dba)rootlinux158 # cd /homerootlinux158 home# lsdds miaoyl oraclerootlinux158 home# cp oracle/.bash_profile dds/cp: overwrite dds/.bash_profile? yrootlinux158 home# chown dds:dba dds/.bash_profile rootlinux158 home# su - ddsddslinux158 $ lsddslinux158 $ pwd/home/ddsddslinux158 $ vi .bash_profile -修改dds用户环境变量添加参数$DDS_HOME与DDS_DATA# .bash_profile# Get the aliases and functionsif -f /.bashrc ; then . /.bashrcfi# User specific environment and startup programsunset USERNAMEexport ORACLE_BASE=/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10gexport ORACLE_SID=ora1export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK -使用select * from v$nls_parameters where parameter=NLS_CHARACTERSET; 可查询出数据库具体的字符集export ORA_NLS10=$ORACLE_HOME/nls/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport SHLIB_PATH=$ORACLE_HOME/libexport DDS_HOME=/home/dds/dds/binexport DDS_DATA=/home/dds/dds/dsexport PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$DDS_DATA:$DDS_HOME:.ulimit -c unlimited.bash_profile 22L, 562C written ddslinux158 $ . .bash_profile -使修改过的参数生效1.2.2装软件介质ddslinux158 dds$ cd $DDS_DATAddslinux158 ds$ lsddslinux158 ds$ cd .ddslinux158 dds$ lsdds2.13.5.linux32_2.6.5.tar.bz2 dsdds2.13.5.linux32_2.6.5.tar.bz2 dsddslinux158 dds$ tar -vxjf dds2.13.5.linux32_2.6.5.tar.bz2 -解压软件介质ddslinux158 dds$ddslinux158 dds$ lsbin dds2.13.5.linux32_2.6.5.tar.bz2 dsddslinux158 dds$ cd bin/ddslinux158 bin$ ls -查看软件所有命令crc ddsplus dds_pput ddstail forkrun omerge otabs rid rrput testtab vshmsdds_conf dds_pmerge dds_precvs ddstest hostparam oobj otime rm_dump semget t_qmi vshmtdds_parch dds_pmons dds_precvt dict html.tar oobj_cnt otrack rm_find semput t_repeat vshowdds_pclean dds_pmont dds_ptrack dmptm odmp opriv ounload rm_merge sn.txt t_session_n1dds_pclr dds_pmsgs ddspwd exec_plsql oexp oput ouser rm_show sysparam t_session_nidds_pcomm dds_pmsgt dds_pweb filepart ofile oselect rename_dtf rput testcase.sql unl.txt1.2.3配置生成软件参数与脚本ddslinux158 bin$ dds_conf -运行配置命令按需求生成脚本Which Side do you want to configure: S - Source T - Target O - Target (ODBC) Please Select(Q-QUIT)(DEFAULT:S): s -下面的参数可先不修改直接按回车按默认配置，后续再修改调整参数文件。How many MERGE-Processes Please Select(0-QUIT)(132)(DEFAULT:2): How many COMM-Processes Please Select(0-QUIT)(132)(DEFAULT:2): How many msg.log preserved Please Select(q-QUIT)(050)(DEFAULT:0): 10 -设置日志最大数量pages/pages/menu_s.htmlpages/index_t.htmlpages/warning.mp3pages/menuscript_s.jspages/menu_t.htmlpages/colors.csspages/winIE.csspages/unix.csspages/logo_s.htmlpages/menuscript_t.jspages/min.gifpages/ddstop.htmlpages/sele.jspages/fullscr.htmlpages/interval.htmlpages/ddcleant.htmlpages/index_s.htmlpages/src_interval.htmlpages/diff_objF.htmlpages/ddclean.htmlpages/ddstart.htmlpages/fullscr.html2pages/stylemain.csspages/plus.gifpages/logo_t.htmlpages/live.jspages/mac.cssPlease Input User/Passwd for login into ORACLE DataBase, It must OK when using sqlplus, If RAC, Multi-LoginUserPasswd is separated by :(colon), For Examples: system/manager system/managerrac1:system/abcrac2(DEFAULT:dds1/dds1):dds/dds -设置软件登录oracle的用户，rac要添加所有实例 Please Input Authority String For this System(DEFAULT:dds1/dds1): -软件管理员帐户密码Source ID(q-QUIT)(00)(DEFAULT:0): How many seconds to query change each time(0-QUIT)(00)(DEFAULT:2): Size(MB) of Share Memory (0-QUIT)(2100)(DEFAULT:8): Size(MB) of message log (0-QUIT)(5100)(DEFAULT:100): TCP Port of Source System(0-QUIT)(00)(DEFAULT:8203): -源端软件使用端口号TCP Port of Source Web System(0-QUIT)(00)(DEFAULT:8303): -源堵web监控使用端口号Size(MB) each read(0-QUIT)(510)(DEFAULT:5): Size(KB) each read addtional(q-QUIT)(04096)(DEFAULT:0): Trace SEQUENCE (DEFAULT:1): Trace PROC/FUNC/PACK (DEFAULT:1): Trace VIEW (DEFAULT:1): Trace Privilege (DEFAULT:1): Trace Synonym (DEFAULT:1): Trace Index (DEFAULT:1): Trace Trigger (DEFAULT:1): Is RedoLOG in OCFS (DEFAULT:0): Is DBF in ASM (DEFAULT:0): DDS Name (DEFAULT:source): Size(MB) when ORACLE write redo-log, Oracle will overwrite redo, and thenPTRACK cannot to read redo-log forever: (0-QUIT)(50500)(DEFAULT:50): Size(MB) of DISK SPACE reserved when PTRACK write cache file: (0-QUIT)(32500)(DEFAULT:32): Please Input User List for bi-direction syncing. DDS will not track the Oracle users operations. If there are more than one user, seperate it by , For Examples: dds1 dds1,dds2(DEFAULT:): Additional Log Path (DEFAULT:): -设置归档路径，非归档可不设Config: - $DDS_DATA/config/tgt.cfg -TgtID (0-QUIT)(14)(DEFAULT:1): Target IP : -添加目标端IP，可以后再配置Config: - $DDS_DATA/config/map.cfg -Please edit configure file /home/dds/dds/ds/config/map.cfg1.2.4修改参数文件及脚本ddslinux158 dds$ cp bin/sn.txt ds/config/ -使授权文件生效ddslinux158 dds$ cd ds/ddslinux158 ds$ cd config/ddslinux158 config$ lsgrp.CFG0 map.cfg mapnot.CFG0 setup.sql sn.txt sys.cfg tgt.cfgddslinux158 config$ vi tgt.cfg -目标端信息添加#tgtID NextSendNo NextSaveNo Communication-Param# 1 0 0 TCP 192.168.1.1:8204 1 0 0 TCP 192.168.0.159:8204ddslinux158 config$ vi sys.cfg -源端系统参数详细信息，具体含义请查询安装文档LOGIN dds/ddsSOURCE_ID 0INTERVAL 2SZSHM 8388608COMM_PARAM TCP:192.168.0.158:8203WEB_PORT 8303AuthStr dds/ddsREDO_ARCH 50 (MB)DISK_REMAIN 32 (MB)WEB_REFRESH 600 (Seconds)ALARM_COMM_DELAY 60 (Seconds)ALARM_DIFF_OBJ 10 (Seconds)LEN_LOG_BUF 5242880LEN_LOG_ADD 0Sequence 1Procedure 1View 1Privilege 1Synonym 1Index 1Trigger 1redoINocfs 0dbfInASM 0dml_mode rowidmax_lob_rows 64delete_arch 0#no_tbs tbs1,tbs2LogPath1 /oracle/archszLog 104857600DDS_NAME source# no_user dds/dds2CONFIG1 4ba25ef0CONFIG2 09f6060acb30e19ca8fef13575dbc24b38951dae61600bd2c6a044d19dfcc624ddslinux158 config$ vi map.cfg -修改添加要复制的对象# define the mapping# Fields description# 1. map_id ( must0, if mapidcreate user dds identified by dds；SQL /home/dds/dds/ds/config/setup.sql; -运行安装脚本View created.View created.Database altered.Database altered.Database altered.User created.Role created.Grant succeeded.Grant succeeded.Grant succeeded.Grant succeeded.Grant succeeded.Grant succeededGrant succeeded.Grant succeededUser altered.Table created.SQL !1.2.6启动源端软件ddslinux158 ds$ ddstart -软件启动03181322275.PMONS License valid date is 2009/08/05 - 2012/05/01 (1000 Days)ddslinux158 ds$ vshms p -软件进程检查PID(oracle): PID-PMONS : 4725 Running PID-PMSGS : 4727 Running PID-PRECVS : 4729 Running PID-PTRACK : 4731 Running PID-PCLEAN : 4743 Running PID-PARCH : 4733 Running PID-PMERGE : 4739 Running PID-PMERGE : 4741 Running PID-SENDER : 4735 Running PID-SENDER : 4737 Running ddslinux158 ds$ vshms m -软件复制对象检查Mapping Info(10 mappings, MAX 256): ID TgtID TYPE STATE 1 1 USER STOP hs_bodn 2 1 USER STOP hs_crdt 3 1 USER STOP hs_fund 4 1 USER STOP hs_futures 5 1 USER STOP hs_opfund 6 1 USER STOP hs_secu 7 1 USER STOP hs_secusz 8 1 USER STOP hs_trust 9 1 USER STOP hs_user 10 1 USER STOP hs_his 源端DDS安装完成！=1.3目标端安装 1.3.1目标端建操作系统用户（可不创建，使用oracle用户只需修改参数文件）rootlinux159 # id oracleuid=501(oracle) gid=502(oinstall) groups=502(oinstall),501(dba)rootlinux159 # useradd -g oinstall -G dba ddsrootlinux159 # passwd ddsChanging password for user dds.New UNIX password: BAD PASSWORD: its WAY too shortRetype new UNIX password: passwd: all authentication tokens updated successfully.rootlinux159 # cd /homerootlinux159 home# lsdds miaoyl oraclerootlinux159 home# cp oracle/.bash_profile dds/cp: overwrite dds/.bash_profile? yrootlinux159 home# chown dds:dba dds/.bash_profile rootlinux159 home# su - ddsddslinux159 $ lsddslinux159 $ mkdir -p dds/dtddslinux159 $ vi .bash_profile -添加用户环境变量# .bash_profile# Get the aliases and functionsif -f /.bashrc ; then . /.bashrcfi# User specific environment and startup programsunset USERNAMEexport ORACLE_BASE=/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10gexport ORACLE_SID=ora2export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK -使用select * from v$nls_parameters where parameter=NLS_CHARACTERSET; 可查询出数据库具体的字符集export ORA_NLS10=$ORACLE_HOME/nls/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:.export SHLIB_PATH=$ORACLE_HOME/libexport DDS_HOME=/home/dds/dds/binexport DDS_DATA=/home/dds/dds/dtexport PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$DDS_DATA:$DDS_HOME:.ulimit -c unlimitedddslinux159 $ . .bash_profile 1.3.2安装软件介质ddslinux159 $ cd dds/ddslinux159 dds$ lsdds2.13.5.linux32_2.6.5.tar.bz2 dtddslinux159 dds$ tar -vxjf dds2.13.5.linux32_2.6.5.tar.bz2 ddslinux159 dds$ lsbin dds2.13.5.linux32_2.6.5.tar.bz2 dtddslinux159 dds$ ddslinux159 dds$ cd bin/ddslinux159 bin$ lscrc ddsplus dds_pput ddstail forkrun omerge otabs rid rrput testtab vshmsdds_conf dds_pmerge dds_precvs ddstest hostparam oobj otime rm_dump semget t_qmi vshmtdds_parch dds_pmons dds_precvt dict html.tar oobj_cnt otrack rm_find semput t_repeat vshowdds_pclean dds_pmont dds_ptrack dmptm odmp opriv ounload rm_merge sn.txt t_session_n1dds_pclr dds_pmsgs ddspwd exec_plsql oexp oput ouser rm_show sysparam t_session_nidds_pcomm dds_pmsgt dds_pweb filepart ofile oselect rename_dtf rput testcase.sql unl.txt1.3.3配置生产软件参数与脚本ddslinux159 bin$ dds_conf Which Side do you want to configure: S - Source T - Target O - Target (ODBC) Please Select(Q-QUIT)(DEFAULT:S): t -下面的参数可先不修改直接按回车按默认配置，后续再修改调整参数文件。How many Proc PPUT Please Select(0-QUIT)(132)(DEFAULT:1): How many Proc PPUT-H Please Select(0-QUIT)(132)(DEFAULT:3): How many Proc PPUT-V Please Select(0-QUIT)(116)(DEFAULT:3): How many msg.log preserved Please Select(q-QUIT)(050)(DEFAULT:0): 10 -日志最大数量pages/pages/menu_s.htmlpages/index_t.htmlpages/warning.mp3pages/menuscript_s.jspages/menu_t.htmlpages/colors.csspages/winIE.csspages/unix.csspages/logo_s.htmlpages/menuscript_t.jspages/min.gifpages/ddstop.htmlpages/sele.jspages/fullscr.htmlpages/interval.htmlpages/ddcleant.htmlpages/index_s.htmlpages/src_interval.htmlpages/diff_objF.htmlpages/ddclean.htmlpages/ddstart.htmlpages/fullscr.html2pages/stylemain.csspages/plus.gifpages/logo_t.htmlpages/live.jspages/mac.cssPlease Input User/Passwd for login into ORACLE DataBase, It must OK when using sqlplus, If RAC, Multi-LoginUserPasswd is separated by :(colon), For Examples: system/manager system/managerrac1:system/abcrac2(DEFAULT:dds2/dds2): dds/dds -软件登录数据库用户How many Source-DDS?(0-QUIT)(1256)(DEFAULT:1): Please Input Authority String For this System(DEFAULT:dds2/dds2): -软件管理员帐户密码Please Source System IP-Address or HostNAme (DEFAULT:): Source DDS Comm PORT (0-QUIT)(00)(DEFAULT:8203): How many table reserve (0-QUIT)(10300)(DEFAULT:50): How many BLKs cache in RM (0-QUIT)(10200)(DEFAULT:128): Seconds Delay load (00)(DEFAULT:0): Size(MB) of message log (0-QUIT)(5100)(DEFAULT:100): TCP Port of Target System (0-QUIT)(00)(DEFAULT:8204): DDS WEB PORT (0-QUIT)(00)(DEFAULT:8304): DDS Name (DEFAULT:target): SOURCE WEB PORT (0-QUIT)(00)(DEFAULT:8303): Is DBF in ASM (DEFAULT:0): Backup Loaded DTF File (0-QUIT)(024)(DEFAULT:5): Diff Edndian in 2 side (DEFAULT:0): Size(MB) of DISK SPACE reserved when Communication-Receiver write cache file: (0-QUIT)(321024)(DEFAULT:512): Config: - $DDS_DATA/config/tgt_map.cfg -Source USER(DEFAULT:): Config: -