GoldenGate synchronizes Oracle Data to GreenPlum

GoldenGate synchronizes Oracle Data to GreenPlum

Source end
Oracle 11.2.0.4 RAC 2-Nodes
Oracle Linux 5.8 x86_64
 
Oracle GoldenGate V11.1.1.0.0 for Oracle 11g on Linux x86-64.zip

Oracle GoldenGate V11.1.1.0.0 For FlatFile on Linux 64-bit for OGG v11.1.1.0.0.zip

Target end
Greenplum Database 4.2.6.1 4-Nodes
 
CentOS 5.7 x86_64

Oracle GoldenGate V11.1.1.0.0 for Oracle 11g on Linux x86-64.zip

Oracle GoldenGate V11.1.1.0.0 For FlatFile on Linux 64-bit for OGG v11.1.1.0.0.zip

-------------------------------------- Split line --------------------------------------

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

-------------------------------------- Split line --------------------------------------

Source Configuration
 

-- In this example, OGG is installed on ACFS shared storage to facilitate switching between RAC node failure OGG.
-- ACFS Information
[Root @ vzwc1 ~] # Acfsutil info fs
/Ggs
ACFS Version: 11.2.0.4.0
Flags: MountPoint, Available
Mount time: Sat Feb 15 14:33:22 2014
Volumes: 1
Total size: 8589934592
Total free: 8453541888
Primary volume: // dev/asm/ggs-11
Label:
Flags: Primary, Available, ADVM
On-disk version 39.0
Allocation unit: 4096
Major, min or: 252,563 3
Size: 8589934592
Free: 8453541888
ADVM diskgroup OGGDG
ADVM resize increment: 33554432
ADVM redundancy: mirror
ADVM stripe columns: 4
ADVM stripe width: 131072
Number of snapshots: 0
Snapshot space usage: 0
Replication status: DISABLED
[Root @ vzwc1 ~] #
[Root @ vzwc1 ~] # Df-Th
Filesystem Type Size Used Avail Use % Mounted on
/Dev/mapper/VolGroup00-LogVol00
Ext3 44G 15G 28G 35%/
/Dev/sda1 ext3 99 M 24 M 71 M 25%/boot
Tmpfs 1.5G 944 M 564 M 63%/dev/shm
// Dev/asm/ggs-11
Acfs 8.0G 131 M 7.9G 2%/ggs



-- Source RAC Information
[Root @ vzwc1 ~] # Crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]
[Root @ vzwc1 ~] # Crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.4.0]
[Root @ vzwc1 ~] # Crsctl query crs softwareversion-all
Oracle Clusterware version on node [vzwc1] is [11.2.0.4.0]
Oracle Clusterware version on node [vzwc2] is [11.2.0.4.0]
[Root @ vzwc1 ~] #
[Root @ vzwc1 ~] # Crsctl stat res-t
--------------------------------------------------------------------------------
Name target state server STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
Ora. CRSDG. dg
ONLINE vzwc1
ONLINE vzwc2
Ora. DATADG. dg
ONLINE vzwc1
ONLINE vzwc2
Ora. FRADG. dg
ONLINE vzwc1
ONLINE vzwc2
Ora. LISTENER. lsnr
ONLINE vzwc1
ONLINE vzwc2
Ora. OGGDG. dg
ONLINE vzwc1
ONLINE vzwc2
Ora. SYSDG. dg
ONLINE vzwc1
ONLINE vzwc2
Ora. asm
ONLINE vzwc1 Started
ONLINE vzwc2 Started
Ora. gsd
OFFLINE vzwc1
OFFLINE vzwc2
Ora. net1.network
ONLINE vzwc1
ONLINE vzwc2
Ora. ons
ONLINE vzwc1
ONLINE vzwc2
Ora. registry. acfs
ONLINE vzwc1
ONLINE vzwc2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
Ora. LISTENER_SCAN1.lsnr
1 ONLINE vzwc1
Ora. cvu
1 ONLINE vzwc1
Ora. productname
1 ONLINE vzwc1
Ora. scan1.vip
1 ONLINE vzwc1
Ora. vzwc1.vip
1 ONLINE vzwc1
Ora. vzwc2.vip
1 ONLINE vzwc2
Ora. zwc. db
1 ONLINE vzwc1 Open
2 ONLINE vzwc2 Open



-- Configure oracle user environment variables and add OGG Configuration
[Oracle @ vzwc1 ~] $ Cat. bash_profile
#. Bash_profile
 

# Get the aliases and functions
If [-f ~ /. Bashrc]; then
.~ /. Bashrc
Fi
 

# User specific environment and startup programs
 

PATH = $ PATH: $ HOME/bin
 

Export PATH
 

Alias ls = "ls-FA"
GG_HOME =/ggs/ogg; export GG_HOME
ORACLE_SID = zwc1; export ORACLE_SID
ORACLE_UNQNAME = zwc; export ORACLE_UNQNAME
JAVA_HOME =/usr/local/java; export JAVA_HOME
ORACLE_BASE =/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_PATH =/u01/app/common/oracle/SQL; export ORACLE_PATH
TNS_ADMIN = $ ORACLE_HOME/network/admin; export TNS_ADMIN
ORA_NLS11 = $ ORACLE_HOME/nls/data; export ORA_NLS11
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG
PATH =. :$ {JAVA_HOME}/bin :$ {PATH }:$ HOME/bin: $ ORACLE_HOME/OPatch: $ GG_HOME
PATH =$ {PATH }:/ usr/bin:/usr/bin/X11:/usr/local/bin
PATH =$ {PATH}:/u01/app/common/oracle/bin
Export PATH
LD_LIBRARY_PATH = $ ORACLE_HOME/lib: $ GG_HOME
LD_LIBRARY_PATH =$ {LD_LIBRARY_PATH}: $ ORACLE_HOME/mongom/lib
LD_LIBRARY_PATH =$ {LD_LIBRARY_PATH}:/lib:/usr/local/lib
Export LD_LIBRARY_PATH
CLASSPATH = $ ORACLE_HOME/JRE
CLASSPATH =$ {CLASSPATH}: $ ORACLE_HOME/jlib
CLASSPATH =$ {CLASSPATH}: $ ORACLE_HOME/rdbms/jlib
CLASSPATH =$ {CLASSPATH}: $ ORACLE_HOME/network/jlib
Export CLASSPATH
THREADS_FLAG = native; export THREADS_FLAG
Export TEMP =/tmp
Export TMPDIR =/tmp
Umask 022
 

Alias sqlplus = "rlwrap sqlplus"
Alias rman = "rlwrap rman"

For more details, please continue to read the highlights on the next page:

1 2 3 4 Next Page