Viewing Available Patches

You can view a list of patches that are associated with a Database Classic Cloud Service database deployment by using the Oracle Database Classic Cloud Service console or, if desired, by using one of the ways listed in Other Ways to View Available Patches at the end of this topic.

Viewing Available Patches by Using the Oracle Database Classic Cloud Service Console

Go to the Patching page for the database deployment on which you want to check patching:
1. Open the Oracle Database Classic Cloud Service console.
  
  For detailed instructions, see Accessing the Oracle Database Classic Cloud Service Console.
2. Click the database deployment on which you want to check patching.
  
  The Oracle Database Classic Cloud Service Overview page is displayed.
3. Click the Administration tile and then click the Patching tab.
  
  The Oracle Database Classic Cloud Service Patching page is displayed.
A list of patches you can apply appears in the Available Patches section.

Other Ways to View Available Patches

For database deployments hosting single-instance databases, you can use the patch db list subcommand of the dbaascli utility. See Viewing Available Patches by Using the dbaascli Utility.

Viewing Available Patches by Using the dbaascli Utility

You can use the patch db list subcommand of the dbaascli utility to check whether any patches are available for a database deployment hosting a single-instance database or an Oracle Data Guard configuration of single-instance databases.

Connect as the opc user to the compute node.

For detailed instructions, see Connecting to a Compute Node Through Secure Shell (SSH).
Start a root-user command shell:
```
$ sudo -s
#
```
View available patches:
```
# dbaascli patch db list
```
A patch update is available if the command response includes the "INFO: images available for patching" message. The patch ID will be displayed as part of the command response. This patch ID can be used to download and apply the patch.

The patch db list subcommand is not yet available on Oracle Cloud at Customer. Instead, for a database deployment hosting a single-instance database you must use the dbaascli dbpatchm list_patches command, and for a database deployment hosting an Oracle Data Guard configuration of single-instance databases you must use the dbpatchmdg -list_patches command.
Exit the root-user command shell:
```
# exit
$
```