关于，sybase Replication Server不同步的问题！

youwei

前辈，为了，测试一个，把复制服务器、主服务器、目的服务器，分别在三个主机上实现复制服务的效果，小弟做了一个这样的环境，
在test1 上安装rep   IP 192.168.0.210
在test2 上安装源数据库 IP 192.168.0.66
在test3 上安装目的数据库 IP 192.168.0.110

复制服务的名为rep1 在test1系统上sql.ini 配置文件里面是这样设置的

[rep1]
master=TCP,192.168.0.210,8888
query=TCP,192.168.0.210,8888
会是这里端口配置引起的呢？

在所有配置好后，当在进行
选中Add a database to the replication system，
在Replication Server information中，参数为：
Replication Server name：rep1
RS SA user：sa，　
RS SA password：
在Database information中，参数为：
SQL Server name：test2
SA user：sa，SA password：
Database name：dbtest2
Will the database be replicated：Yes


在Replication Server information中，参数为：
Replication Server name：rep1
RS SA user：sa，　
RS SA password：
在Database information中，参数为：
SQL Server name：test3
SA user：sa，SA password：
Database name：dbtest3
Will the database be replicated：No
至此，复制服务器的安装基本完成，通过如下的方法可以检测安装是否成功：
1> admin health
2> go
Mode             Quiesce  Status
---------------- -------- --------
NORMAL           TRUE     SUSPECT
1>
status 值为SUSPECT  这种情怳应该是没的成功。。。
我没有管它，继续往下操作。。。
进行了 定义复制和订购。。
最后执行。
1> check subscription test_sub for test_rep with replicate at  test3.dbtest3
2> go
Subscription test_sub is VALID at the replicate.
Subscription test_sub is VALID at the primary.
1>
后，的返回值，好像是成功了。。。
但是测试test表复制是仍不成功。。
下面是复制的日志。。。能否找到问题呢。。。 谢谢！
I. 2010/08/28 15:54:41. 'Replication Server/12.5/P/PC Intel/Windows NT 4.0/1/OPT/Mon Apr 8 13:33:39 PDT 2002'
I. 2010/08/28 15:54:41. 'Confidential property of Sybase, Inc.
(c) Copyright 1992, 2002
Sybase Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use, duplication, or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA.'
I. 2010/08/28 15:54:41. Logging messages in file 'C:\Sybase\REP-12_5\install\rep1.log'.
I. 2010/08/28 15:54:41. Using interfaces file 'C:\Sybase\ini\sql.ini'.
I. 2010/08/28 15:54:41. Server name is 'rep1'.
I. 2010/08/28 15:54:41. SYSAM: Replication Server received a valid 'REP_SERVER' license.
I. 2010/08/28 15:54:41. Reading 'C:\Sybase\REP-12_5\install\rep1.cfg' for configuration information.
I. 2010/08/28 15:54:41. Using the 'cp850' character set.
I. 2010/08/28 15:54:41. Using the 'us_english' language.
I. 2010/08/28 15:54:41. Using the 'binary' sort order.
I. 2010/08/28 15:54:41. Using the 'binary' unicode sort order.
I. 2010/08/28 15:54:41. Using server 'rep1' for an ID Server.
I. 2010/08/28 15:54:41. Using config file password for the ID user.
I. 2010/08/28 15:54:41. Using user 'rep1_id_user' for the ID Server.
I. 2010/08/28 15:54:41. Using config file maintenance password for the RSSD maint user.
I. 2010/08/28 15:54:41. RSSD maintenace user is 'rep1_RSSD_maint'.
I. 2010/08/28 15:54:41. Using config file password for the RSSD primary user.
I. 2010/08/28 15:54:41. RSSD primary user is 'rep1_RSSD_prim'.
I. 2010/08/28 15:54:41. RSSD database is 'rep1_RSSD'.
I. 2010/08/28 15:54:41. RSSD server is 'test1'.
I. 2010/08/28 15:54:41. Reading 'test1.rep1_RSSD..rs_config' for system configuration parameters.
I. 2010/08/28 15:54:41. Value of the 'memory_limit' config parameter is: 20 megabytes.
I. 2010/08/28 15:54:41. Maximum outbound connections allowed: 64.
I. 2010/08/28 15:54:41. System outbound connection fadeout time: '30'.
I. 2010/08/28 15:54:41. System table cache size: 100 rows.
I. 2010/08/28 15:54:41. Maximum number of Open Server threads allowed: 50.
I. 2010/08/28 15:54:41. Maximum number of Open Server mutexes allowed: 128.
I. 2010/08/28 15:54:41. Maximum number of incoming client connections allowed: 30.
I. 2010/08/28 15:54:41. Maximum number of Open Server message queues allowed: 178.
I. 2010/08/28 15:54:41. Maximum number of Open Server messages allowed: 45568.
I. 2010/08/28 15:54:41. Maximum number of stable queues allowed: 32.
I. 2010/08/28 15:54:41. Password encryption option: 0.
I. 2010/08/28 15:54:41. Use SSL service is set to 'off'.
I. 2010/08/28 15:54:41. Default for connection ha_failover is set to 'off',
I. 2010/08/28 15:54:41. Default directory service provider is: 'InterfacesDriver'.
I. 2010/08/28 15:54:41. System configuration complete.
I. 2010/08/28 15:54:41. Server using Open Server version Sybase Server-Library/12.5/P-EBF10092-10091/PC Intel/BUILD125-012/OPT/Wed Feb 27 11:13:05 2002
I. 2010/08/28 15:54:41. Server using Open Client version Sybase Client-Library/12.5/P-EBF10091/PC Intel/BUILD125-012/OPT/Wed Feb 27 11:13:05 2002
W. 2010/08/28 15:54:41. WARNING #13061 GLOBAL RS(GLOBAL RS) - eue(4684)
        Server test1 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
I. 2010/08/28 15:54:41. Server site id is '16777317'.
I. 2010/08/28 15:54:41. Embedded database id is '101'.
I. 2010/08/28 15:54:41. The site version has been set to '1250'.
W. 2010/08/28 15:54:41. WARNING #6131 GLOBAL RS(GLOBAL RS) - (160
        Replication Server has no partitions.
I. 2010/08/28 15:54:41. The DSI thread for database 'test1.rep1_RSSD' is started.
I. 2010/08/28 15:54:41. Replication Server 'rep1' is started.
I. 2010/08/28 15:54:41. SQM starting: 101:0 test1.rep1_RSSD
I. 2010/08/28 15:54:41. Partition 'disk_dev' is added.
I. 2010/08/28 16:04:33. SQM starting: 102:0 test2.dbtest2
I. 2010/08/28 16:04:33. The DSI thread for database 'test2.dbtest2' is started.
I. 2010/08/28 16:04:33. SQM starting: 102:1 test2.dbtest2
I. 2010/08/28 16:04:33. DIST for 'test2.dbtest2' is Starting
I. 2010/08/28 16:05:25. SQM starting: 103:0 test3.dbtest3
I. 2010/08/28 16:05:25. The DSI thread for database 'test3.dbtest3' is started.
I. 2010/08/28 16:13:12. 'Replication Server/12.5/P/PC Intel/Windows NT 4.0/1/OPT/Mon Apr 8 13:33:39 PDT 2002'
I. 2010/08/28 16:13:12. 'Confidential property of Sybase, Inc.
(c) Copyright 1992, 2002
Sybase Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use, duplication, or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA.'
I. 2010/08/28 16:13:12. Logging messages in file 'C:\Sybase\REP-12_5\install\rep1.log '.
I. 2010/08/28 16:13:12. Using interfaces file 'C:\Sybase\ini\sql.ini '.
I. 2010/08/28 16:13:12. Server name is 'rep1'.
I. 2010/08/28 16:13:12. SYSAM: Replication Server received a valid 'REP_SERVER' license.
I. 2010/08/28 16:13:12. Reading 'C:\Sybase\REP-12_5\install\rep1.cfg ' for configuration information.
I. 2010/08/28 16:13:12. Using the 'cp850' character set.
I. 2010/08/28 16:13:12. Using the 'us_english' language.
I. 2010/08/28 16:13:12. Using the 'binary' sort order.
I. 2010/08/28 16:13:12. Using the 'binary' unicode sort order.
I. 2010/08/28 16:13:12. Using server 'rep1' for an ID Server.
I. 2010/08/28 16:13:12. Using config file password for the ID user.
I. 2010/08/28 16:13:12. Using user 'rep1_id_user' for the ID Server.
I. 2010/08/28 16:13:12. Using config file maintenance password for the RSSD maint user.
I. 2010/08/28 16:13:12. RSSD maintenace user is 'rep1_RSSD_maint'.
I. 2010/08/28 16:13:12. Using config file password for the RSSD primary user.
I. 2010/08/28 16:13:12. RSSD primary user is 'rep1_RSSD_prim'.
I. 2010/08/28 16:13:12. RSSD database is 'rep1_RSSD'.
I. 2010/08/28 16:13:12. RSSD server is 'test1'.
I. 2010/08/28 16:13:12. Reading 'test1.rep1_RSSD..rs_config' for system configuration parameters.
I. 2010/08/28 16:13:12. Value of the 'memory_limit' config parameter is: 20 megabytes.
I. 2010/08/28 16:13:12. Maximum outbound connections allowed: 64.
I. 2010/08/28 16:13:12. System outbound connection fadeout time: '30'.
I. 2010/08/28 16:13:12. System table cache size: 100 rows.
I. 2010/08/28 16:13:12. Maximum number of Open Server threads allowed: 50.
I. 2010/08/28 16:13:12. Maximum number of Open Server mutexes allowed: 128.
I. 2010/08/28 16:13:12. Maximum number of incoming client connections allowed: 30.
I. 2010/08/28 16:13:12. Maximum number of Open Server message queues allowed: 178.
I. 2010/08/28 16:13:12. Maximum number of Open Server messages allowed: 45568.
I. 2010/08/28 16:13:12. Maximum number of stable queues allowed: 32.
I. 2010/08/28 16:13:12. Password encryption option: 0.
I. 2010/08/28 16:13:12. Use SSL service is set to 'off'.
I. 2010/08/28 16:13:12. Default for connection ha_failover is set to 'off',
I. 2010/08/28 16:13:12. Default directory service provider is: 'InterfacesDriver'.
I. 2010/08/28 16:13:12. System configuration complete.
I. 2010/08/28 16:13:12. Server using Open Server version Sybase Server-Library/12.5/P-EBF10092-10091/PC Intel/BUILD125-012/OPT/Wed Feb 27 11:13:05 2002
I. 2010/08/28 16:13:12. Server using Open Client version Sybase Client-Library/12.5/P-EBF10091/PC Intel/BUILD125-012/OPT/Wed Feb 27 11:13:05 2002
W. 2010/08/28 16:13:12. WARNING #13061 GLOBAL RS(GLOBAL RS) - eue(4684)
        Server test1 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
I. 2010/08/28 16:13:12. Server site id is '16777317'.
I. 2010/08/28 16:13:12. Embedded database id is '101'.
I. 2010/08/28 16:13:12. The DSI thread for database 'test1.rep1_RSSD' is started.
I. 2010/08/28 16:13:12. The DSI thread for database 'test2.dbtest2' is started.
I. 2010/08/28 16:13:12. The DSI thread for database 'test3.dbtest3' is started.
I. 2010/08/28 16:13:13. Replication Server 'rep1' is started.
I. 2010/08/28 16:13:13. SQM starting: 102:0 test2.dbtest2
I. 2010/08/28 16:13:13. SQM starting: 103:0 test3.dbtest3
I. 2010/08/28 16:13:13. DIST for 'test2.dbtest2' is Starting
I. 2010/08/28 16:13:13. SQM starting: 101:0 test1.rep1_RSSD
I. 2010/08/28 16:13:13. SQM starting: 102:1 test2.dbtest2
W. 2010/08/28 16:13:13. WARNING #13061 DSI(102 test2.dbtest2) - eue(4684)
        Server test2 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
W. 2010/08/28 16:13:13. WARNING #13061 DSI(103 test3.dbtest3) - eue(4684)
        Server test3 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
I. 2010/08/28 16:19:01. REPLICATE Replication Server: Creating subscription <test_sub> for replication definition <test_rep> with replicate at <test3.dbtest3>
I. 2010/08/28 16:19:02. PRIMARY Replication Server: Creating subscription <test_sub> for replication definition <test_rep> with replicate at <test3.dbtest3>
I. 2010/08/28 16:19:03. REPLICATE Replication Server: Created subscription <test_sub> for replication definition <test_rep> with replicate at <test3.dbtest3> without materialization.
I. 2010/08/28 16:19:03. PRIMARY Replication Server: Created subscription <test_sub> for replication definition <test_rep> with replicate at <test3.dbtest3> without materialization.
I. 2010/08/28 16:24:14. Connection to server 'test3' as user 'dbtest3_maint' has been faded out (closed).

youwei

执行检测命令后有下面的提示

小弟不太看的懂

看到，其中“   REP AGENT  Down                 test2.dbtest2”这句，
应该是，test2.dbtest2,复制成员没有激活 会是什么原因呢！
test2 （源系统）和test3（目的系统) 都是用sa登录，密码也是相同的。。。
只是test1（复制系统） 的sa 没有设密码！


C:\Documents and Settings\fdtx>isql -Usa -P -Srep1
1> admin health
2> go
Mode             Quiesce  Status
---------------- -------- --------
NORMAL           TRUE     SUSPECT
1> admin who
2> go
Spid Name       State                Info
---- ---------- -------------------- ----------------------------------------
   20 DSI EXEC   Awaiting Command     101(1) test1.rep1_RSSD
   12 DSI        Awaiting Command     101 test1.rep1_RSSD
    8 SQM        Awaiting Message     101:0 test1.rep1_RSSD
   21 DSI EXEC   Awaiting Command     102(1) test2.dbtest2
   13 DSI        Awaiting Command     102 test2.dbtest2
   16 DIST       Active               102 test2.dbtest2
   19 SQT        Awaiting Wakeup      102:1  DIST test2.dbtest2
   10 SQM        Awaiting Message     102:1 test2.dbtest2
    9 SQM        Awaiting Message     102:0 test2.dbtest2
      REP AGENT  Down                 test2.dbtest2
   22 DSI EXEC   Awaiting Command     103(1) test3.dbtest3
   14 DSI        Awaiting Command     103 test3.dbtest3
   11 SQM        Awaiting Message     103:0 test3.dbtest3
   15 dSUB       Active
    6 dCM        Awaiting Message
    7 dAIO       Awaiting Message
   17 dREC       Active               dREC
   18 dSTATS     Active
   29 USER       Active               sa
    5 dALARM     Awaiting Wakeup
1>

Eisen

在rs_init时，一定要选择Will the database be replicated：Yes  ，
在drop connection后要sysadmin dropdb, data_server, database，将该库以前的登记信息删除掉。