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.