Connect to Autonomous Database on Dedicated Exadata Infrastructure with Oracle SQL Developer

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

Requirements

To be able to connect SQL Developer to an Autonomous Database, the system running SQL Developer must have network access to the Autonomous Database. This can be achieved using either of the following ways:

Connect with Oracle SQL Developer Version 18.2 or Later

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

  1. Download the zip file containing client credentials for your database to a secure directory on system.
    This zip file is available for download from the database's Details page in the Oracle Cloud console. If you have an Oracle Cloud user account that permits you to access this page, download the credentials as described in Download Client Credentials. Otherwise, you will need to get the zip file from the administrator of the database, together with the password that was used to protect the zip file.
  2. Start Oracle SQL Developer and in the connections panel, right-click Connections and select New Database Connection....

    Description of adb_sqldev_20.2conn.png follows

  3. Choose the Connection Type Cloud Wallet.

    Description of adb_connect_sqldev_db20.png follows

  4. 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 (with the older version, SQL Developer 18.2, this is Cloud PDB)

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

    • Service: Enter the service name. The client credentials file provides the service names.

  5. Click Connect to connect to the database.

Connect with Oracle SQL Developer Versions Earlier Than 18.2

Oracle recommends that you use Oracle SQL Developer version 18.2 or later; however, earlier versions of SQL Developer will work with Autonomous Database.

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

  1. Download the zip file containing client credentials for your database to a secure directory on system.
    This zip file is available for download from the database's Details page in the Oracle Cloud console. If you have an Oracle Cloud user account that permits you to access this page, download the credentials as described in Download Client Credentials. Otherwise, you will need to get the zip file from the administrator of the database, together with the password that was used to protect the zip file.
  2. Start Oracle SQL Developer and in the connections panel, right-click Connections and select New Connection.

    Description of dwcs_sqldev_conn.jpg follows

  3. Choose the Connection Type Cloud PDB.

    Description of atpc_connect_sqldev17.png follows

  4. 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 PDB.

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

    • Keystore Password: Enter the password generated while downloading the client credentials from Autonomous Database.

    • Service: Enter the service name. The client credentials file provides the service names.