GoldenGate 12c: Initial Configuration
November 25, 2014 Leave a comment
In our last post we have seen “GoldenGate 12c: Installation for Oracle DB” on Linux platform. Now we will do initial configuration before configuring extract and replicat on source and target databases respectively. Here are the steps:
Create tablespace for GGS operations (on both Source & Target DB)
SQL> create tablespace GGS_DATA;
Create User for extract on source database (on both Source & Target DB)
SQL> create user GGSUSER identified by GGSUSER
default tablespace GGS_DATA
temporary tablespace TEMP;
Grant required permissions (on both Source & Target DB)
SQL> grant connect, resource to ggsuser;
SQL> grant select any dictionary, select any table to ggsuser;
SQL> grant create table to ggsuser;
SQL> grant flashback any table to ggsuser;
SQL> grant execute on dbms_flashback to ggsuser;
SQL> grant execute on utl_file to ggsuser;
SQL> grant create any table to ggsuser;
SQL> grant insert any table to ggsuser;
SQL> grant update any table to ggsuser;
SQL> grant delete any table to ggsuser;
SQL> grant drop any table to ggsuser;
SQL> grant ALTER ANY TABLE to ggsuser;
SQL> grant ALTER SYSTEM to ggsuser;
SQL> grant LOCK ANY TABLE to ggsuser;
/*Only for initial load.*/
SQL> grant SELECT ANY TRANSACTION to ggsuser;
/*To extract changes from redo stored on ASM for classic extract.*/
