This discussion is archived
8 Replies Latest reply: Aug 18, 2013 5:04 AM by SG2 RSS

applying patch set update11.2.0.3.7 on 11.2.0.3.0

SG2 Newbie
Currently Being Moderated

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 Oracle ACE Director
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Oracle ACE Director
    Currently Being Moderated

    [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 Newbie
    Currently Being Moderated

    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

  • 5. Re: applying patch set update11.2.0.3.7 on 11.2.0.3.0
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    Pl see MOS Doc 1446945.1

     

    HTH
    Srini

  • 6. Re: applying patch set update11.2.0.3.7 on 11.2.0.3.0
    SG2 Newbie
    Currently Being Moderated

    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.

  • 7. Re: applying patch set update11.2.0.3.7 on 11.2.0.3.0
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    Pl see MOS Doc 861152.1

     

    HTH
    Srini

  • 8. Re: applying patch set update11.2.0.3.7 on 11.2.0.3.0
    SG2 Newbie
    Currently Being Moderated

    Dear Srini,

     

    Thanks allot and i appreciate your support.

    My patch installation went successfull.

     

    Regards,

    SG

     


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points