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
oracle@oracle:~$ 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
oracle@oracle:~$ 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 oracle@oracle:~$ cat /etc/environment JAVA_HOME="/usr/lib/jvm/java-8-oracle" PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" oracle@oracle:~$ source /etc/environment oracle@oracle:~$ 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
oracle@oracle:~/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