Oracle Cloud Infrastructure Documentation

Updating the Database and Access Modes

You can update the database and access modes of a DB system.

Note

If the DB system has HeatWave cluster enabled, you cannot set the database mode to read-only.
Note

If the DB system has REST enabled, you cannot set the database mode to read-only or set the access mode to administrators only.

Using the Console

You can update the database and access modes of a DB system.

Do the following to update the database and access modes of a DB system:

  1. On the DB systems list page, select the DB system that you want to work with. If you need help finding the list page or the DB system, see Listing DB Systems - Using the Console.

    The details page opens and displays information about the DB system.

  2. Select the Details tab.
  3. Select Edit in the Access mode or Database mode field:
  4. In the Update database and access modes dialog box:
    • Select the database mode if required.
      Note

      You cannot select read-only database mode if the DB system has REST enabled or a HeatWave cluster attached to it.
    • Select the access mode if required.
      Note

      You cannot select administrators only access mode if the DB system has REST enabled.
  5. Select Save changes.

Using the CLI

Use the command-line interface to update the database mode or access mode of a DB system.

This task requires the following:
  • A DB system Oracle Cloud Identifier (OCID).
  • A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
  1. Open a command prompt and run the following command:
    oci mysql db-system update --db-system-id <DBSystemOCID> --database-mode <DatabaseMode> --access-mode <AccessMode>
    • db-system-id: Specify the OCID of the DB system.
    • database-mode: Specify the database mode.
    • access-mode: Specify the access mode.
The command updates the DB system and returns the work request information.