Connect to OceanBase Database in Oracle mode by using Navicat

Navicat is a powerful database management tool that supports connecting to various databases, including OceanBase Database in Oracle mode. This topic describes how to connect to OceanBase Database in Oracle mode by using Navicat.

Version compatibility

• Navicat Premium 16.1.9 or later supports OceanBase Enterprise Edition (Oracle mode) V3 or later
• Navicat for Oracle 16.1.9 or later supports OceanBase Enterprise Edition (Oracle mode) V3 or later

Prerequisites

• You have installed Navicat Premium 16.1.9+ or Navicat for Oracle 16.1.9+
• You have obtained the connection information of OceanBase Database, including:
  • The IP address and port of the database server
  • The tenant name
  • The username and password

Download OceanBase JDBC driver

1. Visit OceanBase Download Center, and download OceanBase Connector/J under Drivers and Middleware.

2. After the download is complete, save the JAR file to a local directory, such as: /path/to/oceanbase-client.jar

Configure a Navicat connection

1. Start Navicat and choose File > New Connection > Oracle.

2. On the connection settings page, specify the following parameters:

   Parameter	Description	Example
   Host	The IP address of the OceanBase server.	127.0.0.1
   Port	The port of the database. Default value: 2881.	2881
   Username	The username of the database.	user@tenant
   Password	The password of the database.	********

3. Switch to the Advanced tab:

   • In the OCI Library section, select Use OCI.
   • In the OCI Library Path field, select the oci.dll file in Windows or the libclntsh.dylib file in macOS.

4. Switch to the Driver tab:

   • Select Use Custom JDBC Driver.
   • Click Add and select the downloaded OceanBase JDBC driver JAR file.
   • Enter com.alipay.oceanbase.jdbc.Driver in Class Name.
   • Enter jdbc:oceanbase://{host}:{port}/{database} in URL Template.

5. Click Test Connection to verify the connection.

Manage OceanBase Database with Navicat

After the connection is established, you can perform the following operations in the graphical user interface of Navicat:

• Browse database objects such as tables, views, and stored procedures
• Execute SQL queries
• Import and export data
• Manage database users and privileges
• Monitor database performance