I'm trying to configure multi master with two servers (orclsrc and orcltgt) on Oracle 11G (yes, I know it is old but is what we have here) following this guide.
When I'm trying to do:
EXEC DBMS_REPCAT.ADD_MASTER_DATABASE (GNAME=> 'REP2', MASTER=>'ORCLTGT',USE_EXISTING_OBJECTS => TRUE,COPY_ROWS=> FALSE, PROPAGATION_MODE=> 'ASYNCHRONOUS');
I got this error:
ERROR at line 1:
ORA-04052: error occurred when looking up remote object REPADMIN.SYS@ORCLTGT
ORA-00604: error occurred at recursive SQL level 2
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 4280
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2158
ORA-06512: at "SYS.DBMS_REPCAT", line 146
ORA-06512: at line 1
AFAIK I have a proper TNS config because tnsping works ok on both directions.
So the problem seems that when a run former command login action appends or concatenates ".sys" to my username (repadmin.sys instead of repadmin).
How can I avoid this behaviour?
PS: is there any other better option for multimaster?