If you have created a free database in the new Always Free Oracle Cloud Tier, you can use the provided web version of SQL Developer to gain access to your schemas for development.
However, it is also possible to use the tools you have installed on your local machine, such as SQL Developer, PL/SQL Developer, TOAD, etc. This is done using a wallet.
Firstly, you need to download the client credentials wallet from the Administration menu in the service console of your ATP database in the Cloud.
Enter your admin password and click the download button to save a copy of the wallet to your local machine.
One of the simplest tools to use with a wallet is SQL Developer, as you can create a new connection that links directly to your wallet.
To create a new connection follow these simple steps.
You should now be able to use SQL Developer on your local machine to access your ATP database in the Cloud.
For applications that use the Oracle Instant Client and TNSNAMES file such as PL/SQL Developer and TOAD etc. you need to extract the files from your zipped wallet and follow these simple steps.
You should now be able to use tools such as PL/SQL Developer on your local machine to access your ATP database in the Cloud.
The following screenshot shows my local installation of PL/SQL Developer accessing an APEX Workspace schema on my ATP Cloud Database with a copy of the Sample Database Application installed.
Author: Colin Archer
Job Title: Senior Oracle APEX Development Consultant
Bio: Colin is a Senior Development Consultant at DSP-Explorer with 20 years’ experience of analysis, design, and development of bespoke Oracle applications for a wide variety of business functions. Building on his previous experience of Forms and PL/SQL he is now focusing on developing high quality fit for purpose solutions using APEX.