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

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_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

---
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kedryna Marcin-HKP384
Sent: dinsdag 14 juni 2011 13:39
To: oracle-l_at_freelists.org
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
--
http://www.freelists.org/webpage/oracle-l