01 Preparing Client Machine


we would need SQL Developer to connect to Autonomous Data warehouse , you can use other Clients as well , in this section we will prepare our ubuntu machine to have latest JDK and latest Sql developer running

Latest JDK version
[email protected]:~$ lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 18.04.1 LTS
Release:	18.04
Codename:	bionic
// Install Latest version of Java 8
[email protected]:~$ sudo add-apt-repository ppa:webupd8team/java
[sudo] password for oracle: 
 Oracle Java (JDK) Installer (automatically downloads and installs Oracle JDK8). 
There are no actual Java files in this PPA.
sudo apt-get update
sudo apt-get install oracle-java8-installer
// Set the JAVA_HOME
[email protected]:~$ cat /etc/environment
[email protected]:~$ source /etc/environment
[email protected]:~$ java -version
java version "1.8.0_191"
Java(TM) SE Runtime Environment (build 1.8.0_191-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.191-b12, mixed mode)
Download and run the SQL Developer

Edit the sqldeveloper.conf and add the following line, so that it picks latest JDK that we just installed.

#SetJavaHome ../../jdk
SetJavaHome /usr/lib/jvm/java-8-oracle
[email protected]:~/sqldeveloper$ ./sqldeveloper.sh 

Oracle SQL Developer

Start the SQL Developer , click on Add DB Connection, You should be able to see Cloud Wallet as connection type and an option to Browse for configuration file as shown below

What Next >> Creating Instance of Oracle Autonomous Data Warehouse