2 Replies Latest reply: Oct 17, 2012 7:09 AM by 957434 RSS

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

    957434
      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
          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
            Thanks a lot for your suggestions will try out