Change Autonomous Database Operation Mode to Read/Write Read-Only or Restricted

You can select an Autonomous Database operation mode. The default mode is Read/Write. If you select Read-Only mode users can only run queries. In addition, for either of these modes you can restrict access to only allow users with the RESTRICTED SESSION privilege to connect to the database. The ADMIN user has this privilege. You can use the restricted access mode to perform administrative tasks such as indexing, data loads, or other planned activities.

Perform the following prerequisite steps as necessary:

  • Open the Oracle Cloud Infrastructure console by clicking the navigation icon next to Oracle Cloud.

  • From the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.

  • On the Autonomous Databases page select an Autonomous Database from the links under the Display Name column.

To change the Autonomous Database operation mode, do the following:

  1. On the Details page, in the Mode field under General Information, click Edit.

    This shows the Change Database Mode dialog.

    Description of adb_mode_edit.png follows
    Description of the illustration adb_mode_edit.png
  2. Select a mode, either Read/Write or Read-Only.
  3. If you want to restrict access to only allow the ADMIN or privileged users, then select Allow administrator access only.
  4. Click Confirm.

    While the mode changes, the Lifecycle State field shows Updating. After the mode change completes, the Lifecycle State field shows Available.

Notes for changing the database mode:

  • The database must be available with the Lifecycle State field showing Available to change the database mode.

  • When you change the database mode to restricted mode or when you change from restricted mode to unrestricted mode, the database terminates existing database connections as follows:

    • When the mode is restricted, that is the Mode field shows (Admin-only access), if you deselect Allow administrator access only and click Confirm, then users and applications need to reestablish database connections after the mode change completes.

    • When the mode is unrestricted, that is the Mode field does not show (Admin-only access), if you select Allow administrator access only and click Confirm, then users and applications need to reestablish database connections after the mode change completes.

  • When the database is in Read-Only mode, each of the following is disabled:

    • The change Admin Password action is not allowed. Also, on the Service Console Administration area the Set Administrator Password link is disabled.

    • Oracle Application Express URLs are not available and on the Service Console Development area the Oracle APEX link is disabled. Also on the Oracle Cloud Infrastructure console on the Tools tab the Open APEX link is disabled.

    • Oracle Machine Learning User Administration is disabled and on the Service Console in the Development area the Oracle Machine Learning Notebooks link is disabled. Also, on the Oracle Cloud Infrastructure console on the Tools tab the Open Oracle ML User Administration link is disabled.

    • Setting resource management rules is disabled. Also, on the Service Console in the Administration area the Set Resource Management Rules link is disabled.

    • Upgrading the database is disabled when the database is in Read-Only mode.