Monday, May 25, 2015

DDL : initial_setup: :ORA-01031: insufficient privileges while running ddl_setup.sql

Error:

DDL : Creating DDL sequence: :ORA-01031: insufficient privileges
DDL : initial_setup: :ORA-01031: insufficient privileges
DDL : STARTING DDL REPLICATION SETUP
DDL : Instantiating new DDL replication package
DDL : Initial setup starting
DDL : Creating DDL sequence: :ORA-01031: insufficient privileges
DDL : initial_setup: :ORA-01031: insufficient privileges
DDL : STARTING DDL REPLICATION SETUP
DDL : Instantiating new DDL replication package
DDL : Initial setup starting
DDL : Creating DDL sequence: :ORA-01031: insufficient privileges
DDL : initial_setup: :ORA-01031: insufficient privileges
DDL : STARTING DDL REPLICATION SETUP
DDL : Instantiating new DDL replication package
DDL : Initial setup starting
DDL : Creating DDL sequence: :ORA-01031: insufficient privileges
DDL : initial_setup: :ORA-01031: insufficient privileges
DDL : STARTING DDL REPLICATION SETUP
DDL : Instantiating new DDL replication package



Solution:

1. Create new table space for Golden Gate schema.
2.Golden Gate schema should have below privilleges

grant connect, resource to ggs_owner;
grant select any dictionary, select any table to ggs_owner;
grant create table to ggs_owner;
grant flashback any table to ggs_owner;
grant execute on dbms_flashback to ggs_owner;
grant execute on utl_file to ggs_owner;
grant create any table to ggs_owner;
grant insert any table to ggs_owner;
grant update any table to ggs_owner;
grant delete any table to ggs_owner;
grant drop any table to ggs_owner;
grant create any table to ggs_owner;
grant create any view to ggs_owner;
grant create any procedure to ggs_owner;
grant create any sequence to ggs_owner;
grant create any index to ggs_owner;
grant create any trigger to ggs_owner;
grant create any view to ggs_owner;

No comments: