In Oracle DB Version 19.19.0.0.0, “Current” PDB throws an error when running the package dbms_goldengate_auth.grant_admin_privilege :
SQL> exec dbms_goldengate_auth.grant_admin_privilege('ggadmin', container='current');
BEGIN dbms_goldengate_auth.grant_admin_privilege('ggadmin', container='current'); END;
ERROR at line 1:
ORA-06550: line 1, column 61:
PLS-00201: identifier 'CONTAINER' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Solution:
Specify the PDB name of the container
SQL> exec dbms_goldengate_auth.grant_admin_privilege('ggadmin', container=>'current');
BEGIN dbms_goldengate_auth.grant_admin_privilege('ggadmin', container=>'current'); END;
*
ERROR at line 1:
ORA-65011: Pluggable database CURRENT does not exist.
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 3812
ORA-06512: at "SYS.DBMS_GOLDENGATE_AUTH", line 63
ORA-06512: at line 1
SQL> exec dbms_goldengate_auth.grant_admin_privilege('ggadmin', container=>'ORCLPDB1');
PL/SQL procedure successfully completed.
SQL>
Leave a comment