cancel
Showing results for 
Search instead for 
Did you mean: 

Problem applying patch collection with OPatch in Oracle 11.2.0.1

Former Member
0 Kudos

Hi

I have just installed Oracle 11.2.0.1 on Windows server 2008 SR2 prior to installing SAP and I'm getting the following error when trying to apply patch collection 10 with OPatch

Following files are active :

D:\oracle\CLU\112\bin\oci.dll

INFO:Prerequisite check "CheckActiveFilesAndExecutables" failed.

OPatch failed with error code = 74

Which seems to suggestthat some service or process in Oracle is still running but I've stopped the Oracle services and the distributed transaction coordinator but still I get the problem.

The full error log is below :

SEVERE:OPatch invoked as follows: 'apply '

INFO:

Oracle Home : D:\oracle\CLU\112

Central Inventory : C:\Program Files\Oracle\Inventory

from : n/a

OPatch version : 11.2.0.1.3

OUI version : 11.2.0.1.0

OUI location : D:\oracle\CLU\112\oui

Log file location : D:\oracle\CLU\112\cfgtoollogs\opatch\opatch2011-02-15_15-21-15PM.log

INFO:Patch history file: D:\oracle\CLU\112\cfgtoollogs\opatch\opatch_history.txt

INFO:Starting ApplySession at Tue Feb 15 15:21:15 GMT 2011

INFO:Starting Apply Session at Tue Feb 15 15:21:15 GMT 2011

INFO:PatchObject::PatchObject() Patch location is X:\SOFTWARE\ORACLE\Patches\Collection\p10432045_112010_MSWINx86\10432045

INFO:PatchObject::createPatchObject() Patch location is X:\SOFTWARE\ORACLE\Patches\Collection\p10432045_112010_MSWINx86\10432045

INFO:PatchObject::createPatchObject() patch location is X:\SOFTWARE\ORACLE\Patches\Collection\p10432045_112010_MSWINx86\10432045

INFO:ApplySession applying interim patch '10432045' to OH 'D:\oracle\CLU\112'

INFO:Starting to apply patch to local system at Tue Feb 15 15:21:16 GMT 2011

INFO:Patch 10432045 has no conflicts/superset wiht any other patch processed till now

INFO:Checking conflicts for patch: 10432045

INFO:Checking conflicts/supersets for patch: 10432045 with patch:10432045

INFO:Start the Apply initScript at Tue Feb 15 15:21:19 GMT 2011

INFO:Finish the Apply initScript at Tue Feb 15 15:21:19 GMT 2011

INFO:

Running prerequisite checks...

INFO:Space Needed : 1788152458

INFO:Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 10432045

INFO:

Following files are active :

D:\oracle\CLU\112\bin\oci.dll

INFO:Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following files are active :

D:\oracle\CLU\112\bin\oci.dll

SEVERE:OUI-67074:ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveFilesAndExecutables" failed.

INFO:System intact, OPatch will not attempt to restore the system

INFO:Finishing ApplySession at Tue Feb 15 15:21:25 GMT 2011

INFO:Total time spent waiting for user-input is 0 seconds. Finish at Tue Feb 15 15:21:25 GMT 2011

INFO:Stack Description: oracle.opatch.PrereqFailedException: Prerequisite check "CheckActiveFilesAndExecutables" failed.

INFO:StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:4416)

INFO:StackTrace: oracle.opatch.ApplySession.processLocal(ApplySession.java:3695)

INFO:StackTrace: oracle.opatch.ApplySession.process(ApplySession.java:5577)

INFO:StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:1719)

INFO:StackTrace: oracle.opatch.OPatch.main(OPatch.java:630)

can anyone help please.

Thanks

Steve

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

I've just found the answer on this Oracle forum

It seems that If you get an error like below and the patch wonu2019t install

Running prerequisite checks...

INFO:Space Needed : 1788152458

INFO:Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 10432045

INFO:

Following files are active :

D:\oracle\CLU\112\bin\oci.dll

INFO:Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Opatch failed with error code = 74

First stop the Distributed Transaction Coordinator service and try again.

This is a known problem with Oracle on Windows, there are a few windows services which lock the Oracle oci.dll file and therefore we get the error above. From a couple of forums Iu2019ve established that there are at least two known services which do this but there may be more that we donu2019t know about

Distributed Transaction Coordinator

Machine Debug Manager

If it still doesnu2019t work then rename the ORACLE_HOME directory and reboot

eg Change D:\oracle\CLU\112 to D:\oracle\CLU\112-orig

Reboot and then rename it back again

Opatch will now work fine.