Subscriber Count

    464

Subscribe to Posts by Email

Pages

Example 1: GoldenGate Setup & Configuration

On Source & Target Hosts Perform the Following

############################################################

On Source: Unzip the GG Software and Perform the installation & Configuration

###############################################################

[oracle@sourcehost]/data # unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

Archive:  ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

  inflating: fbo_ggs_Linux_x64_ora11g_64bit.tar

  inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf

  inflating: Oracle GoldenGate 11.2.1.0.1 README.txt

  inflating: Oracle GoldenGate 11.2.1.0.1 README.doc

[oracle@sourcehost]/data # tar -xvf ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

[oracle@sourcehost]/data/ggate # ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

## Create Directories

GGSCI (sourcehost) 1> create subdirs

Creating subdirectories under current directory /data/ggate

Parameter files                /data/ggate/dirprm: already exists

Report files                   /data/ggate/dirrpt: created

Checkpoint files               /data/ggate/dirchk: created

Process status files           /data/ggate/dirpcs: created

SQL script files               /data/ggate/dirsql: created

Database definitions files     /data/ggate/dirdef: created

Extract data files             /data/ggate/dirdat: created

Temporary files                /data/ggate/dirtmp: created

Stdout files                   /data/ggate/dirout: created

GGSCI (targethost) 2>

#############################################################################

On Target: Unzip the GG Software and Perform the installation & Configuration

##############################################################################

[oracle@targethost]/data # unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

Archive:  ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

  inflating: fbo_ggs_Linux_x64_ora11g_64bit.tar

  inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf

  inflating: Oracle GoldenGate 11.2.1.0.1 README.txt

  inflating: Oracle GoldenGate 11.2.1.0.1 README.doc

[oracle@targethost]/data # tar -xvf ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

[oracle@sourcehost]/data/ggate # ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI (targethost) 1> create subdirs

Creating subdirectories under current directory /data/ggate

Parameter files                /data/ggate/dirprm: already exists

Report files                   /data/ggate/dirrpt: created

Checkpoint files               /data/ggate/dirchk: created

Process status files           /data/ggate/dirpcs: created

SQL script files               /data/ggate/dirsql: created

Database definitions files     /data/ggate/dirdef: created

Extract data files             /data/ggate/dirdat: created

Temporary files                /data/ggate/dirtmp: created

Stdout files                   /data/ggate/dirout: created

GGSCI (targethost) 2>

############################################################

On Source & Target: Prepare Source Database for GG Replication 

###############################################################

1. Ensure The database is in archive log mode

2. Create Necessary tablespace and goldengate user in database

SQL> create tablespace ggs_data datafile '/data/GGS/Base/ggs_data01.dbf' size 200m;

SQL> create user ggs_owner identified by ggs_owner default tablespace ggs_data temporary tablespace temp;

SQL> grant connect,resource to ggs_owner;

SQL> grant select any dictionary, select any table to ggs_owner;

SQL> grant create table to ggs_owner;

SQL> grant flashback any table to ggs_owner;

SQL> grant execute on dbms_flashback to ggs_owner;

SQL> grant execute on utl_file to ggs_owner;

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

SQL> alter session set recyclebin=OFF;

SQL> exec dbms_goldengate_auth.grant_admin_privilege('GGS_OWNER');

SQL> grant select any dictionary to GGS_OWNER;

SQL> grant insert any table to GGS_OWNER;

SQL> grant update any table to GGS_OWNER;

 

SQL> grant delete any table to GGS_OWNER;

Also Configure DDL Replication, Run the following scripts from goldengate software directory

@marker_setup

@ddl_setup

@role_setup

grant ggs_ggsuser_role to ggs_owner;

@ddl_enable

@ddl_pin GGS_OWNER