Setup a SQL*Developer connection to an Autonomous Database

In this article I will show you how easy it is to connect to an Autonomous Transaction Processing Database using SQL*Developer

Note that for this I downloaded the latest version of SQL*Developer (18.3) from Oracle Technology Network.

While connected to the Oracle Cloud Infrastructure console, from the navigation menu select Autonomous Transaction Processing

From the overview page select the database you want to connect

 

Press [DB Connection]

Create the network/admin directory on your desktop to contain the tnsnames.ora and sqlnet.ora files

Copy the downloaded Wallet zip file to this directory (i.e. Wallet_DBATPD01)

Leave the zipfile, don’t extract it

Copy the contents of the tnsnames.ora file within the wallet zip file to the tnsnames.ora file in directory network/admin

Make sure the sqlnet.ora file includes the following entries:

WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="<Your Oracle Client Directory>/network/admin")))
SSL_SERVER_DN_MATCH=yes
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Open SQL*Developer in your desktop

From the Oracle SQL Developer menu select preferences

Navigate Database > Advanced

Enter the location of the network/admin directory for Tnsnames Directory

From Oracle Connections choose Create new connection

Enter the following entries:

 

Press [Test] to test the new connection and when successful press [Save]

From the SQL Developer Connections pane select the ‘+’ in front of the database connection you just created (DBATPD01 in this example)

You can now start examining the database structure / contents…

Disclaimer
Please notice that all statements made by me and information provided on this blog are mine and not necessarily those of Oracle Corporation.

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