Database Software

Hi..I'm trying to set up a replication between Timesten 11gs

However, I'm getting weird error when I executed ttrepadmin.


here are my settings

Hostname : rhel53-x64
[master1]
DataStore=/home/timesten/TimesTen/tt1121/info/master1
Driver=/home/timesten/TimesTen/tt1121/lib/libtten.so
DatabaseCharacterSet=US7ASCII
ConnectionCharacterSet=US7ASCII
UID=terry
PWD=terry

hostname : blue
[master2]
DataStore=/home/js77/TimesTen/tt1121/info/master2
DatabaseCharacterSet=US7ASCII
ConnectionCharacterSet=US7ASCII

and I simply followed the example of replication from document.


-on rhel53-x64

Table Schema
create table tb_test1
(
c1 integer primary key,
c2 char(10),
c3 integer,
c4 char(10),
c5 char(10),
c6 char(10),
c7 char(10),
c8 char(10),
c9 integer,
c10 date );
create index TB_TEST1_IDX on TB_TEST1 (c3 desc, c1 asc);

create active standby pair master1 on "rhel53-x64", master2 on "blue";
call ttrepstart;
call ttrepstateset('active');
call ttrepstateget;

create user terry identified by terry;
grant all to terry;

after I created user terry, I added UID and PWD on DSN


-on blue
I also created user terry as same as rhel53-x64

ttrepadmin -duplicate -verbosity 2 -from master1 -host "rhel53-x64" -uid terry -pwd terry "dsn=master2";

11:49:37 Contacting remote main daemon at 192.168.1.76 port 17302
11:49:37 Contacting the replication agent for MASTER1 ON RHEL53-X64 (192.168.1.76) port 60419
11:49:37 Beginning transfer from MASTER1 ON RHEL53-X64 to MASTER2 ON BLUE
11:49:42 Checkpoint transfer 10 percent complete
11:49:42 Checkpoint transfer 20 percent complete
11:49:42 Checkpoint transfer 100 percent complete
11:49:42 Checkpoint transfer phase complete
11:49:42 Log transfer 100 percent complete
11:49:42 Log transfer phase complete
11:49:43 Transfer complete
11:49:43 Duplicate Operation Ends
TT12020: Failed to connect to data store
TT12020: ** [TimesTen][TimesTen 11.2.1.2.0 ODBC Driver][TimesTen]TT7001: User authentication failed -- file "db.c", lineno 9585, procedure "sbDbConnect" (ODBC Error: S1000; TimesTen Error: 7001) **

could anyone help me?
Thanks~