Applying Patch 17747140 - QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) and Patch 17992671 - CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)

Applying Patch 17747140 - QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) and Patch 17992671 - CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)

- Login to server as proper OS user.
- cd to stage area where the patch is copied.

Check for conflicts:
===================

[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17747140

Oracle Interim Patch Installer version 11.2.0.3.5

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

PREREQ session


Oracle Home       : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory

   from           : /instance_name/oracle/product/112/oraInst.loc
OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : 
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[orinstance_name@localhost 17747147]$  $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17992671/custom/server/17992671

Oracle Interim Patch Installer version 11.2.0.3.5

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

PREREQ session


Oracle Home       : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory

   from           : /instance_name/oracle/product/112/oraInst.loc
OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : 
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.



[orinstance_name@localhost 17747147]$  $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17992671/custom/server/17992671

Oracle Interim Patch Installer version 11.2.0.3.5

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

PREREQ session


Oracle Home       : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory

   from           : /instance_name/oracle/product/112/oraInst.loc
OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : 
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


Checks System Space
===================


[orinstance_name@localhost 17747147]$  $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17747140

Oracle Interim Patch Installer version 11.2.0.3.5

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

PREREQ session


Oracle Home       : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory

   from           : /instance_name/oracle/product/112/oraInst.loc
OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : 
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log


Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.


OPatch succeeded.


[orinstance_name@localhost 17747147]$  $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17992671/custom/server/17992671

Oracle Interim Patch Installer version 11.2.0.3.5

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

PREREQ session


Oracle Home       : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory

   from           : /instance_name/oracle/product/112/oraInst.loc
OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : 
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log


Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.


OPatch succeeded.
[orinstance_name@localhost 17747147]$


[orinstance_name@localhost 17747147]$  $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17992671/custom/server/17992671

Oracle Interim Patch Installer version 11.2.0.3.5

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

PREREQ session


Oracle Home       : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory

   from           : /instance_name/oracle/product/112/oraInst.loc
OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : 
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log


Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.


OPatch succeeded.


Applying the patches:

- Shutdown the services (Cold backup recommended before patching)

- Apply patch using the below steps 
  
export ORACLE_HOME=/instance_name/oracle/product/112;
echo $ORACLE_HOME


Run prepatch.sh

/stage/17747147/17992671/custom/server/17992671/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

Apply patch

$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /stage/17747147/17747140

$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /stage/17747147/17992671/custom/server/17992671 

Run postpatch.sh

/stage/17747147/17992671/custom/server/17992671/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME

- Start services after applying the patches


- Execute catbundle.sql only on one node

sqlplus / as sysdba

@?/rdbms/admin/catbundle.sql exa apply



Verify if patches applied successfully.
=======================================

[orinstance_name@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -local | grep 17747140

Patch  17747140     : applied on date_timestamp

Patch description:  "QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) : 
(17747140)"
[orinstance_name@localhost ~]$

[orinstance_name@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -local | grep 17992671

Patch  17992671     : applied on date_timestamp

Patch description:  "QUARTERLY CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) 
(17992671)"
[orinstance_name@localhost ~]$



Related Posts:

Oracle Database - Enterprise Edition - Applying Patch 21800477: QUARTERLY DATABASE PATCH FOR EXADATA (OCT2015 - 11.2.0.4.20)