Skip to Main Content

timesten 17086 err

852456Jan 7 2016 — edited Jan 18 2016

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Feb 15 2016
Added on Jan 7 2016
3 comments
1,017 views