Oracle Cloud Infrastructure Documentation

Database and Access Modes

By default, a DB system runs in read-write mode and allows all valid user accounts to connect to it. You can configure the DB system to read-only mode where write operations are not allowed. You can also set the access mode to allow only administrator users to connect to it.

Database Mode

The database mode determines the type of operations which users connected to the DB system can perform.

There are two database modes:
  • Read-write: Allows users to retrieve and modify the data stored in the DB system.
  • Read-only: Allows data retrievals and prevents the data from being modified. You can use this mode to prevent write operations on a target DB system of an inbound replication.
    Note

    If you configure the database mode of a DB system to read-only, HeatWave sets the SUPER_READ_ONLY system variable to ON. Health Monitor also set this variable to ON when there is a sustained shortage of disk space. When the disk space shortage has recovered, Health Monitor resets the variable to OFF, causing the DB system to allow write operations regardless of the database mode. You can restart the DB system to preserve the read-only database mode. See Overview of Health Monitor.

Access Mode

The access mode determines which user accounts can connect to the DB system.

There are two access modes:
  • All users: Allows all users to connect to the DB system to access the data.
  • Administrators only: Restricts the access to administrator users only. You can use this mode to allow administrators to perform maintenance operations on a DB system without the interference of user operations. You can also use this mode to prevent users from accessing a DB system meant for disaster recovery or other purposes.
    Note

    If you configure the access mode of a DB system to administrators only, HeatWave sets the OFFLINE_MODE system variable to ON. Health Monitor also set this variable to ON when there is a sustained shortage of disk space. When the disk space shortage has recovered, Health Monitor resets this variable to OFF, allowing all users to be able to connect to the DB system regardless of the access mode. You can restart the DB system to preserve the administrators only access mode. See Overview of Health Monitor.