Hello,
I am having 2 machines :-
1) Linux - Oracle 11g - GoldenGate 11g - with 2 DB's on it - We are going to use only one i.e. DB name - "SOURCE".
2) Windows xp - Oracle 11g - GoldenGate 11g - with 2 DB's on it - We are going to use only one i.e. DB name - "REPLICA"
My major concern is that if both the machines are having more than one DB, then how will it understand that from which db's schema he has to extract & replicate the data ? Also the OS for both the machine is different, will it be any issue ?
I want to extract data from EMP table of SCOTT user from SOURCE db & replicate it to EMP table of SCOTT user of REPLICA db.
Below is the extract load1 file from SOURCE :-
EXTRACT load1
USERID ggs_owner,PASSWORD ggs_owner
RMTHOST IFLMUd5HP04W9,MGRPORT 7809
RMTTASK replicat,GROUP load2
TABLE scott.emp;
Below is the load2 file from the REPLICA db :-
REPLICAT load2
USERID ggs_owner,PASSWORD ggs_owner
ASSUMETARGETDEFS
MAP scott.emp,TARGET scott.emp;
When i started the extract process by the following command :-
GGSCI (iflmud5im0087) 3> start extract load1
Sending START request to MANAGER ...
EXTRACT LOAD1 starting
GGSCI (iflmud5im0087) 4> info extract load1
EXTRACT LOAD1 Initialized 2011-09-02 19:45 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Not Available
First Record Record 0
Task SOURCEISTABLE
The view report of the load1 is as follows :-
2011-09-06 17:00:52 INFO OGG-01017 Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.1.1.1 OGGCORE_11.1.1_PLATFORMS_110421.2040
Linux, x64, 64bit (optimized), Oracle 11g on Apr 30 2011 18:52:51
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2011-09-06 17:00:52
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Mon Mar 29 22:10:29 EDT 2010, Release 2.6.18-194.el5
Node: iflmud5im0087.i-flex.com
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 7576
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
EXTRACT load1
USERID ggs_owner,PASSWORD *********
RMTHOST IFLMUd5HP04W9,MGRPORT 7809
RMTTASK replicat,GROUP load2
TABLE scott.emp;
Using the following key columns for source table SCOTT.EMP: EMPNO.
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 8G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 16G
CACHESIZEMAX (strict force to disk): 13.99G
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Database Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will be used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
2011-09-06 17:00:52 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2011-09-06 17:01:02 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2011-09-06 17:01:12 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2011-09-06 17:01:22 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2011-09-06 17:01:32 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2011-09-06 17:01:42 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
Please suggest how can i transfer the data from one db to other using golden gate. I am referring Gavin Soorma blog's for implementing golden gate.
Thanks in advance .