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:
Oracle GoldenGate - Version 12.3.0.1.4 and laterInformation in this document applies to any platform.
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
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 |