Database In Memory : GoldenGate Installation 11g/12c

Create New Linux account: ggs01

SOURCE & TARGET:

Verify ggs01 is part of these groups: ggsoper, dba

[root@z1p12c ~]# id ggs01

uid=503(ggs01) gid=507(ggsoper) groups=507(ggsoper),501(dba)

create directories at os level and change permissions required

/appl/ggs_oracle/gg_home/ (For Goldengate Home)

/appl/ggs_stage/ ( For Goldengate Installation Files )

Change permissions required

chown -R ggs01:ggsoper /appl/ggs_oracle/gg_home

chown -R ggs01:ggsoper /appl/ggs_stage

Set up the base profile accordingly for goldengate user ggs01

Create Database Account:

SOURCE & TARGET:

create new Tablespace

SQL> create tablespace <gg_stage> datafile ‘/path/ggs_stage.dbf’ size 200m;

create new User

SQL> create user <ggsuser> identified by <pa55w0rd> default tablespace <ggs_stage> temporary tablespace temp;

Grant Privileges for GoldenGate User

SOURCE:

SQL> grant create session, resource, create table, create sequence, select any table, flashback any table, select any dictionary, alter session, become user, unlimited tablespace to ggsuser;

TARGET:

SQL> grant create session, resource, create table, create sequence, select any table, insert any table, update any table, delete any table, alter any table, alter any sequence, flashback any table, select any dictionary, alter session, become user, unlimited tablespace, create any table, drop any table, create any index, alter any index, drop any index, create any trigger, drop any trigger, alter any trigger, comment any table to ggsuser;

During Installation, GRANT DBA PRIVELEGE TO GOLDENGATE user ggsuser;

After GoldenGate Installation, Revoke DBA for GOLDENGATE User make sure grant unlimited Tablespace to ggsuser

Enable Force Logging & Minimal Supplemental Logging at Database Level #

source: (as oracle)

Log into the database #

sql> alter database force logging;

For Enabling CR is required for database Bounce

sql> Shutdown database;

sql> startup mount;

sql> alter database add supplemental log data;

sql> alter database open;

GoldenInstallation as GoldenGate OS User

SOURCE & TARGET:

copy Installation file to the GoldenStaging Location and Un-tar it for GoldenGate Installation 11g

$ tar -xvf Goldengate.tar

create subdirs required for goldengate s/w

GGSCI(z1p12c)1> create subdirs

Create GoldenGate checkpoint table
GGSCI(z1p12c)2> dblogin userid ggsuser password pa55w0rd
GGSCI(z1p12c)3> add checkpointtable ggsuser.ckptab

Installing DDL support for Database

Connect source and setup DDL

sql> @marker_setup.sql

prompt for goldengate schema : ggsuser

sql> @ddl_setup.sql

prompt for goldengate schema : ggsuser

sql> @role_setup.sql

prompt for goldengate schema : ggsuser

Grant this role to each user assigned to the Extract, GGSCI,

and Manager processes, by using the following SQL command:

GRANT GGS_GGSUSER_ROLE TO <loggedUser>

where <loggedUser> is the user assigned to the GoldenGate processes.