10 Replies Latest reply: Jul 1, 2013 4:30 PM by jgarry RSS

    How to install Patch 14503114

    jds1207

      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

          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

            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

              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

                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

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

                  • 6. Re: How to install Patch 14503114
                    jgarry

                    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

                      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

                        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

                          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

                            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.