Connect with Oracle SQL Developer Versions Earlier Than 18.2

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

Note:

To connect Oracle SQL Developer to an Autonomous Transaction Processing dedicated database, the system running Oracle SQL Developer must have network access to the database.

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

To create a new connection to an Autonomous Transaction Processing dedicated 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. For more information, see Download Client Credentials.
  2. Start Oracle SQL Developer and in the connections panel, right-click Connections and select New Connection.
  3. Choose the Connection Type Cloud PDB.
  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 Transaction Processing.

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