ORA-20782 Creating GGS_DDL_RULES table ; ORA-01031: Insufficient Privs Running DDL_setup.sql (Doc ID 1576164.1)

Last updated on AUGUST 17, 2013

Applies to:

Oracle GoldenGate - Version 11.2.1.0.4 to 11.2.1.0.9 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Using Golden Gate version 11.2.1.0.4, running on a Solaris 5.10 64 bit platform, the following errors occur when running ddl_setup.sql
ORA-01031: insufficient privileges
BEGIN "GGS_APP112" .initial_setup; END;

*
ERROR at line 1:
ORA-20782: Creating GGS_DDL_RULES table:ORA-01031: insufficient privileges:ORA-01031: insufficient privileges
ORA-06512: at "GGS_APP112.INITIAL_SETUP", line 477
ORA-06512: at line 1

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