EM Patch apply failing with: Prereq "checkActiveFilesAndExecutables" is not executed

This post is also available in: Português

Those days, when trying to apply Database Patches using the Oracle Enterprise Manager 12c, I was getting an error: Prereq "checkActiveFilesAndExecutables" is not executed.

Invoking prereq "checkactivefilesandexecutables"

Prereq "checkActiveFilesAndExecutables" is not executed.

The details are:
No patch location specified.

OPatch failed with error code 2
 
ERROR: Failed to invoke 'opatch prereq checkActiveFilesAndExecutables' 
ERROR: Some processes are still running.

The last error said something about "processes are still running". However, checking with "ps", there wasn't any oracle process executing. The DB was already down.

Checking the log file generated inside the DB server ( $ORACLE_HOME/cfgtoollogs/opatch ), the things start becoming even more strange:

[Nov 24, 2015 4:01:30 PM]    PREREQ session
[Nov 24, 2015 4:01:31 PM]    OPatch invoked as follows: 'prereq checkActiveFilesAndExecutables -phBaseFile /tmp/JOB_254C3E1748426EDAE053DE3FDD0A00B7/ChkProcess_PatchList_ciocopbddrjs002 -invPtrLoc /u01/app/oracle/product/12.1.2/dbhome_1/oraInst.loc '
[Nov 24, 2015 4:01:31 PM]    Could not get central inventory using NGOUI; oracle.sysman.nextgen.utils.NextGenInventoryUtil
[Nov 24, 2015 4:01:31 PM]    OUI-67077:
                             Oracle Home       : /u01/app/oracle/product/12.1.2/dbhome_1
                             Central Inventory : /u01/app/oraInventory
                                from           : /u01/app/oracle/product/12.1.2/dbhome_1/oraInst.loc
                             OPatch version    : 12.1.0.1.10
                             OUI version       : 12.1.0.2.0
                             OUI location      : /u01/app/oracle/product/12.1.2/dbhome_1/oui
                             Log file location : /u01/app/oracle/product/12.1.2/dbhome_1/cfgtoollogs/opatch/opatch2015-11-24_16-01-30PM_1.log
[Nov 24, 2015 4:01:31 PM]    Patch history file: /u01/app/oracle/product/12.1.2/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
[Nov 24, 2015 4:01:31 PM]    Invoking prereq "checkactivefilesandexecutables"
[Nov 24, 2015 4:01:31 PM]    Prereq "checkActiveFilesAndExecutables" is not executed.
[Nov 24, 2015 4:01:31 PM]    The details are:
                             No patch location specified.
[Nov 24, 2015 4:01:31 PM]    Finishing PrereqSession at Tue Nov 24 16:01:31 BRST 2015

So actually the error was "No patch location specified". Smell of bug is in the air.

After researching in MOS, my conclusion became true: Bug 21469024 - Prereq checkActiveFilesAndExecutables fails with "No patch location specified"

There was also a MOS Doc talking about that: Patching a Database Using Cloud Control With In place Patching Fails At Step "Check If All Processes Are Shut Down" (Doc ID 2077727.1)

The solution for this bug is basically to apply the EM-DB-BP 12.1.0.8.4 bundle patch. You can find it for download in Doc ID 2039331.1.

Actually, the bundles are cumulative monthly patches. Going forward, the most recent bundle will contain all patches from previous months., you can download the latest. Apply both "OMS-Side System" and "Agent-Side-Monitoring".

That's it. YAOB.

0