Gostaria de uma opiniao, vcs tem mais experiencia em aplicar patch do que
eu...

Agora final do dia, fui tentar aplicar e eu to achando estranho essa
reclamacao do OPatch, veja abaixo, o que marquei em vermelho
O que acontece, durante o processo, ta reclamando de um monte de DLL que
estaria ativa (ou registrada, que é o certo, nao?)  e todos os serviços do
Oracle estão parados e a base parada.

A maquina nao ta em produção ainda, então tô.. mexendo..


Ambiente Oracle 11.2.0.4  x64  Windows e o patch que tentei aplicar
foi o *23530402
  (desse CPU que saiu esse mes recente, o banco foi atualizado ha pouco
tempo do 11.2.0.3.x pra 11.2.0.4) *


[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)


Eu até poderia desregistra-las uma a uma na mão mas, acho que vai dar ruim

Sera que é caso para se abrir um chamado ? Ou sera que esqueci de algo ?


[]s angelo

Responder a