4 Replies Latest reply on Mar 31, 2008 10:49 PM by 480154

    OPatch encounters the following file roll-back issues: File Back-up Errors!

    user453063
      Operating System: Windows XP
      Oracle Virsion: 9.2.0.8
      Patches applied:
      Oracle Patch: 5726045 - Successfully patched with zero return code.
      Oracle Patch: 641703 - Failed with Error Code 200.

      Scenario:

      I have to apply CPUJAN2008 patch on 55 different servers located at different places in different states. Previously some other DBA had written a Windows NT Script for applying patch CPUOCT2007 on these
      55 differnet servers which have the same instances, same filing system, same oracle version, same directories, same oracle_home, etc. In other words they are replicas to each other. For the purpose of
      patching, the script is the best option. The Script for CPUOCT2007 was never went through, hence I am trying to test this CPUOCT2007 script and if tested allright, I will make certain amendmends to make it
      ready for CPUJAN2008 patch.


      Problem:

      I tested the script for CPUOCT2007 patch and encountered the following problem:

      I am providing the necessary information between the dotted lines:

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

      Archive: p6417013_92080_WINNT.zip
      Entered
      Exited
      ~~~~~~~~~~~~~~6417013 patch~~~~~~~~~~~~~~

      Oracle Interim Patch Installer version 1.0.0.0.57
      Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

      We recommend you refer to the OPatch documentation under
      OPatch/docs for usage reference. We also recommend using
      the latest OPatch version. For the latest OPatch version
      and other support related issues, please refer to document
      293369.1 which is viewable from metalink.oracle.com

      Oracle Home : D:\App\Oracle\Product\9.2.0
      Oracle Home Inventory : D:\App\Oracle\Product\9.2.0\inventory
      Central Inventory : C:\Program Files\oracle\inventory
      from : N/A
      OUI location : D:\App\Oracle\Product\9.2.0\oui
      OUI shared library : D:\App\Oracle\Product\9.2.0\oui\lib\win32\oraInstaller.dll
      Java location : "D:\App\Oracle\Product\9.2.0\jre\1.4.2\bin\java.exe"
      Log file location : D:\App\Oracle\Product\9.2.0/.patch_storage/<patch ID>/*.log

      Creating log file "D:\app\oracle\product\9.2.0\.patch_storage\6417013\Apply_6417013_03-29-2008_14-43-19.log"


      Subset patches: 6417013,

      The fixes for Patch 6417013, are included in the patch currently
      being installed (6417013). OPatch will roll back the subset patch(es) and
      install the new patch (6417013).


      Backing up comps.xml ...

      OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


      Please shut down Oracle instances running out of this ORACLE_HOME
      (Oracle Home = d:\app\oracle\product\9.2.0)
      Is this system ready for updating?
      Please respond Y|N >
      Y (auto-answered by -silent)

      Rolling back patch 6417013...

      Creating log file "D:\app\oracle\product\9.2.0\.patch_storage\6417013\RollBack_6417013_03-29-2008_14-43-35.log"

      Rolling back with all-node mode.
      OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

      Oracle instances have been shut down, proceeding with auto-rollback.

      Executing the Roll-back pre-patch script (D:\app\oracle\product\9.2.0\.patch_storage\6417013\custom\scripts\pre.bat)...
      Removing patch 6417013...

      Restoring copied files...

      OPatch encounters the following file roll-back issues:
      The following files had problems with being restored:
      1.     d:\app\oracle\product\9.2.0\bin\oracle.exe
      2.     d:\app\oracle\product\9.2.0\bin\oraclient9.dll
      3.     d:\app\oracle\product\9.2.0\bin\oracommon9.dll
      4.     d:\app\oracle\product\9.2.0\bin\oracore9.dll
      5.     d:\app\oracle\product\9.2.0\bin\orageneric9.dll
      6.     d:\app\oracle\product\9.2.0\bin\oran9.dll
      7.     d:\app\oracle\product\9.2.0\bin\oranl9.dll
      8.     d:\app\oracle\product\9.2.0\bin\oranldap9.dll
      9.     d:\app\oracle\product\9.2.0\bin\orannts9.dll
      10.     d:\app\oracle\product\9.2.0\bin\orapls9.dll
      11.     d:\app\oracle\product\9.2.0\bin\oraxml9.dll
      12.     d:\app\oracle\product\9.2.0\rdbms\mesg\oraus.msb

      Replying 'Y' will terminate the patch roll-back immediately. It WILL NOT restore any updates that have been performed to this point. It WILL NOT update the inventory.
      Replying 'N' will update the inventory showing the patch has been removed.

      Do you want to STOP?
      Please respond Y|N >
      Y (auto-answered by -silent)

      ERROR: OPatch failed during patching, possibly due to missing files.
      File Back-up Errors!

      OPatch returns with error code = 200

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







      The rollback file provided the following (See between the dotted lines)

      .................................................................................................................................................................
      Creating log file "D:\app\oracle\product\9.2.0\.patch_storage\6417013\RollBack_6417013_03-29-2008_14-43-35.log"

      Starting OPatch Rollback session at 03-29-2008_14-43-35.

      Command arguments parsed by OPatch are: -id 6417013 -ph D:\app\oracle\product\9.2.0\6417013

      Checking the patch inventory.

      Checking system activity.

      Retrieving details of patch 6417013.


      Accessing inventory ... (retry 10 times, delay 30 seconds each time)


      System Command: ""D:\App\Oracle\Product\9.2.0\jre\1.4.2\bin\java.exe" -Doracle.installer.invPtrLoc=N/A -classpath "D:\App\Oracle\Product\9.2.0\oui\jlib\OraInstaller.jar;D:\App\Oracle\Product\9.2.0

      \oui\jlib\srvm.jar;D:\app\oracle\product\9.2.0\OPatch\jlib\opatch.jar;D:\app\oracle\product\9.2.0\oui\jlib\xmlparserv2.jar;D:\app\oracle\product\9.2.0\oui\jlib\share.jar" opatch/GetPatchDetails

      "D:\App\Oracle\Product\9.2.0\oui" "d:\app\oracle\product\9.2.0" opatch.pl 1.0.0.0.57 6417013"

      Result:

      6417013: D:/app/oracle/product/9.2.0/network/agent/events/oracle/rdbms/space/tbspfull.tcl

      6417013: D:/app/oracle/product/9.2.0/bin/agentctl.exe

      6417013: D:/app/oracle/product/9.2.0/bin/agntsrvc.exe

      6417013: D:/app/oracle/product/9.2.0/bin/ctxhx.exe

      6417013: D:/app/oracle/product/9.2.0/bin/dbsnmp.exe

      6417013: D:/app/oracle/product/9.2.0/bin/dbv.exe

      6417013: D:/app/oracle/product/9.2.0/bin/EXP.EXE

      6417013: D:/app/oracle/product/9.2.0/bin/htmcnv.dll

      6417013: D:/app/oracle/product/9.2.0/bin/htmsr.dll

      6417013: D:/app/oracle/product/9.2.0/bin/IMP.EXE

      6417013: D:/app/oracle/product/9.2.0/bin/jtdsr.dll

      6417013: D:/app/oracle/product/9.2.0/bin/kvxwpsa.dll

      6417013: D:/app/oracle/product/9.2.0/bin/mw8sr.dll

      6417013: D:/app/oracle/product/9.2.0/bin/oidldapd.exe +> NEW

      6417013: D:/app/oracle/product/9.2.0/bin/oracle.exe

      6417013: D:/app/oracle/product/9.2.0/bin/oraclient9.dll

      6417013: D:/app/oracle/product/9.2.0/bin/oracommon9.dll

      6417013: D:/app/oracle/product/9.2.0/bin/ORACORE9.DLL

      6417013: D:/app/oracle/product/9.2.0/bin/orageneric9.dll

      6417013: D:/app/oracle/product/9.2.0/bin/oran9.dll

      6417013: D:/app/oracle/product/9.2.0/bin/ORANK59.DLL

      6417013: D:/app/oracle/product/9.2.0/bin/oranl9.dll

      6417013: D:/app/oracle/product/9.2.0/bin/oranldap9.dll

      6417013: D:/app/oracle/product/9.2.0/bin/oranmi.dll

      6417013: D:/app/oracle/product/9.2.0/bin/orannts9.dll

      6417013: D:/app/oracle/product/9.2.0/bin/ORAPLS9.DLL

      6417013: D:/app/oracle/product/9.2.0/bin/ORAXML9.DLL

      6417013: D:/app/oracle/product/9.2.0/bin/pdfsr.dll

      6417013: D:/app/oracle/product/9.2.0/bin/SQLLDR.EXE

      6417013: D:/app/oracle/product/9.2.0/bin/sqlplus.exe

      6417013: D:/app/oracle/product/9.2.0/bin/sqlplusw.exe

      6417013: D:/app/oracle/product/9.2.0/bin/vdc.dll

      6417013: D:/app/oracle/product/9.2.0/bin/wp6sr.dll

      6417013: D:/app/oracle/product/9.2.0/bin/xlssr.dll

      6417013: D:/app/oracle/product/9.2.0/plsql/lib/orapls9.lib +> NEW

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/oracle.sym

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/oraclient9.sym

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/oracommon9.sym

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/ORACORE9.SYM

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/orageneric9.sym

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/ORAPLS9.SYM

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtbadd.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtbath.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtbkrs.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtbmas.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtbobg.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtbrpc.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtbrrq.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtbsqu.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtbut4.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtbutl.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtgen.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtofln.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtpexp.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtsath.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtxdbp.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/prvtxdbz.plb

      6417013: D:/app/oracle/product/9.2.0/rdbms/admin/recover.bsq

      6417013: D:/app/oracle/product/9.2.0/rdbms/mesg/dbvus.msb

      6417013: D:/app/oracle/product/9.2.0/rdbms/mesg/oraus.msb

      6417013: D:/app/oracle/product/9.2.0/rdbms/jlib/CDC.jar

      6417013: D:/app/oracle/product/9.2.0/cpu/cpuoct2007/catcpu.sql +> NEW

      6417013: D:/app/oracle/product/9.2.0/cpu/cpuoct2007/catcpu_rollback.sql +> NEW

      6417013: D:/app/oracle/product/9.2.0/cpu/cpuoct2007/ctxcpu.sql +> NEW

      6417013: D:/app/oracle/product/9.2.0/cpu/cpuoct2007/imcpu.sql +> NEW

      6417013: D:/app/oracle/product/9.2.0/cpu/cpuoct2007/imcpu_rollback.sql +> NEW

      6417013: D:/app/oracle/product/9.2.0/cpu/cpuoct2007/jvmcpu.sql +> NEW

      6417013: D:/app/oracle/product/9.2.0/cpu/cpuoct2007/sdocpu.sql +> NEW

      6417013: D:/app/oracle/product/9.2.0/cpu/cpuoct2007/wkcpu.sql +> NEW

      6417013: D:/app/oracle/product/9.2.0/cpu/cpuoct2007/xdbcpu.sql +> NEW

      6417013: D:/app/oracle/product/9.2.0/soap/webapps/soap/WEB-INF/lib/soap.jar

      6417013: D:/app/oracle/product/9.2.0/soap/webapps/soap/WEB-INF/lib/xmlparserv2-soap.jar +> NEW

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/Apache.exe

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/ApacheCore.dll

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/bin/htdigest.exe

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/bin/htpasswd.exe

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/bin/rotatelogs.exe

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/modules/ApacheModuleDigest.dll

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/modules/ApacheModuleDMS.dll

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/modules/ApacheModuleFastCGI.dll

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/modules/ApacheModuleOprocmgr.dll

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/modules/ApacheModuleProxy.dll

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/modules/ApacheModuleRewrite.dll

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/modules/ApacheModuleSecurity.dll +> NEW

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/modules/ApacheModuleSSL.dll

      6417013: D:/app/oracle/product/9.2.0/Apache/Apache/htdocs/mod_ose.html

      6417013: D:/app/oracle/product/9.2.0/Apache/Jserv/ApacheJServ.jar

      6417013: D:/app/oracle/product/9.2.0/Apache/Jserv/ApacheModuleJServ.dll

      6417013: D:/app/oracle/product/9.2.0/Apache/Jserv/dms2Client.jar

      6417013: D:/app/oracle/product/9.2.0/Apache/Jserv/dms2Server.jar

      6417013: D:/app/oracle/product/9.2.0/Apache/Jserv/servlets/IsItWorking.class

      6417013: D:/app/oracle/product/9.2.0/Apache/Jserv/servlets/IsItWorking.java

      6417013: D:/app/oracle/product/9.2.0/ocs4j/lib/cache.jar

      6417013: D:/app/oracle/product/9.2.0/Apache/open_ssl/bin/openssl.exe

      6417013: D:/app/oracle/product/9.2.0/lib/xmlcomp.jar

      6417013: D:/app/oracle/product/9.2.0/ctx/admin/driload.plb

      6417013: D:/app/oracle/product/9.2.0/ord/jlib/ordimimg.jar

      6417013: D:/app/oracle/product/9.2.0/ord/jlib/ordimimg_depl.jar

      6417013: D:/app/oracle/product/9.2.0/javavm/admin/classes.bin

      6417013: D:/app/oracle/product/9.2.0/javavm/admin/ordimimg_lib.jar +> NEW

      6417013: D:/app/oracle/product/9.2.0/md/admin/prvtcat.plb

      6417013: D:/app/oracle/product/9.2.0/md/admin/prvtgmd.plb

      6417013: D:/app/oracle/product/9.2.0/md/admin/prvtrtr.plb

      6417013: D:/app/oracle/product/9.2.0/md/admin/sdolrsb.plb

      6417013: D:/app/oracle/product/9.2.0/md/admin/sdopatch.sql

      6417013: D:/app/oracle/product/9.2.0/ultrasearch/lib/ultrasearch_midtier.jar

      6417013: D:/app/oracle/product/9.2.0/ultrasearch/admin/wk0qapi.plb

      6417013: D:/app/oracle/product/9.2.0/ultrasearch/admin/wk0qry.plb

      6417013: D:/app/oracle/product/9.2.0/oracore/zoneinfo/readme.txt

      6417013: D:/app/oracle/product/9.2.0/oracore/zoneinfo/timezlrg.dat

      6417013: D:/app/oracle/product/9.2.0/oracore/zoneinfo/timezone.dat

      Retrieving patch to roll back: patch_found = 1.
      Looking for pre-patch readme D:\app\oracle\product\9.2.0\.patch_storage\6417013\custom\pre.txt

      Rolling back with all-node mode.
      OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

      Oracle instances have been shut down, proceeding with auto-rollback.


      Starting to remove patch from the system at 03-29-2008_14-43-41.

      Looking for pre-patch script D:\app\oracle\product\9.2.0\.patch_storage\6417013\custom\scripts\pre.bat

      preparing to execute D:\app\oracle\product\9.2.0\.patch_storage\6417013\custom\scripts\pre.bat

      Executing the Roll-back pre-patch script (D:\app\oracle\product\9.2.0\.patch_storage\6417013\custom\scripts\pre.bat)...

      ======= Pre-Install Script Output ==============================

      exit code = "0"

      ======= End of Pre-Install Script Output =======================

      Removing patch 6417013...

      Restore Archive File
      Restore Copy File
      Restoring copied files...

      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\network\agent\events\oracle\rdbms\space\tbspfull.tcl_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\agentctl.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\agntsrvc.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\ctxhx.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\dbsnmp.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\dbv.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\exp.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\htmcnv.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\htmsr.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\imp.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\jtdsr.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\kvxwpsa.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\mw8sr.dll_done_6417013
      Restoring d:\app\oracle\product\9.2.0\bin\oidldapd.exe.

      Restoring d:\app\oracle\product\9.2.0\bin\oracle.exe.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\oracle.exe_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\oracle.exe

      Restoring d:\app\oracle\product\9.2.0\bin\oraclient9.dll.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\oraclient9.dll_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\oraclient9.dll

      Restoring d:\app\oracle\product\9.2.0\bin\oracommon9.dll.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\oracommon9.dll_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\oracommon9.dll

      Restoring d:\app\oracle\product\9.2.0\bin\oracore9.dll.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\oracore9.dll_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\oracore9.dll

      Restoring d:\app\oracle\product\9.2.0\bin\orageneric9.dll.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\orageneric9.dll_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\orageneric9.dll

      Restoring d:\app\oracle\product\9.2.0\bin\oran9.dll.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\oran9.dll_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\oran9.dll

      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\orank59.dll_done_6417013
      Restoring d:\app\oracle\product\9.2.0\bin\oranl9.dll.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\oranl9.dll_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\oranl9.dll

      Restoring d:\app\oracle\product\9.2.0\bin\oranldap9.dll.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\oranldap9.dll_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\oranldap9.dll

      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\oranmi.dll_done_6417013
      Restoring d:\app\oracle\product\9.2.0\bin\orannts9.dll.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\orannts9.dll_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\orannts9.dll

      Restoring d:\app\oracle\product\9.2.0\bin\orapls9.dll.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\orapls9.dll_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\orapls9.dll

      Restoring d:\app\oracle\product\9.2.0\bin\oraxml9.dll.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\oraxml9.dll_pre_6417013 -> d:\app\oracle\product\9.2.0\bin\oraxml9.dll

      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\pdfsr.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\sqlldr.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\sqlplus.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\sqlplusw.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\vdc.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\wp6sr.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\bin\xlssr.dll_done_6417013
      Restoring d:\app\oracle\product\9.2.0\plsql\lib\orapls9.lib.

      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\oracle.sym_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\oraclient9.sym_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\oracommon9.sym_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\oracore9.sym_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\orageneric9.sym_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\orapls9.sym_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtbadd.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtbath.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtbkrs.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtbmas.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtbobg.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtbrpc.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtbrrq.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtbsqu.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtbut4.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtbutl.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtgen.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtofln.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtpexp.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtsath.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtxdbp.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\prvtxdbz.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\admin\recover.bsq_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\mesg\dbvus.msb_done_6417013
      Restoring d:\app\oracle\product\9.2.0\rdbms\mesg\oraus.msb.

      Restoring file: D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\mesg\oraus.msb_pre_6417013 -> d:\app\oracle\product\9.2.0\rdbms\mesg\oraus.msb

      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\rdbms\jlib\cdc.jar_done_6417013
      Restoring d:\app\oracle\product\9.2.0\cpu\cpuoct2007\catcpu.sql.

      Restoring d:\app\oracle\product\9.2.0\cpu\cpuoct2007\catcpu_rollback.sql.

      Restoring d:\app\oracle\product\9.2.0\cpu\cpuoct2007\ctxcpu.sql.

      Restoring d:\app\oracle\product\9.2.0\cpu\cpuoct2007\imcpu.sql.

      Restoring d:\app\oracle\product\9.2.0\cpu\cpuoct2007\imcpu_rollback.sql.

      Restoring d:\app\oracle\product\9.2.0\cpu\cpuoct2007\jvmcpu.sql.

      Restoring d:\app\oracle\product\9.2.0\cpu\cpuoct2007\sdocpu.sql.

      Restoring d:\app\oracle\product\9.2.0\cpu\cpuoct2007\wkcpu.sql.

      Restoring d:\app\oracle\product\9.2.0\cpu\cpuoct2007\xdbcpu.sql.

      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\soap\webapps\soap\web-inf\lib\soap.jar_done_6417013
      Restoring d:\app\oracle\product\9.2.0\soap\webapps\soap\web-inf\lib\xmlparserv2-soap.jar.

      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\apache.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\apachecore.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\bin\htdigest.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\bin\htpasswd.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\bin\rotatelogs.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\modules\apachemoduledigest.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\modules\apachemoduledms.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\modules\apachemodulefastcgi.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\modules\apachemoduleoprocmgr.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\modules\apachemoduleproxy.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\modules\apachemodulerewrite.dll_done_6417013
      Restoring d:\app\oracle\product\9.2.0\apache\apache\modules\apachemodulesecurity.dll.

      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\modules\apachemodulessl.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\apache\htdocs\mod_ose.html_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\jserv\apachejserv.jar_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\jserv\apachemodulejserv.dll_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\jserv\dms2client.jar_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\jserv\dms2server.jar_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\jserv\servlets\isitworking.class_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\jserv\servlets\isitworking.java_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\ocs4j\lib\cache.jar_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\apache\open_ssl\bin\openssl.exe_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\lib\xmlcomp.jar_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\ctx\admin\driload.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\ord\jlib\ordimimg.jar_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\ord\jlib\ordimimg_depl.jar_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\javavm\admin\classes.bin_done_6417013
      Restoring d:\app\oracle\product\9.2.0\javavm\admin\ordimimg_lib.jar.

      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\md\admin\prvtcat.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\md\admin\prvtgmd.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\md\admin\prvtrtr.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\md\admin\sdolrsb.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\md\admin\sdopatch.sql_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\ultrasearch\lib\ultrasearch_midtier.jar_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\ultrasearch\admin\wk0qapi.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\ultrasearch\admin\wk0qry.plb_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\oracore\zoneinfo\readme.txt_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\oracore\zoneinfo\timezlrg.dat_done_6417013
      File patched on previous run, will be skipped : D:\app\oracle\product\9.2.0\.patch_storage\6417013\\oracore\zoneinfo\timezone.dat_done_6417013
      Restore Jar File
      Restoring jar files...


      OPatch encounters the following file roll-back issues:
      The following files had problems with being restored:
      1.     d:\app\oracle\product\9.2.0\bin\oracle.exe
      2.     d:\app\oracle\product\9.2.0\bin\oraclient9.dll
      3.     d:\app\oracle\product\9.2.0\bin\oracommon9.dll
      4.     d:\app\oracle\product\9.2.0\bin\oracore9.dll
      5.     d:\app\oracle\product\9.2.0\bin\orageneric9.dll
      6.     d:\app\oracle\product\9.2.0\bin\oran9.dll
      7.     d:\app\oracle\product\9.2.0\bin\oranl9.dll
      8.     d:\app\oracle\product\9.2.0\bin\oranldap9.dll
      9.     d:\app\oracle\product\9.2.0\bin\orannts9.dll
      10.     d:\app\oracle\product\9.2.0\bin\orapls9.dll
      11.     d:\app\oracle\product\9.2.0\bin\oraxml9.dll
      12.     d:\app\oracle\product\9.2.0\rdbms\mesg\oraus.msb

      Replying 'Y' will terminate the patch roll-back immediately. It WILL NOT restore any updates that have been performed to this point. It WILL NOT update the inventory.
      Replying 'N' will update the inventory showing the patch has been removed.

      Do you want to STOP?
      Please respond Y|N >
      Y (auto-answered by -silent)

      File Back-up Errors!
      ERROR: OPatch failed during patching, possibly due to missing files.

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

      Please provide me a resolution as I have tried my best in google, yahoo and different place with no luck as yet.

      Thanks,

      blf2vkr
        • 1. Re: OPatch encounters the following file roll-back issues: File Back-up Errors!
          480154
          A couple of things to check:

          Are you sure patch 6417013 is not already installed?

          Has the o/s user got the correct file permissions i.e. in the admin group?

          Did the instance shut down?
          • 2. Re: OPatch encounters the following file roll-back issues: File Back-up Errors!
            584650
            Are you sure everything has been shut down or not started up while you were patching. Those list of files at the end are the commonly loaded files in memory when the oracle db is running.
            • 3. Re: OPatch encounters the following file roll-back issues: File Back-up Errors!
              user453063
              Hi there:

              My greetings and regards for all the efforts you are putting to resolve this issue.

              Thanks!

              I have checked all the Oracle Related services including Distributed Transaction Coordinator were stopped. In a summury the following services were stopped before the patched were applied.

              1. OracleOra920Agent
              2. OracleOra920TNSListener
              3. OracleServiceMission
              4. OracleServiceReposit
              5. Distributed Transaction Coordinator


              Here it shows as follows when I execute the command lsinventory:

              D:\app\oracle\product\9.2.0\OPatch>opatch lsinventory

              Oracle Interim Patch Installer version 1.0.0.0.57
              Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

              We recommend you refer to the OPatch documentation under
              OPatch/docs for usage reference. We also recommend using
              the latest OPatch version. For the latest OPatch version
              and other support related issues, please refer to document
              293369.1 which is viewable from metalink.oracle.com

              Oracle Home : D:\app\oracle\product\9.2.0
              Oracle Home Inventory : D:\app\oracle\product\9.2.0\inventory
              Central Inventory : C:\Program Files\oracle\inventory
              from : N/A
              OUI location : D:\app\oracle\product\9.2.0\oui
              OUI shared library : D:\app\oracle\product\9.2.0\oui\lib\win32\oraInstaller.dll
              Java location : "D:\app\oracle\product\9.2.0\jre\1.4.2\bin\java.exe"
              Log file location : D:\app\oracle\product\9.2.0/.patch_storage/<patch ID>/*.log

              Creating log file "D:\app\oracle\product\9.2.0\.patch_storage\LsInventory__03-31-2008_10-34-33.log"

              Result:


              Installed Patch List:
              =====================
              1) Patch 5878965 applied on Sat Mar 29 14:43:08 EST 2008
              [ Base Bug(s): 5726045  ]
              2) Patch 6417013 applied on Fri Dec 21 10:42:43 EST 2007
              [ Base Bug(s): 4689959 5263201 5354122 5214373 5901910 5211863 3308166 4057920 5660451 5172444 5744161 5530583 508423
              9 4660718 5731178 3578226 5887105 6395038 5901875 4483286 5523578 6079582 3755693 5576565 5609388 5385973 5845928 2558849 5
              369855 5865568 5958589 3036540 5116414 6417013 4401437 4219214 6130292 5723241 6130293 5860241 3870360 5129407 5065418 6404
              861 5671074 6263319 5639513 5631836 5225596 5068565 5530958 5275475 5284862 5169684 5566937 5495695 5977665 5396877 6079599
              6133610 5223027 4628013 5681320 5911532 4254094 5188321 5602654 3667025 4480159 6028753 3378426 5728380 5703297 5650477 60
              38279 5842790 4905638 4593537 5629365 5970484 5933477 5523799 2775579 5895827 5345999 5031712 5140931 3639130 3521347 45415
              24 5491035 5391326 5652380 5845232 5915901 3679014 4901089 4695511 3920693 4372359 4969005 5505981 5509707 5765361 5726094
              5562159 6128197 3959063 5762618 2965960 4966417 5149865 5742895 4998554 5887577 ]




              OPatch succeeded.
              OPatch returns with error code = 0

              D:\app\oracle\product\9.2.0\OPatch>


              Truly Yours,

              blf2vkr
              • 4. Re: OPatch encounters the following file roll-back issues: File Back-up Errors!
                480154
                Patch 6417013 applied on Fri Dec 21 10:42:43 EST
                2007
                [ Base Bug(s): 4689959 5263201 5354122 5214373
                5901910 5211863 3308166 4057920 5660451 5172444
                5744161 5530583 508423
                4660718 5731178 3578226 5887105 6395038 5901875
                4483286 5523578 6079582 3755693 5576565 5609388
                5385973 5845928 2558849 5
                69855 5865568 5958589 3036540 5116414 6417013 4401437
                4219214 6130292 5723241 6130293 5860241 3870360
                5129407 5065418 6404
                861 5671074 6263319 5639513 5631836 5225596 5068565
                5530958 5275475 5284862 5169684 5566937 5495695
                5977665 5396877 6079599
                6133610 5223027 4628013 5681320 5911532 4254094
                5188321 5602654 3667025 4480159 6028753 3378426
                5728380 5703297 5650477 60
                8279 5842790 4905638 4593537 5629365 5970484 5933477
                5523799 2775579 5895827 5345999 5031712 5140931
                3639130 3521347 45415
                24 5491035 5391326 5652380 5845232 5915901 3679014
                4901089 4695511 3920693 4372359 4969005 5505981
                5509707 5765361 5726094
                5562159 6128197 3959063 5762618 2965960 4966417
                5149865 5742895 4998554 5887577 ]

                It's already installed.