Re: Patch Issue 11g

The distributed transaction manager is a common problem patching oracle on windows. You need to shut it down and disable the service until patching is complete.

On Wed, Jul 27, 2016 at 4:45 PM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Of course the other people are getting "files active" error, all the time.
> The first thing to do before even installing the patch is to shut down the
> distributed transaction manager service and WMI service. For the remaining
> files that will stay active more often than not, you can use this:
>
> https://technet.microsoft.com/en-us/sysinternals/bb896653
>
> That is Microsoft process explorer which can find the process holding the
> DLL. Of course, the permanent solution to the problem can be found here:
> https://www.redhat.com and it includes formatting your C: drive to become
> an XFS file system.
>
>
> On 07/27/2016 05:31 PM, angelo wrote:
>
> Hello,
>
> Have you seen this kind of issues before ?
>
> I was trying to apply a Patch ( last cpu patch from July 16 ) and got
> these error below about *.DLLs from Oracle on red tagged lines
>
> But everything, all Oracle´s related service was stopped
> This server is not production yet
>
> Oracle Windows 11.2.0.4.0 x64
>
> patch to apply 23530402
>
> thank you for comments
>
> regards,
>
> angelo
>
>
>
> [27/07/2016 18:11:17] OUI exists, the oraclehome is OUI based.
> [27/07/2016 18:11:17] OUI exists, the oraclehome is OUI based.
> [27/07/2016 18:11:18] OPatch invoked as follows: 'apply '
> [27/07/2016 18:11:18] OUI-67077:
> Oracle Home :
> D:\U01\product\11.2.0\dbhome_1
> Inventário Central: C:\Program
> Files\Oracle\Inventory
> de :
> Versão de OPatch : 11.2.0.3.14
> Versão de OUI : 11.2.0.4.0
> Localização de OUI :
> D:\U01\product\11.2.0\dbhome_1\oui
> Localização do arquivo de log:
> D:\U01\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch2016-07-27_18-11-17PM_1.log
> [27/07/2016 18:11:18] Patch history file:
> D:\U01\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch_history.txt
> [27/07/2016 18:11:21] [OPSR-MEMORY-1] : after
> installInventory.getAllCompsVect() call : 9 (MB)
> [27/07/2016 18:11:21] [OPSR-MEMORY-2] : after loading
> rawOneOffList9 (MB)
> [27/07/2016 18:11:21] NApply::new process() calls old process() if
> CAS is not enabled.
> [27/07/2016 18:11:21] Verifying environment and performing
> prerequisite checks...
> [27/07/2016 18:11:21] [OPSR-MEMORY-3] : before loading cooked one
> off : 13 (MB)
> [27/07/2016 18:11:21] [OPSR-MEMORY-4] : after filling cookedOneOffs
> and when inventory is loaded.. : 14 (MB)
> [27/07/2016 18:11:22] Checking conflict among patches...
> [27/07/2016 18:11:22] checkConflictAmongPatchesWithDetail start ->
> Wed Jul 27 18:11:22 BRT 2016
> [27/07/2016 18:11:22] Wed Jul 27 18:11:22 BRT 2016
> [27/07/2016 18:11:22] Adapter can go list: 23530402
> [27/07/2016 18:11:22] Adapter not need list:
> [27/07/2016 18:11:22] Adapter auto-rollback list:
> [27/07/2016 18:11:22] checkConflictAmongPatchesWithDetail end ->
> Wed Jul 27 18:11:22 BRT 2016
> [27/07/2016 18:11:22] Intra-Conflict check PASSED
> [27/07/2016 18:11:22] Checking if Oracle Home has components
> required by patches...
> [27/07/2016 18:11:22] Check if patch "23530402" is a no-op patch.
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory: oracle.sdo,
> 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.sysman.agent, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.rdbms.tg4msql, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.rdbms.tg4sybs, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.rdbms.tg4tera, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.rdbms.tg4ifmx, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.rdbms.tg4db2, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.oraolap, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.oraolap.api, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.rdbms.ic, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.rdbms.dv, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.network.aso, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.has.cfs, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.has.crs, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory:
> oracle.has.cvu, 11.2.0.4.0
> [27/07/2016 18:11:22] Opt. comp. not in OH inventory: oracle.usm,
> 11.2.0.4.0
> [27/07/2016 18:11:22] [ oracle.sdo, 11.2.0.4.0 ] , [
> oracle.sysman.agent, 11.2.0.4.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.4.0 ] ,
> [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4tera, 11.2.0.4.0 ]
> , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0
> ] , [ oracle.oraolap, 11.2.0.4.0 ] , [ oracle.oraolap.api, 11.2.0.4.0 ] , [
> oracle.rdbms.ic, 11.2.0.4.0 ] , [ oracle.rdbms.dv, 11.2.0.4.0 ] , [
> oracle.network.aso, 11.2.0.4.0 ] , [ oracle.has.cfs, 11.2.0.4.0 ] , [
> oracle.has.crs, 11.2.0.4.0 ] , [ oracle.has.cvu, 11.2.0.4.0 ] , [
> oracle.usm, 11.2.0.4.0 ]
> [27/07/2016 18:11:22] CheckMissingComp: OPatch is not running w/
> 2-phase patching, re-build FVs
> [27/07/2016 18:11:22] Checking conflicts against Oracle Home...
> [27/07/2016 18:11:22] checkConflictAgainstOHWithDetail start -> Wed
> Jul 27 18:11:22 BRT 2016
> [27/07/2016 18:11:22] Wed Jul 27 18:11:22 BRT 2016
> [27/07/2016 18:11:22] Adapter can go list: 23530402
> [27/07/2016 18:11:22] Adapter not need list:
> [27/07/2016 18:11:22] Adapter auto-rollback list:
> [27/07/2016 18:11:22] checkConflictAgainstOHWithDetail end -> Wed
> Jul 27 18:11:22 BRT 2016
> [27/07/2016 18:11:23] Running prerequisite checks...
> [27/07/2016 18:11:23] Space Needed : 2042.208MB
> [27/07/2016 18:11:23] Prereq checkPatchApplicableOnCurrentPlatform
> Passed for patch : 23530402
> [27/07/2016 18:11:23] Following files are active :
>
> D:\U01\product\11.2.0\dbhome_1\bin\oracell11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraasmclnt11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orapls11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orageneric11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraclient11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oracommon11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraplp11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraxml11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orannzsbb11.dll
> D:\U01\product\11.2.0\dbhome_1\bin\orazt11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraztkg11.dll
> D:\U01\product\11.2.0\dbhome_1\bin\oran11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orantcp11.dll
> D:\U01\product\11.2.0\dbhome_1\bin\oranl11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orancrypt11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orahasgen11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraocr11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraocrb11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraocrutl11.dll
> [27/07/2016 18:11:23] Prerequisite check
> "CheckActiveFilesAndExecutables" failed.
> The details are:
>
> Following files are active :
>
> D:\U01\product\11.2.0\dbhome_1\bin\oracell11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraasmclnt11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orapls11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orageneric11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraclient11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oracommon11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraplp11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraxml11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orannzsbb11.dll
> D:\U01\product\11.2.0\dbhome_1\bin\orazt11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraztkg11.dll
> D:\U01\product\11.2.0\dbhome_1\bin\oran11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orantcp11.dll
> D:\U01\product\11.2.0\dbhome_1\bin\oranl11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orancrypt11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\orahasgen11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraocr11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraocrb11.dll
>
> D:\U01\product\11.2.0\dbhome_1\bin\oraocrutl11.dll
> [27/07/2016 18:11:23] OUI-67073:UtilSession falhou: Prerequisite
> check "CheckActiveFilesAndExecutables" failed.
> [27/07/2016 18:11:23] Finishing UtilSession at Wed Jul 27 18:11:23
> BRT 2016
> [27/07/2016 18:11:23] Log file location:
> D:\U01\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch2016-07-27_18-11-17PM_1.log
> [27/07/2016 18:11:23] Descrição da Pilha:
> java.lang.RuntimeException: Prerequisite check
> "CheckActiveFilesAndExecutables" failed.
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:5765)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:905)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:367)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> oracle.opatch.opatchutil.NApply.process(NApply.java:362)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1084)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> java.lang.reflect.Method.invoke(Method.java:597)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> oracle.opatch.UtilSession.process(UtilSession.java:358)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> oracle.opatch.OPatchSession.process(OPatchSession.java:2507)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> oracle.opatch.OPatch.process(OPatch.java:796)
> [27/07/2016 18:11:23] Rastreamento da Pilha:
> oracle.opatch.OPatch.main(OPatch.java:846)
>
>
>
>
>
>
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l