OceanBase Developer Center

V4.3.1

Overview
- What is ODC?
- Features
- Architecture
- Limitations
- ODC console
Quick Start
- Client ODC
  - Overview
  - Install Client ODC
  - Use Client ODC
- Web ODC
  - Overview
  - Deploy Web ODC
  - Use Web ODC
Data Source Management
- Create a data source
- Data sources and project collaboration
- Database O&M
  - Session management
  - Global variable management
  - Recycle bin management
SQL Development
- SQL editing and execution
- Perform PL compilation and debugging
- Use the command-line window
- Edit and export the result set of an SQL statement
- Execution analysis
- Generate test data
- Database objects
  - Table objects
    - Overview
    - Create a table
    - Manage tables
  - 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
    - Overview
    - Create a trigger
    - Manage triggers
  - Type objects
    - Overview
    - Create a type
    - Manage types
  - Synonym objects
    - Overview
    - Create a synonym
    - Manage synonyms
Import and Export
- Import schemas and data
- Export schemas and data
Database Change Management
- User Permission Management
  - Users and roles
  - Automatic authorization
- Project collaboration management
- Risk levels, risk identification rules, and approval processes
- SQL check specifications
- SQL window specification
- Database change management
- Logical database change management
- Batch database change management
- Lock-free schema changes
- Synchronize shadow tables
- Schema comparison
Data Lifecycle Management
- Archive data
- Clean up data
- Partitioning Plan Management
  - Manage partitioning plans
  - Set partitioning strategies
  - Examples
- SQL plan task
Data Desensitization and Auditing
- Desensitize data
- Operation records
Notification Management
- Overview
- View notification records
- Manage Notification Channel
  - Create a notification channel
  - View, edit, and delete a notification channel
  - Configure a custom channel
- Manage notification rules
System Integration
- Login integration
- Approval integration
- SQL approval integration
Deployment Guide
- Deployment overview
- Preparations before deployment
- Load and run an ODC image
- Deploy ODC in high-availability mode
- Deployment verification
Upgrade Guide
- Upgrade Overview
- Preparations before upgrade
- Update single-node ODC
- Update high-avaliability ODC
- Upgrade verification
- Rollback after upgrade failed
Troubleshooting
- ODC troubleshooting process
- Collect Message
  - View the runtime environment and version information
  - View web ODC logs
  - View client ODC logs
  - View end-to-end ODC-related logs
  - View ODC MetaDB data
  - Query the index status in OceanBase Database V4.x
  - Query the index status in OceanBase Database V1.4.x to V3.2.x
  - Collect JVM runtime information
  - Use tcpdump to capture packets
- Common Troubleshooting
  - Deployment Upgrade
    - Web ODC cannot be accessed after startup
  - 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
  - SQL Execution
    - Disconnection during SQL execution
    - `Over tenant memory limits` is reported during SQL execution
    - `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
    - Garbled Chinese characters in the SQL execution result set
    - Garbled Chinese data is returned for query of data in GBK encoding
  - 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
  - Import and Export
    - Garbled Chinese characters in an imported file in GBK encoding
    - Invalid ZIP package reported during file import
    - Time-type data exported from an Oracle tenant cannot be imported
    - Mismatched columns reported during the import of a single-table CSV file
    - Failed to export a result set in ODC to an Excel file
    - Incorrect display in Excel for a result set exported in CSV format
    - Incomplete data in batch export of multiple tables
    - `javax.crypto.BadPaddingException: Given final block not properly padded` is returned for a data import or export failure
  - 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
  - Front Page Exception
    - JavaScript exception is thrown on the ODC page
    - No response in browser after opening ODC
    - White screen in ODC
  - 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
  - FAQ
  - Command-line window
  - DDL statement display
Release Note
- V4.3
  - ODC V4.3.2
  - ODC V4.3.1
  - ODC V4.3.0
- V4.2
  - ODC V4.2.4
  - ODC V4.2.3
  - ODC V4.2.2
  - ODC V4.2.1
  - ODC V4.2.0
- V4.1
  - ODC V4.1.3
  - ODC V4.1.2
  - ODC V4.1.1
  - ODC V4.1.0
- V4.0
  - ODC V4.0.2
  - ODC V4.0.0
- V3.4
  - ODC V3.4.0
- V3.3
  - ODC V3.3.3
  - ODC V3.3.2
  - ODC V3.3.1
  - ODC V3.3.0
- V3.2
  - ODC V3.2.3
  - ODC V3.2.2
  - ODC V3.2.1
  - ODC V3.2.0

Download PDF

OceanBase, A Highly Scalable Database for Transactional, Analytical, and AI Workloads.

Company

About OceanBase Contact Us Partner

Product

OceanBase Cloud OceanBase Enterprise Quick Start Download Pricing

Resources

Docs Blog White Paper Trust Center

Document Feedback

`Not a valid secret key` is returned for connection creation in client ODC

Last Updated：2025-01-14 06:25:33 Updated

Symptom

A parameter error is returned for connection creation, deletion, or modification in client ODC.

The following error message is returned:

Not a valid secret key

Possible causes

ODC V2.4.1 and later versions have introduced password encryption algorithms for secure password storage. Earlier versions of Java implement export restrictions on high-strength encryption algorithms, such as AES256, and report the following error for AES256:

java.security.InvalidKeyException:  Illegal  key  size  or  default  parameters

Affected versions

Client ODC versions without JRE in the installation package

Solutions

Solution 1: Upgrade ODC

Installation packages of client ODC V3.2.0 and later versions contain the JRE installation package (including JRE for macOS and for Windows 64-bit). We recommend that you upgrade client ODC to V3.2.0 or later.

Solution 2: Upgrade Java

Upgrade Java to 1.8.0_200 or later.

Previous topic

Client ODC startup failure or no response

Last

Next topic

`User does not exist` returned for connection creation in client ODC