How to Connect Oracle to DBeaver

How do I connect Oracle Database to DBeaver?

Connect Oracle to DBeaver by installing the Oracle JDBC driver, creating a new connection, and testing the link for error-free SQL work.

Welcome to the Galaxy, Guardian!

Oops! Something went wrong while submitting the form.

Description

Why connect Oracle to DBeaver?

Connecting Oracle to DBeaver lets developers leverage a modern, cross-platform SQL IDE with autocomplete, ER diagrams, data export, and AI assistance while working against Oracle schemas.

What are the prerequisites?

Install DBeaver 24.x+, ensure Java 11+, obtain the Oracle JDBC driver, and have a user with CREATE SESSION privileges plus network access to the Oracle listener port (1521).

How do you load the Oracle JDBC driver?

Open DBeaver → Database → Driver Manager → Oracle → Edit → Download/Find. Let DBeaver fetch "ojdbc11.jar". If the internet is blocked, click “Add File” and select the JAR you downloaded from Oracle.

How do you create a new Oracle connection?

Click the plug-plus icon → Oracle. Fill “Host”, “Port”, “Service/SID”, “User”, and “Password”. Toggle “Save password” if permitted. Use the “Driver properties” tab for options such as sslServerDNMatch=true.

How do you test and save the connection?

Press “Test Connection”. DBeaver loads the driver and pings Oracle. A green check means success. Click “Finish” to save; the connection appears in Database Navigator.

What SQL syntax explores data?

Standard Oracle SQL works. In the SQL Editor, write queries and press Ctrl-Enter (Cmd-Enter on macOS) to run. Results appear in the Data tab where you can filter, sort, and export.

How do you query ecommerce tables?

Review monthly revenue with a join on Customers, Orders, OrderItems, and Products.

SELECT c.name, o.order_date, p.name AS product, oi.quantity, p.price, oi.quantity * p.price AS line_total FROM Customers c JOIN Orders o ON o.customer_id = c.id JOIN OrderItems oi ON oi.order_id = o.id JOIN Products p ON p.id = oi.product_id WHERE o.order_date > SYSDATE - 30 ORDER BY o.order_date DESC;

Best practices for stable connections

Prefer the “Service” connection type for CDB/PDB setups. Enable “Keep-alive” under Connection Settings to avoid idle disconnects. Store credentials in DBeaver’s secure storage instead of plain files.

Common mistakes and quick fixes

ORA-12514 means a wrong service name—verify with SELECT sys_context('USERENV','SERVICE_NAME') FROM dual;. “I/O Error: The Network Adapter could not establish the connection” signals a missing or mismatched driver—re-download the correct ojdbc JAR.

Why How to Connect Oracle to DBeaver is important

How to Connect Oracle to DBeaver Example Usage


-- Monthly revenue by product in DBeaver
SELECT p.name AS product,
       SUM(oi.quantity * p.price) AS revenue
FROM   OrderItems oi
JOIN   Products   p ON p.id = oi.product_id
JOIN   Orders     o ON o.id = oi.order_id
WHERE  o.order_date >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -1)
GROUP  BY p.name
ORDER  BY revenue DESC;

How to Connect Oracle to DBeaver Syntax


jdbc:oracle:thin:@//host:port/service_name
jdbc:oracle:thin:@host:port:sid
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=port))(CONNECT_DATA=(SERVICE_NAME=svc)))

/* Example using service name */
CONNECT username/password@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db-prod)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCLPDB1)))";

/* SQL example in DBeaver for ecommerce */
SELECT o.id, c.email, o.total_amount
FROM   Orders o
JOIN   Customers c ON c.id = o.customer_id
WHERE  o.order_date BETWEEN DATE '2024-09-01' AND DATE '2024-09-30';

Common Mistakes

Using the SID field for a PDB connection: Oracle 19c and newer default to services, not SIDs. Fix by selecting "Service" and entering the correct PDB service name.
Forgetting to add the Oracle JDBC driver: DBeaver shows “No suitable driver” and cannot test the connection. Open Driver Manager → Oracle → Download to install the driver before retrying.