Error PLS-00201: identifier 'DBMS_GOLDENGATE_AUTH' must be declared in OGG Configuration in Autonomous oracle Database (Doc ID 3072769.1)

Last updated on FEBRUARY 18, 2025

Applies to:

Symptoms

Execute below command from created new user <GG_USERNAME>  on Autonomous Oracle Database.

SQL>exec dbms_goldengate_auth.grant_admin_privilege('<GG_USERNAME>');

Error received:

SQL> exec dbms_goldengate_auth.grant_admin_privilege('<GG_USERNAME>');
BEGIN dbms_goldengate_auth.grant_admin_privilege('<GG_USERNAME>'); END;
 
  *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_GOLDENGATE_AUTH' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Cause

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