How To Patch Oracle Goldengate

Patching Goldengate Binaries - Step by Step

1. change oracle_home to point to gg home directory

export ORACLE_HOME=/ggs/home

verify above change echo $ORACLE_HOME


2. change opatch directory in PATH variable to OPatch in /ggs/home

export PATH=/oracle/ora11g/11gbase/dbhome/bin:/usr/ccs/bin:/usr/bin:/usr/ucb:/usr/bin:/usr/sbin:/ggs/home/OPatch

verify
ora11g@MINNAOPPRDDBS1:/ggs/home$ which opatch
/ggs/home/OPatch/opatch


3. opatch lsinventory should list gg production information and give no errors.

ora11g@MINNAOPPRDDBS1:/ggs/home$ opatch lsinventory
/ggs/home/OPatch/opatch[103]: whereis: not found [No such file or directory]
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /ggs/home
Central Inventory : /oracle/ora11g/oraInventory
   from           : /var/opt/oracle/oraInst.loc  --- BACKUP .LOC FILE BEFORE INSTALLING PATCH ---
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /ggs/home/cfgtoollogs/opatch/opatch2015-02-04_12-43-33PM.log

Lsinventory Output file location : /ggs/home/cfgtoollogs/opatch/lsinv/lsinventory2015-02-04_12-43-33PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle GoldenGate Core                                               12.1.2.1.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------

OPatch succeeded.


4. Navigate to patch_top_directory/patch_number_directory

cd /ggs/home

cd 20417912


5. Fire opatch apply in this directory






################# De-Installation Steps ###################


1. Navigate to patch_top_directory/patch_number_directory

cd /ggs/home

cd 20417912



opatch rollback -id 20417912




#################### opatch apply output ####################

ora11g@MINNAOPPRDDBS1:/ggs/home/20417912$ opatch apply
/ggs/home/OPatch/opatch[103]: whereis: not found [No such file or directory]
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /ggs/home
Central Inventory : /oracle/ora11g/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /ggs/home/cfgtoollogs/opatch/opatch2015-02-04_13-51-18PM.log

Applying interim patch '20417912' to OH '/ggs/home'
Verifying environment and performing prerequisite checks...

Do you want to proceed? [y|n]
y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/ggs/home')

y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/ggs/home')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

Patching component oracle.oggcore.ora11g, 12.1.2.1.0...
Patch 20417912 successfully applied
Log file location: /ggs/home/cfgtoollogs/opatch/opatch2015-02-04_13-51-18PM.log

OPatch succeeded.

######################################################################