I have two servers gg1 and gg2 using bidirectional replication. before i start replication I create one table on both gg1 and gg2. Then I turn on replication and insert rows into gg1 and it words fine.
However when i try to create a "new' table on gg1 replication fails on gg1 with 2025-03-15T18:13:25.318-0400 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, s_rep.prm: Fatal error executing DDL replication: error [Error code [955], ORA-00955: name is already used by an existing object ], no error handler present.
This is my replicat setting on gg2
replicat s_rep
userid ggs_owner, password Newpassword_2
assumetargetdefs
discardfile /u01/gg/dirrpt/srep1.dsc, append
reperror (default, exception)
map sender.*, target sender.*;
MACRO #exception_handler
BEGIN
, TARGET GGS_OWNER.GGS_EXCEPTIONS
, COLMAP ( rep_name = @GETENV('GGENVIRONMENT', 'GROUPNAME')
, TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME')
, ERRNO = @GETENV ('LASTERR', 'DBERRNUM')
, DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG')
, OPTYPE = @GETENV ('LASTERR', 'OPTYPE')
, ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE')
, LOGRBA = @GETENV ('GGHEADER', 'LOGRBA')
, LOGPOSITION = @GETENV ('GGHEADER', 'LOGPOSITION')
, COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')
, GGS_FILENAME = @GETENV('GGFILEHEADER', 'FILENAME')
, CDRFAIL = @GETENV('DELTASTATS','CDR_RESOLUTIONS_FAILED')
, CDRSUC = @GETENV('DELTASTATS','CDR_RESOLUTIONS_SUCCEEDED')
, CDRDETECT = @GETENV('DELTASTATS','CDR_CONFLICTS'))
, INSERTALLRECORDS
, EXCEPTIONSONLY;
END;
MAP sender.* #exception_handler();
the extract and pump on gg1 is
extract s_ext
userid ggs_owner, password oracle
tranlogoptions excludeuser ggs_owner
exttrail /u01/gg/dirdat/lt
ddl include all
getupdatebefores
sequence sender.*;
table sender.*;
extract s_pmp
userid ggs_owner, password oracle
rmthost 192.168.1.146, mgrport 7809
rmttrail /u01/gg/dirdat/rt
passthru
sequence sender.*;
table sender.*;
tried recreate golden gate and same issue.