Disable the arbitration service

If the arbitration service is enabled, you can disable the arbitration service as needed.

Procedure

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

   Note that you must specify the corresponding fields in the following sample code based on your actual database configurations.

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

   For more information about how to connect to a database, see Database connection overview (MySQL mode) or Database connection overview (Oracle mode).

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

   Sample statement:

   obclient [(oceanbase)]> SELECT * FROM DBA_OB_TENANTS WHERE tenant_name = 'oracle001';
   *************************** 1. row ***************************
                    TENANT_ID: 1004
                  TENANT_NAME: oracle001
                  TENANT_TYPE: USER
                  CREATE_TIME: 2023-02-06 13:38:27.626314
                  MODIFY_TIME: 2023-02-06 13:38:45.005930
                 PRIMARY_ZONE: zone1
                     LOCALITY: FULL{1}@zone1
            PREVIOUS_LOCALITY: NULL
           COMPATIBILITY_MODE: ORACLE
                       STATUS: NORMAL
                IN_RECYCLEBIN: NO
                       LOCKED: NO
                  TENANT_ROLE: PRIMARY
            SWITCHOVER_STATUS: NORMAL
             SWITCHOVER_EPOCH: 0
                     SYNC_SCN: 1677665769026296752
               REPLAYABLE_SCN: 1677665769026296752
                 READABLE_SCN: 1677665768858323118
           RECOVERY_UNTIL_SCN: 4611686018427387903
                     LOG_MODE: NOARCHIVELOG
   ARBITRATION_SERVICE_STATUS: ENABLED
   1 row in set
   

   The preceding query result shows that the value of the ARBITRATION_SERVICE_STATUS field 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:

   Syntax:

   ALTER TENANT tenant_name [SET] ENABLE_ARBITRATION_SERVICE = false;
   

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

   The following sample statement disables the arbitration service for a tenant named oracle001:

   obclient [(none)]> ALTER TENANT oracle001 ENABLE_ARBITRATION_SERVICE = false;
   Query OK, 0 rows affected
   

4. Query the oceanbase.DBA_OB_TENANTS view to verify whether the arbitration service is disabled for the tenant.

   Sample statement:

   obclient [(oceanbase)]> SELECT * FROM DBA_OB_TENANTS WHERE tenant_name = 'oracle001';
   *************************** 1. row ***************************
                    TENANT_ID: 1004
                  TENANT_NAME: oracle001
                  TENANT_TYPE: USER
                  CREATE_TIME: 2023-02-06 13:38:27.626314
                  MODIFY_TIME: 2023-02-06 13:38:45.005930
                 PRIMARY_ZONE: zone1
                     LOCALITY: FULL{1}@zone1
            PREVIOUS_LOCALITY: NULL
           COMPATIBILITY_MODE: ORACLE
                       STATUS: NORMAL
                IN_RECYCLEBIN: NO
                       LOCKED: NO
                  TENANT_ROLE: PRIMARY
            SWITCHOVER_STATUS: NORMAL
             SWITCHOVER_EPOCH: 0
                     SYNC_SCN: 1677665769026296752
               REPLAYABLE_SCN: 1677665769026296752
                 READABLE_SCN: 1677665768858323118
           RECOVERY_UNTIL_SCN: 4611686018427387903
                     LOG_MODE: NOARCHIVELOG
   ARBITRATION_SERVICE_STATUS: DISABLED
   1 row in set
   

   The preceding query result shows that the value of the ARBITRATION_SERVICE_STATUS field 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, see Remove the arbitration service.

More information

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

• Overview

• Enable the arbitration service

• Modify the downgrade timeout period

• Replace the arbitration service

• Remove the arbitration service