Issue:
OPatch is getting failed with error
opatch apply
SEVERE:OPatch invoked as follows: 'apply '
INFO:
Oracle Home : /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1
Central Inventory : /ora_DEV/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/oui
Log file location : /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/cfgtoollogs/opatch/opatch2011-07-30_10-40-24AM.log
INFO:Patch history file: /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
INFO:Starting ApplySession at Sat Jul 30 10:40:25 GMT+05:30 2011
INFO:Starting Apply Session at Sat Jul 30 10:40:25 GMT+05:30 2011
INFO:ApplySession applying interim patch '12320006' to OH '/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1'
INFO:Starting to apply patch to local system at Sat Jul 30 10:40:25 GMT+05:30 2011
INFO:Start the Apply initScript at Sat Jul 30 10:40:25 GMT+05:30 2011
INFO:Finish the Apply initScript at Sat Jul 30 10:40:25 GMT+05:30 2011
INFO:Patch 12320006 has no conflicts/superset wiht any other patch processed till now
INFO:Checking conflicts for patch: 12320006
INFO:Checking conflicts/supersets for patch: 12320006 with patch:12320006
INFO:Checking conflicts/supersets for patch: 12320006 with patch:8553944
INFO:Checking conflicts/supersets for patch: 12320006 with patch:8730312
INFO:Checking conflicts/supersets for patch: 12320006 with patch:9147659
INFO:Checking conflicts/supersets for patch: 12320006 with patch:9218789
INFO:
Running prerequisite checks...
INFO:Space Needed : 13812976
INFO:Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 12320006
INFO:Current working directory is : /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/OPatch
INFO:OPatch is generic, it is not bundled with OCM.
INFO:
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.
INFO:Start saving patch at Sat Jul 30 10:40:29 GMT+05:30 2011
INFO:Finish saving patch at Sat Jul 30 10:40:29 GMT+05:30 2011
INFO:Start backing up system for restore at Sat Jul 30 10:40:29 GMT+05:30 2011
INFO:Backing up files and inventory (not for auto-rollback) for the Oracle Home
INFO:Backing up files affected by the patch '12320006' for restore. This might take a while...
INFO:Finish backing up system for restore at Sat Jul 30 10:40:29 GMT+05:30 2011
INFO:******* create file /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/interim_inventory.txt
INFO:Start backing up system for rollback at Sat Jul 30 10:40:29 GMT+05:30 2011
INFO:Backing up files affected by the patch '12320006' for rollback. This might take a while...
INFO:Finish backing up system for rollback at Sat Jul 30 10:40:29 GMT+05:30 2011
INFO:Start modifying the system at Sat Jul 30 10:40:29 GMT+05:30 2011
INFO:
Patching component oracle.oracore.rsf, 11.2.0.1.0...
INFO:Copying file to "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/oracore/zoneinfo/timezlrg_16.dat"
INFO:Start Copy Action at Sat Jul 30 10:40:29 GMT+05:30 2011
INFO:Finish Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Copying file to "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/oracore/zoneinfo/timezone_16.dat"
INFO:Start Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Finish Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Copying file to "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/oracore/zoneinfo/readme_16.txt"
INFO:Start Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Finish Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Copying file to "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/oracore/zoneinfo/big/timezlrg_16.dat"
INFO:Start Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Finish Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Copying file to "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/oracore/zoneinfo/big/timezone_16.dat"
INFO:Start Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Finish Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Copying file to "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/oracore/zoneinfo/little/timezlrg_16.dat"
INFO:Start Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Finish Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Copying file to "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/oracore/zoneinfo/little/timezone_16.dat"
INFO:Start Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Finish Copy Action at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Finish modifying the system at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:ApplySession adding interim patch '12320006' to inventory
INFO:Start saving patch to inventory at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:Registered Encoding value is : ISO8859-1 for the file /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/inventory/oneoffs/12320006/etc/config/actions.xml
INFO:Finish saving patch to inventory at Sat Jul 30 10:40:30 GMT+05:30 2011
INFO:
Verifying the update...
INFO:Inventory check OK: Patch ID 12320006 is registered in Oracle Home inventory with proper meta-data.
INFO: verifying 7 copy files.
INFO:Files check OK: Files from Patch ID 12320006 are present in Oracle Home.
INFO:Finish applying patch to local system at Sat Jul 30 10:40:31 GMT+05:30 2011
INFO:Starting to apply patch to remote nodes 'ifebdbdev' 'ifebprd2' at Sat Jul 30 10:40:31 GMT+05:30 2011
INFO:
Patching in all-node mode.
INFO:Updating nodes 'ifebdbdev' 'ifebprd2'
INFO: Apply-related files are:
FP = "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/copy_files.txt"
DP = "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/copy_dirs.txt"
MP = "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/make_cmds.txt"
RC = "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/remote_cmds.txt"
INFO:Instantiating the file "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/copy_files.txt" with actual path.
INFO:Propagating files to remote nodes...
WARNING:OUI-67187:
OPatch failed to copy files to remote nodes 'ifebdbdev' 'ifebprd2' . Detail: Error while copying files inside directory '/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1' based on listed file '/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/copy_files.txt.instantiated' to nodes 'ifebdbdev,ifebprd2'. [PRKC-1044 : Failed to check remote command execution setup for node ifebdbdev using shells /usr/bin/ssh and /usr/bin/rsh
rshd: 0826-813 Permission is denied.PRKC-1044 : Failed to check remote command execution setup for node ifebprd2 using shells /usr/bin/ssh and /usr/bin/rsh
host: name ifebprd2 NOT FOUND]
INFO:
OPatch failed to copy files to remote nodes 'ifebdbdev' 'ifebprd2' .
Do you want to proceed? [y|n]
INFO:Start to wait for user-input at Sat Jul 30 10:40:31 GMT+05:30 2011
INFO:Finish waiting for user-input at Sat Jul 30 10:41:30 GMT+05:30 2011
INFO:User Responded with: Y
INFO:Instantiating the file "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/copy_dirs.txt" with actual path.
INFO:Propagating directories to remote nodes...
WARNING:OUI-67188:
OPatch failed to copy directories to remote nodes 'ifebdbdev' 'ifebprd2' . Detail: Error while copying files inside directory '/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1' based on listed file '/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/copy_dirs.txt.instantiated' with excludeListFile 'null' to nodes 'ifebdbdev,ifebprd2'. [PRCF-2020 : Cannot retrieve the host for node "ifebprd2"
PRCF-2020 : Cannot retrieve the host for node "ifebprd2"]
INFO:
OPatch failed to copy directories to remote nodes 'ifebdbdev' 'ifebprd2' .
Do you want to proceed? [y|n]
INFO:Start to wait for user-input at Sat Jul 30 10:41:30 GMT+05:30 2011
INFO:Finish waiting for user-input at Sat Jul 30 10:41:37 GMT+05:30 2011
INFO:User Responded with: Y
INFO:Finish applying patch to remote nodes at Sat Jul 30 10:41:37 GMT+05:30 2011
INFO:--------------------------------------------------------------------------------
INFO:The following warnings have occurred during OPatch execution:
INFO:1) OUI-67187:
OPatch failed to copy files to remote nodes 'ifebdbdev' 'ifebprd2' . Detail: Error while copying files inside directory '/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1' based on listed file '/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/copy_files.txt.instantiated' to nodes 'ifebdbdev,ifebprd2'. [PRKC-1044 : Failed to check remote command execution setup for node ifebdbdev using shells /usr/bin/ssh and /usr/bin/rsh
rshd: 0826-813 Permission is denied.PRKC-1044 : Failed to check remote command execution setup for node ifebprd2 using shells /usr/bin/ssh and /usr/bin/rsh
host: name ifebprd2 NOT FOUND]
INFO:2) OUI-67188:
OPatch failed to copy directories to remote nodes 'ifebdbdev' 'ifebprd2' . Detail: Error while copying files inside directory '/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1' based on listed file '/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/.patch_storage/12320006_Jun_13_2011_23_18_57/rac/copy_dirs.txt.instantiated' with excludeListFile 'null' to nodes 'ifebdbdev,ifebprd2'. [PRCF-2020 : Cannot retrieve the host for node "ifebprd2"
PRCF-2020 : Cannot retrieve the host for node "ifebprd2"]
INFO:--------------------------------------------------------------------------------
SEVERE:OUI-67204:OPatch Session completed with warnings.
INFO:Finishing ApplySession at Sat Jul 30 10:41:37 GMT+05:30 2011
INFO:Total time spent waiting for user-input is 65 seconds. Finish at Sat Jul 30 10:41:37 GMT+05:30 2011
$ opatch lsinventory
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 : /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1
Central Inventory : /ora_DEV/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/oui
Log file location : /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/cfgtoollogs/opatch/opatch2011-08-03_16-16-12PM.log
Patch history file: /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2011-08-03_16-16-12PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 11g 11.2.0.1.0
Oracle Database 11g Examples 11.2.0.1.0
There are 2 products installed in this Oracle Home.
Interim patches (5) :
Patch 12320006 : applied on Sat Jul 30 10:40:30 GMT+05:30 2011
Unique Patch ID: 13845592
Created on 13 Jun 2011, 23:18:57 hrs PST8PDT
Bugs fixed:
12320006
Patch 8553944 : applied on Wed Apr 13 15:35:57 GMT+05:30 2011
Unique Patch ID: 13551690
Created on 22 Mar 2011, 23:46:42 hrs PST8PDT
Bugs fixed:
8553944
Patch 8730312 : applied on Wed Sep 29 00:57:31 GMT+05:30 2010
Unique Patch ID: 12202102
Created on 14 Feb 2010, 21:47:42 hrs PST8PDT
Bugs fixed:
8730312
Patch 9147659 : applied on Fri Sep 24 00:23:37 GMT+05:30 2010
Unique Patch ID: 12128903
Created on 18 Jan 2010, 03:05:31 hrs PST8PDT
Bugs fixed:
9037724, 9007836, 9004697
Patch 9218789 : applied on Thu Jul 01 17:39:01 GMT+05:30 2010
Unique Patch ID: 12217103
Created on 16 Feb 2010, 14:41:20 hrs PST8PDT
Bugs fixed:
9218789
Rac system comprising of multiple nodes
Local node = ifebprd1
Remote node = ifebdbdev
Remote node = ifebprd2
--------------------------------------------------------------------------------
OPatch succeeded.
Findings:
Sometimes we simply copy the Oracle binaries from database server to another server and then create a new database.
The new database will work fine.But we can face issue while applying an patch.
In the above example we copied the binaries from a RAC database(ifebprd) to non-rac database(ifebdbdev).
While applying the opatch an error occured.
Solution:
cd /etc
vi oraInst.loc
inst_group=oinstall
inventory_loc=/home/applprod/oraInventory
Change the inventory_loc entry with right location.
inst_group=oinstall
inventory_loc=/ora_DEV/oraInventory
# chown oradev:dba oraInst.loc
# chmod 777 oraInst.loc
cd $ORACLE_HOME/oui/bin
./runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/ora_DEV/app/oracle/product/11.2.0/prodclone/dbhome_1" ORACLE_HOME_NAME="proddev_oradev_11_2_0_1"
Starting Oracle Universal Installer...
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-10-15_01-08-47PM. Please wait ...$ 'AttachHome' was successful.
Now try the opatch.
No comments:
Post a Comment