Monday, 14 July 2014

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




Post a Comment