This discussion is archived
2 Replies Latest reply: Oct 17, 2012 5:09 AM by 957434 RSS

Timesten error: TT8179: Cannot create duplicate store : store already exist

957434 Newbie
Currently Being Moderated
Hi,

When we are trying to replicate the database from master to standby using the below command

ttrepadmin -duplicate -from master1 -host "slc01mux" -keepCG -cacheuid ttorauser -cachepwd timesten -uid ttorauser -pwd timesten master2

got the following error

TT5160: Failed to prepare Oracle objects for datastore duplication: File bdbConn ect.c, Line 4585, (ORA-01017) ORA-01017: invalid username/password; logon denied

Later i created the same user(ttorauser) in the standby node as below

create user ttorauser identified by timesten;
grant admin to ttorauser;

connect "dsn=master2;uid=ttorauser;pwd=timesten;oraclepwd=timesten";
call ttcacheuidpwdset ('ttorauser','timesten');
call ttcachestart;

and now for the same ttrepadmin command i am getting the above mentioned error in the subject.

TT8179: Cannot create duplicate store : store already exists


Thanks in advance.
  • 1. Re: Timesten error: TT8179: Cannot create duplicate store : store already exist
    jspalmer Journeyer
    Currently Being Moderated
    There are a couple of existing Notes on the TT5160 error - Note 1477698.1 and Note 1232594.1.

    From the latter, please refer to:

    "cachepwd has to be the pwd of the oracle user defined for cache administrator in the oracle db."

    From the information you've provided, it looks like -cacheuid is a user with ADMIN privileges in the TimesTen datastore. Are you certain this is the CACHE ADMINISTRATOR user defined in TimesTen and on the Oracle database?

    -cacheuid ttorauser -cachepwd timesten

    A CACHE ADMINISTRATOR user in a TimesTen datastore is not the same as a regular user given ADMIN privileges. Try running

    select * from sys.dba_sys_privs

    to see who it says is the CACHE_MANAGER. I think this is probably the user you need to use for -cacheuid. You should check what Oracle password this user has for the argument to -cachepwd

    The TT8179 wuld be happening because it looks like the Standby datastore is already existing when the -duplicate is run preventing the -duplicate from creating the Standby datastore itself.
  • 2. Re: Timesten error: TT8179: Cannot create duplicate store : store already exist
    957434 Newbie
    Currently Being Moderated
    Thanks a lot for your suggestions will try out

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points