8 Replies Latest reply: Aug 18, 2013 7:04 AM by SG2 RSS

    applying patch set update11.2.0.3.7 on 11.2.0.3.0

    SG2

      Dear DBA's,

       

      Database = 11.2.0.3.0

      Operating System : Solaris 11 sparc 64.

      applying PSU patch : 16619892

       

      I am trying to apply patch 16619892 on 11.2.0.3.0 to upgrade it to 11.2.0.3.7.

      I hope this is a straight forword stuff i beleive, but i am getting the following errors and log details.

      Please advice the action?

       

      $ cd /noracle/patch/16619892/
      xxxx@xxxx$ /noracle/home/oracle/product/11.2.0.3/OPatch/opatch apply
      Oracle Interim Patch Installer version 11.2.0.3.4
      Copyright (c) 2012, Oracle Corporation.  All rights reserved.


      Oracle Home       : /noracle/home/oracle/product/11.2.0.3
      Central Inventory : /noracle/home/oracle/oraInventory
         from           : /noracle/home/oracle/product/11.2.0.3/oraInst.loc
      OPatch version    : 11.2.0.3.4
      OUI version       : 11.2.0.3.0
      Log file location : /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_12-26-10PM_1.log

      Verifying environment and performing prerequisite checks...
      Prerequisite check "CheckActiveFilesAndExecutables" failed.
      The details are:


      Following executables are active :
      /noracle/home/oracle/product/11.2.0.3/bin/tnslsnr
      Prerequisite check "CheckActiveFilesAndExecutables" failed.
      The details are:


      Following executables are active :
      /noracle/home/oracle/product/11.2.0.3/lib/libclntsh.so.11.1
      UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.
      Log file location: /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_12-26-10PM_1.log

      OPatch failed with error code 73
      xxxx@xxxx$ /noracle/home/oracle/product/11.2.0.3/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./16619892
      Oracle Interim Patch Installer version 11.2.0.3.4
      Copyright (c) 2012, Oracle Corporation.  All rights reserved.

      PREREQ session

      Oracle Home       : /noracle/home/oracle/product/11.2.0.3
      Central Inventory : /noracle/home/oracle/oraInventory
         from           : /noracle/home/oracle/product/11.2.0.3/oraInst.loc
      OPatch version    : 11.2.0.3.4
      OUI version       : 11.2.0.3.0
      Log file location : /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_12-26-41PM_1.log

      Invoking prereq "checkconflictagainstohwithdetail"

      Prereq "checkConflictAgainstOHWithDetail" passed.

      OPatch succeeded.
      xxxx@xxxx$ /noracle/home/oracle/product/11.2.0.3/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./       
      Oracle Interim Patch Installer version 11.2.0.3.4
      Copyright (c) 2012, Oracle Corporation.  All rights reserved.

      PREREQ session

      Oracle Home       : /noracle/home/oracle/product/11.2.0.3
      Central Inventory : /noracle/home/oracle/oraInventory
         from           : /noracle/home/oracle/product/11.2.0.3/oraInst.loc
      OPatch version    : 11.2.0.3.4
      OUI version       : 11.2.0.3.0
      Log file location : /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_12-26-48PM_1.log

      Invoking prereq "checkconflictagainstohwithdetail"

      Prereq "checkConflictAgainstOHWithDetail" passed.

      OPatch succeeded.
      xxxx@xxxx$ more /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_12-26-10PM_1.log
      [Aug 18, 2013 12:26:10 PM]   OPatch invoked as follows: 'apply -invPtrLoc /noracle/home/oracle/product/11.2.0.3/oraInst.loc '
      [Aug 18, 2013 12:26:10 PM]   OUI-67077:
                                   Oracle Home       : /noracle/home/oracle/product/11.2.0.3
                                   Central Inventory : /noracle/home/oracle/oraInventory
                                      from           : /noracle/home/oracle/product/11.2.0.3/oraInst.loc
                                   OPatch version    : 11.2.0.3.4
                                   OUI version       : 11.2.0.3.0
                                   OUI location      : /noracle/home/oracle/product/11.2.0.3/oui
                                   Log file location : /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_12-26-10PM_1.log
      [Aug 18, 2013 12:26:10 PM]   Patch history file: /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch_history.txt
      [Aug 18, 2013 12:26:13 PM]   Verifying environment and performing prerequisite checks...
      [Aug 18, 2013 12:26:13 PM]   Ignoring file "/noracle/patch/16619892/README.html" in the patch directory.
      [Aug 18, 2013 12:26:13 PM]   Ignoring file "/noracle/patch/16619892/README.txt" in the patch directory.
      [Aug 18, 2013 12:26:13 PM]   Ignoring file "/noracle/patch/16619892/patchmd.xml" in the patch directory.
      [Aug 18, 2013 12:26:14 PM]   Checking conflict among patches...
      [Aug 18, 2013 12:26:14 PM]   Patch ID  16619892
      [Aug 18, 2013 12:26:14 PM]   Patches that conflict: [  ]
      [Aug 18, 2013 12:26:14 PM]   Checking conflicts for patch : 16619892
      [Aug 18, 2013 12:26:14 PM]   Checking if Oracle Home has components required by patches...
      [Aug 18, 2013 12:26:14 PM]   Check if patch "13343438"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Check if patch "13696216"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Check if patch "13923374"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
      [Aug 18, 2013 12:26:14 PM]   [ oracle.network.cman, 11.2.0.3.0 ]
      [Aug 18, 2013 12:26:14 PM]   Check if patch "14275605"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0
      [Aug 18, 2013 12:26:14 PM]   [ oracle.precomp.lang, 11.2.0.3.0 ]
      [Aug 18, 2013 12:26:14 PM]   Check if patch "14727310"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Check if patch "16056266"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
      [Aug 18, 2013 12:26:14 PM]   [ oracle.network.cman, 11.2.0.3.0 ]
      [Aug 18, 2013 12:26:14 PM]   Check if patch "16619892"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0
      [Aug 18, 2013 12:26:14 PM]   [ oracle.precomp.lang, 11.2.0.3.0 ]
      [Aug 18, 2013 12:26:14 PM]   Running prerequisite checks...
      [Aug 18, 2013 12:26:14 PM]   Patch "13343438" is ignored as it is not a "Fusion Applications patch".
      [Aug 18, 2013 12:26:14 PM]   Patch "13696216" is ignored as it is not a "Fusion Applications patch".
      [Aug 18, 2013 12:26:14 PM]   Patch "13923374" is ignored as it is not a "Fusion Applications patch".
      [Aug 18, 2013 12:26:14 PM]   Patch "14275605" is ignored as it is not a "Fusion Applications patch".
      [Aug 18, 2013 12:26:14 PM]   Patch "14727310" is ignored as it is not a "Fusion Applications patch".
      [Aug 18, 2013 12:26:14 PM]   Patch "16056266" is ignored as it is not a "Fusion Applications patch".
      [Aug 18, 2013 12:26:14 PM]   Patch "16619892" is ignored as it is not a "Fusion Applications patch".
      [Aug 18, 2013 12:26:14 PM]   Check if patch "13343438"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Check if patch "13696216"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Check if patch "13923374"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
      [Aug 18, 2013 12:26:14 PM]   [ oracle.network.cman, 11.2.0.3.0 ]
      [Aug 18, 2013 12:26:14 PM]   Check if patch "14275605"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0
      [Aug 18, 2013 12:26:14 PM]   [ oracle.precomp.lang, 11.2.0.3.0 ]
      [Aug 18, 2013 12:26:14 PM]   Check if patch "14727310"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Check if patch "16056266"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
      [Aug 18, 2013 12:26:14 PM]   [ oracle.network.cman, 11.2.0.3.0 ]
      [Aug 18, 2013 12:26:14 PM]   Check if patch "16619892"  is a no-op patch.
      [Aug 18, 2013 12:26:14 PM]   Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0
      [Aug 18, 2013 12:26:14 PM]   [ oracle.precomp.lang, 11.2.0.3.0 ]
      [Aug 18, 2013 12:26:14 PM]   None of the selected patches are no-op. patches..
      [Aug 18, 2013 12:26:14 PM]   Space Needed : 880.924MB
      [Aug 18, 2013 12:26:15 PM]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 13343438
      [Aug 18, 2013 12:26:15 PM]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 13696216
      [Aug 18, 2013 12:26:15 PM]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 13923374
      [Aug 18, 2013 12:26:15 PM]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 14275605
      [Aug 18, 2013 12:26:15 PM]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 14727310
      [Aug 18, 2013 12:26:15 PM]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 16056266
      [Aug 18, 2013 12:26:15 PM]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 16619892
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/oracle at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/oracle at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/asmcmdcore at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/asmcmdcore at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/renamedg at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/renamedg at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/nid at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/nid at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/tnslsnr at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/tnslsnr at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Following executables are active :
                                   /noracle/home/oracle/product/11.2.0.3/bin/tnslsnr
      [Aug 18, 2013 12:26:16 PM]   Prerequisite check "CheckActiveFilesAndExecutables" failed.
                                   The details are:
                                  
                                  
                                   Following executables are active :
                                   /noracle/home/oracle/product/11.2.0.3/bin/tnslsnr
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/proc at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/proc at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/rman at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/rman at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/wrap at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/wrap at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/plshprof at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/plshprof at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/lib/libclntsh.so.11.1 at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/lib/libclntsh.so.11.1 at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Following executables are active :
                                   /noracle/home/oracle/product/11.2.0.3/lib/libclntsh.so.11.1
      [Aug 18, 2013 12:26:16 PM]   Prerequisite check "CheckActiveFilesAndExecutables" failed.
                                   The details are:
                                  
                                  
                                   Following executables are active :
                                   /noracle/home/oracle/product/11.2.0.3/lib/libclntsh.so.11.1
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/amdu at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/amdu at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/kfed at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/kfed at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.
      [Aug 18, 2013 12:26:16 PM]   Finishing UtilSession at Sun Aug 18 12:26:16 GMT+04:00 2013
      [Aug 18, 2013 12:26:16 PM]   Log file location: /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_12-26-10PM_1.log
      [Aug 18, 2013 12:26:16 PM]   Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.
      [Aug 18, 2013 12:26:16 PM]   StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6420)
      [Aug 18, 2013 12:26:16 PM]   StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:1587)
      [Aug 18, 2013 12:26:16 PM]   StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1136)
      [Aug 18, 2013 12:26:16 PM]   StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      [Aug 18, 2013 12:26:16 PM]   StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      [Aug 18, 2013 12:26:16 PM]   StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      [Aug 18, 2013 12:26:16 PM]   StackTrace: java.lang.reflect.Method.invoke(Method.java:592)
      [Aug 18, 2013 12:26:16 PM]   StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:322)
      [Aug 18, 2013 12:26:16 PM]   StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2346)
      [Aug 18, 2013 12:26:16 PM]   StackTrace: oracle.opatch.OPatch.main(OPatch.java:613)
      xxxx@xxxx$ 

       

      Regards,

      SG

        • 1. Re: applying patch set update11.2.0.3.7 on 11.2.0.3.0
          Srini Chavali-Oracle

          Pl follow the steps in the README of the patch. The database and listener need to be shutdown before you can apply the patch.

           

          HTH
          Srini

          • 2. Re: applying patch set update11.2.0.3.7 on 11.2.0.3.0
            SG2

            Dear Srini,

             

            I forgot to down the listener.

            please check the bellow output.

             

            xxxx@xxxx$ more /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_14-46-58PM_1.log

            [Aug 18, 2013 2:46:58 PM]    OPatch invoked as follows: 'apply -invPtrLoc /noracle/home/oracle/product/11.2.0.3/oraInst.loc '

            [Aug 18, 2013 2:46:58 PM]    OUI-67077:

                                         Oracle Home       : /noracle/home/oracle/product/11.2.0.3

                                         Central Inventory : /noracle/home/oracle/oraInventory

                                            from           : /noracle/home/oracle/product/11.2.0.3/oraInst.loc

                                         OPatch version    : 11.2.0.3.4

                                         OUI version       : 11.2.0.3.0

                                         OUI location      : /noracle/home/oracle/product/11.2.0.3/oui

                                         Log file location : /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_14-46-58PM_1.log

            [Aug 18, 2013 2:46:58 PM]    Patch history file: /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch_history.txt

            [Aug 18, 2013 2:47:01 PM]    Verifying environment and performing prerequisite checks...

            [Aug 18, 2013 2:47:01 PM]    Ignoring file "/noracle/patch/16619892/README.html" in the patch directory.

            [Aug 18, 2013 2:47:01 PM]    Ignoring file "/noracle/patch/16619892/README.txt" in the patch directory.

            [Aug 18, 2013 2:47:01 PM]    Ignoring file "/noracle/patch/16619892/patchmd.xml" in the patch directory.

            [Aug 18, 2013 2:47:02 PM]    Checking conflict among patches...

            [Aug 18, 2013 2:47:02 PM]    Patch ID  16619892

            [Aug 18, 2013 2:47:02 PM]    Patches that conflict: [  ]

            [Aug 18, 2013 2:47:02 PM]    Checking conflicts for patch : 16619892

            [Aug 18, 2013 2:47:02 PM]    Checking if Oracle Home has components required by patches...

            [Aug 18, 2013 2:47:02 PM]    Check if patch "13343438"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Check if patch "13696216"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Check if patch "13923374"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0

            [Aug 18, 2013 2:47:02 PM]    [ oracle.network.cman, 11.2.0.3.0 ]

            [Aug 18, 2013 2:47:02 PM]    Check if patch "14275605"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0

            [Aug 18, 2013 2:47:02 PM]    [ oracle.precomp.lang, 11.2.0.3.0 ]

            [Aug 18, 2013 2:47:02 PM]    Check if patch "14727310"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Check if patch "16056266"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0

            [Aug 18, 2013 2:47:02 PM]    [ oracle.network.cman, 11.2.0.3.0 ]

            [Aug 18, 2013 2:47:02 PM]    Check if patch "16619892"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0

            [Aug 18, 2013 2:47:02 PM]    [ oracle.precomp.lang, 11.2.0.3.0 ]

            [Aug 18, 2013 2:47:02 PM]    Running prerequisite checks...

            [Aug 18, 2013 2:47:02 PM]    Patch "13343438" is ignored as it is not a "Fusion Applications patch".

            [Aug 18, 2013 2:47:02 PM]    Patch "13696216" is ignored as it is not a "Fusion Applications patch".

            [Aug 18, 2013 2:47:02 PM]    Patch "13923374" is ignored as it is not a "Fusion Applications patch".

            [Aug 18, 2013 2:47:02 PM]    Patch "14275605" is ignored as it is not a "Fusion Applications patch".

            [Aug 18, 2013 2:47:02 PM]    Patch "14727310" is ignored as it is not a "Fusion Applications patch".

            [Aug 18, 2013 2:47:02 PM]    Patch "16056266" is ignored as it is not a "Fusion Applications patch".

            [Aug 18, 2013 2:47:02 PM]    Patch "16619892" is ignored as it is not a "Fusion Applications patch".

            [Aug 18, 2013 2:47:02 PM]    Check if patch "13343438"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Check if patch "13696216"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Check if patch "13923374"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0

            [Aug 18, 2013 2:47:02 PM]    [ oracle.network.cman, 11.2.0.3.0 ]

            [Aug 18, 2013 2:47:02 PM]    Check if patch "14275605"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0

            [Aug 18, 2013 2:47:02 PM]    [ oracle.precomp.lang, 11.2.0.3.0 ]

            [Aug 18, 2013 2:47:02 PM]    Check if patch "14727310"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Check if patch "16056266"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0

            [Aug 18, 2013 2:47:02 PM]    [ oracle.network.cman, 11.2.0.3.0 ]

            [Aug 18, 2013 2:47:02 PM]    Check if patch "16619892"  is a no-op patch.

            [Aug 18, 2013 2:47:02 PM]    Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0

            [Aug 18, 2013 2:47:02 PM]    [ oracle.precomp.lang, 11.2.0.3.0 ]

            [Aug 18, 2013 2:47:02 PM]    None of the selected patches are no-op. patches..

            [Aug 18, 2013 2:47:02 PM]    Space Needed : 880.924MB

            [Aug 18, 2013 2:47:02 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 13343438

            [Aug 18, 2013 2:47:02 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 13696216

            [Aug 18, 2013 2:47:02 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 13923374

            [Aug 18, 2013 2:47:02 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 14275605

            [Aug 18, 2013 2:47:03 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 14727310

            [Aug 18, 2013 2:47:03 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 16056266

            [Aug 18, 2013 2:47:03 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 16619892

            [Aug 18, 2013 2:47:03 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/oracle at Sun Aug 18 14:47:03 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/oracle at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/asmcmdcore at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/asmcmdcore at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/renamedg at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/renamedg at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/nid at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/nid at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/tnslsnr at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/tnslsnr at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/proc at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/proc at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/rman at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/rman at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/wrap at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/wrap at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/plshprof at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/plshprof at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/lib/libclntsh.so.11.1 at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/lib/libclntsh.so.11.1 at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Following executables are active :

                                         /noracle/home/oracle/product/11.2.0.3/lib/libclntsh.so.11.1

            [Aug 18, 2013 2:47:04 PM]    Prerequisite check "CheckActiveFilesAndExecutables" failed.

                                         The details are:

                                        

                                        

                                         Following executables are active :

                                         /noracle/home/oracle/product/11.2.0.3/lib/libclntsh.so.11.1

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/amdu at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/amdu at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Start fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/kfed at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Finish fuser command /sbin/fuser /noracle/home/oracle/product/11.2.0.3/bin/kfed at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

            [Aug 18, 2013 2:47:04 PM]    Finishing UtilSession at Sun Aug 18 14:47:04 GMT+04:00 2013

            [Aug 18, 2013 2:47:04 PM]    Log file location: /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_14-46-58PM_1.log

            [Aug 18, 2013 2:47:04 PM]    Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.

            [Aug 18, 2013 2:47:04 PM]    StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6420)

            [Aug 18, 2013 2:47:04 PM]    StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:1587)

            [Aug 18, 2013 2:47:04 PM]    StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1136)

            [Aug 18, 2013 2:47:04 PM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            [Aug 18, 2013 2:47:04 PM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

            [Aug 18, 2013 2:47:04 PM]    StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

            [Aug 18, 2013 2:47:04 PM]    StackTrace: java.lang.reflect.Method.invoke(Method.java:592)

            [Aug 18, 2013 2:47:04 PM]    StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:322)

            [Aug 18, 2013 2:47:04 PM]    StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2346)

            [Aug 18, 2013 2:47:04 PM]    StackTrace: oracle.opatch.OPatch.main(OPatch.java:613)

            • 3. Re: applying patch set update11.2.0.3.7 on 11.2.0.3.0
              Srini Chavali-Oracle

              [Aug 18, 2013 2:47:04 PM]    Following executables are active :

                                           /noracle/home/oracle/product/11.2.0.3/lib/libclntsh.so.11.1

               

              Oracle executables are still in use. Ensure that there are no processes using these executables. How many databases are attached to this home ? You will need to shut down all of the databases. If you have shut down all databases, then kill any processes that may have been orphaned, and try again.

               

              Srini

              • 4. Re: applying patch set update11.2.0.3.7 on 11.2.0.3.0
                SG2

                Dear Srini,

                 

                I rebooted the server and applied the patch and it went fine but the end it thrown the warning.

                 

                                             deleted, Please refer log file.

                [Aug 18, 2013 3:30:43 PM]    Composite patch 16619892 successfully applied.

                [Aug 18, 2013 3:30:43 PM]    UtilSession: N-Apply done.

                [Aug 18, 2013 3:30:43 PM]    --------------------------------------------------------------------------------

                [Aug 18, 2013 3:30:43 PM]    The following warnings have occurred during OPatch execution:

                [Aug 18, 2013 3:30:43 PM]    1) OUI-67215:

                                             OPatch found the word "warning" in the stderr of the make command.

                                             Please look at this stderr. You can re-run this make command.

                                             Stderr output:

                                             ld: warning: symbol '_start' has differing types:

                                                (file /noracle/home/oracle/product/11.2.0.3/lib/prod/lib/v9/crt1.o type=FUNC; file /noracle/home/oracle/product/11.2.0.3/lib//libserver11.a(skds.o) type=OBJT);

                [Aug 18, 2013 3:30:43 PM]    2) OUI-67215:

                                             OPatch found the word "warning" in the stderr of the make command.

                                             Please look at this stderr. You can re-run this make command.

                                             Stderr output:

                                             ld: warning: option -YP appears more than once, first setting taken

                                             ld: warning: option -Q appears more than once, first setting taken

                [Aug 18, 2013 3:30:43 PM]    --------------------------------------------------------------------------------

                [Aug 18, 2013 3:30:43 PM]    OUI-67008:OPatch Session completed with warnings.

                [Aug 18, 2013 3:30:43 PM]    Finishing UtilSession at Sun Aug 18 15:30:43 GMT+04:00 2013

                [Aug 18, 2013 3:30:43 PM]    Log file location: /noracle/home/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2013-08-18_15-20-53PM_1.log

                • 6. Re: applying patch set update11.2.0.3.7 on 11.2.0.3.0
                  SG2

                  Dear Srini,

                   

                  I ran the post installation, after that i applied patch as per mention in your previous document.

                  but my database version still showing 11.2.0.3.0 not 11.2.0.3.7.

                  Please advice.

                   

                  $ sqlplus "/as sysdba"

                  SQL*Plus: Release 11.2.0.3.0 Production on Sun Aug 18 15:57:39 2013

                  Copyright (c) 1982, 2011, Oracle.  All rights reserved.

                  • 8. Re: applying patch set update11.2.0.3.7 on 11.2.0.3.0
                    SG2

                    Dear Srini,

                     

                    Thanks allot and i appreciate your support.

                    My patch installation went successfull.

                     

                    Regards,

                    SG