Prepare the environment|V3.2.0|OceanBase Loader and Dumper| docs|Distributed Database

Prepare the environment

Last Updated：2023-06-29 12:17:59 Updated

#docslug#/obloader-obdumper/obloader-obdumper/V3.1.0/obdumper-environmental-preparation

Before you run OBDUMPER, ensure that you have the appropriate operating environment and privileges.

Operating environment configurations

Configuration item	Requirements
OS	Linux, macOS, and Windows 7 or later.
Java environment	Install Oracle JDK 1.8, and configure the `JAVA_HOME` environment variable. We do not recommend that you use OpenJDK.
Character set	We recommend that you use UTF-8 as the file character set.
Java virtual machine (JVM) parameters	Modify the JVM memory parameter in the bin/obdumper script to avoid JVM memory insufficiency.

Note
Due to serious garbage collection (GC) bugs in some versions of OpenJDK 1.8, an out of memory (OOM) error or a hang will occur when OBDUMPER is running. Therefore, install the latest minor version of OpenJDK 1.8.

Privileges

When you connect OBDUMPER to OceanBase Database and use this tool to export database object definitions and table data, you must have privileges in the following table.

The user account that you use to connect to OceanBase Database must have the privileges to execute the SET and SELECT statements.
If you do not enable the limited mode, you must specify the --sys-user and --sys-password options for OBDUMPER.

Note
The --sys-user and --sys-password options must be set to the username and password of a user with system table and view query privileges under the SYS tenant.