Connect local SQL Developer to Oracle Cloud Autonomous Database (Always Free Tier)

In a recent article I described how to provision an instance of Oracle Cloud Autonomous Data Warehouse in the recently launched Always Free Tier of OCI. This article shows how to connect from SQL Developer (desktop tool) to this instance. Note: connecting from SQL Developer is the same [of course] whether the database instance is in the free tier, part of a cloud trial or a regular paid for instance.
If you do not already have a 19.x version of SQL Developer, I suggest you first install that. You can download latest (19.2) version of SQL Developer for free from this location: https://www.oracle.com/tools/downloads/sqldev-v192-downloads.html (you need an Oracle account and you must accept the OTN license agreement)
Install SQL Developer 19.2 – by unzipping to a directory of your choice. Run SQL Developer by running the sqldeveloper.exe file.
image
In your Oracle Cloud Infrastructure dashboard, navigate to your ADW (or ATP) instance. From the DB Connections popup on the ADW Dashboard in OCI, click on Download for the Client Credentials (Wallet) – a zip file:
image
Provide the password for the Admin user:
image
The zip file with client credentials is download.
imageIn SQL Developer, create a new Connection (note: do not create a connection of type Cloud Connection – that type refers to the Schema as an Instance service, not to ATP or Adw):
image
Complete the connection wizard:
SNAGHTML3868b653
  • Provide a name for the connection – you can use spaces and other characters.
  • Set Database Type to Oracle.
  • Provide Username and Password – for example for the admin account that was created when the ATP or ADW instance was provisioned.
  • Select default for role – not SYSDBA or something similar
  • Select Cloud Wallet for connection type (note: this option was not available in SQL Developer 18.2 – the version that I tried to use in my first attempt)
  • In the field Configuration File browse for the zip file with client credentials that was downloaded from the ADW DB Connection popup page.
  • Select one of the options for Service – at this stage it does not matter much which one you select.
Click on button Test to verify your settings. When the result is Success you have succeeded and may proceed.
In the Connections tab, open the newly created connection.
image
You get your first glimpse into the ADW or ATP instance (running in the cloud) from the client side desktop comfort of your own laptop.
You can now make use of all facilities in SQL Developer to import and export data, model database objects, manage objects such as users, jobs, privileges and PL/SQL program units. The location of the database is not really relevant.

Comments

Post a Comment

Popular posts from this blog

Flutter for Single-Page Scrollable Websites with Navigator 2.0

Image
  Single page scrollable websites are everywhere. In this website design pattern, all the content is presented in one long-scrolling layout that contains multiple sections. Visitors can scroll or jump to a section by clicking buttons of a sticky menu. This pattern is a good fit for small content such as brochure websites, software library documentation, portfolios, and landing pages that are used to convert users [ 1 ]. Designers also love this pattern because it is simple, clean, and enables cool scroll animations. Jetbrains Mono single-page scrollable website Hive docs multi-page scrollable website In this series of articles, we will explore how to build a  single-page scrollable website  using Flutter. We will benefit from the Navigator 2.0 API to provide a good navigation experience to the users. You can find the source code of this series’ sample apps on my  Github page . The implementation details of the sample apps will be explained in the following articles: ...
Read more

A Data Science Portfolio is More Valuable than a Resume

Image
A Data Science Portfolio is More Valuable than a Resume Benjamin Obi Tayo Ph.D. Following Nov 20  · 5 min read D ata Science is a practical field. Hands-on skills are very important especially when you are interested in working outside academia as a practicing data scientist. In academia, you need more theoretical and research skills. While in-depth knowledge in the theoretical foundations of data science is important, as a practicing data scientist, hands-on experience is very crucial and one way to showcase you hands-on skills is via building a very great portfolio. Companies interested in hiring you would definitely be asking you for a portfolio, as it gives evidence of your strengths in fundamental data science concepts. While a data science resume is important, a data science portfolio is more valuable than a resume. This article will discuss 3 important platforms that can be used for portfolio buildi...
Read more

Better File Storage in Oracle Cloud

Image
Use Oracle Application Express with Oracle Cloud Infrastructure REST APIs to upload, download, and manage big files in Oracle Cloud. By Adrian Png November 27, 2019 Oracle Cloud Infrastructure  provides a comprehensive suite of REST APIs for accessing and managing cloud resources. For example, administrators can use REST APIs to create and manage autonomous databases and initiate backups. Oracle Application Express (Oracle APEX)  makes working with REST easy. The  APEX_WEB_SERVICE  package, available since Oracle APEX 4.0, provides developers with a function for consuming REST APIs. Oracle APEX 5.0 introduced the  APEX_JSON  package, allowing easy parsing of JSON responses. Oracle APEX 18.1 introduced the Web Source Module (WSM), which enables developers to access REST services and use the data in APEX components such as reports, interactive reports, and interactive grids. These features, when used together with Oracle Cloud Infrastructure REST ...
Read more