Seven-Step Guide to Diagnose OceanBase Cluster Login "Access Denied" Errors

This article presents a systematic seven‑step troubleshooting procedure for the common "Access denied" login error when connecting to an OceanBase cluster, covering password verification, network connectivity, user privileges, client compatibility, tenant parameters, obproxy logs, and configuration checks.

AccessDeniedDatabaseTroubleshootingLoginError

0 likes · 6 min read

Seven-Step Guide to Diagnose OceanBase Cluster Login "Access Denied" Errors

Xiaolei Talks DB

Nov 22, 2024 · Databases

Master OceanBase and OBproxy Upgrades on Kubernetes and Bare Metal

This guide details the upgrade procedures, prerequisites, and impact considerations for OceanBase, OBproxy, OCP, and OB‑DashBoard across Kubernetes and bare‑metal environments, providing step‑by‑step commands, dashboard actions, and DBA precautions to ensure a smooth transition.

KubernetesOBproxyOceanBase

0 likes · 10 min read

Master OceanBase and OBproxy Upgrades on Kubernetes and Bare Metal

Aikesheng Open Source Community

Sep 5, 2024 · Databases

Analyzing and Resolving OceanBase Connection Timeout via OBProxy Logs and Packet Capture

This article walks through a production‑level OceanBase connection‑timeout incident, detailing how to examine OBProxy logs, capture and analyze network packets with tcpdump and Wireshark, identify a blocked random port, and apply kernel‑parameter fixes to prevent the issue.

LinuxOBproxyOceanBase

0 likes · 10 min read

Analyzing and Resolving OceanBase Connection Timeout via OBProxy Logs and Packet Capture

Aikesheng Open Source Community

Aug 30, 2023 · Information Security

Configuring Transport Encryption for OceanBase (OBServer and ODP)

This guide explains how to prepare the environment, enable SSL transport encryption for OceanBase OBServer and ODP via OBProxy, configure certificates and whitelist settings, and verify the encryption using MySQL and RPC ports, while highlighting common pitfalls and reference links.

Database SecurityOBproxyObserver

0 likes · 7 min read

Configuring Transport Encryption for OceanBase (OBServer and ODP)

Aikesheng Open Source Community

May 25, 2023 · Databases

Analyzing Slow Queries in OceanBase: Log‑Based Diagnosis and Performance Optimization

This article consolidates practical experience and author insights to guide OceanBase engineers in quickly diagnosing and resolving slow‑SQL performance issues by leveraging ODP and OBServer logs, key metrics, and systematic analysis steps.

Database LogsOBproxyOceanBase

0 likes · 15 min read

Analyzing Slow Queries in OceanBase: Log‑Based Diagnosis and Performance Optimization

AntTech

Oct 12, 2019 · Databases

Technical Analysis of OceanBase TPC-C Benchmark and Link‑Layer Optimizations

This article details OceanBase’s achievement in the TPC‑C benchmark, explaining the test architecture, the role of ODBC and OBProxy, and the various link‑layer performance, resource, and durability optimizations that enable high throughput and continuous service in a distributed database environment.

Database BenchmarkOBproxyODBC

0 likes · 10 min read

Technical Analysis of OceanBase TPC-C Benchmark and Link‑Layer Optimizations