Connect Oracle SQL Developer with a Wallet (mTLS)

Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Autonomous Database.

SQL Developer can connect to Autonomous Database and contains enhancements for key Autonomous Database features. You can download the latest version of Oracle SQL Developer for your platform from the Download link on this page: Oracle SQL Developer.

For connecting with mTLS authentication, Oracle SQL Developer provides support for wallet files using the Cloud Wallet Connection Type. Oracle recommends that you use version 18.2 (or later); however, earlier versions of SQL Developer will work with Autonomous Database using an Oracle Wallet.

For connecting with TLS authentication, Oracle SQL Developer provides support using the Custom JDBC Connection Type. See Connect with Oracle SQL Developer with TLS Authentication for details on connecting using TLS authentication.

To create a new mTLS connection to Autonomous Database, do the following:

Obtain your credentials to access Autonomous Database. For more information, see Download Client Credentials (Wallets).

1. Start Oracle SQL Developer and in the connections panel, right-click Connections and select New Database Connection....
   
   Description of the illustration adb_sqldev_20.2conn.png
2. Choose the Connection Type Cloud Wallet.
3. Enter the following information:

   • Connection Name: Enter the name for this connection.

   • Username: Enter the database username. You can either use the default administrator database account (ADMIN) provided as part of the service or create a new schema, and use it.

   • Password: Enter the password for the database user.

   • Connection Type: Select Cloud Wallet (if you are using SQL Developer 18.2, this is Cloud PDB)

   • Configuration File : Click Browse, and select the client credentials zip file.

   • Service: Enter the database TNS name. The client credentials file includes a tnsnames.ora file that provides database TNS names with corresponding services.

     Note:

     Versions of SQL Developer before 18.2 require that you enter a Keystore Password.
   
   Description of the illustration adb_connect_sqldev_db20.png
4. Click Connect to connect to the database.

Note:

If you are using Microsoft Active Directory, then for Username enter the Active Directory "AD_domain\AD_username" (you may include double quotes), and for the Password, enter the password for the Active Directory user. See Use Microsoft Active Directory with Autonomous Database for more information.