Upgradation Of GoldenGate Version

From version     : 11.2.1.0.3

To Version          : 11.2.1.0.8

OS version          : Linux_x64

(Download the GoldenGate Patch from support.oracle.com)

Step 1: Go to Goldengate Home Directory

[oracle:sukumar:/app/oracle]$ cd /app/oracle/product/ggate

Step 2: Unzip the patch file, which populates the tar file.

 [oracle:sukumar:/app/oracle/product/ggate]$ ls -lrt *.zip

-rwxr-xr-x 1 oracle oinstall 88475139 Jul 13 06:47 p17011917_112108_Linux-x86-64.zip

[oracle:sukumar:/app/oracle/product/ggate]$ unzip p17011917_112108_Linux-x86-64.zip

Archive:  p17011917_112108_Linux-x86-64.zip

  inflating: fbo_ggs_Linux_x64_ora11g_64bit.tar

  inflating: Oracle-GoldenGate-11.2.1.0.8-README.txt

  inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.8.pdf

[oracle:sukumar:/app/oracle/product/ggate]$ ls -lrt *.tar

-rw-rw-r-- 1 oracle oinstall 227624960 Jul 18  2013 fbo_ggs_Linux_x64_ora11g_64bit.tar

Step 3 : Make sure to stop all the Goldengate process.

[oracle:sukumar:/app/oracle/product/ggate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21

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

GGSCI (sukumar) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXT1      00:00:00      00:00:06

EXTRACT     RUNNING     EXT2      00:00:00      00:00:07

EXTRACT     RUNNING     PUMP1     00:00:00      00:00:07

EXTRACT     RUNNING     PUMP2     00:00:00      00:00:02

GGSCI (sukumar) 2> stop *

Sending STOP request to EXTRACT EXT1 ...

Request processed.

Sending STOP request to EXTRACT EXT2 ...

Request processed.

Sending STOP request to EXTRACT PUMP1 ...

Request processed.

Sending STOP request to EXTRACT PUMP2 ...

Request processed.

GGSCI (sukumar) 3> stop manager

Manager process is required by other GGS processes.

Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER ...

Request processed.

Manager stopped.

Step 4: Un Tar the TAR file under Goldengate home directory

[oracle:sukumar:/app/oracle/product/ggate]$ ls -lrt *.tar

-rw-rw-r-- 1 oracle oinstall 227624960 Jul 18  2013 fbo_ggs_Linux_x64_ora11g_64bit.tar

[oracle:sukumar:/app/oracle/product/ggate]$ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar

UserExitExamples/

UserExitExamples/ExitDemo_more_recs/

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX

UserExitExamples/ExitDemo_more_recs/readme.txt

UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c

UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX

UserExitExamples/ExitDemo_pk_befores/

UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX

UserExitExamples/ExitDemo_pk_befores/readme.txt

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX

UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX

UserExitExamples/ExitDemo_lobs/

UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS

UserExitExamples/ExitDemo_lobs/exitdemo_lob.c

UserExitExamples/ExitDemo_lobs/readme.txt

UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX

UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX

UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX

UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj

UserExitExamples/ExitDemo/

UserExitExamples/ExitDemo/exitdemo.vcproj

UserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSS

UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX

UserExitExamples/ExitDemo/exitdemo_utf16.c

UserExitExamples/ExitDemo/exitdemo.c

UserExitExamples/ExitDemo/readme.txt

UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX

UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS

UserExitExamples/ExitDemo/Makefile_exit_demo.AIX

UserExitExamples/ExitDemo_passthru/

UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX

UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX

UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX

UserExitExamples/ExitDemo_passthru/readme.txt

UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS

UserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSS

UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c

UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj

bcpfmt.tpl

bcrypt.txt

cfg/

cfg/Config.properties

cfg/mpmetadata.xml

cfg/MPMetadataSchema.xsd

cfg/password.properties

cfg/jps-config-jse.xml

cfg/ProfileConfig.xml

chkpt_ora_create.sql

cobgen

convchk

db2cntl.tpl

ddl_cleartrace.sql

ddl_create.sql

ddl_ddl2file.sql

ddl_disable.sql

ddl_enable.sql

ddl_filter.sql

ddl_ora10.sql

ddl_ora10upCommon.sql

ddl_ora11.sql

ddl_ora9.sql

ddl_pin.sql

ddl_remove.sql

ddl_session.sql

ddl_session1.sql

ddl_setup.sql

ddl_status.sql

ddl_staymetadata_off.sql

ddl_staymetadata_on.sql

ddl_trace_off.sql

ddl_trace_on.sql

ddl_tracelevel.sql

ddlcob

defgen

demo_more_ora_create.sql

demo_more_ora_insert.sql

demo_ora_create.sql

demo_ora_insert.sql

demo_ora_lob_create.sql

demo_ora_misc.sql

demo_ora_pk_befores_create.sql

demo_ora_pk_befores_insert.sql

demo_ora_pk_befores_updates.sql

dirjar/

dirjar/spring-security-core-3.0.1.RELEASE.jar

dirjar/jmxremote_optional-1.0-b02.jar

dirjar/org.springframework.core-3.0.0.RELEASE.jar

dirjar/org.springframework.aspects-3.0.0.RELEASE.jar

dirjar/xmlparserv2.jar

dirjar/org.springframework.context-3.0.0.RELEASE.jar

dirjar/jps-patching.jar

dirjar/monitor-common.jar

dirjar/osdt_cert.jar

dirjar/org.springframework.context.support-3.0.0.RELEASE.jar

dirjar/log4j-1.2.15.jar

dirjar/org.springframework.web-3.0.0.RELEASE.jar

dirjar/commons-logging-1.0.4.jar

dirjar/osdt_xmlsec.jar

dirjar/org.springframework.jdbc-3.0.0.RELEASE.jar

dirjar/jps-mbeans.jar

dirjar/jagent.jar

dirjar/org.springframework.asm-3.0.0.RELEASE.jar

dirjar/osdt_core.jar

dirjar/jps-manifest.jar

dirjar/identitystore.jar

dirjar/jsr250-api-1.0.jar

dirjar/jps-common.jar

dirjar/jps-upgrade.jar

dirjar/xpp3_min-1.1.4c.jar

dirjar/org.springframework.transaction-3.0.0.RELEASE.jar

dirjar/org.springframework.instrument-3.0.0.RELEASE.jar

dirjar/jps-unsupported-api.jar

dirjar/fmw_audit.jar

dirjar/org.springframework.beans-3.0.0.RELEASE.jar

dirjar/spring-security-web-3.0.1.RELEASE.jar

dirjar/jps-api.jar

dirjar/jps-internal.jar

dirjar/spring-security-taglibs-3.0.1.RELEASE.jar

dirjar/slf4j-api-1.4.3.jar

dirjar/spring-security-config-3.0.1.RELEASE.jar

dirjar/ldapjclnt11.jar

dirjar/jps-ee.jar

dirjar/xstream-1.3.jar

dirjar/spring-security-acl-3.0.1.RELEASE.jar

dirjar/commons-codec-1.3.jar

dirjar/spring-security-cas-client-3.0.1.RELEASE.jar

dirjar/jps-wls.jar

dirjar/jacc-spi.jar

dirjar/org.springframework.orm-3.0.0.RELEASE.jar

dirjar/org.springframework.expression-3.0.0.RELEASE.jar

dirjar/oraclepki.jar

dirjar/identityutils.jar

dirjar/org.springframework.test-3.0.0.RELEASE.jar

dirjar/slf4j-log4j12-1.4.3.jar

dirjar/jdmkrt-1.0-b02.jar

dirjar/org.springframework.aop-3.0.0.RELEASE.jar

dirprm/

dirprm/jagent.prm

emsclnt

extract

freeBSD.txt

ggMessage.dat

ggcmd

ggsci

help.txt

jagent.sh

keygen

libantlr3c.so

libdb-5.2.so

libgglog.so

libggrepo.so

libicudata.so.38

libicui18n.so.38

libicuuc.so.38

libxerces-c.so.28

libxml2.txt

logdump

marker_remove.sql

marker_setup.sql

marker_status.sql

mgr

notices.txt

oggerr

params.sql

prvtclkm.plb

pw_agent_util.sh

remove_seq.sql

replicat

retrace

reverse

role_setup.sql

sequence.sql

server

sqlldr.tpl

tcperrs

ucharset.h

ulg.sql

usrdecs.h

zlib.txt

Step 5: We are done with the version upgrade of Goldengate, connect and check the version.

[oracle:sukumar:/app/oracle/product/ggate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.8 17044551 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_130718.0526_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Jul 18 2013 10:34:27

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

GGSCI (sukumar) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED

EXTRACT     STOPPED     EXT1       00:00:00      00:01:41

EXTRACT     STOPPED     EXT2       00:00:00      00:01:41

EXTRACT     STOPPED     PUMP1      00:00:00      00:01:40

EXTRACT     STOPPED     PUMP2      00:00:00      00:01:39

Step 6: Start the manager process followed by all the extract process.

GGSCI (sukumar) 2> start manager

Manager started.

GGSCI (sukumar) 3> start *

Sending START request to MANAGER ...

EXTRACT EXT1 starting

Sending START request to MANAGER ...

EXTRACT EXT2 starting

Sending START request to MANAGER ...

EXTRACT PUMP1 starting

Sending START request to MANAGER ...

EXTRACT PUMP2 starting

GGSCI (sukumar) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXT1        00:00:00      00:01:56

EXTRACT     RUNNING     EXT2        00:00:00      00:00:00

EXTRACT     RUNNING     PUMP1       00:00:00      00:01:55

EXTRACT     RUNNING     PUMP2       00:03:19      00:00:00