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.
What's cooking at Oracle - Rob Zoeteweij 