hi,all:
1)We create two DSN on timesten database
IP:130.30.10.133
[ocstest2]
Driver=/syn/ocstest2/timesten11/TimesTen/tt1122/lib/libtten.so
DataStore=/syn/ocstest2/ocstest2/ocstest2
logdir=/syn/ocstest2/ocstest2/
DatabaseCharacterSet=ZHS16GBK
MemoryLock=0
SMPOptLevel=1
DurableCommits=0
ExclAccess=0
Connections=512
Isolation=1
LockLevel=0
PermSize=10240
TempSize=1024
ThreadSafe=1
WaitForConnect=0
Authenticate=0
Logging=1
OracleID=ltocs
OraclePWD=ocstest2
UID=ocstest2
PWD=
PassThrough=0
LogPurge=1
ckptFrequency=300
CkptLogVolume=0
LogFlushMethod=1
LogFileSize=64
LogBufMB=1024
PrivateCommands=1
RecoveryThreads=16
LogBufParallelism=8
ReplicationParallelism=8
CacheAwtParallelism=8
IP:130.30.10.132
[ocstest2]
Driver=/public/ocstest2/timesten11/TimesTen/tt1122/lib/libtten.so
DataStore=/public/ocstest2/ocstest2/ocstest2
logdir=/public/ocstest2/ocstest2/
DatabaseCharacterSet=ZHS16GBK
MemoryLock=0
SMPOptLevel=1
DurableCommits=0
ExclAccess=0
Connections=512
Isolation=1
LockLevel=0
PermSize=10240
TempSize=1024
ThreadSafe=1
WaitForConnect=0
Authenticate=0
Logging=1
OracleID=ltocs
OraclePWD=ocstest2
UID=ocstest2
PWD=
PassThrough=0
LogPurge=1
ckptFrequency=300
CkptLogVolume=0
LogFlushMethod=1
LogFileSize=64
LogBufMB=1024
PrivateCommands=1
RecoveryThreads=16
LogBufParallelism=8
ReplicationParallelism=8
CacheAwtParallelism=8
2) create user "ocs" on timesten database
</syn/ocstest2/TimesTen/tt1122/info>$ttisql ocstest2
Copyright (c) 1996, 2015, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "DSN=ocstest2";
Warning 20000: Use of a deprecated feature: Authenticate (ignored)
Connection successful: DSN=ocstest2;UID=ocstest2;DataStore=/syn/ocstest2/ocstest2/ocstest2;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=US7ASCII;LogFileSize=64;WaitForConnect=0;DRIVER=/syn/ocstest2/timesten11/TimesTen/tt1122/lib/libtten.so;OracleId=ltocs;Isolation=1;LogDir=/syn/ocstest2/ocstest2/;PermSize=10240;TempSize=1024;LogFlushMethod=1;Connections=512;CkptFrequency=300;CkptLogVolume=0;PrivateCommands=1;RecoveryThreads=16;TypeMode=0;OracleNetServiceName=ltocs;LogBufMB=1024;LogBufParallelism=8;ReplicationParallelism=8;CacheAwtParallelism=8;
(Default setting AutoCommit=1)
Command> create user ocs identified by ocs;
grant all to ocs;
User created.
Command> grant all to ocs;
3) connect as ocs and create a asynchronous writethrough cache group
/public/ocstest2/timesten11/TimesTen/tt1122/info# ttisql "dsn=ocstest2;uid=ocs;pwd=ocs;oraclepwd=ocs"
Copyright (c) 1996, 2015, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "dsn=ocstest2;uid=ocs;pwd=********";
Warning 20000: Use of a deprecated feature: Authenticate (ignored)
Connection successful: DSN=ocstest2;UID=ocs;DataStore=/public/ocstest2/ocstest2/ocstest2;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=US7ASCII;LogFileSize=64;WaitForConnect=0;DRIVER=/public/ocstest2/timesten11/TimesTen/tt1122/lib/libtten.so;OracleId=ltocs;Isolation=1;LogDir=/public/ocstest2/ocstest2/;PermSize=10240;TempSize=1024;LogFlushMethod=1;Connections=512;CkptFrequency=300;CkptLogVolume=0;PrivateCommands=1;RecoveryThreads=16;TypeMode=0;OracleNetServiceName=ltocs;LogBufMB=1024;LogBufParallelism=8;ReplicationParallelism=8;CacheAwtParallelism=8;
(Default setting AutoCommit=1)
Command> call ttcacheuidpwdset('ocs','ocs');
Command> call ttcachestart;
Command> call ttGridCreate('ocstestGrid');
Command> call ttGridnameSet('ocstestGrid');
Command> create asynchronous writethrough cache group CACHE_T2
> from
> T2 (A NUMBER(38) NOT NULL,
> B CHAR(10 BYTE),
> primary key (A));
Command> refresh cache group CACHE_T2 commit every 8192 rows parallel 8;
3 cache instances affected.
4) create replication between 130.30.10.133 and 130.30.10.132
Command> create replication DATA_SYN
> element R_REP_01 table ocs.t2
> master ocstest2 on "130.30.10.133"
> subscriber ocstest2 on "130.30.10.132"
> element R_REP_02 table ocs.t2
> master ocstest2 on "130.30.10.132"
> subscriber ocstest2 on "130.30.10.133";
17086: ASYNCHRONOUS WRITETHROUGH Cache groups are only permitted with ACTIVE STANDBY PAIR replication schemes.
The command failed.