RC:dbms_goldengate_auth.grant_admin_privilege Is Failing On RAC Database

(Doc ID 2346793.1)

Last updated on FEBRUARY 12, 2018

Applies to:

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

Symptoms

Customer had installed in their Production Environment Oracle database 12.1.0.2 in RAC, when implementing Oracle golden gate 12c on one of the RAC node ( ie. node 1).
while executing  "EXECUTE dbms_goldengate_auth.grant_admin_privilege('GGOWNER','capture');" it is failing after running long time with below error:



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms