DB Patch 19692824 Apply

Patch applying command

[oracle@qpaydb dbhome_1]$ perl -v

[oracle@qpaydb dbhome_1]$ $ORACLE_HOME/OPatch/opatch lsinventory

[oracle@qpaydb orasoft]$ unzip p19692824_112040_Linux-x86-64.zip

[oracle@qpaydb orasoft]$ cd 19692824

[oracle@qpaydb 19692824]$ pwd

/orasoft/19692824

[oracle@qpaydb 19692824]$

[oracle@qpaydb 19692824]$

[oracle@qpaydb 19692824]$ $ORACLE_HOME/OPatch/opatch apply

IMPLEMENT

Step-1: Check Perl 5.00503 or higher installed and configured to ORACLE_HOME.

Last login: Sun Jun  5 12:07:09 2016 from 172.31.1.67

[oracle@qpaydb ~]$

[oracle@qpaydb ~]$ cd $ORACLE_HOME

[oracle@qpaydb dbhome_1]$ perl -v

This is perl 5, version 16, subversion 3 (v5.16.3) built for x86_64-linux-thread-multi

(with 29 registered patches, see perl -V for more detail)

Copyright 1987-2012, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the

GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on

this system using "man perl" or "perldoc perl".  If you have access to the

Internet, point your browser at http://www.perl.org/, the Perl Home Page.

[oracle@qpaydb dbhome_1]$

Step-2: Verify the OUI Inventory.

[oracle@qpaydb dbhome_1]$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.4.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.4.0/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.4

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0.4.0/dbhome_1/cfgtoollogs/opatch/opatch2016-06-05_12-45-37PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.4.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-06-05_12-45-37PM.txt

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

Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.4.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

[oracle@qpaydb dbhome_1]$

[oracle@qpaydb dbhome_1]$

Step-3: Collect/Download requires patch & store in specified location in DB server.

/orasoft

[oracle@qpaydb orasoft]$ ls -ltr p19692824_112040_Linux-x86-64.zip

-rw-r--r-- 1 oracle oinstall 44600 Jun  1 13:37 p19692824_112040_Linux-x86-64.zip

Step-4: unzip patch

[oracle@qpaydb orasoft]$ unzip p19692824_112040_Linux-x86-64.zip

Archive:  p19692824_112040_Linux-x86-64.zip

   creating: 19692824/

   creating: 19692824/custom/

   creating: 19692824/custom/scripts/

  inflating: 19692824/custom/scripts/env_emagent_mk_rollback_19692824.pl

  inflating: 19692824/custom/scripts/post

  inflating: 19692824/custom/scripts/pre

  inflating: 19692824/custom/scripts/env_emagent_mk_install_19692824.pl

   creating: 19692824/etc/

   creating: 19692824/etc/config/

  inflating: 19692824/etc/config/automation.xml

  inflating: 19692824/etc/config/inventory.xml

  inflating: 19692824/etc/config/actions.xml

   creating: 19692824/etc/xml/

  inflating: 19692824/etc/xml/GenericActions.xml

  inflating: 19692824/etc/xml/ShiphomeDirectoryStructure.xml

   creating: 19692824/files/

   creating: 19692824/files/inventory/

   creating: 19692824/files/inventory/Templates/

   creating: 19692824/files/inventory/Templates/sysman/

   creating: 19692824/files/inventory/Templates/sysman/lib/

  inflating: 19692824/files/inventory/Templates/sysman/lib/env_emagent.mk

  inflating: 19692824/README.txt

  inflating: 19692824/emdpatch.pl

[oracle@qpaydb orasoft]$ ls -ltr

Step-5: Apply patch with opatch utility.

[oracle@qpaydb orasoft]$ cd 19692824

[oracle@qpaydb 19692824]$ pwd

/orasoft/19692824

[oracle@qpaydb 19692824]$

[oracle@qpaydb 19692824]$

[oracle@qpaydb 19692824]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.4.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.4.0/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.4

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0.4.0/dbhome_1/cfgtoollogs/opatch/19692824_Jun_05_2016_12_56_15/apply2016-06-05_12-56-15PM_1.log

Applying interim patch '19692824' to OH '/u01/app/oracle/product/11.2.0.4.0/dbhome_1'

Verifying environment and performing prerequisite checks...

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/11.2.0.4.0/dbhome_1')

Is the local system ready for patching? [y|n] y

User Responded with: Y

Backing up files...

Successfully applied the fix for bug 19692824 to /u01/app/oracle/product/11.2.0.4.0/dbhome_1/sysman/lib/env_emagent.mk

Patching component oracle.sysman.agent, 10.2.0.4.5...

............................

............................

................................

Verifying the update...

Patch 19692824 successfully applied

OPatch Session completed with warnings.

Log file location: /u01/app/oracle/product/11.2.0.4.0/dbhome_1/cfgtoollogs/opatch/19692824_Jun_05_2016_12_56_15/apply2016-06-05_12-56-15PM_1.log

OPatch completed with warnings.

[oracle@qpaydb 19692824]$

Rollback Applied Patch:

[oracle@qpaydb ~]$ pwd

/home/oracle

[oracle@qpaydb ~]$

[oracle@qpaydb ~]$ $ORACLE_HOME/OPatch/opatch rollback -id 19692824