Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Friday, September 18, 2015

Use OPatch to install a patch - part1

how to use OPatch to install a patch:

To debug the opatch session:
export OPATCH_DEBUG=TRUE
To disable:
unset OPATCH_DEBUG or export OPATCH_DEBUG=FALSE

[oracle@collabn1 13467683]$ opatch query -h
DESCRIPTION
       This operation loads and prints out various information about a patch.
       Parameter patch_location points to where a patch is located.  
       For example, if you specify "path", there should be sub-dir.
       "etc/config" under "path".



[oracle@collabn1 13467683]$ opatch query
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.2/SHAIKPROD
Central Inventory : /u01/app/oraInventory
  from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/oui
Log file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch2015-09-18_23-01-49PM.log

Patch history file: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch_history.txt

--------------------------------------------------------------------------------
Patch created on 5 Feb 2012, 00:15:49 hrs PST8PDT
Need to shutdown Oracle instances: true
Patch is roll-backable: true
Patch is a rolling patch: true
Patch has sql related actions: false
Patch is an online patch: false
Patch is a portal patch: false

List of platforms supported:
  226: Linux x86-64

List of bugs to be fixed:
  13467683: JOIN OF TEMP AND PERMANENT TABLES IN RAC MIGHT CAUSE CORRUPTION OF PERMANENT TBL

This patch is a "singleton" patch.

List of executables affected:
  ORACLE_HOME/bin/oracle

List of optional components:
  oracle.rdbms:  11.2.0.1.0

List of optional actions:
  Update /u01/app/oracle/product/11.2.0.2/SHAIKPROD/lib/libserver11.a with /kcbz.o
  cd /u01/app/oracle/product/11.2.0.2/SHAIKPROD/rdbms/lib
    ; make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.2/SHAIKPROD

 Possible XML representation of the patch:
<ONEOFF REF_ID="13467683" ROLLBACK="T" XML_INV_LOC="oneoffs/13467683/" ACT_INST_VER="11.2.0.1.0" INSTALL_TIME="2015.Sep.18 23:01:49 EDT">
  <DESC></DESC>
  <REF_LIST>
     <REF NAME="oracle.rdbms" VER="11.2.0.1.0" HOME_IDX="0"/>
  </REF_LIST>
  <BUG_LIST>
    <BUG>13467683</BUG>
  </BUG_LIST>
  <FILE_LIST/>
</ONEOFF>

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

OPatch succeeded.


[oracle@collabn1 13467683]$ opatch prereq CheckApplicable -ph /media/sf_stage/13467683/
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/11.2.0.2/SHAIKPROD
Central Inventory : /u01/app/oraInventory
  from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/oui
Log file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch2015-09-18_23-12-20PM.log

Patch history file: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkapplicable"

Prereq "checkApplicable" for patch 13467683 passed.

OPatch succeeded.


Demo:

Below I will apply the patch  ONLINE to the 2 node RAC database .

Patch 13467683 is staged under /media/sf_stage/

Patch details:
 bug number="13467683"
description="JOIN OF TEMP AND PERMANENT TABLES IN RAC MIGHT CAUSE CORRUPTION OF PERMANENT TBL

Database details:
[oracle@collabn2 ~]$ srvctl start database -d SHAIKPRD

[oracle@collabn2 ~]$ srvctl status database -d SHAIKPRD
Instance SHAIKPRD1 is running on node collabn1
Instance SHAIKPRD2 is running on node collabn2



[oracle@collabn1 ~]$ ls -lrt /media/sf_stage/p13467683_112010_Linux-x86-64.zip
-rwxrwx--- 1 root vboxsf 509191 Sep 18 20:11 /media/sf_stage/p13467683_112010_Linux-x86-64.zip


SHAIKDB>select banner from v$version ;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0    Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


[oracle@collabn1 ~]$ opatch lsinventory -detail
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.2/SHAIKPROD
Central Inventory : /u01/app/oraInventory
  from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/oui
Log file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch2015-09-18_19-59-43PM.log

Patch history file: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/lsinv/lsinventory2015-09-18_19-59-43PM.txt

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

Oracle Database 11g                                                  11.2.0.1.0
There are 1 products installed in this Oracle Home.


Installed Products (134):

Agent Required Support Files                                         10.2.0.4.2
Assistant Common Files                                               11.2.0.1.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              11.2.0.1.0
Character Set Migration Utility                                      11.2.0.1.0
Cluster Verification Utility Common Files                            11.2.0.1.0
Database Configuration and Upgrade Assistants                        11.2.0.1.0
Database SQL Scripts                                                 11.2.0.1.0
Database Workspace Manager                                           11.2.0.1.0
Deinstallation Tool                                                  11.2.0.1.0

There are 134 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


Rac system comprising of multiple nodes
 Local node = collabn1
 Remote node = collabn2

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

OPatch succeeded.



[oracle@collabn1 ~]$ opatch -help
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Usage: opatch [ -help ] [ -r[eport] ] [ command ]

           command := apply
                      lsinventory
                      napply
                      nrollback
                      rollback
                      query
                      version
                      prereq
                      util

example:
  'opatch -help'
  'opatch apply -help'
  'opatch lsinventory -help'
  'opatch napply -help'
  'opatch nrollback -help'
  'opatch rollback -help'
  'opatch prereq -help'
  'opatch util -help'
  

[oracle@collabn1 ~]$ opatch apply -help
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


DESCRIPTION
    This operation applies an interim patch to an ORACLE_HOME from
    the current directory. The patch location can specified using
    the parameter patch_location.

SYNTAX
opatch apply  [-connectString  <List of connect strings>]
             [-delay <value> ] [ -force ]
             [-init <parameters for the init script in escaped double
              quotes> [-opatch_init_end] ]
             [-invPtrLoc <Path to oraInst.loc> ]
             [-jre <LOC> ] [-local ] [-local_node <Local node name>]
             [-minimize_downtime ] [-no_bug_superset ]
         [-no_inventory ] [-no_relink]
             [-no_sysmod] [-ocmrf <Response file location> ]
             [-oh <ORACLE_HOME> ]
             [-post <parameters for the post script in escaped
              quotes> [-opatch_post_end] ]
             [-pre <parameters for the pre script
              in escaped double quotes> [-opatch_pre_end] ]
             [-property_file <Path to property file>]
             [-ptlConnect <portal connect string>]
             [-ptlPassword <portal password>]
             [-ptlSchema <portal schema>]
             [-remote_nodes <List of remote nodes (node1,node2)>]
             [-retry <value ] [-runSql ]
             [silent ] [-sqlScript <path of the sql file>] [-verbose ]
             [ <Patch Location> ]


[oracle@collabn1 sf_stage]$ unzip p13467683_112010_Linux-x86-64.zip

[oracle@collabn1 sf_stage]$ cd 13467683/
[oracle@collabn1 13467683]

[oracle@collabn1 13467683]$ ls -lrt
total 12
-rwxrwx--- 1 root vboxsf 8863 Feb  5  2012 README.txt
drwxrwx--- 1 root vboxsf  136 Feb  5  2012 online
drwxrwx--- 1 root vboxsf  102 Feb  5  2012 files
drwxrwx--- 1 root vboxsf  136 Feb  5  2012 etc
[oracle@collabn1 13467683]$

 -connectString
             This option can be used to specify the list of database
             instances on which the patch needs to be applied. The
             value for this option is specified as per the following
             syntax "SID:User:Passwd:Node". The SID is a must, others
             can be ignored, OPatch takes default values for it.
             Ex: oracle:dba:dba:mymachine,oracle1:::
             NOTE: If the system is not part of RAC setup, then to
             patch just the local node, provide the node name as
             empty string.


[oracle@collabn1 ~]$ cd /media/sf_stage/13467683/
[oracle@collabn1 13467683]$ opatch apply online -connectstring "SHAIKPRD1:system:test123:collabn1,SHAIKPRD2:system:test123:collabn2"
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.2/SHAIKPROD
Central Inventory : /u01/app/oraInventory
  from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/oui
Log file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch2015-09-18_21-19-40PM.log

Patch history file: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch_history.txt


The patch should be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.
ApplySession applying interim patch '13467683' to OH '/u01/app/oracle/product/11.2.0.2/SHAIKPROD'

Running prerequisite checks...

OPatch detected the node list and the local node from the inventory.  OPatch will patch the local system then propagate the patch to the remote nodes.

Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '13467683' for restore. This might take a while...
Backing up files affected by the patch '13467683' for rollback. This might take a while...

Patching component oracle.rdbms, 11.2.0.1.0...
The patch will be installed on active database instances.
Installing and enabling the online patch 'bug13467683.pch', on database 'SHAIKPRD1'.

ApplySession adding interim patch '13467683' to inventory

Verifying the update...
Inventory check OK: Patch ID 13467683 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 13467683 are present in Oracle Home.

Patching in all-node mode.

Updating nodes 'collabn2'
  Apply-related files are:
    FP = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_files.txt"
    DP = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_dirs.txt"
    MP = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/make_cmds.txt"
    RC = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remote_cmds.txt"

Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remote_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remote_cmds.txt" with actual path.
Running command on remote node 'collabn2':
/u01/app/oracle/product/11.2.0.2/SHAIKPROD/bin/mkpatch -fixup /u01/app/oracle/product/11.2.0.2/SHAIKPROD/hpatch/bug13467683.pch /u01/app/oracle/product/11.2.0.2/SHAIKPROD/bin/oracle

Installing and enabling the online patch 'bug13467683.pch', on database 'SHAIKPRD2' on node 'collabn2'.


OPatch succeeded.


If you have multiple databases installed on the same ORACLE_HOME then use ” util enableonlinepatch”
To apply the patch on the SID2: which is SHAIKDB installed on the same node as collabn1 and shares the same ORACLE_HOME as database SHAIKPRD.



[oracle@collabn1 13467683]$ opatch util enableonlinepatch -connectstring SHAIKDB -id 13467683
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.

UTIL session

Oracle Home       : /u01/app/oracle/product/11.2.0.2/SHAIKPROD
Central Inventory : /u01/app/oraInventory
  from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/oui
Log file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch2015-09-18_22-26-10PM.log

Patch history file: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch_history.txt

Invoking utility "enableonlinepatch"
Installing and enabling the online patch 'bug13467683.pch', on database 'SHAIKDB'.


OPatch succeeded.

To rollback the patch from individual nodes:

[oracle@collabn2 .patch_storage2]$ opatch rollback -id 13467683  -connectstring SHAIKPRD2  -local
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.2/SHAIKPROD
Central Inventory : /u01/app/oraInventory
  from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/oui
Log file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch2015-09-18_22-42-27PM.log

Patch history file: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch_history.txt

RollbackSession rolling back interim patch '13467683' from OH '/u01/app/oracle/product/11.2.0.2/SHAIKPROD'

The patch should be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.

Running prerequisite checks...

You selected -local option, hence OPatch will patch the local system only.

Backing up files affected by the patch '13467683' for restore. This might take a while...

Patching component oracle.rdbms, 11.2.0.1.0...
The patch will be removed from active database instances.
Disabling and removing online patch 'bug13467683.pch', on database 'SHAIKPRD2'

RollbackSession removing interim patch '13467683' from inventory

OPatch succeeded.

To rollback from all nodes:

opatch rollback -id 13467683  -connectstring "SHAIKPRD1:system:test123:collabn1,SHAIKPRD2:system:test123:collabn2"




Apply the patch in offline mode:
[oracle@collabn1 13467683]$ srvctl stop database -d SHAIKPRD

[oracle@collabn1 13467683]$ srvctl status database -d SHAIKPRD
Instance SHAIKPRD1 is not running on node collabn1
Instance SHAIKPRD2 is not running on node collabn2

[oracle@collabn1 13467683]$ opatch napply
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.

UTIL session

Oracle Home       : /u01/app/oracle/product/11.2.0.2/SHAIKPROD
Central Inventory : /u01/app/oraInventory
  from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/oui
Log file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch2015-09-18_22-58-08PM.log

Patch history file: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch_history.txt

Invoking utility "napply"
Checking conflict among patches...
Checking if Oracle Home has components required by patches...
Checking conflicts against Oracle Home...
OPatch continues with these patches:   13467683  

Do you want to proceed? [y|n]
y
User Responded with: Y

Running prerequisite checks...

OPatch detected the node list and the local node from the inventory.  OPatch will patch the local system then propagate the patch to the remote nodes.


This node is part of an Oracle Real Application Cluster.
Remote nodes: 'collabn2'
Local node: 'collabn1'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0.2/SHAIKPROD')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch 'NApply' for restore. This might take a while...

Applying patch 13467683...

ApplySession applying interim patch '13467683' to OH '/u01/app/oracle/product/11.2.0.2/SHAIKPROD'
Backing up files affected by the patch '13467683' for rollback. This might take a while...

Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/lib/libserver11.a"  with "lib/libserver11.a/kcbz.o"
ApplySession adding interim patch '13467683' to inventory

Verifying the update...
Inventory check OK: Patch ID 13467683 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 13467683 are present in Oracle Home.
Running make for target ioracle

The local system has been patched and can be restarted.


Patching in rolling mode.


The node 'collabn2' will be patched next.


Please shutdown Oracle instances running out of this ORACLE_HOME on 'collabn2'.
(Oracle Home = '/u01/app/oracle/product/11.2.0.2/SHAIKPROD')

Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'collabn2'
  Apply-related files are:
    FP = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/NApply/2015-09-18_22-58-08PM/rac/copy_files.txt"
    DP = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/NApply/2015-09-18_22-58-08PM/rac/copy_dirs.txt"
    MP = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/NApply/2015-09-18_22-58-08PM/rac/make_cmds.txt"
    RC = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/NApply/2015-09-18_22-58-08PM/rac/remote_cmds.txt"

Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/NApply/2015-09-18_22-58-08PM/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/NApply/2015-09-18_22-58-08PM/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/NApply/2015-09-18_22-58-08PM/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/NApply/2015-09-18_22-58-08PM/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/NApply/2015-09-18_22-58-08PM/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/NApply/2015-09-18_22-58-08PM/rac/make_cmds.txt" with actual path.
Running command on remote node 'collabn2':
cd /u01/app/oracle/product/11.2.0.2/SHAIKPROD/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.2/SHAIKPROD || echo REMOTE_MAKE_FAILED::>&2

RC file not exist.  There are no commands to be run on the remote nodes.

The node 'collabn2' has been patched.  You can restart Oracle instances on it.

UtilSession: N-Apply done.

OPatch succeeded.



To rollback the patch in offline mode:

[oracle@collabn1 13467683]$ opatch rollback -all_nodes -id 13467683
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.2/SHAIKPROD
Central Inventory : /u01/app/oraInventory
  from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/oui
Log file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch2015-09-18_23-00-14PM.log

Patch history file: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch_history.txt

RollbackSession rolling back interim patch '13467683' from OH '/u01/app/oracle/product/11.2.0.2/SHAIKPROD'

Running prerequisite checks...

OPatch detected the node list and the local node from the inventory.  OPatch will patch the local system then propagate the patch to the remote nodes.


This node is part of an Oracle Real Application Cluster.
Remote nodes: 'collabn2'
Local node: 'collabn1'
Please shut down Oracle instances running out of this ORACLE_HOME on all the nodes.
(Oracle Home = '/u01/app/oracle/product/11.2.0.2/SHAIKPROD')


Are all the nodes ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch '13467683' for restore. This might take a while...

Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/lib/libserver11.a"  with "lib/libserver11.a/kcbz.o"
Running make for target ioracle
RollbackSession removing interim patch '13467683' from inventory

Patching in all-node mode.

Updating nodes 'collabn2'
  Rollback-related files are:
    FR = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_files.txt"
    DR = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_dirs.txt"
    FP = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_files.txt"
    MP = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/make_cmds.txt"
    RC = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remote_cmds.txt"

Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_files.txt" with actual path.
Removing files on remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_dirs.txt" with actual path.
Removing directories on remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/make_cmds.txt" with actual path.
Running command on remote node 'collabn2':
cd /u01/app/oracle/product/11.2.0.2/SHAIKPROD/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.2/SHAIKPROD || echo REMOTE_MAKE_FAILED::>&2


All nodes have been patched.  You may start Oracle instances on the local system and nodes 'collabn2'

There were relinks on remote nodes.  Remember to check the binary size and timestamp on the nodes 'collabn2' .
The following make commands were invoked on remote nodes:
'cd /u01/app/oracle/product/11.2.0.2/SHAIKPROD/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.2/SHAIKPROD
'


OPatch succeeded.

No comments: