Oracle Cloud Infrastructure Documentation

Listing DB Systems

You can retrieve a list of DB systems.

Use the Console, a command-line interface, or the REST API to list DB systems.

Using the Console

Use the Console to list DB systems.

  1. Open the navigation menu and select Databases. Under HeatWave MySQL, select DB systems.
    The DB systems list page opens. All DB systems in the selected compartment are displayed in a table.
  2. To view the DB systems in a different compartment, use the Compartment filter to switch compartments.
    Note

    You must have permission to work in a compartment to see the resources in it. If you're not sure which compartment to use, contact an administrator. For more information, see Understanding Compartments.
  3. Filtering List Results: Use filters to limit the DB systems in the list. Perform one of the following actions depending on the options that you see:
    • From the Search and Filter box above the list table, select one or more filters and specify the values that you want to use to narrow the list. In general, the filters correspond to the columns shown in the list table, although some filters represent attributes that aren't shown in the table. The Compartment filter is always displayed next to Applied filters.
    • On the left side of the list page, select a value from one of the available filters, such as compartment, state, or tags.
    Change the order of the items in the list table by using the sort icons next to the column names.
  4. Actions: In the list table, select the name of a DB system to open its details page, where you can view its status and perform other tasks. To perform an action on a DB system directly from the list table, select any of the following options from the Actions menu in the row for that DB system:
    • View details: Open the details page for the DB system.
    • Start: Start the DB system.
    • Stop: Stop the DB system.
    • Restart: Restart the DB system.
    • Switchover: Switch the primary instance of the DB system.
    • Copy OCID: Copy the OCID of the DB system to the clipboard.
    • Delete: Delete the DB system.
    To create a DB system, select Create DB system.
    To perform a bulk action on one or more DB systems, select a list of DB systems and select any of the following options from the Actions menu at the top of the table:
    • Start: Start selected DB systems.
    • Stop: Stop selected DB systems.
    • Restart: Restart selected DB systems.
    • Create manual backup: Back up selected DB systems.
    • Add tags: Add one or more tags to selected DB systems.
    • Delete: Delete selected DB systems.

Using the CLI

Use the command-line interface to list DB systems.

This task requires the following:
  • The Oracle Cloud Identifier (OCID) of your compartment.
  • A policy that permits you to list DB systems in the compartment or tenancy.
  • A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
List all DB systems in a compartment using the CLI:
  1. Open a command prompt and run the following command:
    oci mysql db-system list 
     --compartment-id <CompartmentOCID>
    • compartment-id: Specify the OCID of the compartment.
If the command validates and runs successfully, you get a response similar to the following, which list all the DB systems found in the specified compartment.