Disable the arbitration service for a tenant

After you enable the arbitration service for a tenant, you can disable it based on your business needs.

Procedure

1. Log in to the sys tenant of the cluster as the root user.

   Below is a connection example. Use your actual environment when connecting to the database.

   obclient -h10.xx.xx.xx -P2883 -uroot@sys#obdemo -p***** -A
   

   For more detailed guidance on connecting to the database, see Overview of connection methods (MySQL-compatible mode) and Overview of connection methods (Oracle-compatible mode).

2. Execute the following statement to query the arbitration service status of the tenant.

   Example:

   obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_TENANTS WHERE tenant_name = 'oracle001'\G
   

   The query result is as follows:

   *************************** 1. row ***************************
                    TENANT_ID: 1004
                  TENANT_NAME: oracle001
                  TENANT_TYPE: USER
                  CREATE_TIME: 2026-01-26 19:40:21.457857
                  MODIFY_TIME: 2026-01-26 19:41:14.594119
                 PRIMARY_ZONE: zone1;zone2
                     LOCALITY: FULL{1}@zone1, FULL{1}@zone2
            PREVIOUS_LOCALITY: NULL
           COMPATIBILITY_MODE: ORACLE
                       STATUS: NORMAL
                IN_RECYCLEBIN: NO
                       LOCKED: NO
                  TENANT_ROLE: PRIMARY
            SWITCHOVER_STATUS: NORMAL
             SWITCHOVER_EPOCH: 0
                     SYNC_SCN: 1687844691346544381
               REPLAYABLE_SCN: 1687844691346544381
                 READABLE_SCN: 1687844691346544381
           RECOVERY_UNTIL_SCN: 4611686018427387903
                     LOG_MODE: NOARCHIVELOG
   ARBITRATION_SERVICE_STATUS: ENABLED
                     UNIT_NUM: 1
           ZONE_UNIT_NUM_LIST: zone1:1,zone2:1
                   COMPATIBLE: 4.4.2.0
                    MAX_LS_ID: 1002
            RESTORE_DATA_MODE: NORMAL
            FLASHBACK_LOG_SCN: NULL
                      COMMENT:
   1 row in set
   

   According to the query result, the ARBITRATION_SERVICE_STATUS column is ENABLED, which indicates that the arbitration service is enabled for the tenant.

   For more information about the DBA_OB_TENANTS view, see DBA_OB_TENANTS.

3. Execute the following statement to disable the arbitration service for the tenant.

   The syntax is as follows:

   ALTER TENANT tenant_name [SET] ENABLE_ARBITRATION_SERVICE = false; 
   

   Here, tenant_name is the name of the tenant for which you want to disable the arbitration service. The SET keyword is optional.

   Example for disabling the arbitration service for tenant oracle001:

   obclient(root@sys)[oceanbase]> ALTER TENANT oracle001 ENABLE_ARBITRATION_SERVICE = false; 
   

4. After the command is executed successfully, query the oceanbase.DBA_OB_TENANTS view again to confirm whether the arbitration service is disabled for the tenant.

   Example:

   obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_TENANTS WHERE tenant_name = 'oracle001'\G
   

   The query result is as follows:

   *************************** 1. row ***************************
                    TENANT_ID: 1004
                  TENANT_NAME: oracle001
                  TENANT_TYPE: USER
                  CREATE_TIME: 2026-01-26 19:40:21.457857
                  MODIFY_TIME: 2026-01-27 13:51:47.053502
                 PRIMARY_ZONE: zone1;zone2
                     LOCALITY: FULL{1}@zone1, FULL{1}@zone2
            PREVIOUS_LOCALITY: NULL
           COMPATIBILITY_MODE: ORACLE
                       STATUS: NORMAL
                IN_RECYCLEBIN: NO
                       LOCKED: NO
                  TENANT_ROLE: PRIMARY
            SWITCHOVER_STATUS: NORMAL
             SWITCHOVER_EPOCH: 0
                     SYNC_SCN: 1687845116605766616
               REPLAYABLE_SCN: 1687845116605766616
                 READABLE_SCN: 1687845116605766616
           RECOVERY_UNTIL_SCN: 4611686018427387903
                     LOG_MODE: NOARCHIVELOG
   ARBITRATION_SERVICE_STATUS: DISABLED
                     UNIT_NUM: 1
           ZONE_UNIT_NUM_LIST: zone1:1,zone2:1
                   COMPATIBLE: 4.4.2.0
                    MAX_LS_ID: 1002
            RESTORE_DATA_MODE: NORMAL
            FLASHBACK_LOG_SCN: NULL
                      COMMENT:
   1 row in set
   

   According to the query result, the ARBITRATION_SERVICE_STATUS column is DISABLED, which indicates that the arbitration service is disabled for the tenant.

What to do next

After you disable the arbitration service for all tenants, you can remove the arbitration service if you no longer need it. For more information about removing the arbitration service, see Remove the arbitration service.

References

For more information about the arbitration service, see the following:

• Deploy an OceanBase cluster with two replicas and the arbitration service

• Overview of the arbitration service

• Enable the arbitration service for a tenant

• Modify the log stream downgrade control time

• Replace the arbitration service for a cluster

• Remove the arbitration service for a cluster