OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Database

SQL - V4.0.0Enterprise Edition

  • Overview
    • Overview
    • System architecture
    • Compatibility with MySQL
    • Compatibility with Oracle
      • Overview
      • SQL data types
      • Built-in functions
      • System views
    • Limits
  • Get Started
    • Quick start with OceanBase Database
    • Hands on for OceanBase SQL
      • Usage notes
      • Basic SQL operations (MySQL mode)
      • Basic SQL operations (Oracle mode)
    • Build applications (MySQL Mode)
      • Connect Python applications to OceanBase Database
      • Connect Java applications to OceanBase Database
      • Connect C applications to OceanBase Database
    • Build applications(Oracle Mode)
      • Connect Python applications to OceanBase Database
      • Connect Java applications to OceanBase Database
      • Connect C applications to OceanBase Database
    • Experience OceanBase advanced features
      • Experience scalable OLTP
        • Run the TPC-C benchmark in OceanBase Database
        • Experience the hot row update capability of OceanBase Database
      • Experience operational OLAP
      • Experience parallel import and data compression
      • Experience the multitenancy feature
  • Develop
    • Develop (MySQL Mode)
      • Connect to Oceanbase Database with client
        • Overview
        • Connect to an OceanBase Database tenant by using a MySQL client
        • Connect to an OceanBase Database tenant by using OBClient
        • Connect to OceanBase Database by using ODC
        • Java application
          • OceanBase Connector/J
          • Java APIs
          • Connect Java applications to OceanBase Database
        • C application
          • OceanBase Connector/C
          • C API functions
          • Connect C applications to OceanBase Database
        • Python applications
        • SpringBoot connection example
        • SpringBatch connection example
        • Example of Database connection pool configuration
          • Overview of database connection pool configuration
          • Example of configuring a Tomcat connection pool
          • Example of configuring a C3P0 connection pool
          • Example of configuring a Proxool connection pool
          • Example of configuring a HiKariCP connection pool
          • Example of configuring a DBCP connection pool
          • CommonPool configuration example
          • Example of configuring a JDBC connection pool
        • SpringJDBC connection example
        • SpringJPA connection example
        • Hibernate connection example
        • MyBatis connection example
      • Create and manage database objects
        • About DDL statements
        • View the currently connected database
        • Change the password of a user
        • Data type
          • General data types
          • Unsupported data types
        • Create and manage tables
          • About tables
          • Create a table
          • About auto-increment columns
          • About types of column constraints
          • About table structure modification
          • About table clearing
          • About table dropping
          • Flash back a dropped table
          • About table privileges
        • Create and manage partition tables
          • About partitioned tables
          • Create a partitioned table
          • Manage a partitioned table
          • Create a subpartitioned table
          • Manage a subpartitioned table
          • Partition routing
          • Indexes on partitioned tables
          • Suggestions on using partitioned tables
        • Create and manage indexes
          • About indexes
          • Create an index
          • Drop an index
        • Create and manage views
          • About views
          • Create a view
          • Modify a view
          • Delete a view
        • Create and manage sequences
          • About sequences
          • Create a sequence
          • Modify a sequence
          • Delete a sequence
        • Create and manage triggers
          • About triggers
          • Create a trigger
          • Delete a trigger
      • Query
        • About queries
        • Single-table queries
        • Conditional queries
        • ORDER BY queries
        • GROUP BY queries
        • Use the LIMIT clause in queries
        • Query data from multiple tables
          • About multi-table join queries
          • INNER JOIN queries
          • OUTER JOIN queries
          • Subqueries
        • Use operators and functions in a query
          • Use arithmetic operators in queries
          • Use numerical functions in queries
          • Use string connectors in queries
          • Use string functions in queries
          • Use datetime functions in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use NULL-related functions in queries
          • Use the CASE conditional operator in queries
          • Use the SELECT FOR UPDATE statement to lock query results
        • Execution plan
          • View an execution plan
          • Understand an execution plan
        • Use SQL hints in queries
        • Variables of query timeout
      • DML statements and transactions
        • DML statement
          • About DML statements
          • About the INSERT statement
          • UPDATE statements
          • About the DELETE statement
          • About the REPLACE INTO statement
        • Transactions
          • About transaction control statements
          • Start a transaction
          • Transaction savepoints
          • Commit a transaction
          • Roll back a transaction
          • About transaction timeout
      • Common errors and solutions
        • About error codes
        • Database connection error
        • About timeout
          • Idle session timeout
          • Transaction timeout errors
        • About user
          • Locked user
          • Incorrect user password
        • About table
          • Table already exists
          • Table does not exist
          • Invalid use of NULL value
        • About constraint
          • Unique key conflict
          • Foreign key conflict
        • About SQL commands
          • Data truncation
    • Develop (Oracle Mode)
      • Connect to Oceanbase Database with client
        • Overview
        • Connect to an OceanBase tenant by using an Oracle client
        • Connect to an OceanBase Database tenant by using OBClient
        • Connect to OceanBase Database by using ODC
      • Application development
        • Java application
          • OceanBase Connector/J
          • Java APIs
          • Connect Java applications to OceanBase Database
        • Python application
          • OceanBase Connector/J in Python
          • Python APIs
          • Connect Python applications to OceanBase Database
        • 300.c-application-1
          • OceanBase Connector/C
          • OBCI APIs
          • Connect C applications to OceanBase Database
      • Create and manage database objects
        • About DDL statements
        • View the currently connected database
        • Change the password of a user
        • Data type
          • General data types
          • Unsupported data types
        • Create and manage tables
          • About tables
          • Create a table
          • Define an auto-increment column by using the SEQUENCE keyword
          • About types of column constraints
          • About table structure modification
          • About table clearing
          • About table dropping
          • Flash back a dropped table
          • About table privileges
        • Create and manage partition tables
          • About partitioned tables
          • Create a partitioned table
          • Manage a partitioned table
          • Create a subpartitioned table
          • Manage a subpartitioned table
          • Partition routing
          • Indexes on partitioned tables
          • Suggestions on using partitioned tables
        • Create and manage indexes
          • Drop an index
          • About indexes
          • Create an index
        • Create and manage views
          • About views
          • Create a view
          • Modify a view
          • Drop a view
        • Create and manage sequences
          • About sequences
          • Create a sequence
          • Modify a sequence
          • Delete a sequence
        • Create and manage synonyms
          • About synonyms
          • Create a synonym
          • Delete a synonym
        • Create and manage triggers
          • About triggers
          • Create a trigger
          • Modify a trigger
          • Delete a trigger
          • Enable or disable a trigger
      • Query
        • About queries
        • Single-table queries
        • Conditional queries
        • ORDER BY queries
        • GROUP BY queries
        • Use Row_Limiting_Clause in queries
        • Query data from multiple tables
          • About multi-table join queries
          • INNER JOIN queries
          • OUTER JOIN queries
          • Subqueries
        • Use operators and functions in a query
          • Use arithmetic operators in queries
          • Use numerical functions in queries
          • Use string concatenation operators in queries
          • Use string functions in queries
          • Use datetime functions in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use NULL-related functions in queries
          • Use CASE functions in queries
          • Use the SELECT FOR UPDATE statement to lock query results
        • Execution plan
          • View execution plans of queries
          • Understand an execution plan
        • Use SQL hints in queries
        • About query timeout variables
      • DML statements and transactions
        • DML statement
          • About DML statements
          • About the INSERT statement
          • UPDATE statements
          • About the MERGE statement
          • About the DELETE statement
        • Transactions
          • About transaction control statements
          • Start a transaction
          • Transaction savepoints
          • Commit a transaction
          • Roll back a transaction
          • About transaction timeout
      • Common errors and solutions
        • Overview
        • Database connection error
        • About timeout
          • Idle session timeout
          • Transaction timeout errors
        • About user
          • Locked user
          • Incorrect user password
        • About object
          • Object already exists
          • Object does not exist
        • About constraint
          • Unique key conflict
          • Foreign key conflict
        • About sql
          • Data type inconsistency
  • Deploy
    • Overview
    • Deployment procedure
    • Preparations before deployment
      • Prepare servers
      • Configure servers
      • Prepare installation packages
    • HA solution for OceanBase clusters
    • Deploy through the CLI
      • Configure the deployment environment
        • Install oat-cli
        • Use oat-cli to configure the deployment environment
        • Configure the clock source
        • Upload installation packages
        • Configure host information
        • Check the environment before deployment
      • Deploy OCP
        • Deployment description
        • Generate a configuration file
        • Start deployment
        • Check after deployment
      • Deploy the OceanBase cluster
        • Deploy a single-replica OceanBase cluster
        • Deploy a three-replica OceanBase cluster
      • Deploy OBProxy
        • Deploy OBProxy through the CLI
      • Create an OceanBase tenant
        • View resources available for a business tenant
        • Create a tenant
        • Verify after deployment
      • Deploy OMS
        • Deployment description
        • Modify the configuration file
        • Start deployment
        • Check after deployment
      • Deploy ODC
        • Deployment description
        • Modify the configuration file
        • Start deployment
        • Check after deployment
  • Migrate
    • Overview
    • Migrate data by using SQL scripts
    • Migrate data by using MySQLDump
    • Migrate data by using DataX
    • Migrate data by using OUTFILE statements

Download PDF

Overview System architecture Compatibility with MySQL Overview SQL data types Built-in functions System views Limits Quick start with OceanBase Database Usage notes Basic SQL operations (MySQL mode) Basic SQL operations (Oracle mode) Connect Python applications to OceanBase Database Connect Java applications to OceanBase Database Connect C applications to OceanBase Database Connect Python applications to OceanBase Database Connect Java applications to OceanBase Database Connect C applications to OceanBase Database Experience operational OLAP Experience parallel import and data compression Experience the multitenancy feature Overview Deployment procedure Prepare servers Configure servers Prepare installation packages HA solution for OceanBase clustersOverview Migrate data by using SQL scripts Migrate data by using MySQLDumpMigrate data by using DataX Migrate data by using OUTFILE statements
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogLive DemosTraining & Certification
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Database
  3. SQL
  4. V4.0.0
iconOceanBase Database
SQL - V 4.0.0Enterprise Edition
SQL
KV
  • V 4.4.2
  • V 4.3.5
  • V 4.3.3
  • V 4.3.1
  • V 4.3.0
  • V 4.2.5
  • V 4.2.2
  • V 4.2.1
  • V 4.2.0
  • V 4.1.0
  • V 4.0.0
  • V 3.1.4 and earlier

Generate a configuration file

Last Updated:2023-07-24 09:52:12  Updated
share
What is on this page
Configure environment variables
Description
Applicable versions
Use init_obcluster_conf.sh to generate the configuration file
Single-node deployment
Deployment in three-node mode
Deployment in multi-zone mode

folded

share

Before the deployment of OceanBase Cloud Platform (OCP), you must use oat-cli, the command-line tool of OceanBase Admin Toolkit (OAT), to generate a configuration file template and modify the template as needed.

Configure environment variables

Description

You can execute an SSH connection by specifying environment variables. Non-root users and private keys are supported for the connection. For more information, see the help information in install.sh -h. Note that passwordless SSH logon is no longer supported. This is to improve security.

Applicable versions

oat-cli V1.4.0 and later.

Use init_obcluster_conf.sh to generate the configuration file

If the configuration file exists, the script obtains the values of the following environment variables: SSH_AUTH, SSH_USER, SSH_PORT, SSH_PASSWORD, and SSH_KEY_FILE.

Syntax for parameter setting:

export ssh_parameter = parameter_value

ssh_parameter:
  SSH_AUTH
 | SSH_USER
 | SSH_PORT
 | SSH_PASSWORD
 | SSH_KEY_FILE

Parameters:

  • SSH_AUTH: the authentication mode. Default value: password. Valid values: password and pubkey.

  • SSH_USER: the user. Default value: root. If a non-root user is specified, make sure that the user is authorized to run the sudo bash command and a password or the /etc/sudoers settings are not specified.

  • SSH_PORT: the port number. Default value: 22.

  • SSH_PASSWORD: the password. No password is specified by default.

  • SSH_KEY_FILE: the directory of the key file. Default value: /root/.ssh/id_rsa. This parameter takes effect only when SSH_AUTH is set to pubkey.

Example:

export SSH_AUTH = password
export SSH_USER = root
export SSH_PORT = 22
export SSH_PASSWORD = '******'
export SSH_KEY_FILE = /root/.ssh/id_rsa

Single-node deployment

  1. Log on as the root user to the server where OCP is deployed and run the following commands:

    [root@hostname /]# cd /root/t-oceanbase-antman
    [root@hostname /root/t-oceanbase-antman]# bash init_obcluster_conf.sh
    
  2. During mode selection, enter 1 for single-node deployment.

    The corresponding configuration file template is generated.

    Example:

    ## obcluster.conf
    ##
    SINGLE_OCP_MODE=TRUE
    ################################ MUST CHANGE ACCORDING ENVIRONMENT ################################
    ############ Edit Machine IP and Password Of root/admin ############
    ZONE1_RS_IP=xxx.xxx.xxx.xxx
    OBSERVER01_ROOTPASS=rootpass
    OBSERVER01_ADMINPASS=adminpass
    SSH_PORT=22
    
    ############ Edit Configuration of Load Balance ############
    # lb_mode: dns/f5/none, default: dns for 3 ocp, none for 1 ocp
    lb_mode=none
    
    # Remaining content
    ...
    
  3. Modify the configuration file template based on the comments.

    The following information needs to be modified:

    • You must enter the server IP address and the passwords of the root and admin users. For single-node deployment, you need to specify the information of only one server.

    • For single-node deployment, set lb_mode to none to disable load balancing.

    • Allocate resources to the Docker container based on the CPU and memory resources of the physical server.

    • You can run the docker load -i <docker image> command and the docker images command to obtain the version information of Docker containers of the OBServer, OBProxy, and OCP.

    • To deploy OceanBase Migration Service (OMS), enter the basic configuration of OMS, including the IP address of the OMS server and the version information of the OMS Docker container.

    • To deploy OceanBase Developer Center (ODC), enter the version information of the ODC Docker container.

Deployment in three-node mode

  1. Log on to the OCP server as the root user and run the following command:

    bash init_obcluster_conf.sh
    
  2. During mode selection, enter 3 for three-node deployment.

    The corresponding configuration file template is generated.

    Example:

    ################################ MUST CHANGE ACCORDING ENVIRONMENT ################################
    ############ Edit Machine IP and Password Of root/admin ############
    ZONE1_RS_IP=xxx.xxx.xxx.xxx
    ZONE2_RS_IP=xxx.xxx.xxx.xxx
    ZONE3_RS_IP=xxx.xxx.xxx.xxx
    OBSERVER01_ROOTPASS=rootpass
    OBSERVER02_ROOTPASS=rootpass
    OBSERVER03_ROOTPASS=rootpass
    OBSERVER01_ADMINPASS=adminpass
    OBSERVER02_ADMINPASS=adminpass
    OBSERVER03_ADMINPASS=adminpass
    
    ############ Edit Configuration of Load Balance ############
    # lb_mode: dns/f5/none, default: dns for 3 ocp, none for 1 ocp
    lb_mode=dns
    
    # Remaining content
    ...
    
  3. Modify the configuration file template based on the comments.

    The following information needs to be modified:

    • You must enter the server IP address and the passwords of the root and admin users. For three-node deployment, you must enter the information of three servers.

      • If you select dns for lb_mode, the domain name oceanbase.com is recommended by default. This domain name can be accessed only from OCP nodes. To access this domain name from other nodes, configure domain name resolution for these nodes.
        As an example for description, lb_mode is set to dns.
      • If you select F5 for lb_mode, you need to configure the virtual IP addresses (VIPs) and virtual port numbers of OBProxy and OCP. You need to apply for the VIPs and port numbers in advance.
    • Allocate resources to the Docker containers based on the CPU and memory resources of the physical servers.
      Default specifications: 32C/128G (32 CPU cores and 128 GB of memory) for OBServer, 8C/16G (8 CPU cores and 16 GB of memory) for OCP, and 4C/12G (4 CPU cores and 12 GB of memory) for OBProxy.
      If the physical server is provided based on the recommended minimum configuration, you can customize the server resources. The OBServer resources must be greater than 24C/100G (24 CPU cores and 100 GB of memory), the OCP resources must be greater than 4C/8G (4 CPU cores and 8 GB of memory), and OBProxy resources must be greater than 2C/10G (2 CPU cores and 10 GB of memory).

    • You can run the docker load -i <docker image> command and the docker images command to obtain the version information of Docker containers of the OBServer, OBProxy, and OCP.

    • To deploy OMS, enter the basic configuration of OMS, including the IP address of the OMS server and the version information of the OMS Docker container.

    • To deploy ODC, enter the version information of the ODC Docker container.

Deployment in multi-zone mode

  1. Check if the obcluster.conf file exists in the /root/t-oceanbase-antman/ directory.

    • If yes, skip to Step 4.

    • Otherwise, proceed to the next step.

  2. Log on as the root user to the server where OCP is deployed and run the following commands:

    [root@hostname /]# cd /root/t-oceanbase-antman/
    [root@hostname clonescripts]# bash init_obcluster_conf.sh
    
  3. During mode selection, enter 3 for multi-node deployment.

    The corresponding configuration file template is generated.

    Example:

    ##################  OCP multi-zone configurations  ######################
    OCP_MAZ_ENABLED=TRUE                                 #If multi-zone mode is enabled and no global VIP is available, the configured OCP_VIP and OBPROXY_VIP values can be changed to the VIP of the primary zone or the IP address of any OCP node.
    OCP_MAZ_AZ_NAME_LIST=(az1 az1 az2)                #The zone names that you specified for az_name for OCP 1, OCP 2, and OCP 3.
    OCP_MAZ_OCP_VIP_LIST=(xx.xx.xx.1 xx.xx.xx.2 xx.xx.xx.3)   #The IP addresses that you specified for site-url for OCP 1, OCP 2, and OCP 3.
    OCP_MAZ_OCP_VPORT_LIST=(8080 8080 8080)      #The port numbers that you specified for site-url for OCP 1, OCP 2, and OCP 3.
    OCP_MAZ_METAPROXY_VIP_LIST=(xx.xx.xx.1 xx.xx.xx.2 xx.xx.xx.3)  #The IP addresses of MetaDB for OCP 1, OCP 2, and OCP 3.
    OCP_MAZ_METAPROXY_VPORT_LIST=(2883 2883 2883)         #The port numbers of MetaDB for OCP 1, OCP 2, and OCP 3.
    
  4. When you deploy OCP in multi-zone mode, configure the parameters in the "OCP multi-zone configurations" section.

    The following information needs to be modified:

    Note

    By default, in the template for multi-zone OCP deployment, three zones are configured. You can add or delete the number of values for related parameters as needed. For example, if you want to deploy the OCP cluster across two zones, set OCP_MAZ_AZ_NAME_LIST=(az1 az2).

    • OCP_MAZ_ENABLED: indicates whether multi-zone mode is enabled. Default value: FALSE. Set the value to TRUE when you need to enable multi-zone mode.

    • OCP_MAZ_AZ_NAME_LIST: specifies the zone names of the OCP nodes, for example, (az1 az2 az3). The zone names of different OCP nodes can be the same, for example, (az1 az1 az2).

    • OCP_MAZ_OCP_VIP_LIST: specifies the server addresses of the OCP nodes, namely, the host part of SiteUrl, for example, (10.1.1.1 10.1.1.2 10.1.1.3).

    • OCP_MAZ_OCP_VPORT_LIST: specifies the server ports of the OCP nodes, namely, the part of SiteUrl for the port, for example, (80 80 80).

    • OCP_MAZ_METAPROXY_VIP_LIST: specifies the IP addresses of the OCP nodes for accessing the MetaDB.

    • OCP_MAZ_METAPROXY_VPORT_LIST: specifies the port numbers of the OCP nodes for accessing the MetaDB.

Previous topic

Deployment description
Last

Next topic

Start deployment
Next
What is on this page
Configure environment variables
Description
Applicable versions
Use init_obcluster_conf.sh to generate the configuration file
Single-node deployment
Deployment in three-node mode
Deployment in multi-zone mode