1、REP15 在 REDHAT6 上的安装配置1、 安装 Replication Server15 开始可以不使用 ASE 数据库用来存放复制服务器的数据库信息，本次安装 Replication Server 采用内置的 ASA 数据库存放数据库信息，所以 ASE 不需要安装在本机上。2、创建 sybase 用户和用户组，默认路径/sybase 3、 用 sybase 用户，解安装包和补丁包。上传 rs157linux8664_64.tgz 和 EBF20683.tgz 到/sybase。sybaseX3850 tar -xvf rs157linux8664_64.tgzsybaseX3850
2、$tar -xvf EBF20683.tgz4、 开始安装 Replication Server。sybaseX3850 rs157linux8664_64$ ./setup.bin sybaseX3850 EBF20683$ ./setup.bin Preparing to install. Extracting the JRE from the installer archive. Unpacking the JRE. Extracting the installation resources from the installer archive. Configuring the inst
3、aller for this systems environment. Launching installer. = Replication Server (created with InstallAnywhere) - Preparing CONSOLE Mode Installation. = Introduction - InstallAnywhere will guide you through the installation of Replication Server 15.7.1 ESD #1. It is strongly recommended that you quit a
4、ll programs before continuing with this installation. Respond to each prompt to proceed to the next step in the installation. If you want to change something on a previous step, type back. You may cancel this installation at any time by typing quit. PRESS TO CONTINUE: = Choose Install Folder - Where
5、 would you like to install? Default Install Folder: /sybase ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT : /sybase INSTALL FOLDER IS: /sybase IS THIS CORRECT? (Y/N): y = Choose Whether to Overwrite Newer Versions - Warning: You have chosen to install into an existing directory. If you proc
6、eed with this installation, any older versions of the products you choose to install that are detected in this directory will be replaced. PRESS TO CONTINUE: = Choose Install Set - Please choose the Install Set to be installed by this installer. -1- Typical 2- Full 3- Customize. ENTER THE NUMBER FOR
7、 THE INSTALL SET, OR PRESS TO ACCEPT THE DEFAULT : 2 = End-user license agreement - 1) Argentina 2) Asia Pacific Region - General 3) Australia 4) Belgium(English) 5) Brazil 6) Canada 7) Denmark 8) Europe,Middle East, and Africa - General 9) France(French) 10) Germany(English) 11) Hong Kong 12) India
8、 13) Italy(Italian) 14) Japan 15) Korea 16) Latin America Countries - Other than Argentina, 17) Malaysia 18) Mexico 19) Netherlands 20) New Zealand 21) Norway 22) Peoples Republic of China(PRC) 23) Singapore 24) South Africa 25) Spain(Spanish) 26) Sweden 27) Switzerland(English) 28) Taiwan 29) Unite
9、d Kingdom 30) United States of America 31) Any Other Locations Please enter the number of the location you are installing. (1-31) (DEFAULT: 1): 22LICENSE AGREEMENT Asia Pacific Region - General 20100701 IMPORTANT NOTICE: Read this License Agreement carefully before using the enclosed Program. You ma
10、y Use the Program in any country in the Asia Pacific region not covered by another license listed on the preceding menu, then you may only Use the Program acquired under this Agreement in the country in the Asia Pacific region to which the Program was delivered by Sybase or from which the Program wa
11、s downloaded by you (provided that it was not downloaded from any country listed in the preceding menu), and only in accordance with the following terms and conditions. IF YOU DO NOT AGREE TO BE BOUND BY THESE TERMS, YOU MAY NOT USE THE PROGRAM. By downloading, installing, or using the Program in an
12、y way, You acknowledge that You have read, understand and agree to the terms of this Agreement. If You do not agree with these terms, present your receipt or other proof of purchase, Press ENTER to read the text Type back and press ENTER to skip the text : back I agree to the terms of the Sybase lic
13、ense for the install location specified. (Y/N): y = Sybase Software Asset Management License - Enter the Replication Server license key(s) or specify the license server where license key(s) were previously deployed. -1- Specify license keys 2- Use previously deployed license server 3- Continue insta
14、llation without a license key Enter one of the options above: 3 = Sybase Software Asset Management Notification - Please configure the Sybase Software Asset Management (SySAM) email alert mechanism. When configured, specified recipients will receive email notifications about SySAM events that may ne
15、ed administrator attention. Do you want to configure email alerts? (Y/N): n = Pre-Installation Summary - Please Review the Following Before Continuing: Product Name: Replication Server Install Folder: /sybase Product Features: Replication Server, Additional Replication Server Language Modules, Open
16、Client, Additional Connectivity Language Modules, SySAM License Utilities, SySAM License Server Disk Space Information (for Installation Target): Required: 479,738,163 bytes Available: 7,624,404,992 bytes PRESS TO CONTINUE: = Ready To Install - InstallAnywhere is now ready to install Replication Ser
17、ver onto your system at the following location: /sybase PRESS TO INSTALL: = Installing. - =|=|=|= -|-|-|- = Start Sample Replication Server - Would you like to start a sample Replication Server? 1- Yes -2- No ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT: = Create Sample RepServer
18、 Directory - Create Sample RepServer Directory ? 1- Yes -2- No ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT: = Installation Complete - Congratulations. Replication Server has been successfully installed to: /sybase To install Data Assurance go to /sybase/rep/da_installer and run
19、setup.bin (Unix) setup.exe (Windows) setupConsole.exe (Windows) PRESS TO EXIT THE INSTALLER: 5、sybaseX3850 $cat SYBASE.sh .bash_profile注销用户重新登录环境变量更新6、增加 rslinux 及 rsagent 主点和备点的服务信息同时需要在主点和备点服务器上增加 rslinux 服务器信息，尽量 3 台上保持一样sybaseX3850 $export LANG=en_USsybaseX3850 $vi inrerfacesASEREMOTEmaster tcp
20、ether 10.6.157.195 5000query tcp ether 10.6.157.195 5000rslinux_ERSSDmaster tcp ether 10.7.112.20 8003query tcp ether 10.7.112.20 8003rslinuxmaster tcp ether 10.7.112.20 8800query tcp ether 10.7.112.20 8800data18master tcp ether 10.173.101.18 5000query tcp ether 10.173.101.18 50007、准备稳定队列设备sybaseX38
21、50 $mkdir partionsybaseX3850 $touch partition/part1.datsybaseX3850 $touch partition/part2.datsybaseX3850 $touch partition/part3.datsybaseX3850 $touch partition/part4.datsybaseX3850 $touch partition/part5.datsybaseX3850 $touch partition/part6.datsybaseX3850 $touch partition/part7.datsybaseX3850 $touc
22、h partition/part8.dat8、开始初始化复制sybaseX3850 $cd /REP-15_5/install/sybaseX3850 $./rs_init输入 2，即选择 Configure a Server Product，按回车继续。输入 1，即选择 Replication Server，按回车继续。输入 1，即选择 Install a new Replication server，按回车继续。输入 1，即选择 Replication Server Information，按回车继续。当此画面上的 5 项信息均为complete 时，安装新的 Replication Se
23、rver 的工作就完成了。输入 1，即选择 Replication Server Name，按回车继续。录入服务器名称，按回车继续。这里输入为 rslinux。按 Ctrl-a 继续。输入 1，将这个 Replication Server 设为 ID Server。输入 4，设置 Replication server SA password 密码，回车继续。按 ctrl-a 继续。此时第 1 项应该显示为 complete。输入 2，即选择 ID Server Information，按回车继续。输入 2，设置 ID Server Password按 ctrl-a 继续。此时第 1、2 项应该
24、显示为 complete。输入 3，即选择 Replication Server System Database，按回车继续。输入 1，即选择 Do you want Replication Server System Database embedded。输入 2，即选择 Embedded Replication Server System Database。输入 1，选择 ERSSD Name，输入 rslinux_ERSSD按 ctrl-a 继续。输入 7，即选择 Primary password，录入密码，按回车继续。输入 9，即选择 Maintenance password，录入密码，
25、按回车继续。按 ctrl-a 继续两次。此时第 1、2、3 项应该显示为 complete。输入 4，即选择 Disk Partition，按回车继续。输入 1，即选择 Disk Partition Path，按回车继续。录入稳定队列的物理路径，按回车继续。这里输入为/sybase/partition/part1.dat 。输入 2，即选择 Logical Identifier For Disk Partition，按回车继续。录入稳定队列的逻辑名，按回车继续。这里输入为 part1。输入 3，即选择 Size of Disk Partition，输入 5000，回车继续。按 ctrl-a 继
26、续。此时第 1、2、3、4 项应该显示为 complete。输入 5，即选择 Remote Site Connections，回车继续。输入 2，即选择 Replication Server password，输入密码，回车继续按 ctrl-a 继续此时第 1、2、3、4、5 项应该显示为 complete。输入 6，即选择 Database Replication Agent，回车继续输入 2，即选择 RS password，输入密码，回车继续按 ctrl-a 继续此时应该所有项目均为 Complete。按 ctrl-a 继续，输入 y，按回车开始创建 Replication Server。
27、9、修改 Replication Server 字符集Replication Server 使用的字符集必须和复制系统中数据库使用的字符集兼容，否则会造成复制失败或其他未知错误。将 Replication Server 服务停止首先修改SYBASE/REP-15_5/install/rslinux.cfg 文件，将 RS_charset 设为 cp936。重新启动 Replication Server 服务即可10、优化isql Ursliunux_prim Prslinux_prim_ps Srslinux_ERSSDrs_configure memory_limit,20000gors_c
28、onfigure smp_enable,ongors_configure num_threads,200gors_configure num_client_connections,50gors_configure sts_cachesize,20000gors_configure sqt_max_cache_size,1024000000gors_configure sts_full_cache_rs_columns,ongors_configure sts_full_cache_rs_objects,ongo11、增加稳定队列isql -Usa -P Srslinuxadd partitio
29、n part2 on /sybase/partitons/part2.dat with size 5000goadd partition part3 on /sybase/partitons/part3.dat with size 5000goadd partition part4 on /sybase/partitons/part4.dat with size 5000goadd partition part5 on /sybase/partitons/part5.dat with size 5000goadd partition part6 on /sybase/partitons/par
30、t6.dat with size 5000goadd partition part7 on /sybase/partitons/part7.dat with size 5000goadd partition part8 on /sybase/partitons/part8.dat with size 5000go11、添加到 ASE 复制数据库的连接，主点和备点的连接都需要，主点多一个允许复制选项（此部分操作需要备点已经创建数据库，可以是空库）sybaseX3850 $./rs_init输入 2，即选择 Configure a Server Product，按回车继续。输入 1，即选择 Rep
31、lication Server，按回车继续。输入 2，即选择 Add a database to the replication system，按回车继续。输入 1，即选择 Replication Server Information，按回车继续。输入 1，即选择 Replication Server Name，录入复制服务器名，按回车继续。这里录入rslinux。按 ctrl-a 继续。输入 2，即选择 RS SA password，录入密码，回车继续按 ctrl-a 继续。输入 2，即选择 Database Information，按回车继续。输入 1，即选择 SQL Server Nam
32、e，录入 ASE 服务器名 data18，按回车继续。输入 3，即选择 SA password，按回车继续。输入 4，即选择 Database Name，录入数据库名 gjjmx12，按回车继续。对于主点数据库，输入 5，即选择 Will the database be replicated，此数据库将被复制，这样Replication 会在此数据库上创建 Rep Agent 线程。输入 7，即选择 Maintenance password，密码一般是 6 Maintenance user 的用户名后面加_ps，按回车继续。按 ctrl-a 继续输入 3，即选择 Database Replic
33、ation Agent，回车继续输入 2，即选择 RS password，录入密码，回车继续按 ctrl-a 两次，输入 y 即可完成数据库的添加。如果复制系统中有多个数据库重复此操作。注意一点，就是备库添加时 Will the database be replicated 不要选择，保持默认为 no 值即可。12、禁用备点触发器复制suspend connection to ASEREMOTE.gjjmx12goalter connection to ASEREMOTE.gjjmx12set dsi_keep_triggers offgoresume connection to ASEREM
34、OTE.gjjmx12go多个库可以参考这个语法进行设置13、备点数据库权限设置登录备点数据库sp_dboption gjjmx12,select into/bulkcopy/pllsort,truegosp_dboption gjjmx12,trunc log on chkpt,truegogrant role sa_role to gjjmx12_maintgo14、设置数据库允许复制登录主点服务器上use gjjmx12gosp_reptostandby gjjmx12, allgosp_config_rep_agent gjjmx12, send warm standby xacts,
35、truegouse cw0001gosp_reptostandby cw0001, allgosp_config_rep_agent cw0001, send warm standby xacts,truego15、备点恢复数据库主点执行use gjjmx2gosp_flushstatsgocheckpointgouse mastergosp_dboption gjjmx12,single user,truegodump database gjjmx12 to “/dump5b/gjjmx12.dump“go通过 ftp 传输备份到备点服务器备点执行 load database gjjmx12
36、 from /sybase/dump/gjjmx12.dumpgoonline database gjjmx12go主点执行use mastergosp_dboption gjjmx12,single user,flasego16、增加复制create database replication definition gjjmx12_SYBASE2_repwith primary at data18.gjjmx12replicate ddlgocreate database replication definition cw0001_SYBASE2_repwith primary at data
37、18.cw0001replicate ddlgo17、复制订阅create subscription gjjmx12_ASEREMOTE_subfor database replication definition gjjmx12_SYBASE2_repwith primary at data18.gjjmx12with replicate at ASEREMOTE.gjjmx12without materializationcreate subscription cw0001_ASEREMOTE_subfor database replication definition cw0001_SY
38、BASE2_repwith primary at data18.cw0001with replicate at ASEREMOTE.cw0001without materialization18、启动复制 agent默认是自动开始复制，最好是手工停止再启动一次主点执行use gjjmx12go停止sp_stop_rep_agent gjjmx12go启动sp_start_rep_agent gjjmx12go19、复制测试登录主点数据库执行create table rep_test(id varchar(2),name varchar)goinsert into rep_test values
39、(1,test1)go备点数据库核对select * from rep_test附录1、启动和停止 rs运行 Replication Server 使用下面的命令：/REP-15_5/install/RUN_rslinux停止 Replication Server 使用下面的命令：isql -Usa -P -Srslinuxshutdown go2、 查看复制系统当前状态。isql -Usa -P Srslinuxadmin healthgo其中 quiesce 为 True 时表示复制系统当前没有进行操作，status 为 healthy 时表示复制系统当前没有关闭或挂起的线程。3、更新 license登录官方网站注册后根据网站提示，生成 license，下载文件，上传到 /SYBASE/SYSAM-2_0/licenses 下即可。查看 license 信息sysadmin lmconfigrepserver permanent 表示过期日期是永久不过期4、默认日志位置/REP-15_5/install/rslinux.log
