DDL Setup Failed

(Doc ID 1564408.1)

Last updated on JUNE 26, 2013

Applies to:

Oracle GoldenGate - Version 11.2.1.0.6 and later
Information in this document applies to any platform.

Symptoms

ddl_setup.sql returns the following errors:


DDLREPLICATION PACKAGE BODY STATUS

Line/pos
----------------------------------------------------------------------------------------------------------------
Error
-----------------------------------------------------------------
1048/13
PL/SQL: Statement ignored

1048/25
PLS-00201: identifier 'UTL_RAW' must be declared

1049/13
PL/SQL: Statement ignored

As per the cust last update :
========================

I believe customer don't have privilege to run the package since those package belongs to sysdba. When customer try to grant those package, and also get error:

I had previously granted dba to GGS. As sys, I tried to explicitly grant execute on utl_file to GGS. Interestingly I got this error:
SQL> GRANT EXECUTE ON utl_file TO GGS;
GRANT EXECUTE ON utl_file TO GGS
              *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04063: package body "GGS.DDLREPLICATION" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"GGS.DDLREPLICATION"
ORA-06512: at line 60

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms