My Oracle Support Banner

Replicat Processes Abended With OGG-00519 And ORA-01917 After New User Is Created On Source Site (Doc ID 2106395.1)

Last updated on JANUARY 12, 2020

Applies to:

Oracle GoldenGate - Version 11.2.1.0.27 and later
Information in this document applies to any platform.

Symptoms

Replicat has abended while creating a user with below error:

2016-02-12 22:56:46 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [1917], ORA-01917: user or role 'NAME1' does not exist SQL grant select on XXXXX.YYY to XXXXX /* GOLDENGATE_DDL_REPLICATION */], no error handler present.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.