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