Connecting to an Oracle Autonomous Database Using SQL Developer

Hello,
In this blog post I want to describe how to connect to an Autonomous Database.

Applications and tools connect to Autonomous Databases by using Oracle Net Services (also known as SQL*Net). SQL*Net supports a variety of connection types to Autonomous Databases, including Oracle Call Interface (OCI), ODBC drivers, JDBC OC, and JDBC Thin Driver.

To support connections of any type, you’ll need to download the client security credentials and network configuration settings required to access your database. You’ll also need to supply the applicable TNS names or connection strings for a connection, depending on the client application or tool, type of connection, and service level. You can view or copy the TNS names and connection strings in the DB Connection dialog for your Autonomous Database.

Firstly let me download a wallet for an Autonomous Database on shared Exadata infrastructure.

1- Open the navigation menu. Under Database, click Autonomous Transaction Processing or Autonomous Data Warehouse.
2- Choose your Compartment.
3- In the list of Autonomous Databases, click on the display name of the database you are interested in.
4- Click DB Connection.

5-In the Download Client Credentials (Wallet) section, select the Wallet Type. You can choose to download an instance wallet or a regional wallet .

6- To obtain the client credentials, click Download Wallet. You will be prompted to provide a password to encrypt the keys inside the wallet. The password must be at least 8 characters long and must include at least 1 letter and either 1 numeric character or 1 special character. Save the client credentials zip file to a secure location

7-Take note of or copy the TNS names or connection strings you need for your connection.

8- Now, Open SQL Developer on your local computer. In the Connections panel, right-click Connections and select New Connection.

9- The New/Select Database Connection dialog appears. Enter the following information:

Connection Name – Enter the name for this cloud connection.
Username – Enter the database username .
Password – Enter the password.
Connection Type – Select Cloud Wallet.
Configuration File – Click Browse, and select the path to your local copy of the Client Credentials zip file, downloaded from the Autonomous Transaction Processing console by you, or given to you by your Autonomous Transaction Processing administrator.
Keystore Password –
If using SQL Developer 18.2.0 or newer: Starting with version 18.2.0, SQL Developer does not require that you enter a Keystore Password and does not provide the Keystore Password field.
If using a version of SQL Developer older than 18.2.0: Enter the password that was generated when you or your Autonomous Transaction Processing administrator downloaded the Client Credentials zip file from the Autonomous Transaction Processing console.
Service – In the drop-down menu, service selections are prepended with database names. Select the tpurgent, tp, high, medium, or low menu item for your database. These service levels map to the TPURGENT, TP, HIGH, MEDIUM and LOW consumer groups, which provide different levels of priority for your session.

10- Click Test. Status: Success displays at the bottom left of the New/Select Database Connection dialog.
11- Click Connect. An entry for the new connection appears under Connections.

Now you connected to Autonomous Transaction Processing Database.

2 thoughts on “Connecting to an Oracle Autonomous Database Using SQL Developer

  1. Rahul Solunke

    at the first i was able to connect to datbase using sql developer but now it is giving me ora 12529 error please help

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s