Goldengate on ASM using DBLOGREADER

This is demostration of CLASSIC CAPTURE on ASM using New ASM API ,
Which reading redo log on ASM Using GoldenGate user provided by USERID in Extract

Source Side : 3 Node RAC / Grid Infrastructure 11.2.0.2
Target Side : Stand-alone 11.2.0.1

DBLOGREADER

(Oracle) Valid for Extract in classic capture mode.Causes Extract to use a newer ASM API that is available as
of Oracle 10.2.0.5 and later 10g R2 versions, and Oracle 11.2.0.2 and later 11g R2 versions (but not in Oracle 11g R1
versions). This API uses the database server to access the redo and archive logs, instead of connecting directly to the
Oracle ASM instance. The database must contain the libraries that contain the API modules and must be
running. To use this feature, the Extract database user must have SELECT ANY TRANSACTION privilege.
When used, DBLOGREADER enables Extract to use a read size of up to 4 MB in size. This is controlled with the
DBLOGREADERBUFSIZE option The maximum read size when using the default OCI buffer is 28672 bytes.
This is controlled by the ASMBUFSIZE option. A larger buffer may improve the performance of Extract
when redo rate is high.When using DBLOGREADER, do not use the ASMUSER and ASMPASSWORD options of TRANLOGOPTIONS.
The API uses the user and password specified with the USERID parameter.

DBLOGREADERBUFSIZE

(Oracle) Valid for Extract in classic capture mode.Controls the maximum size, in bytes, of a read operation
into the internal buffer that holds the results of each read of the transaction log in ASM. Higher values increase
extraction speed but cause Extract to consume more memory. Low values reduce memory usage but increase I/O
because Extract must store data that exceeds the cache size to disk.
Use DBLOGREADERBUFSIZE together with the DBLOGREADER option if the source ASM instance is Oracle 10.2.0.5 or
later10g R2 versions, or Oracle 11.2.0.2 and later 11g R2 versions (but not Oracle 11g R1 versions). The newer ASM
API in those versions provides better performance than the older one. If the Oracle version is not one of those versions,
then ASMBUFSIZE must be used.



--SOURCE SIDE

Add supplement log at database level.

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

Database altered.

--ON SOURCE Add checkpoint Table if it is bi-directional replication,and if you dont have one.

GGSCI (PNETN1.localdomain.com) 19>DBLOGIN, USERID GGADMIN, PASSWORD Summer2011
GGSCI (PNETN1.localdomain.com) 19>INFO CHECKPOINTTABLE

--if you dont have one , create it. 

GGSCI (PNETN1.localdomain.com) 19>ADD CHECKPOINTTABLE GGADMIN.CKPT_TABLE

GGSCI (PNETN1.localdomain.com) 19>EDIT PARAMS ./GLOBALS
GGSCHEMA GGADMIN
CHECKPOINTTABLE GGADMIN.CKPT_TABLE

--Add Extract as Below , REGISTER extract using LOGRETENTION

Use DBLOGIN to REGISTER extract

GGSCI (PNETN1.localdomain.com)>DBLOGIN USERID GGADMIN,PASSWORD Summer2011
GGSCI (PNETN1.localdomain.com)>REGISTER EXTRACT DW_EX LOGRETENTION

--Add extract 

GGSCI (PNETN1.localdomain.com)>ADD EXTRACT DW_EX TRANLOG,BEGIN NOW,THREADS 3
GGSCI (PNETN1.localdomain.com)>ADD EXTTRAIL ./dirdat/EX, EXTRACT DW_EX

--Create parameter file for Extract 
GGSCI (PNETN1.localdomain.com) 19>EDIT PARAMS DW_EX
EXTRACT DW_EX
---ORACLE ENVIRONMET
SETENV (ORACLE_HOME = "/u01/app/oracle/11.2.0/db_1")
SETENV (ORACLE_SID = "EDWP1")
SETENV (NLS_LANG = "AMERICAN_AMERICA.WE8MSWIN1252")
USERID GGADMIN, PASSWORD Summer2011

--TRANLOGOPTIONS ASMUSER sys@+ASM, ASMPASSWORD Summer69
--This is ASM API that is available as of
--Oracle 10.2.0.5 and later 10g R2 versions AND
--Oracle 11.2.0.2 and later 11g R2 versions
--BUT NOT in Oracle 11g R1 versions

TRANLOGOPTIONS DBLOGREADER, DBLOGREADERBUFSIZE  2597152,ASMBUFSIZE 28000
DYNAMICRESOLUTION
DISCARDFILE ./dirrpt/edwp.dsc,PURGE, MEGABYTES 100
EXTTRAIL ./dirdat/EX

--DDL REPLICATION
DDL INCLUDE MAPPED OBJNAME TEST.*

--DML replication for SCHEMA level.
TABLE TEST.*;
--end

--Add DATAPUMP

GGSCI (PNETN1.localdomain.com) 19>ADD EXTRACT DW_EP, EXTTRAILSOURCE ./dirdat/EX,begin now
GGSCI (PNETN1.localdomain.com) 19>ADD RMTTRAIL ./dirdat/EP, EXTRACT DW_EP, MEGABYTES 100
GGSCI (PNETN1.localdomain.com) 19>edit params DW_EP
EXTRACT DW_EP
SETENV (ORACLE_HOME = "/u01/app/oracle/11.2.0/db_1")
SETENV (ORACLE_SID = "EDWP1")
SETENV (NLS_LANG = "AMERICAN_AMERICA.WE8MSWIN1252")
USERID GGADMIN, PASSWORD Summer2011
PASSTHRU
RMTHOST 192.168.100.101, MGRPORT 7809
RMTTRAIL ./dirdat/EP
TABLE TEST.*;
--end

--START extract / Pump.

GGSCI (PNETN1.localdomain.com) 17> start DW_EX

Sending START request to MANAGER ...
EXTRACT DW_EX starting


GGSCI (PNETN1.localdomain.com) 18> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     STOPPED     DW_EP       00:00:00      00:20:02
EXTRACT     RUNNING     DW_EX       00:33:56      00:00:06


GGSCI (PNETN1.localdomain.com) 19> start DW_EP

Sending START request to MANAGER ...
EXTRACT DW_EP starting


GGSCI (PNETN1.localdomain.com) 20> INFO ALL

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     DW_EP       00:00:00      00:00:08
EXTRACT     RUNNING     DW_EX       00:00:02      00:00:07

--Output from ggserr.log

 
[[A2012-07-31 12:34:15  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start DW_EX.
2012-07-31 12:34:15  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host PNETN1.localdomain.com (START EXTRACT DW_EX ).
2012-07-31 12:34:15  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT DW_EX starting.
2012-07-31 12:34:15  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  EXTRACT DW_EX starting.
2012-07-31 12:34:15  INFO    OGG-03035  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2012-07-31 12:34:15  INFO    OGG-01635  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  BOUNDED RECOVERY: reset to initial or altered checkpoint.
2012-07-31 12:34:15  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /u02/gghome/BR/DW_EX.
2012-07-31 12:34:15  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /u02/gghome/dirtmp.
2012-07-31 12:34:17  INFO    OGG-00546  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Default thread stack size: 33554432.
2012-07-31 12:34:17  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Positioning to begin time Jul 31, 2012 12:00:23 PM.
2012-07-31 12:34:18  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Positioned to (Thread 1) Sequence 4, RBA 5810192, SCN 0.0, Jul 31, 2012 12:00:23 PM.
2012-07-31 12:34:18  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Positioning to begin time Jul 31, 2012 12:00:23 PM.
2012-07-31 12:34:18  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Positioned to (Thread 2) Sequence 2, RBA 5019152, SCN 0.0, Jul 31, 2012 12:00:23 PM.
2012-07-31 12:34:18  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Positioning to begin time Jul 31, 2012 12:00:23 PM.
2012-07-31 12:34:19  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Positioned to (Thread 3) Sequence 2, RBA 4712464, SCN 0.0, Jul 31, 2012 12:00:23 PM.
2012-07-31 12:34:19  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Position of first record processed for Thread 2, Sequence 2, RBA 5019152, SCN 0.1098626, Jul 31, 2012 12:00:23 PM.
2012-07-31 12:34:19  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Position of first record processed for Thread 3, Sequence 2, RBA 4712464, SCN 0.1098627, Jul 31, 2012 12:00:23 PM.
2012-07-31 12:34:19  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  EXTRACT DW_EX started.
2012-07-31 12:34:19  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  No recovery is required for target file ./dirdat/EX000000, at RBA 0 (file not opened).
2012-07-31 12:34:19  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Output file ./dirdat/EX is using format RELEASE 11.2.
2012-07-31 12:34:19  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, dw_ex.prm:  Position of first record processed for Thread 1, Sequence 4, RBA 5810192, SCN 0.1098585, Jul 31, 2012 12:00:23 PM.
2012-07-31 12:34:32  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start DW_EP.
2012-07-31 12:34:32  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host PNETN1.localdomain.com (START EXTRACT DW_EP ).
2012-07-31 12:34:32  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT DW_EP starting.
2012-07-31 12:34:33  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, dw_ep.prm:  EXTRACT DW_EP starting.
2012-07-31 12:34:33  INFO    OGG-03035  Oracle GoldenGate Capture for Oracle, dw_ep.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2012-07-31 12:34:33  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, dw_ep.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /u02/gghome/dirtmp.
2012-07-31 12:34:33  WARNING OGG-01015  Oracle GoldenGate Capture for Oracle, dw_ep.prm:  Positioning with begin time: Jul 31, 2012 12:02:01 PM, waiting for data: at extseqno 0, extrba 0.
2012-07-31 12:34:33  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, dw_ep.prm:  EXTRACT DW_EP started.
2012-07-31 12:34:38  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, dw_ep.prm:  Socket buffer size set to 27985 (flush size 27985).
2012-07-31 12:34:38  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, dw_ep.prm:  No recovery is required for target file ./dirdat/EP000000, at RBA 0 (file not opened).
2012-07-31 12:34:38  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, dw_ep.prm:  Output file ./dirdat/EP is using format RELEASE 11.2.

---Also you will see below output on Target ggserr.log

2012-07-31 09:32:36  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from EXTRACT on host 192.168.100.126 (START SERVER CPU -1 PRI -1  TIMEOUT 300 PARAMS ).
2012-07-31 09:32:36  INFO    OGG-00974  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started collector process (Port 7840).
2012-07-31 09:32:36  INFO    OGG-01677  Oracle GoldenGate Collector:  Waiting for connection (started dynamically).
2012-07-31 09:32:36  INFO    OGG-01228  Oracle GoldenGate Collector:  Timeout in 300 seconds.
2012-07-31 09:32:41  INFO    OGG-01229  Oracle GoldenGate Collector:  Connected to 192.168.100.126:23270.
2012-07-31 09:32:41  WARNING OGG-01223  Oracle GoldenGate Collector:  did not recognize command (n).
2012-07-31 09:32:41  INFO    OGG-01669  Oracle GoldenGate Collector:  Opening ./dirdat/EP000000 (byte -1, current EOF 0).
2012-07-31 09:32:41  INFO    OGG-01670  Oracle GoldenGate Collector:  Closing ./dirdat/EP000000.
2012-07-31 09:32:41  INFO    OGG-01669  Oracle GoldenGate Collector:  Opening ./dirdat/EP000000 (byte -1, current EOF 0).

=============================================================
=============================================================

--TARGET SIDE

--Add checkpoint Table into GLOBALS, if you dont have any.

GGSCI (TEST.localdomain.com) 4> view PARAMS ./GLOBALS
CHECKPOINTTABLE GGSUSER.CKPT
GGSCHEMA GGSUSER

--Add checkpoint Table into Database. 

GGSCI (TEST.localdomain.com) 6>DBLOGIN USERID GGSUSER,PASSWORD Summer2011
Successfully logged into database.

--confirm if any checkpoint Table is already exist. 
GGSCI (TEST.localdomain.com) 8>INFO CHECKPOINTTABLE

No checkpoint table specified, using GLOBALS specification (GGSUSER.CKPT)...
Checkpoint table GGSUSER.CKPT created 2012-05-31 13:32:57.

--Add Replicat on Target SIDE.

GGSCI (TEST.localdomain.com) 8>ADD REPLICAT DW_ER, EXTTRAIL ./dirdat/EP,checkpointtable GGSUSER.CKPT

--Create parameter file for Replicat

GGSCI (TEST.localdomain.com) 8>edit params DW_ER
REPLICAT DW_ER
SETENV (ORACLE_HOME = "/u00/app/oracle/product/11.2.0/db_1")
SETENV (ORACLE_SID = "TEST")
--Assume DDL of Source.
ASSUMETARGETDEFS
USERID ggsuser, PASSWORD Summer2011
DISCARDFILE ./dirrpt/EDWP.dsc, append, megabytes 100
--DLL replication. 
DDL INCLUDE ALL
--DML replication from TEST schema to TEST schema. 
MAP TEST.*, TARGET TEST.*;
--end

--start Replicat

GGSCI (TEST.localdomain.com) 6> start DW_ER

Sending START request to MANAGER ...
REPLICAT DW_ER starting

--Some Output from Replicat ggserr.log

2012-07-31 09:33:08  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start DW_ER.
2012-07-31 09:33:08  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 192.168.100.101 (START REPLICAT DW_ER ).
2012-07-31 09:33:08  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT DW_ER starting.
2012-07-31 09:33:09  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, dw_er.prm:  REPLICAT DW_ER starting.
2012-07-31 09:33:09  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, dw_er.prm:  REPLICAT DW_ER started.

Goldengate on ASM / Goldengate on RAC / Goldengate on Grid Infrastructure

If you database is on ASM and running on below version.

• Oracle 10.2.0.5 or later 10g R2 versions
• Oracle 11.2.0.2 or later 11g R2 versions

Please visit, Goldengate on ASM using DBLOGREADER .

Environment used in Below exercise.

	SOURCE	TARGET
DATABASE	DEVDB (2 NODE RAC)	TEST
DATABASE VERSION	11.2.0.1	11.2.0.1
PLATFORM	Linux, x64, 64bit	Linux, x64, 64bit
STORAGE	ASM	File-system

Steps for Uni-directional Replication
1.   Add remote listener for ASM.
2.   EDIT ASM entry in  Listener.ora in $GRID_HOME/network/admin for All node respectively & Reload Listener.
3.   Add TNS entry for ASM on All Nodes
4.   Test ASM connection from sqlplus as sys user.
5.   Network configuration on Target.
6.   Configure Goldengate extract & Datapump for Source.
7.   Start extract & Datapump.
8.   Configure Goldengate Replicate for Target.
9.   Start replicate on target.
10. Confirm Goldengate connection on Source DB & ASM and Target DB.
11. Test Replication.

1) Add Remote listener for ASM.

ALTER SYSTEM SET remote_listener='RACD-SCAN:1521' SCOPE=BOTH SID='*';

2) Static registration of ASM in LISTNER.ORA IN $GRID_HOME/network/admin for All node respectively.
Edit below entry into Listener.ora intO $GRID_HOME/network/admin/listener.ora and Reload listener.

SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /u00/app/11.2.0/grid)
  (PROGRAM = extproc)
   )
   (SID_DESC =
    (ORACLE_HOME = /u00/app/11.2.0/grid)
    (SID_NAME = +ASM1)
   )
  )
  

---Reload listener.ora on All Nodes.

RACD1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $lsnrctl reload

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-JUN-2012 16:09:01
Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
The command completed successfully

--Grid Infrastructure Network configuration on Source.

RACD1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $ll
total 36
-rw-r--r--  1 oracle oinstall  187 May  7  2007 shrept.lst
drwxr-xr-x  2 oracle oinstall 4096 Jun  7 11:25 samples
drwxr-xr-x 11 oracle oinstall 4096 Jun  7 11:28 ..
-rw-r--r--  1 oracle oinstall  552 Jun  7 11:44 listener.ora.bak.racd1
-rw-r--r--  1 oracle oinstall  552 Jun  7 12:13 listener12060712PM1317.bak
-rw-r--r--  1 oracle oinstall  216 Jun  7 12:13 sqlnet.ora
-rw-r--r--  1 oracle oinstall  186 Jun 13 11:12 endpoints_listener.ora
-rw-r--r--  1 oracle oinstall  948 Jun 17 16:07 listener.ora
drwxr-xr-x  3 oracle oinstall 4096 Jun 17 16:07 .

RACD1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $cat listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))                # line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))                # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /u00/app/11.2.0/grid)
  (PROGRAM = extproc)
   )
   (SID_DESC =
    (ORACLE_HOME = /u00/app/11.2.0/grid)
    (SID_NAME = +ASM1)
   )
  )

RACD1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $cat endpoints_listener.ora

LISTENER_RACD1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=RACD1-VIP)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.124)(PORT=1521)(IP=FIRST))))            # line added by Agent

RACD1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $

---Listener status after changes.

--Listener status

RACD1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-JUN-2012 18:25:38
Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                17-JUN-2012 15:59:02
Uptime                    0 days 2 hr. 26 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u00/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u00/app/oracle/diag/tnslsnr/RACD1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.124)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.134)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM1" has 1 instance(s).
  Instance "+ASM1", status UNKNOWN, has 1 handler(s) for this service...
Service "DEVDB" has 1 instance(s).
  Instance "DEVDB1", status READY, has 1 handler(s) for this service...
Service "DEVDBXDB" has 1 instance(s).
  Instance "DEVDB1", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

--Listener services

RACD1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $lsnrctl services

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-JUN-2012 18:27:07
Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0 state:ready
         LOCAL SERVER
Service "+ASM1" has 1 instance(s).
  Instance "+ASM1", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "DEVDB" has 1 instance(s).
  Instance "DEVDB1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0 state:ready
         LOCAL SERVER
Service "DEVDBXDB" has 1 instance(s).
  Instance "DEVDB1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER 
         (ADDRESS=(PROTOCOL=tcp)(HOST=RACD1.localdomain.com)(PORT=31649))
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
The command completed successfully

3) ADDED TNS NAMES TO $ORACLE_HOME/network/admin/tnsnames.ora on All nodes.

+ASM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = RACD-SCAN)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = +ASM)
    )
  )
  

4) Test +ASM tnsenry from $ORACLE_HOME

-----From Node1 

RACD1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $. oraenv
ORACLE_SID = [+ASM1] ? DEVDB1
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u00/app/oracle
RACD1@:/u00/app/11.2.0/grid/network/admin :DEVDB1 $sqlplus sys/Summer69@+ASM as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 17 18:12:29 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options


18:12:29 @+ASM->

------From Node 2 

RACD2@:/u00/app/11.2.0/grid/network/admin :+ASM2 $. oraenv
ORACLE_SID = [+ASM2] ? DEVDB2
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u00/app/oracle
RACD2@:/u00/app/11.2.0/grid/network/admin :DEVDB2 $sqlplus sys/Summer69@+ASM as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 17 18:13:26 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

18:13:15 @+ASM->

5) Network configuration on Target.

-- listener.ora on TARGET. 

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u00/app/oracle/product/11.2.0/db_1)
      (PROGRAM = extproc)
    )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.101 )(PORT = 1521))
    )
  )

-- Tns entry on TARGET

TEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.101 )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = TEST)
    )
  )

6) Configure Goldengate Extract & Datapump on Source

DBLOGIN is specially required for 10.2,for 11.1 DBLOGIN is not required but I did.As if you want to delete EXTRACT you have to first DBLOGIN
if you need help on syntax here it is.

GGSCI (RACD1.localdomain.com) > help add extract

--CONFIGURE EXTRACT RACDE

RACD1@:/u02/gghome :DEVDB1 $./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 11g on Oct  4 2011 23:49:46


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


GGSCI (RACD1.localdomain.com) 1> DBLOGIN USERID GGSUSER
Password:
Successfully logged into database.
GGSCI (RACD1.localdomain.com) 3>ADD EXTRACT RACDE TRANLOG,BEGIN NOW,THREADS 2
GGSCI (RACD1.localdomain.com) 8>ADD EXTTRAIL ./dirdat/DE, EXTRACT RACDE
EXTTRAIL added.


GGSCI (RACD1.localdomain.com) 9> EDIT PARAMS RACDE
EXTRACT RACDE
---ORACLE ENVIRONMET 
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db_1")
SETENV (ORACLE_SID = "DEVDB1")
USERID ggsuser, PASSWORD Summer2011
TRANLOGOPTIONS ASMUSER sys@+ASM, ASMPASSWORD Summer69
DYNAMICRESOLUTION
DISCARDFILE ./dirrpt/racde.dsc,PURGE, MEGABYTES 100
EXTTRAIL ./dirdat/DE
--DDL REPLICATION
DDL INCLUDE MAPPED OBJNAME TEST.*
--DML replication for SCHEMA level. 
TABLE TEST.*;

--CONFIGURE DATAPUMP RACDP

GGSCI (RACD1.localdomain.com) 10> ADD EXTRACT RACDP, EXTTRAILSOURCE ./dirdat/DE,begin now
EXTRACT added.
GGSCI (RACD1.localdomain.com) 12> ADD RMTTRAIL ./dirdat/DP, EXTRACT RACDP, MEGABYTES 100
RMTTRAIL added.
GGSCI (RACD1.localdomain.com) 13> edit params RACDP
EXTRACT RACDP
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db_1")
SETENV (ORACLE_SID = "DEVDB1")
USERID ggsuser, PASSWORD Summer2011
PASSTHRU
RMTHOST 192.168.100.101, MGRPORT 7809
RMTTRAIL ./dirdat/DP
TABLE TEST.*;


GGSCI (RACD1.localdomain.com) 14> info all


Program     Status      Group       Lag           Time Since Chkpt


MANAGER     RUNNING
EXTRACT     STOPPED     RACDE       00:00:00      00:04:44
EXTRACT     STOPPED     RACDP       00:00:00      00:01:14

7) START EXTRACT & DATAPUMP

GGSCI (RACD1.localdomain.com) 15> start racde


Sending START request to MANAGER ...
EXTRACT RACDE starting


----Output from tail -f ggserr.log at time of starting extract. 


2012-06-17 17:01:06  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit params RACDP.
2012-06-17 17:01:49  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start racde.
2012-06-17 17:01:49  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 192.168.100.124 (START EXTRACT RACDE ).
2012-06-17 17:01:50  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT RACDE starting.
2012-06-17 17:01:50  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, racde.prm:  EXTRACT RACDE starting.
2012-06-17 17:01:51  INFO    OGG-01635  Oracle GoldenGate Capture for Oracle, racde.prm:  BOUNDED RECOVERY: reset to initial or altered checkpoint.
2012-06-17 17:01:56  INFO    OGG-00546  Oracle GoldenGate Capture for Oracle, racde.prm:  Default thread stack size: 10485760.
2012-06-17 17:01:56  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, racde.prm:  Positioning to begin time Jun 17, 2012 4:57:01 PM.
2012-06-17 17:02:01  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, racde.prm:  Positioned to (Thread 1) Sequence 13, RBA 2676224, SCN 0.0, Jun 17, 2012 4:57:01 PM.
2012-06-17 17:02:01  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, racde.prm:  Positioning to begin time Jun 17, 2012 4:57:01 PM.
2012-06-17 17:02:01  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, racde.prm:  Positioned to (Thread 2) Sequence 17, RBA 2571264, SCN 0.0, Jun 17, 2012 4:57:01 PM.
2012-06-17 17:02:01  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, racde.prm:  EXTRACT RACDE started.
2012-06-17 17:02:01  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, racde.prm:  Position of first record processed for Thread 1, Sequence 13, RBA 2681872, SCN 0.1079716, Jun 17, 2012 4:57:12 PM.
2012-06-17 17:02:01  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, racde.prm:  No recovery is required for target file ./dirdat/DE000000, at RBA 0 (file not opened).
2012-06-17 17:02:01  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, racde.prm:  Output file ./dirdat/DE is using format RELEASE 10.4/11.1.
2012-06-17 17:02:02  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, racde.prm:  Position of first record processed for Thread 2, Sequence 17, RBA 2630160, SCN 0.1079872, Jun 17, 2012 4:58:57 PM.


GGSCI (RACD1.localdomain.com) 16> START racdp


Sending START request to MANAGER ...
EXTRACT RACDP starting


----Output from tail -f ggserr.log at time of starting Pump. 


2012-06-17 17:07:03  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 192.168.100.124 (START EXTRACT RACDP ).
2012-06-17 17:07:03  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT RACDP starting.
2012-06-17 17:07:03  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, racdp.prm:  EXTRACT RACDP starting.
2012-06-17 17:07:03  WARNING OGG-01015  Oracle GoldenGate Capture for Oracle, racdp.prm:  Positioning with begin time: Jun 17, 2012 5:00:31 PM, waiting for data: at extseqno 0, extrba 0.
2012-06-17 17:07:03  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, racdp.prm:  EXTRACT RACDP started.
2012-06-17 17:07:08  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, racdp.prm:  Socket buffer size set to 27985 (flush size 27985).
2012-06-17 17:07:08  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, racdp.prm:  No recovery is required for target file ./dirdat/DP000000, at RBA 0 (file not opened).
2012-06-17 17:07:08  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, racdp.prm:  Output file ./dirdat/DP is using format RELEASE 10.4/11.1.

GGSCI (RACD1.localdomain.com) 4> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     RACDE       00:00:00      00:00:03
EXTRACT     RUNNING     RACDP       00:00:00      00:00:05

8) Configure Goldengate for Replicate on Target.

--CONFIGURE REPLICATE RACDR

TEST:/u00/app/gghome :TEST$./ggsci


Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 11g on Oct  4 2011 23:49:46


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

GGSCI (TEST.localdomain.com) 1> ADD REPLICAT RACDR, EXTTRAIL ./dirdat/DP,checkpointtable ggsuser.ckpt
REPLICAT added.

GGSCI (TEST.localdomain.com) 2> edit params RACDR
REPLICAT RACDR
SETENV (ORACLE_HOME = "/u00/app/oracle/product/11.2.0/db_1")
SETENV (ORACLE_SID = "TEST")
--Assume DDL of Source.
ASSUMETARGETDEFS
USERID ggsuser, PASSWORD Summer2011
DISCARDFILE ./dirrpt/RACDR.dsc, append, megabytes 100
--DLL replication. 
DDL INCLUDE ALL
--DML replication from TEST schema to TEST schema. 
MAP TEST.*, TARGET TEST.*;

9). Start replicate on target.

GGSCI (TEST.localdomain.com) 3> start racdr

Sending START request to MANAGER ...
REPLICAT RACDR starting

----Output from tail -f ggserr.log at time of starting Replicate


2012-06-17 14:31:17  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start racdr.
2012-06-17 14:31:17  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 192.168.100.101 (START REPLICAT RACDR ).
2012-06-17 14:31:17  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT RACDR starting.
2012-06-17 14:31:17  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, racdr.prm:  REPLICAT RACDR starting.
2012-06-17 14:31:17  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, racdr.prm:  REPLICAT RACDR started.


GGSCI (TEST.localdomain.com) 4> info all


Program     Status      Group       Lag           Time Since Chkpt


MANAGER     RUNNING
REPLICAT    RUNNING     RACDR       00:00:00      00:00:01

GGSCI (TEST.localdomain.com) 5> exit

10). Confirm Goldengate connection on Source DB & ASM and Target DB.

-----Goldengate Connection on Source DB

RACD2@:/u01/app/oracle/product/11.2.0/db_1/network/admin :DEVDB2$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 17 17:36:53 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options


set lines 170
col machine for a25
COL USERNAME FOR A10
SELECT USERNAME,INST_ID,PROGRAM,machine,process from gv$session WHERE PROGRAM LIKE 'extract%';
USERNAME      INST_ID PROGRAM                                          MACHINE                   PROCESS
---------- ---------- ------------------------------------------------ ------------------------- ------------------------
GGSUSER             1 extract@RACD1.localdomain.com (TNS V1-V3)        RACD1.localdomain.com     7650
GGSUSER             1 extract@RACD1.localdomain.com (TNS V1-V3)        RACD1.localdomain.com     7650
GGSUSER             1 extract@RACD1.localdomain.com (TNS V1-V3)        RACD1.localdomain.com     7889
GGSUSER             1 extract@RACD1.localdomain.com (TNS V1-V3)        RACD1.localdomain.com     7650

-----Goldengate Connection on Source ASM

RACD2@:/u01/app/oracle/product/11.2.0/db_1/network/admin :+ASM2 $orasql

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 17 19:03:26 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
set lines 170
col machine for a25
COL USERNAME FOR A10
SELECT USERNAME,INST_ID,PROGRAM,machine,process from gv$session WHERE PROGRAM LIKE 'extract%';
USERNAME      INST_ID PROGRAM                                          MACHINE                   PROCESS
---------- ---------- ------------------------------------------------ ------------------------- ------------------------
SYS                 2 extract@RACD1.localdomain.com (TNS V1-V3)        RACD1.localdomain.com     7650
SYS                 2 extract@RACD1.localdomain.com (TNS V1-V3)        RACD1.localdomain.com     7650

----Goldengate connection on Target DB

SELECT USERNAME,INST_ID,PROGRAM,machine,process from gv$session WHERE PROGRAM LIKE 'replicat%';
USERNAME                INST_ID PROGRAM                                          MACHINE                   PROCESS
---------- -------------------- ------------------------------------------------ ------------------------- ------------------------
GGSUSER                       1 replicat@TEST.localdomain.com (TNS V1-V3)        TEST.localdomain.com      3875

11. Test Replication.
////////////////////////////////////////////////////////////////
DDL+DML replication Test
////////////////////////////////////////////////////////////////


ON NODE2. Create Table & Insert few records.

RACD2@:/u01/app/oracle/product/11.2.0/db_1/network/admin :DEVDB2 $sqlplus / as sysdba


SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 17 17:36:53 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

create table TEST.INFORMATION(
  ID                 VARCHAR2(4 BYTE)         NOT NULL,
  First_Name         VARCHAR2(10 BYTE),
  4    Last_Name          VARCHAR2(10 BYTE),
  Start_Date         DATE,
  End_Date           DATE,
  Salary             Number(8,2),
  City               VARCHAR2(10 BYTE),
  Description        VARCHAR2(15 BYTE)
)
/


insert into TEST.INFORMATION(ID,  First_Name, Last_Name, Start_Date,                     End_Date,                       Salary,  City,       Description)
                values ('01','Jason',    'Martin',  to_date('19960725','YYYYMMDD'), to_date('20060725','YYYYMMDD'), 1234.56, 'Toronto',  'Programmer')
/
insert into TEST.INFORMATION(ID,  First_Name, Last_Name, Start_Date,                     End_Date,                       Salary,  City,       Description)
              values('02','Alison',   'Mathews', to_date('19760321','YYYYMMDD'), to_date('19860221','YYYYMMDD'), 6661.78, 'Vancouver','Tester')
/
insert into TEST.INFORMATION(ID,  First_Name, Last_Name, Start_Date,                     End_Date,                       Salary,  City,       Description)
              values('03','James',    'Smith',   to_date('19781212','YYYYMMDD'), to_date('19900315','YYYYMMDD'), 6544.78, 'Vancouver','Tester')
/
insert into TEST.INFORMATION(ID,  First_Name, Last_Name, Start_Date,                     End_Date,                       Salary,  City,       Description)
              values('04','Celia',    'Rice',    to_date('19821024','YYYYMMDD'), to_date('19990421','YYYYMMDD'), 2344.78, 'Vancouver','Manager')
/
insert into TEST.INFORMATION(ID,  First_Name, Last_Name, Start_Date,                     End_Date,                       Salary,  City,       Description)
              values('05','Robert',   'Black',   to_date('19840115','YYYYMMDD'), to_date('19980808','YYYYMMDD'), 2334.78, 'Vancouver','Tester')
/
insert into TEST.INFORMATION(ID,  First_Name, Last_Name, Start_Date,                     End_Date,                       Salary, City,        Description)
              values('06','Linda',    'Green',   to_date('19870730','YYYYMMDD'), to_date('19960104','YYYYMMDD'), 4322.78,'New York',  'Tester')
/
insert into TEST.INFORMATION(ID,  First_Name, Last_Name, Start_Date,                     End_Date,                       Salary, City,        Description)
              values('07','David',    'Larry',   to_date('19901231','YYYYMMDD'), to_date('19980212','YYYYMMDD'), 7897.78,'New York',  'Manager')
/
insert into TEST.INFORMATION(ID,  First_Name, Last_Name, Start_Date,                     End_Date,                       Salary, City,        Description)
              values('08','James',    'Cat',     to_date('19960917','YYYYMMDD'), to_date('20020415','YYYYMMDD'), 1232.78,'Vancouver', 'Tester')
COMMIT;



SELECT * FROM TEST.INFORMATION


ID   FIRST_NAME LAST_NAME  START_DAT END_DATE      SALARY CITY       DESCRIPTION
---- ---------- ---------- --------- --------- ---------- ---------- ---------------
01   Jason      Martin     25-JUL-96 25-JUL-06    1234.56 Toronto    Programmer
02   Alison     Mathews    21-MAR-76 21-FEB-86    6661.78 Vancouver  Tester
03   James      Smith      12-DEC-78 15-MAR-90    6544.78 Vancouver  Tester
04   Celia      Rice       24-OCT-82 21-APR-99    2344.78 Vancouver  Manager
05   Robert     Black      15-JAN-84 08-AUG-98    2334.78 Vancouver  Tester
06   Linda      Green      30-JUL-87 04-JAN-96    4322.78 New York   Tester
07   David      Larry      31-DEC-90 12-FEB-98    7897.78 New York   Manager
08   James      Cat        17-SEP-96 15-APR-02    1232.78 Vancouver  Tester



---Output from Source ggserr.log

2012-06-17 17:42:28  WARNING OGG-00869  Oracle GoldenGate Capture for Oracle, racde.prm:  No unique key is defined for table INFORMATION. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.

---Confirm on Target side.

SELECT * FROM TEST.INFORMATION


ID   FIRST_NAME LAST_NAME  START_DAT END_DATE                SALARY CITY       DESCRIPTION
---- ---------- ---------- --------- --------- -------------------- ---------- ---------------
01   Jason      Martin     25-JUL-96 25-JUL-06              1234.56 Toronto    Programmer
02   Alison     Mathews    21-MAR-76 21-FEB-86              6661.78 Vancouver  Tester
03   James      Smith      12-DEC-78 15-MAR-90              6544.78 Vancouver  Tester
04   Celia      Rice       24-OCT-82 21-APR-99              2344.78 Vancouver  Manager
05   Robert     Black      15-JAN-84 08-AUG-98              2334.78 Vancouver  Tester
06   Linda      Green      30-JUL-87 04-JAN-96              4322.78 New York   Tester
07   David      Larry      31-DEC-90 12-FEB-98              7897.78 New York   Manager
08   James      Cat        17-SEP-96 15-APR-02              1232.78 Vancouver  Tester


---Output from Target ggserr.log

2012-06-17 14:42:24  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, racdr.prm:  Setting current schema for DDL operation to [SYS].
2012-06-17 14:42:29  INFO    OGG-01408  Oracle GoldenGate Delivery for Oracle, racdr.prm:  Restoring current schema for DDL operation to [GGSUSER].
2012-06-17 14:42:39  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, racdr.prm:  No unique key is defined for table INFORMATION. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.

Golden Gate on ASM

I  also wrote latest post  Goldengate on ASM / RAC  , which is step by step configuration of GG on Grid Infrastructure.


Create the parameter file for the Primary Extract group

Its setup for 2 Node RAC , THREADS will be 2.

ggsci>>ADD EXTRACT E_X, TRANLOG, THREADS 2, BEGIN NOW
ggsci>>ADD EXTTRAIL /u01/ggate/TRAIL/ts, EXTRACT E_X

ggsci>>edit params ./GLOBALS
GGSCHEMA GGS
CHECKPOINTTABLE GGS.CKPT

ggsci>>DBLOGIN USERID ggs, PASSWORD test
ADD CHECKPOINTTABLE GGS.CKPT

sqlplus / as sysdba
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER SYSTEM SWITCH LOGFILE;

Configure tnsentry as +ASM alias and password file.

ggsci>>edit params E_X
SETENV (ORACLE_SID=abc)
USERID ggsuser, PASSWORD ggs_tmp1
EXTTRAIL /u01/ggate/TRAIL/ts
DISCARDFILE ./dirout/E_X.dsc, APPEND, MEGABYTES 10
TRANLOGOPTIONS ASMUSER SYS@+ASM, ASMPASSWORD system
--GETTRUNCATES
DYNAMICRESOLUTION
--TRANLOGOPTIONS FETCHCHAINEDUPDATES
ddl include mapped objname xxx.*;
TABLE xxx.*;
TABLEEXCLUDE xxx.USER_ACTIVITY_TRACE;

Create the parameter file for the Data pump group

ggsci>>ADD EXTRACT P_x,EXTTRAILSOURCE /u01/ggate/TRAIL/ts
ggsci>>ADD RMTTRAIL /u01/ggate/TRAIL/rs, EXTRACT P_x

ggsci>>edit params p_x
userid ggs, password test
rmthost 192.168.1.72, mgrport 7809
rmttrail /u01/ggate/TRAIL/rs
PASSTHRU
--GETTRUNCATES
DYNAMICRESOLUTION
ddl include mapped objname xxx.*;
TABLE xxx.*;

===================================================
ON TARGET SYSTEM
===================================================
Create the parameter file for the replicate group

ggsci>>EDIT PARAMS ./GLOBALS
GGSCHEMA GGS
CHECKPOINTTABLE GGS.CKPT

ggsci>>DBLOGIN USERID ggs, PASSWORD test
ADD CHECKPOINTTABLE GGS.CKPT

sqlplus / as sysdba

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER SYSTEM SWITCH LOGFILE;

ggsci>>ADD REPLICAT R_x,EXTTRAIL /u01/ggate/TRAIL/rs, CHECKPOINTTABLE GGS.CKPT

ggsci>>EDIT PARAMS r_x
REPLICAT R_x
ASSUMETARGETDEFS
userid ggs, password test
DDL
MAP xxx.*, TARGET xxx.*;

ON SOURCE

START EXTRACT E_X
START EXTRACT P_x

ggsci>>info all

make sure every process is running

ON TARGET SYSTEM

START REPLICAT R_x
STATUS REPLICAT R_x

make sure every process is running

---------------------
The best Drill down
---------------------

tail -f ggserr.log