Disable the arbitration service for a tenant

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

Procedure

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

   Here is an example of connecting to the database. Please replace the actual environment variables in the example.

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

   For more information about how to connect to the database, see Overview of connecting to a database (MySQL mode) and Overview of connecting to a database (Oracle mode).

2. Execute the following command to view the status of the arbitration service for the tenant.

   Here is an 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: ENABLED
                     UNIT_NUM: 1
           ZONE_UNIT_NUM_LIST: zone1:1,zone2:1
                   COMPATIBLE: 4.6.0.0
                    MAX_LS_ID: 1002
            RESTORE_DATA_MODE: NORMAL
            FLASHBACK_LOG_SCN: NULL
                      COMMENT:
   1 row in set
   

   If the ARBITRATION_SERVICE_STATUS column is ENABLED, 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 command to disable the arbitration service for the tenant.

   The statement is as follows:

   ALTER TENANT tenant_name [SET] ENABLE_ARBITRATION_SERVICE = false; 
   

   In this statement, tenant_name specifies the name of the tenant for which you want to disable the arbitration service. SET is an optional keyword.

   Here is an example of disabling the arbitration service for the oracle001 tenant:

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

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

   Here is an 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.6.0.0
                    MAX_LS_ID: 1002
            RESTORE_DATA_MODE: NORMAL
            FLASHBACK_LOG_SCN: NULL
                      COMMENT:
   1 row in set
   

   If the ARBITRATION_SERVICE_STATUS column is DISABLED, the arbitration service is disabled for the tenant.

What to do next

After you disable the arbitration service for all tenants, you can delete the arbitration service if you no longer need it. For more information, see Delete the arbitration service.

References

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

• 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 degradation timeout

• Replace the arbitration service for a cluster

• Delete the arbitration service for a cluster