1. Using Oracle Autonomous Database on Shared Exadata Infrastructure
  2. Using Autonomous Database
  3. Connecting to Autonomous Database
  4. Connect to Autonomous Database Using Oracle Database Tools
  5. Connect with Oracle SQL Developer (18.2 or later)

Connect with Oracle SQL Developer (18.2 or later)

Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and cloud deployments.

SQL Developer can connect to Autonomous Database using an Oracle Wallet and contains enhancements for key Autonomous Database features. Oracle SQL Developer provides support for wallet files using the Cloud Wallet Connection Type (SQL Developer 18.2 shows this as Cloud PDB). Oracle recommends that you use version 18.2 (or later); however, earlier versions of SQL Developer will work with Autonomous Database.

Download the latest version of Oracle SQL Developer for your platform from the Download link on this page: Oracle SQL Developer.

To create a new 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....
  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. For more information, see Connect with Oracle SQL Developer (earlier than Version 18.2).
  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.