OGG-00519 Fatal error executing DDL replication: error [Error code [1918], ORA-01918: user 'RDSADMIN' does not exist SQL /* GOLDENGATE_DDL_REPLICATION */ ALTER USER RDSADMIN IDENTIFIED BY VALUES 'S:09E677F1EA54AF1925BFBD45B711898AFEECB073BF92D4121D9039B941E2;H:5914B325962646A6BF25A5ED11D05EB6;T:0D26A57D 465696E608FDF426F80983E15C089BE83F94132B2E5CA957E6F54668DAB561414ED67CBCEE87A3BCF2AA124BE2C514F779AD15C2C1B3E4 337671D8341DEC0FA8F67FED0A17BC9B3610AA33CE;3870B0091A7B89C5' /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
MACRO #exception_handler BEGIN , TARGET ggadmin.exceptions , COLMAP ( rep_name = "REPGDRDS" , 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")) , INSERTALLRECORDS , EXCEPTIONSONLY; END; REPERROR (DEFAULT, EXCEPTION) REPERROR (1918, exception)
- Oracle GoldenGate Documentation, 15 Handling Processing Errors
- Creating a GoldenGate Exception Handler to Trap and Log Oracle Errors