Golden Gate 12c Apply Patch 21913095

Stage Patch

1.      Download January Security Patch 2016

Path # 21913095

2.      Put downloaded patch into software staging location

Example staging location on server: /u01/app/oracle/software/gg_121210

Example:

[2016-02-02 14:04.54]  /drives/y/Database Administration/Patches/GG_Jan2016

[mmessina.JXWPRDVDS20] → scp * agodevorl03:/u01/app/oracle/software/gg_121210

### This system is for authorized users only.

mmessina@agodevorl03's password:

p21913095_1212110_Linux-x86-64.zip                                                         100%  130MB   4.1MB/s   00:32

                                           

3.      Login to the server to apply Golden Gate Patch on and get to the oracle account.

ssh servername

sudo su – oracle

4.      Goto the location where the Golden Gate Patch is staged

cd /u01/app/oracle/software/gg_121210

5.      Unzip the Golden Gate Patch

unzip p21913095_1212110_Linux-x86-64.zip                                                        

6.  Ensure Golden Gate Home is in the /etc/oratab

Example:

vi /ec/oratab

ggs:/ggs:N

Update OPatch to Latest Version

1.  Download latest version of OPatch  *** THIS MUST BE THE LATEST 11.2.0.3 OPatch

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=224346.1

2.      Stage latest version of Opatch on server where you staged the Golden Gate Patch

Example:

[2016-02-02 14:24.56]  /drives/y/Database Administration/Patches/GG_Jan2016

[mmessina.JXWPRDVDS20] → scp p6880880_121010_Linux-x86-64.zip agodevorl03:/u01/app/oracle/software/gg_121210

### This system is for authorized users only.

mmessina@agodevorl03's password:

p6880880_112000_Linux-x86-64.zip                                                           100%   50MB   4.2MB/s   00:12

3.      Login to the server and get to the Oracle account where OPatch is staged

ssh servername

sudo su – oracle

4.      Go to the stage location and unsip OPatch

cd /u01/app/oracle/software/gg-121210

unzip p6880880_112000_Linux-x86-64.zip                                                          

5.      Update OPatch for the Golden Gate Home Directory

sudo su – oracle

. oraenv

ggs

cd $ORACLE_HOME

cd OPatch

./OPatch version

rm –rf *

cp –r /u01/app/oracle/software/gg-121210/OPatch/* ./                                              

./opatch version

Apply Golden Gate Patch

1.      Login to the server to be patched and goto the oracle account

ssh servername

sudo su – oracle

2.      Shutdown all running golden gate processes

. oraenv

defdb

cd /ggs

./ggsci

stop *

stop jagent

stop mgr

3.      Check the Golden Gate Home is set to ORACLE_HOME

. oraenv

ggs

echo $ORACLE_HOME

/ggs

4.      Ensure the OPatch location in the Golden Gate Home is in the path

export PATH=$ORACLE_HOME/OPatch:$PATH

which opatch

5.      Goto the Golden Gate January 2016 unzipped location

cd /u01/app/oracle/software/gg-121210/21913095

6.      Apply the patch

opatch apply

7.      Check patch applied ok

opatch lsinventory

8.      Restart all Golden Gate Processes

. oraenv

defdb  -- local database Golden Gate is running for

cd /ggs

./ggsci

start mgr

start jagent     -- May not apply to all environments

start *

9.      Check that all Golden Gate Processes are back running

. oraenv

defdb

./ggsci

info all