PLS-00201: Identifier 'DBMS_GOLDENGATE_AUTH' Must Be Declared
(Doc ID 2680684.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 19.1.0.0.2 and laterOracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.
Symptoms
Configuring GoldenGate on a Container (CDB) database, DBMS_GOLDENGATE_AUTH will fail with following error:
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_GOLDENGATE_AUTH' must be declared
It may fail as well with ORA-1031:
BEGIN dbms_goldengate_auth.grant_admin_privilege('C##GGADMIN',container=>'ALL'); END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 3652
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 93
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 84
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 123
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 3635
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 3812
ORA-06512: at "SYS.DBMS_GOLDENGATE_AUTH", line 63
ORA-06512: at line 1
When checking the ERRORSTACK trace of ORA-1031, this is the statement causing the error:
-- Goldengate PDB section
alter user "C##GGADMIN" set container_data=ALL container=CURRENT
Changes
Configuring GoldenGate admin user against Oracle RDBMS 12.2 or higher.
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 |
Changes |
Cause |
Solution |
References |