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

Unable to get property values from properties file of the Online patch.

Unable to get property values from properties file of the Online patch.
The node name is "collabn1".


While trying to rollback a patch I am getting above error:

[oracle@collabn1 13467683]$  opatch rollback -id 13467683 -connectstring "SHAIKPRD1:system:test123:collabn1"
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_20-49-34PM.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...
Prerequisite check "CheckRollbackSid" failed.

Patch ID: 13467683

The details are:

Unable to get property values from properties file of the Online patch.
The node name is "collabn1".

RollbackSession failed during prerequisite checks: Prerequisite check "CheckRollbackSid" failed.
System intact, OPatch will not attempt to restore the system

OPatch failed with error code 74


[oracle@collabn1 13467683]$


Fix:
Missing OnlinePatch.properties file under $ORACLE_HOME/.patch_storage dir

[oracle@collabn1 SHAIKPROD]$ cd /u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/

[oracle@collabn1 .patch_storage]$ ls -lrt
total 8
drwxr-xr-x 3 oracle oinstall 4096 Sep 18 20:46 13467683_Feb_5_2012_00_15_49
-rw-r--r-- 1 oracle oinstall   25 Sep 18 20:49 db_status.sql
-rw-r--r-- 1 oracle oinstall    0 Sep 18 20:49 patch_free

Create the OnlinePatch.properties

[oracle@collabn1 .patch_storage]$ vi OnlinePatch.properties
#Fri Sep 18 20:54:39 EDT 2015
PATCH_ID=13467683
13467683_ONLINE_SID=SHAIKPRD1

Rerun the opatch:

[oracle@collabn1 .patch_storage]$  opatch rollback -id 13467683 -connectstring "SHAIKPRD1:system:test123:collabn1"

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_20-54-33PM.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...

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 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 'SHAIKPRD1'

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...

OPatch succeeded.

No comments: