Pages

Saturday, June 11, 2016

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.

sql> grant GGS_GGSUSER_ROLE to ggsuser;

sql> @ddl_enable.sql

sql> @ddl_pin ggsuser

If we want to revoke DBA from ggsuser make sure we assign following privileges to ggsuser 
sql> grant execute on dbms_flashback to ggsuser;
sql> grant alter any table to ggsuser;
sql> grant unlimited tablespace to ggsuser;
sql> revoke dba from ggsuser;

sql> select grantee, privilege from dba_sys_privs where grantee = 'GGSUSER';
sql> select grantee, granted_role from dba_role_privs where grantee = 'GGSUSER';
sql> select grantee, privilege from dba_sys_privs where grantee = ‘GGSUSER’;

—Nikhil Tatineni
—Oracle In Memory--

links related to goldengate


GoldenGate subdirectories 

Sample Extract, pump and Replicat GoldenGate process

Goldengate: Supplemental Logging

GoldenGate Checkpoint table 

12c: Oracle Goldengate wallet

Oracle GoldenGate: General Monitoring

Oracle GoldenGate: logdump utility

Oracle GoldenGate: Defgen utility

12c: Integrated GoldenGate Extract

converting classic Extract to Integrated Extract 

GoldenGate Integrated Replicat

Convert Classic Replicat to Integrated replicat 

Obey files GoldenGate 

GoldenGate co-ordinate Replicat

Delete Unused Process in Goldengate

GoldenGate Daily Patrol scripts on Servers

Migrating Oracle database using Goldengate

Query’s to monitor Integrated Extract#

Keygen # GoldenGate Password Encryption

Remove DDL replication # GoldenGate

What is lag in OGG ?

GoldenGate Extract : Bounded Recovery

>>>