Listing Applied Patches

You can produce a list of applied patches to determine which patches have been applied.

You can use the opatch utility to determine the patches that have been applied to an Oracle Database or Grid Infrastructure installation.

To produce a list of applied patches for an Oracle Database installation, proceed as follows:

  1. Connect to a compute node as the oracle user.

    For detailed instructions, see Connecting to a Compute Node Through Secure Shell (SSH).

  2. Set the ORACLE_HOME variable to the location of the Oracle Database installation you wish to examine. For example:

    $ export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1
    
  3. Execute the opatch command with the lspatches option:

    $ $ORACLE_HOME/OPatch/opatch lspatches

To produce a list of applied patches for Oracle Grid Infrastructure, proceed as follows:

  1. Connect to a compute node as the opc user.

    For detailed instructions, see Connecting to a Compute Node Through Secure Shell (SSH).

  2. Become the grid user:

    $ sudo -s
    # su - grid
    
  3. Execute the opatch command with the lspatches option:

    $ $ORACLE_HOME/OPatch/opatch lspatches