:

Prerequisite check “CheckActiveFilesAndExecutables” failed

Pre-requisite Check Failed Oracle Patch

Oracle Database: 11.2.0.3
Platform: Windows Server 2003, Sp2

The Problem

When using Opatch utility 11.2.0.1.3, and attempting to patch an Oracle 11g home, I got the following:

Verifying environment and performing prerequisite checks…

Prerequisite check “CheckActiveFilesAndExecutables” failed.

The details are:

Following files are active :

D:\oracle\product\11.2.0\dbhome_1\bin\oraclient11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\orageneric11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\orapls11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\oracommon11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\oci.dll
D:\oracle\product\11.2.0\dbhome_1\bin\orahasgen11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\oraocr11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\oraocrb11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\oraocrutl11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\oran11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\orantcp11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\orannzsbb11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\orazt11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\oraztkg11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\orasql11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\oranls11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\orasnls11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\oraxml11.dll
D:\oracle\product\11.2.0\dbhome_1\bin\oraasmclnt11.dll
[ Error during Prerequisite for apply Phase]. Detail: ApplySession fa
[ Error during Prerequisite for apply Phase]. Detail: ApplySession failed during prerequisite checks: Prerequisite check “CheckActiveFilesAndExecutables” failed.

The Problem

There are still services which are running locking the above files from being updated.

The Solution

An ideal way is to shutdown all Oracle related services running out of the home, then use process explorer which is a Windows product to search for any handles which have the Oracle home in the name and it will display anything still running out of that home. For example, I search for “D:\Oracle\product\11.2.0\dbhome_1” and see what is still running.

And one very important non Oracle service to shutdown is the Distributed Transaction Coordinator. Until recently, this service was not specified within the Oracle documentation being required to be stopped, but it is.

Like it, share it...

Category: Upgrades


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *