This guide explains how to recover a multi-node OCP cluster after a failed NLB upgrade by diagnosing METADB connection errors, extracting VIP/PORT information, and re-creating NLB load-balancing rules through Docker and nlbcli commands, ensuring the cluster becomes reachable again.
This article walks through three common Oracle OCP exam questions—distinguishing permanent, temporary, and UNDO tablespaces, choosing the correct object versus system privilege syntax, and selecting the safest RMAN command for a hot backup—providing detailed explanations and the correct answers.
In multi‑node OCP deployments, accessing monitoring data via the master node IP/VIP can trigger a 401 "invalid VIP" error, and this guide explains the root cause, how OCP validates source IPs, and provides two reliable methods to correct the source IP configuration.
This article explains the five essential software architecture principles—Single Responsibility, Open‑Closed, Liskov Substitution, Interface Segregation, and Dependency Inversion—detailing their definitions, real‑world e‑commerce examples, and why they are crucial for building maintainable, scalable systems.
This article explains OceanBase's full‑link tracing feature, covering its definition, internal working principle, trace‑log structure, span and tag details, configuration steps, and how to view trace data via the show‑trace command or the OCP visual interface, helping DBAs quickly diagnose performance issues.
This article walks through a real‑world OceanBase OMS migration case where adding an OCP association triggers a “Server Internal Error”, detailing log analysis, metadb schema inspection, OAT deployment checks, the impact of the MySQL “-f” flag, a temporary fix, and the root‑cause conclusion.
This article provides a step‑by‑step guide on how to replace OceanBase Cloud Platform (OCP) nodes using the ANTMAN tool, covering environment preparation, configuration adjustments, execution of management scripts, tenant migration, cleanup of old services, and troubleshooting tips for a seamless database cluster upgrade.
This article explains the six core object‑oriented design principles—Single Responsibility, Open/Closed, Liskov Substitution, Dependency Inversion, Interface Segregation, and Law of Demeter—detailing their definitions, benefits, and Java code examples to illustrate proper application.
This article recounts a DBA’s personal journey preparing for and passing the Oracle OCP 051 certification, detailing study resources, hands‑on experiments, common Oracle errors, exam strategies, and lessons learned for future database learning.
