4 Replies Latest reply: Mar 15, 2012 8:12 AM by Mark D Powell RSS

    how to check latest patch installed?

    user399500
      Hi ,

      how to check which is the latest patch installed on oracle on window server?


      Thanks,
        • 1. Re: how to check latest patch installed?
          415289
          sure...go to ORACLE_HOME/Opatch and run opatch lsinventory

          > opatch lsinventory
          Invoking OPatch 10.2.0.4.3

          Oracle Interim Patch Installer version 10.2.0.4.3
          Copyright (c) 2007, Oracle Corporation. All rights reserved.


          Oracle Home : /u01/app/oracle/product/10/db
          Central Inventory : /u01/app/oracle/oraInventory
          from : /etc/oraInst.loc
          OPatch version : 10.2.0.4.3
          OUI version : 10.2.0.4.0
          OUI location : /u01/app/oracle/product/10/db/oui
          Log file location : /u01/app/oracle/product/10/db/cfgtoollogs/opatch/opatch2012-03-15_12-14-59PM.log

          Lsinventory Output file location : /u01/app/oracle/product/10/db/cfgtoollogs/opatch/lsinv/lsinventory2012-03-15_12-14-59PM.txt

          --------------------------------------------------------------------------------
          Installed Top-level Products (2):

          Oracle Database 10g 10.2.0.1.0
          Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
          There are 2 products installed in this Oracle Home.


          There are no Interim patches installed in this Oracle Home.



          OPatch succeeded.
          • 2. Re: how to check latest patch installed?
            ora_tech
            Hi,

            The mentioned above command will give the o/p for all applied patches to your RDBMS home.

            If you want to search for any specific patch then use :
            opatch lsinventory | grep patch-number
            thanks,
            X A H E E R
            • 3. Re: how to check latest patch installed?
              User332967
              cd $ORACLE_HOME/OPatch
              opatch lsinventory
              opatch lsinventory -invPtrLoc /etc/oraInst.loc

              Edited by: 920138 on Mar 15, 2012 2:58 AM
              • 4. Re: how to check latest patch installed?
                Mark D Powell
                On version 10g+ you can query dba_registry_history and/or sys.registry$history (as sysdba) to get patch information from within the database.

                HTH -- Mark D Powell --