Forum Stats

  • 3,783,310 Users
  • 2,254,756 Discussions
  • 7,880,358 Comments

Discussions

Patching Oracle 11.2.0.3.0

1052595
1052595 Member Posts: 25
edited Jan 25, 2014 7:12AM in General Database Discussions

We have downloaded and installed patches to both 11.2.0.2.0  and  11.2.0.3.0 (Enterprise edition on Linux x86-64)successfully

we faced the following issue on one of our servers

here is the output of logfile

[Jan 25, 2014 4:44:57 AM]    PatchObject::createPatchObject() patch location is /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/inventory/oneoffs/15862020
[Jan 25, 2014 4:44:57 AM]    PatchObject::createPatchObject() Patch location is /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/inventory/oneoffs/15862021
[Jan 25, 2014 4:44:57 AM]    PatchObject::createPatchObject() patch location is /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/inventory/oneoffs/15862021
[Jan 25, 2014 4:44:57 AM]    Verifying the update...
[Jan 25, 2014 4:44:57 AM]    PatchObject::PatchObject() Patch location is /u100/app/testmach/ortestmach/oracle/17478415/15862021
[Jan 25, 2014 4:44:57 AM]    PatchObject::createPatchObject() Patch location is /u100/app/testmach/ortestmach/oracle/17478415/15862021
[Jan 25, 2014 4:44:57 AM]    PatchObject::createPatchObject() patch location is /u100/app/testmach/ortestmach/oracle/17478415/15862021
[Jan 25, 2014 4:44:57 AM]    PatchObject::createPatchObject() Patch location is /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/inventory/oneoffs/15862021
[Jan 25, 2014 4:44:57 AM]    PatchObject::createPatchObject() patch location is /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/inventory/oneoffs/15862021
[Jan 25, 2014 4:44:57 AM]    Inventory check OK: Patch ID 15862021 is registered in Oracle Home inventory with proper meta-data.
[Jan 25, 2014 4:44:58 AM]    Verify for Jar file "ORACLE_HOME/sysman/jlib/emDB.jar" failedinvalid entry size (expected 12595 but got 356328 bytes)
[Jan 25, 2014 4:44:59 AM]    Verify for Jar file "ORACLE_HOME/sysman/jlib/emdb_emjsp.jar" failedinvalid entry size (expected 61764 but got 450388 bytes)
[Jan 25, 2014 4:44:59 AM]    There are 3 jar files under ORACLE_HOME that are not patched.
[Jan 25, 2014 4:44:59 AM]    OUI-67124:Files check failed: Some files under ORACLE_HOME are not patched. Please see log file for details.
[Jan 25, 2014 4:44:59 AM]    OUI-67124:ApplySession failed in system modification phase... 'Verification of patch failed: Files are not updated completely.'
[Jan 25, 2014 4:44:59 AM]    Restoring "/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1" to the state prior to running NApply...
[Jan 25, 2014 4:45:10 AM]    Checking if OPatch needs to invoke 'make' to restore some binaries...
[Jan 25, 2014 4:45:10 AM]    OPatch was able to restore your system. Look at log file and timestamp of each file to make sure your system is in the state prior to applying the patch.
[Jan 25, 2014 4:45:10 AM]    OUI-67124:
                             NApply restored the home. Please check your ORACLE_HOME to make sure:
                               - files are restored properly.
                               - binaries are re-linked correctly.
                             (use restore.[sh,bat] and make.txt (Unix only) as a reference. They are located under
                             "/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/.patch_storage/NApply/2014-01-25_04-41-40AM"
[Jan 25, 2014 4:45:10 AM]    OUI-67073:UtilSession failed: ApplySession failed in system modification phase... 'Verification of patch failed: Files are not updated completely.'
[Jan 25, 2014 4:45:10 AM]    --------------------------------------------------------------------------------
[Jan 25, 2014 4:45:10 AM]    The following warnings have occurred during OPatch execution:
[Jan 25, 2014 4:45:10 AM]    1) OUI-67302:
                             OPatch found that the following patches are not required.
                             They are either subset of the patches in Oracle Home (or) subset of the patches in the given list
                             (or) duplicate :
                                13742433   13742434   13742435   13742436   13742438   14062795   14062797   14480675   14480676   15862016   15862017   15862018   15862019   15862020
[Jan 25, 2014 4:45:10 AM]    2) OUI-67303:
                             Patches [   14063280   14841409   14664355   14548763   14480674   14062796   14062794   14062792   13742464 ] will be rolled back.
[Jan 25, 2014 4:45:10 AM]    3) OUI-67160:ApplySession for patch ID '15862021': Could not back up following actions for patch rollback:
                             1) Didn't back up entry [oracle/sysman/db/adm/dist/advRepl/AdvReplicationAdminController.class, ] from file emDB.jar
                             2) Didn't back up entry [oracle/sysman/emo/dist/advRepl/util/PurgeSchedule.class, ] from file emDB.jar
                             3) Didn't back up entry [_database/_dist/_advrepl/_admin/_purgeSchedule.class, ] from file emdb_emjsp.jar
[Jan 25, 2014 4:45:10 AM]    4) OUI-67124:Jar not applied /u100/app/testmach/ortestmach/oracle/17478415/15862021/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/dist/advRepl/AdvReplicationAdminController.class to /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/sysman/jlib/emDB.jar... 'invalid entry size (expected 12595 but got 356328 bytes)'
                             Jar not applied /u100/app/testmach/ortestmach/oracle/17478415/15862021/files//sysman/jlib/emDB.jar/oracle/sysman/emo/dist/advRepl/util/PurgeSchedule.class to /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/sysman/jlib/emDB.jar... 'invalid entry size (expected 12595 but got 356328 bytes)'
                           
                             Jar not applied /u100/app/testmach/ortestmach/oracle/17478415/15862021/files//sysman/jlib/emdb_emjsp.jar/_database/_dist/_advrepl/_admin/_purgeSchedule.class to /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/sysman/jlib/emdb_emjsp.jar... 'invalid entry size (expected 61764 but got 450388 bytes)'
[Jan 25, 2014 4:45:10 AM]    5) OUI-67124:Files check failed: Some files under ORACLE_HOME are not patched. Please see log file for details.
[Jan 25, 2014 4:45:10 AM]    6) OUI-67124:ApplySession failed in system modification phase... 'Verification of patch failed: Files are not updated completely.'
[Jan 25, 2014 4:45:10 AM]    7) OUI-67124:
                             NApply restored the home. Please check your ORACLE_HOME to make sure:
                               - files are restored properly.
                               - binaries are re-linked correctly.
                             (use restore.[sh,bat] and make.txt (Unix only) as a reference. They are located under
                             "/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/.patch_storage/NApply/2014-01-25_04-41-40AM"
[Jan 25, 2014 4:45:10 AM]    --------------------------------------------------------------------------------
[Jan 25, 2014 4:45:10 AM]    Finishing UtilSession at Sat Jan 25 04:45:10 CST 2014
[Jan 25, 2014 4:45:10 AM]    Log file location: /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/cfgtoollogs/opatch/opatch2014-01-25_04-41-40AM.log
[Jan 25, 2014 4:45:10 AM]    Stack Description: java.lang.RuntimeException: ApplySession failed in system modification phase... 'Verification of patch failed: Files are not updated completely.'
[Jan 25, 2014 4:45:10 AM]    StackTrace: oracle.opatch.ApplySession.processLocal(ApplySession.java:4845)
[Jan 25, 2014 4:45:10 AM]    StackTrace: oracle.opatch.ApplySession.process(ApplySession.java:5853)
[Jan 25, 2014 4:45:10 AM]    StackTrace: oracle.opatch.ApplySession.process(ApplySession.java:5666)
[Jan 25, 2014 4:45:10 AM]    StackTrace: oracle.opatch.OPatchACL.processApply(OPatchACL.java:301)
[Jan 25, 2014 4:45:10 AM]    StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:2858)
[Jan 25, 2014 4:45:10 AM]    StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:935)
[Jan 25, 2014 4:45:10 AM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[Jan 25, 2014 4:45:10 AM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[Jan 25, 2014 4:45:10 AM]    StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[Jan 25, 2014 4:45:10 AM]    StackTrace: java.lang.reflect.Method.invoke(Method.java:592)
[Jan 25, 2014 4:45:10 AM]    StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:316)
[Jan 25, 2014 4:45:10 AM]    StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2074)
[Jan 25, 2014 4:45:10 AM]    StackTrace: oracle.opatch.OPatch.main(OPatch.java:651)

select * from  sys.registry$history;

ACTION_TIMEACTIONNAMESPACEVERSIONIDCOMMENTSBUNDLE_SERIES

11/10/2012 1:10:13.419220 AM      VIEW INVALIDATE                8289601view invalidation
11/10/2012 1:10:13.443301 AMUPGRADE  SERVER11.2.0.3.0Upgraded from 11.2.0.2.0
11/10/2012 1:11:07.974203 AMAPPLYSERVER11.2.0.30Patchset 11.2.0.2.0PSU
2/9/2013 6:47:32.196248 AMAPPLYSERVER11.2.0.35CPUJan2013CPU
1/25/2014 4:30:54.984668 AMAPPLYSERVER11.2.0.35CPUJan2013CPU

opatch -version

Oracle Interim Patch Installer version 11.2.0.3.4

/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/OPatch> opatch napply /u100/app/testmach/ortestmach/oracle/17478415 -skip_subset -skip_duplicate
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.




Oracle Home       : /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1
Central Inventory : /u100/app/testmach/ortestmach/oracle/oraInventory
   from           : /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.3.0
Log file location : /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/cfgtoollogs/opatch/opatch2014-01-25_05-38-00AM_1.log


Verifying environment and performing prerequisite checks...


The following patches are identical and are skipped:
[ 13742433 13742434 13742435 13742436 13742438 14062795 14062797 14480675 14480676 15862016 15862017 15862018 15862019 15862020  ]


Checking skip_duplicate
Checking skip_subset


Conflicts/Supersets for each patch are:


Patch : 16314467


        Bug Superset of 14063280
        Super set bugs are:
        14063280,  12880299


Patch : 17478415


        Bug Superset of 14841409
        Super set bugs are:
        13466801,  14390252,  13632717,  14038787,  14841409


Patch : 17748834


        Bug Superset of 14664355
        Super set bugs are:
        14664355


        Bug Superset of 14548763
        Super set bugs are:
        14063281,  13772618,  13528551,  13916709,  12748240,  12780098,  14548763


        Bug Superset of 14480674
        Super set bugs are:
        14062793,  14480674


        Bug Superset of 14062796
        Super set bugs are:
        14062796


        Bug Superset of 14062794
        Super set bugs are:
        14062794


        Bug Superset of 14062792
        Super set bugs are:
        14062792


        Bug Superset of 13742464
        Super set bugs are:
        13499128,  13742464,  13503598,  13554409


Patches [   14063280   14841409   14664355   14548763   14480674   14062796   14062794   14062792   13742464 ] will be rolled back.




Do you want to proceed? [y|n]
y
User Responded with: Y
OPatch continues with these patches:   15862021  15862022  15862023  15862024  16314467  16794241  16794242  16794244  17333197  17333198  17333199  17333202  17333203  17478415  17748830  17748831  17748832  17748833  17748834  17748835 


Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:


You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y






Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1')




Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '15862021' to OH '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1'
Rolling back interim patch '14063280' from OH '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1'


Patching component oracle.network.rsf, 11.2.0.3.0...


Patching component oracle.network.listener, 11.2.0.3.0...
RollbackSession removing interim patch '14063280' from inventory
Rolling back interim patch '14841409' from OH '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1'


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14841409' from inventory
Rolling back interim patch '14664355' from OH '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1'


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms.util, 11.2.0.3.0...
RollbackSession removing interim patch '14664355' from inventory
Rolling back interim patch '14548763' from OH '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1'


Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14548763' from inventory
Rolling back interim patch '14480674' from OH '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1'


Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14480674' from inventory
Rolling back interim patch '14062796' from OH '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1'


Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14062796' from inventory
Rolling back interim patch '14062794' from OH '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1'


Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14062794' from inventory
Rolling back interim patch '14062792' from OH '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1'


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '14062792' from inventory
Rolling back interim patch '13742464' from OH '/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1'


Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '13742464' from inventory




OPatch back to application of the patch '15862021' after auto-rollback.



ApplySession for patch ID '15862021': Could not back up following actions for patch rollback:
1) Didn't back up entry [oracle/sysman/db/adm/dist/advRepl/AdvReplicationAdminController.class, ] from file emDB.jar
2) Didn't back up entry [oracle/sysman/emo/dist/advRepl/util/PurgeSchedule.class, ] from file emDB.jar
3) Didn't back up entry [_database/_dist/_advrepl/_admin/_purgeSchedule.class, ] from file emdb_emjsp.jar




Do you want to proceed? [y|n]
n
User Responded with: N
ApplySession failed in system modification phase... 'User requested not to continue.'


Restoring "/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1" to the state prior to running NApply...
Checking if OPatch needs to invoke 'make' to restore some binaries...
OPatch was able to restore your system. Look at log file and timestamp of each file to make sure your system is in the state prior to applying the patch.


NApply restored the home. Please check your ORACLE_HOME to make sure:
  - files are restored properly.
  - binaries are re-linked correctly.
(use restore.[sh,bat] and make.txt (Unix only) as a reference. They are located under
"/u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/.patch_storage/NApply/2014-01-25_05-38-00AM"


UtilSession failed: ApplySession failed in system modification phase... 'User requested not to continue.'
Log file location: /u100/app/testmach/ortestmach/oracle/product/11.2.3/dbhome_1/cfgtoollogs/opatch/opatch2014-01-25_05-38-00AM_1.log


OPatch failed with error code 73

12862021 is what fails repeatedly..

Thanks

Tagged:

Answers

This discussion has been closed.