OGG DDL_SetUp.sql Script Fails With PLS-00201 Identifier DBMS_SQL Must Be Declared (Doc ID 2644500.1)

Last updated on MARCH 25, 2020

Applies to:

Symptoms

While executing ddl_setup.sql script fails with following errors:

SQL> @ddl_setup.sql
Oracle GoldenGate DDL Replication setup script
Verifying that current user has privileges to install DDL Replication...

........................

Line/pos   Error
---------- -----------------------------------------------------------------
No errors  No errors
DDLREPLICATION PACKAGE BODY STATUS:
Line/pos   Error
---------- -----------------------------------------------------------------
2725/17    PL/SQL: Statement ignored
2725/40    PLS-00201: identifier 'DBMS_SQL' must be declared
2730/17    PL/SQL: Statement ignored
2734/33    PLS-00201: identifier 'DBMS_SQL' must be declared
2736/17    PL/SQL: Statement ignored
2736/17    PLS-00201: identifier 'DBMS_SQL' must be declared
2737/17    PL/SQL: Statement ignored
2737/17    PLS-00201: identifier 'DBMS_SQL' must be declared
2738/17    PL/SQL: Statement ignored
2738/17    PLS-00201: identifier 'DBMS_SQL' must

...................

Script complete.
SQL> @role_setup.sql
GGS Role setup script

...................................

SQL> grant GGS_GGSUSER_ROLE to oggadmin;
grant GGS_GGSUSER_ROLE to oggadmin
*
ERROR at line 1:
ORA-04088: error during execution of trigger 'SYS.GGS_DDL_TRIGGER_BEFORE'
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of
OGGADMIN.DDLREPLICATION
ORA-04067: not executed, package body "OGGADMIN.DDLREPLICATION" does
not exist
ORA-06508: PL/SQL: could not find program unit being called:
"OGGADMIN.DDLREPLICATION"
ORA-06512: at line 1337
ORA-04067: not executed, package body "OGGADMIN.DDLREPLICATION" does
not exist
ORA-06508: PL/SQL: could not find program unit being called:
"OGGADMIN.DDLREPLICATION"
ORA-06512: at line 97
ORA-06508: PL/SQL: could not find program unit being called:
"OGGADMIN.DDLREPLICATION"
ORA-06512: at line 1198
ORA-04045: errors during recompilation/revalidation of
OGGADMIN.DDLREPLICATION

Changes

Cause

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