OceanBase

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

Product Overview

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 Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase 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

OceanBase Developer Center

V4.2.1

Overview
- What is ODC?
- Limitations
- User interface
- Features
- Architecture
Quick Start
- Web ODC
  - Use Web ODC
  - Overview
  - Deploy Web ODC
- Client ODC
  - Overview
  - Install Client ODC
  - Use Client ODC
Data Source Management
- Create a data source
- Data sources and project collaboration
- Database O&M
  - Recycle bin management
  - Session management
  - Global variable management
SQL Development
- Edit and execute SQL statements
- Compile and debug PL objects
- Command-line window
- Edit and export results
- Analyze SQL statements
- Data mocking
- Database objects
  - Table objects
    - Manage table attributes
    - Manage table data
    - Overview
    - Create a table
    - Table list
  - View objects
    - Overview
    - Create a view
    - Manage views
  - Function objects
    - Overview
    - Create a function
    - Manage functions
  - Stored procedure objects
    - Overview
    - Create a stored procedure
    - Manage stored procedures
  - Sequence objects
    - Overview
    - Create a sequence
    - Manage sequences
  - Package objects
    - Overview
    - Create a program package
    - Manage program packages
  - Trigger objects
    - Create a trigger
    - Overview
    - Manage triggers
  - Type objects
    - Create a type
    - Overview
    - Manage types
  - Synonym objects
    - Overview
    - Create a synonym
    - Manage synonyms
Import and Export
- Export schema and data
- Import schema and data
Database Change Management
- Change lock-free structures
- SQL check specifications
- Manage database changes
- Risk levels, risk identification rules, and approval processes
- SQL window specification
- Synchronize shadow tables
- Collaborative project management
- User Permission Management
  - Automatic authorization
  - Users and roles
Data Lifecycle Management
- SQL plan task
- Archive data
- Manage partitions
- Clean up data
Data Desensitization and Auditing
- Data desensitization
- Operation audit
System Integration
- Approval integration
- SSO integration
- SQL approval integration
Deployment Guide
- Deployment overview
- Preparations before deployment
- Deploy ODC in single-node mode
- Load and run an ODC image
- Deployment verification
Upgrade Guide
- Upgrade Overview
- Preparations before upgrade
- Upgrade single-node ODC
- Update high-avaliability ODC
- Upgrade verification
- Rollback after upgrade failed
Troubleshooting
- ODC troubleshooting process
- Collect Message
  - Query the index status in OceanBase Database V1.4.x to V3.2.x
  - View client ODC logs
  - Query the index status in OceanBase Database V4.x
  - Use tcpdump to capture packets
  - View the runtime environment and version information
  - Collect JVM runtime information
  - View ODC MetaDB data
  - View end-to-end ODC-related logs
  - View web ODC logs
- Common Troubleshooting
  - Front-end Page Exception
    - JavaScript exception is thrown on the ODC page
    - No response in browser after opening ODC
    - White screen in ODC
  - SQL Execution
    - Garbled Chinese characters in the SQL execution result set
    - `Unknown thread id` is returned during SQL execution
    - `timeout` errors returned during SQL execution
    - `OutOfMemoryError` is returned during SQL execution
    - Incomplete result columns for the SELECT statement
    - `Over tenant memory limits` is reported during SQL execution
    - Garbled Chinese data is returned for query of data in GBK encoding
    - Disconnection during SQL execution
  - PL Object
    - Debugging is not supported for invalid PL objects
    - `JSONException` is reported during PL debugging
    - Garbled variable values in debugging
    - Failed to view PL objects or garbled characters are returned
    - PL objects cannot be executed or an execution error is returned
    - ODC issues during PL debugging
    - PL anonymous block cannot be debugged
    - Alert information of a PL object is unavailable
  - Client ODC Problems
    - Client ODC startup failure / H2 Database corruption: Chuck not found
    - Garbled Chinese characters in the command-line window of ODC
    - Failed to install client ODC
    - Client ODC startup failure or no response
    - `Not a valid secret key` is returned for connection creation in client ODC
    - `User does not exist` returned for connection creation in client ODC
    - High memory usage of client ODC
    - Client ODC fails to be installed or start due to a port conflict
  - Database Connection
    - Access denied in a connection trial or test
    - Connection is refused in a connection trial or test
    - Connection times out
    - `Connection reset` is reported for a time-consuming statement
    - `socket write error` or `closed by server` is reported for a connection
  - Import and Export
    - `javax.crypto.BadPaddingException: Given final block not properly padded` is returned for a data import or export failure
    - Time-type data exported from an Oracle tenant cannot be imported
    - Invalid ZIP package reported during file import
    - Mismatched columns reported during the import of a single-table CSV file
    - Incomplete data in batch export of multiple tables
    - Failed to export a result set in ODC to an Excel file
    - Incorrect display in Excel for a result set exported in CSV format
    - Garbled Chinese characters in an imported file in GBK encoding
  - Deployment Upgrade
    - Web ODC cannot be accessed after startup
  - Account Password Problem
    - Forgot the admin account password in ODC V3.2.0 or later
    - Forgot an account password in ODC V2.4.1 to V3.1.3
    - Forgot an account password in ODC V2.4.0 or earlier
- FAQ
  - Installation of client ODC
  - Web ODC deployment and startup
  - Connection information
  - Command-line window
  - DDL statement display
Release Note
- 90.odc-rn-4.2
  - ODC V4.2.1
  - ODC V4.2.0
- V4.1
  - ODC V4.1.1
  - ODC V4.1.0
  - ODC V4.1.2
- V4.0
  - ODC V4.0.0
  - ODC V4.0.2
- V3.4
  - ODC V3.4.0
- V3.3
  - ODC V3.3.1
  - ODC V3.3.3
  - ODC V3.3.0
  - ODC V3.3.2
- V3.2
  - ODC V3.2.3
  - ODC V3.2.2
  - ODC V3.2.0
  - ODC V3.2.1

Download PDF

Document Feedback

Client ODC fails to be installed or start due to a port conflict

Last Updated：2026-04-13 07:40:37 Updated

Symptom

Client ODC fails to be installed or start due to a port conflict.

Possible causes

Check the process that occupies port 8989, kill the process, and then reinstall or restart client ODC. Dynamic ports are used in ODC V2.3.0 and later versions to avoid this problem.

Solutions

In the macOS, run the following command to check the use status of port 8989:
```
lsof -i tcp:8989
```
In the Windows OS, run the following statement to check the use status of port 8989:
```
netstat -ano|findstr 8989
```

ODC V3.2.0 allows you to set custom ports.

On macOS, set environment variables and run the corresponding command to enable the port:
On Windows, set the ODC_MAPPING_PORT parameter to enable the specified port.

Previous topic

High memory usage of client ODC

Last

Next topic

JavaScript exception is thrown on the ODC page