联系:手机/微信(+86 17813235971) QQ(107644445)
标题:Configuring an active standby pair with one subscriber
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
Step 1: Create the DSNs for the master and the subscriber databases
[master1] DRIVER=/u01/TimesTen/tt1122/lib/libtten.so DataStore=/u01/TimesTen/replicate//master1 DatabaseCharacterSet=ZHS16GBK ConnectionCharacterSet=ZHS16GBK PermSize=64 [master2] DRIVER=/u01/TimesTen/tt1122/lib/libtten.so DataStore=/u01/TimesTen/replicate//master2 DatabaseCharacterSet=ZHS16GBK ConnectionCharacterSet=ZHS16GBK PermSize=64 [subscriber1] DRIVER=/u01/TimesTen/tt1122/lib/libtten.so DataStore=/u01/TimesTen/replicate/subscriber1 DatabaseCharacterSet=ZHS16GBK ConnectionCharacterSet=ZHS16GBK PermSize=64
Step 2: Create a table in one of the master databases
[oracle@xifenfei info]$ ttIsql master1 Copyright (c) 1996-2011, Oracle. All rights reserved. Type ? or "help" for help, type "exit" to quit ttIsql. connect "DSN=master1"; Connection successful: DSN=master1;UID=oracle;DataStore=/u01/TimesTen/replicate//master1;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/u01/TimesTen/tt1122/lib/libtten.so;PermSize=64;TypeMode=0; (Default setting AutoCommit=1) Command> CREATE TABLE tab (a NUMBER NOT NULL, > b CHAR(18), > PRIMARY KEY (a));
Step 3: Define the active standby pair
Command> CREATE ACTIVE STANDBY PAIR master1, master2 > SUBSCRIBER subscriber1;
Step 4: Start the replication agent on a master database
Command> CALL ttRepStart;
Step 5: Set the state of a master database to ‘ACTIVE’
Command> CALL ttRepStateSet('ACTIVE');
Step 6. Create a user on the active database
Command> CREATE USER terry IDENTIFIED BY terry; User created. Command> GRANT admin TO terry;
Step 7: Duplicate the active database to the standby database
[oracle@xifenfei info]$ ttRepAdmin -duplicate -from master1 -host xifenfei -uid terry -pwd terry "dsn=master2"
Step 8: Start the replication agent on the standby database
[oracle@xifenfei info]$ ttIsql master2 Copyright (c) 1996-2011, Oracle. All rights reserved. Type ? or "help" for help, type "exit" to quit ttIsql. connect "DSN=master2"; Connection successful: DSN=master2;UID=oracle;DataStore=/u01/TimesTen/replicate//master2;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/u01/TimesTen/tt1122/lib/libtten.so;PermSize=64;TypeMode=0; (Default setting AutoCommit=1) Command> CALL ttRepStart;
Step 9. Duplicate the standby database to the subscriber
[oracle@xifenfei info]$ ttRepAdmin -duplicate -from master2 -host xifenfei -uid terry -pwd terry "dsn=subscriber1"
Step 10: Start the replication agent on the subscriber
[oracle@xifenfei info]$ ttIsql subscriber1 Copyright (c) 1996-2011, Oracle. All rights reserved. Type ? or "help" for help, type "exit" to quit ttIsql. connect "DSN=subscriber1"; Connection successful: DSN=subscriber1;UID=oracle;DataStore=/u01/TimesTen/replicate/subscriber1;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/u01/TimesTen/tt1122/lib/libtten.so;PermSize=64;TypeMode=0; (Default setting AutoCommit=1) Command> CALL ttRepStart;
Step 11: Insert data into the table on the active database
[oracle@xifenfei info]$ ttIsql master1 Copyright (c) 1996-2011, Oracle. All rights reserved. Type ? or "help" for help, type "exit" to quit ttIsql. connect "DSN=master1"; Connection successful: DSN=master1;UID=oracle;DataStore=/u01/TimesTen/replicate//master1;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/u01/TimesTen/tt1122/lib/libtten.so;PermSize=64;TypeMode=0; (Default setting AutoCommit=1) Command> INSERT INTO tab VALUES (1,'Hello'); 1 row inserted. Command> commit;
Setp 12:Verify that the insert is replicated to master2 and subscriber1
[oracle@xifenfei info]$ ttIsql master2 Copyright (c) 1996-2011, Oracle. All rights reserved. Type ? or "help" for help, type "exit" to quit ttIsql. connect "DSN=master2"; Connection successful: DSN=master2;UID=oracle;DataStore=/u01/TimesTen/replicate//master2;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/u01/TimesTen/tt1122/lib/libtten.so;PermSize=64;TypeMode=0; (Default setting AutoCommit=1) Command> select * from tab; < 1, Hello > 1 row found. Command> exit Disconnecting... Done. [oracle@xifenfei info]$ ttIsql subscriber1 Copyright (c) 1996-2011, Oracle. All rights reserved. Type ? or "help" for help, type "exit" to quit ttIsql. connect "DSN=subscriber1"; Connection successful: DSN=subscriber1;UID=oracle;DataStore=/u01/TimesTen/replicate/subscriber1;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/u01/TimesTen/tt1122/lib/libtten.so;PermSize=64;TypeMode=0; (Default setting AutoCommit=1) Command> select * from tab; < 1, Hello > 1 row found.
你的实验是同步还是异步方式?
是不是服务端没有启动?
11:24:16.35 Err : SRV: 5537: EventID=17| Connect failed for client: 56148AD2A855453 (56148AD2A855453); IP address: 192.168.128.1; Client PID: 596; DSN: quhaizhou; UID: admintest; SQL State: S1000; Error: [TimesTen][TimesTen 11.2.2.2.0 SERVER]Client failover configured but server is not in ACTIVE state
最近遇到这个错误,有解决方法吗?