This discussion is archived
10 Replies Latest reply: Jul 1, 2013 2:30 PM by jgarry RSS

How to install Patch 14503114

jds1207 Newbie
Currently Being Moderated

I am trying to install Oracle patch 14503114 using Windows Server 2008R2.  I am running Oracle 11g R2.  I tried to go by the readme.txt but its not working.  Does anyone know how to install oracle patches using opatch?

 

Any ideas will be greatly appreciated.

  • 1. Re: How to install Patch 14503114
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    The phrase "not working" is devoid of any information or actionable items :-) Pl post details of how exactly you tried to apply this patch and contents of the opatch log file

     

    HTH
    Srini

  • 2. Re: How to install Patch 14503114
    jds1207 Newbie
    Currently Being Moderated

    Here are the instructions I am following:

    1. Shutdown EM DB Console using the following command.
          % $ORACLE_HOME/bin/emctl stop dbconsole

    2. Set your current directory to the directory where the patch is located:
          % cd <PATCH_TOP>/14503114
          Ensure that the directory containing the opatch script appears in your $PATH; then enter the following command:
               % opatch apply
    3. Start EM DB Console using the following command.
          % $ORACLE_HOME/bin/emctl start dbconsole

     

    I can start and stop the dbconsole just fine.  The issue is getting the % opatch apply to work in step 2.  When I type % opatch apply at the command prompt, I get the following message:

     

    '%' is not recognized as an internal or external command, operable program or batch file.

  • 3. Re: How to install Patch 14503114
    jgarry Guru
    Currently Being Moderated

    I believe the % is just an example of a prompt, you don't type it in.

     

    http://www.perl.com/doc/FMTEYEWTK/versus/csh.whynot

  • 4. Re: How to install Patch 14503114
    jds1207 Newbie
    Currently Being Moderated

    I still get the same error.  This time saying 'opatch ' is not recognized as an internal or external command, operable program or batch file.  I got to be missing something.

  • 5. Re: How to install Patch 14503114
    weq92f Newbie
    Currently Being Moderated

    try \full\path\to\opatch ...

  • 6. Re: How to install Patch 14503114
    jgarry Guru
    Currently Being Moderated

    The path to the directory where opatch is is not on your $PATH.  Did you put it on your $PATH?  Did you export that?  What do you see when you go into a subshell and echo $PATH?

     

    Edit: Oops, you are on Windows.  Are you looking at the correct instructions?

  • 7. Re: How to install Patch 14503114
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    Pl post the output of the "set" command just before you invoke OPatch - most likely required environment variables have not been set.

     

    HTH
    Srini

  • 8. Re: How to install Patch 14503114
    Justin_Mungal Journeyer
    Currently Being Moderated

    The instructions for that patch are generic, so unfortunately he is looking at the right ones.

     

    The options I can think of are: 1) set the environment variables or 2) add the opatch location to your path variable.

     

    1)

     

    C:\Users\oracle>SET ORACLE_SID=PROD
    C:\Users\oracle>set ORACLE_HOME=C:\app\oracle\product\11.2.0\dbhome_1
    C:\Users\oracle>%ORACLE_HOME%\OPatch\opatch lsinventory
    Oracle Interim Patch Installer version 11.2.0.3.4
    Copyright (c) 2012, Oracle Corporation.  All rights reserved.
    Oracle Home       : C:\app\oracle\product\11.2.0\dbhome_1
    Central Inventory : C:\Program Files\Oracle\Inventory
       from           : n/a
    OPatch version    : 11.2.0.3.4
    OUI version       : 11.2.0.3.0
    Log file location : C:\app\oracle\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opa
    tch2013-06-27_20-39-23PM_1.log
    Lsinventory Output file location : C:\app\oracle\product\11.2.0\dbhome_1\cfgtool
    logs\opatch\lsinv\lsinventory2013-06-27_20-39-23PM.txt
    --------------------------------------------------------------------------------
    Installed Top-level Products (1):
    Oracle Database 11g                                                  11.2.0.3.0
    There are 1 products installed in this Oracle Home.
    <output truncated>
    

    2)

     

    C:\Users\oracle>set PATH=%PATH%;C:\app\oracle\product\11.2.0\dbhome_1\OPatch
    C:\Users\oracle>opatch lsinventory
    Oracle Interim Patch Installer version 11.2.0.3.4
    Copyright (c) 2012, Oracle Corporation.  All rights reserved.
    Oracle Home       : C:\app\oracle\product\11.2.0\dbhome_1
    Central Inventory : C:\Program Files\Oracle\Inventory
       from           : n/a
    OPatch version    : 11.2.0.3.4
    OUI version       : 11.2.0.3.0
    Log file location : C:\app\oracle\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opa
    tch2013-06-27_20-46-55PM_1.log
    Lsinventory Output file location : C:\app\oracle\product\11.2.0\dbhome_1\cfgtool
    logs\opatch\lsinv\lsinventory2013-06-27_20-46-55PM.txt
    --------------------------------------------------------------------------------
    Installed Top-level Products (1):
    Oracle Database 11g                                                  11.2.0.3.0
    There are 1 products installed in this Oracle Home.
    <output truncated>
    

     

    HTH

     

    Message was edited by: Justin_Mungal - Ugh... why is the code highlighting axing all of my spaces?

  • 9. Re: How to install Patch 14503114
    jds1207 Newbie
    Currently Being Moderated

    Now when I run opatch apply I get the following error:

    Prerequisite check  " CheckApplicable" failed.
    The details are:
    Patch 14503114:  Required Component(s) missing : [ oracle.sysman.console.db, 11.2.0.2.0 ]
    applySession failed during prerequisite checks:  Prerequisites check "CheckApplicable" failed.
    System intact, Opatch will not attempt to restore the sysem

    OPatch failed with error code = 74

     

    Any ideas?

  • 10. Re: How to install Patch 14503114
    jgarry Guru
    Currently Being Moderated

    Open an SR with MOS.  Could be you haven't applied prerequisite patches, could be not everything is shut down.  I really don't know, but I've seen windows be recalcitrant about letting threads go.

Legend

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