Install GoldenGate 10.4.0 on Unix

Posted on April 20, 2010 by Jianming Li

Contents

  1. Download GoldenGate
    1. From Oracle GoldenGate Download
    2. From eDelivery
  2. Setup Environment Variables
    1. Set ORACLE_HOME and ORACLE_SID
    2. Setup PATH and LD_LIBRARY_PATH
  3. Install GoldenGate
    1. Unpack Download
    2. Example
    3. Create Subdirectories
    4. Configure Manager Port
    5. Start Manager
    6. Stop Manager
  4. Prepare Database
    1. Enable Supplemental Log
  5. Issues
    1. Error Loading Shared Libraries
    2. cannot restore segment prot after reloc
 

Download GoldenGate

From Oracle GoldenGate Download

* Go to Oracle GoldenGate Download site.

From eDelivery

Download GoldenGate from Oracle edelivery site under Oracle Fusion Middleware product pack. For example, to download GoldenGate 10.4.0/Solaris 10 Sparc/Oracle 10g:
* Select Product pack: Oracle Fusion Middleware.
* Select Platform: Oracle Solaris on SPARC (64bit).
* Click “Go” button.
* Select “Oracle GoldenGate on Oracle Media Pack for Sun Solaris”.
* Click “Download” button next to “Oracle GoldenGate V10.4.0.x for Oracle 10g 64bit on Solaris 10”.
* V18148-01.zip will be downloaded.

Setup Environment Variables

Set ORACLE_HOME and ORACLE_SID

* If only one instance of Oracle is running, set ORACLE_HOME and ORACLE_SID to that instance.
* If multiple instances of Oracle is running, then set ORACLE_HOME and ORACLE_SID to desired instance in process parameter files.

SETENV (ORACLE_HOME = "orahome")
SETENV (ORACLE_SID = "mysid")

Setup PATH and LD_LIBRARY_PATH

 
GG_HOME=/goldengate; export GG_HOME
PATH=$GG_HOME:$PATH; export PATH
LD_LIBRARY_PATH=$GG_HOME:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH

Install GoldenGate

Unpack Download

* Copy GoldenGate download to target machine.
* Unzip download.
* Create a new directory to host GoldenGate.
* cd to the new directory and untar the unzip tar ball.

Example

 
# Downloaded file
ls
V18148-01.zip
 
# Unzip
$JAVA_HOME/bin/jar xvf V18148-01.zip
# We get
ls
V18148-01.zip
ggs_solaris10_sparc_ora10g_64bit_v10.4.0.19_002.tar
 
# Make a new directory
mkdir goldengate104
 
# Untar
cd goldengate104
tar xvf ggs_solaris10_sparc_ora10g_64bit_v10.4.0.19_002.tar

Create Subdirectories

 
cd $GG_HOME
$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Solaris, sparc, 64bit (optimized), Oracle 10 on Sep 23 2009 15:19:42
 
Copyright (C) 1995, 2009, Oracle and/or its affiliates.  All rights reserved.
GGSCI 1> CREATE SUBDIRS
 
Creating subdirectories under current directory /goldengate
 
Parameter files                /goldengate/dirprm: created
Report files                   /goldengate/dirrpt: created
Checkpoint files               /goldengate/dirchk: created
Process status files           /goldengate/dirpcs: created
SQL script files               /goldengate/dirsql: created
Database definitions files     /goldengate/dirdef: created
Extract data files             /goldengate/dirdat: created
Temporary files                /goldengate/dirtmp: created
Veridata files                 /goldengate/dirver: created
Veridata Lock files            /goldengate/dirver/lock: created
Veridata Out-Of-Sync files     /goldengate/dirver/oos: created
Veridata Out-Of-Sync XML files /goldengate/dirver/oosxml: created
Veridata Parameter files       /goldengate/dirver/params: created
Veridata Report files          /goldengate/dirver/report: created
Veridata Status files          /goldengate/dirver/status: created
Veridata Trace files           /goldengate/dirver/trace: created
Stdout files                   /goldengate/dirout: created

Configure Manager Port

 
GGSCI 3> EDIT PARAMS MGR
# Manager listening on port 7809
PORT 7809
# Additional params
# DYNAMICPORTLIST {<port> | <port>-<port>} [, ...]
# DYNAMICPORTREASSIGNDELAY <seconds>
AUTORESTART {ER | EXTRACT | REPLICAT} {group name | wildcard}
[, RETRIES <max retries>]
[, WAITMINUTES <wait minutes>]
[, RESETMINUTES <reset minutes>]
# PURGEOLDEXTRACTS

Start Manager

* From shell command line:

mgr paramfile <param file> [reportfile <report file>]

* From ggsci:

START MANAGER

Stop Manager

 
STOP MANAGER [!]

Prepare Database

Enable Supplemental Log

* Login as sysdba and run following SQL statements:

-- Enable supplemental logging
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
 
-- Swith log to start supplemental logging
ALTER SYSTEM SWITCH LOGFILE;
 
-- Verify supplemental logging is enabled (with a result of 'YES')
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;

Issues

Error Loading Shared Libraries

* Error message:

./ggsci: error while loading shared libraries: libnnz10.so: cannot open shared object file: No such file or directory

* Solution: add $ORACLE_HOME/lib to LD_LIBRARY_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

cannot restore segment prot after reloc

* Environment: SELinux
* Error message:

error while loading shared libraries: cannot restore segment prot after reloc: Permission denied

* Solutions: login as root and turn off SELinux

setenforce 0
This entry was posted in goldengate and tagged , , . Bookmark the permalink.