RE: Please help: OPatch fails (Following files are active : c:\oracle\ora11g\bin\oci.dll)

  • From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
  • To: "MarcinK@xxxxxxxxxxxxxxxxxxxxx" <MarcinK@xxxxxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 14 Jun 2011 13:52:12 +0200

Hi,

On windows you can user process explorer from sysinternals (now owned by 
Microsoft I believe).
On linux you can use lsof.

You could check for any open files in the oracle home before applying the 
patch, or you could check a specific file when encountering an error during the 
patching.


Regards,


Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
---
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Kedryna Marcin-HKP384
Sent: dinsdag 14 juni 2011 13:39
To: oracle-l@xxxxxxxxxxxxx
Subject: Please help: OPatch fails (Following files are active : 
c:\oracle\ora11g\bin\oci.dll)



Hi All, 

I have the problem patching Oracle. 
I get the error: 

Following files are active :
c:\oracle\ora11g\bin\oci.dll
ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveF
ilesAndExecutables" failed.
System intact, OPatch will not attempt to restore the system

OPatch failed with error code = 74

It seems that some other services are using this dll. 
I read about this on the web and did some research and I found out that this 
oci.dll is beeing used by another services, and thus patch cannot be applied. 
For example if I turned off manually servrices: 
COM+ System Application
VMware Tools Service

It did work.  Sometimes it works without turning off these services. 
But I also found that when I turn them off from the script that runs the patch 
they sometimes immediately come up again and my patch fails with the same 
error. 

Is there a solution to this problem?  Can I find out what services I need to 
turn off before running the patch?

Please help me and thanks in advance,

Marcin 


additional info from log:
 
database version:  11.2.0.1.0
Checking if patch is not already installed
Patch is not installed.
Applying patch...
Invoking OPatch 11.2.0.1.4

Oracle Interim Patch Installer version 11.2.0.1.4
Copyright (c) 2010, Oracle Corporation.  All rights reserved.


Oracle Home       : c:\oracle\ora11g
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 11.2.0.1.4
OUI version       : 11.2.0.1.0
OUI location      : c:\oracle\ora11g\oui
Log file location : c:\oracle\ora11g\cfgtoollogs\opatch\opatch2011-04-26_03-13-5
0AM.log

Patch history file: c:\oracle\ora11g\cfgtoollogs\opatch\opatch_history.txt

ApplySession applying interim patch '11731176' to OH 'c:\oracle\ora11g'
Interim patch 11731176 is a superset of the patch(es) [  10100101 ] in the Oracl
e Home
OPatch will rollback the subset patches and apply the given patch.

Running prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following files are active :
c:\oracle\ora11g\bin\oci.dll
ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveF
ilesAndExecutables" failed.
System intact, OPatch will not attempt to restore the system
--------------------------------------------------------------------------------

The following warnings have occurred during OPatch execution:
1) OUI-67620:Interim patch 11731176 is a superset of the patch(es) [  10100101 ]
 in the Oracle Home
--------------------------------------------------------------------------------


OPatch failed with error code = 74
--
//www.freelists.org/webpage/oracle-l


Other related posts: