How to Connect Oracle Cloud Autonomous Database to DBeaver and SQL Developer: Complete Step-by-Step Guide 2025

Introduction

Oracle Cloud Autonomous Database offers powerful, self-managing database capabilities in the cloud. However, connecting to it from popular database client tools like DBeaver and Oracle SQL Developer requires specific configuration steps. This comprehensive guide walks you through the entire process, from initial setup to successful connection.

Prerequisites

Before starting, ensure you have:

• Active Oracle Cloud Infrastructure (OCI) account

• Provisioned Autonomous Database (ATP or ADW)

• Administrative access to your Autonomous Database

• DBeaver or Oracle SQL Developer installed on your local machine

• Basic understanding of database connections

Step 1: Download the Client Credentials (Wallet)

The Oracle Autonomous Database uses a secure wallet file for connections. Here's how to download it:

1.1 Access Your Autonomous Database

1. Log into your Oracle Cloud Console

2. Navigate to Menu → Oracle Database → Autonomous Database

3. Select your target database from the list

4. Click on your database name to open the details page

1.2 Download the Wallet

1. Click the Database Connection button

2. In the popup window, click Download Wallet

3. Create a strong wallet password (save this securely)

4. Click Download to save the wallet ZIP file

5. Extract the ZIP file to a secure location on your computer

Important: The wallet contains sensitive connection information. Store it securely and never share it.

Step 2: Connecting with DBeaver

DBeaver is a popular, free universal database tool that supports Oracle Autonomous Database connections.

2.1 Install Oracle JDBC Driver (if needed)

1. Open DBeaver

2. Go to Database → Driver Manager

3. Look for Oracle in the list

4. If not present, click New and configure Oracle driver

5. Download the latest Oracle JDBC driver (ojdbc8.jar or ojdbc11.jar)

2.2 Create New Connection

1. Click New Database Connection (+ icon)

2. Select Oracle from the database list

3. Click Next

2.3 Configure Connection Settings

1. Connection Type: Select Custom

2. JDBC URL: Use one of these formats:

   jdbc:oracle:thin:@your_service_name_high?TNS_ADMIN=/path/to/wallet

   or

   jdbc:oracle:thin:@(description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=your_host))(connect_data=(service_name=your_service_name))(security=(ssl_server_cert_dn="CN=adwc.eucom-central-1.oraclecloud.com, OU=Oracle BMCS FRANKFURT, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))

3. Username: Use your database username (typically ADMIN)

4. Password: Enter your database password

2.4 Configure SSL and Wallet

1. Go to Driver Properties tab

2. Add these properties:

   • oracle.net.ssl_server_dn_match: true

   • oracle.net.ssl_version: 1.2

   • javax.net.ssl.trustStore: /path/to/wallet/truststore.jks

   • javax.net.ssl.trustStorePassword: your_wallet_password

   • javax.net.ssl.keyStore: /path/to/wallet/keystore.jks

   • javax.net.ssl.keyStorePassword: your_wallet_password

2.5 Test and Save Connection

1. Click Test Connection to verify setup

2. If successful, click Finish to save the connection

3. Your Autonomous Database will appear in the Database Navigator

Step 3: Connecting with Oracle SQL Developer

Oracle SQL Developer is Oracle's official database development tool with native support for Autonomous Database.

3.1 Create New Connection

1. Open Oracle SQL Developer

2. In the Connections panel, right-click and select New Connection

3. The New/Select Database Connection dialog opens

3.2 Configure Connection Details

1. Connection Name: Enter a descriptive name

2. Username: Your database username (typically ADMIN)

3. Password: Your database password

4. Connection Type: Select Cloud Wallet

5. Configuration File: Browse and select your wallet ZIP file

6. Service: Choose from dropdown (HIGH, MEDIUM, LOW, or custom services)

3.3 Advanced Configuration (Optional)

1. Click Show Details for additional options

2. Configure connection pooling if needed

3. Set Retrieval Options for better performance

3.4 Test and Save

1. Click Test to verify the connection

2. Look for "Success" message in the status area

3. Click Save to store the connection

4. Click Connect to establish the connection

Step 4: Understanding Service Names

Autonomous Database provides different service names for various workload types:

• HIGH: Maximum resources, for analytics and batch operations

• MEDIUM: Balanced resources, for mixed workloads

• LOW: Limited resources, for development and testing

• TP/TPURGENT: For transaction processing workloads

• DW: For data warehouse workloads

Choose the appropriate service based on your use case.

Step 5: Troubleshooting Common Issues

Connection Timeout Errors

• Verify your network allows outbound connections on port 1522

• Check if corporate firewall blocks Oracle Cloud connections

• Ensure wallet files are in the correct location

Authentication Failures

• Confirm username and password are correct

• Verify wallet password matches what you set during download

• Check if database user account is locked or expired

SSL Certificate Issues

• Download a fresh wallet if certificates are expired

• Ensure system date/time is correct

• Verify SSL properties are correctly configured

Performance Issues

• Use appropriate service name for your workload

• Configure connection pooling in SQL Developer

• Consider network latency between client and Oracle Cloud region

Step 6: Best Practices for Secure Connections

Security Recommendations

1. Rotate Wallets Regularly: Download new wallets periodically

2. Limit Network Access: Use VCN and security lists to restrict access

3. Strong Passwords: Use complex passwords for database accounts

4. Monitor Connections: Review database audit logs regularly

Performance Optimization

1. Choose Right Service: Select appropriate service name for workload

2. Connection Pooling: Enable for applications with multiple users

3. Regional Proximity: Deploy clients close to database region

4. Batch Operations: Use HIGH service for large data operations

Conclusion

Connecting Oracle Cloud Autonomous Database to client tools like DBeaver and SQL Developer requires proper wallet configuration and understanding of connection parameters. By following this step-by-step guide, you can establish secure, reliable connections to leverage the full power of Oracle's autonomous database technology.

The key to success is ensuring proper wallet management, choosing appropriate service names, and following security best practices. With these connections established, you can efficiently develop, manage, and analyze your data using familiar database tools.

Additional Resources

• Oracle Cloud Infrastructure Documentation

• DBeaver Oracle Connection Guide

• Oracle SQL Developer Downloads

• Oracle JDBC Drivers Download