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;
call ttcacheuidpwdset ('ttorauser','timesten');
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.
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.