Configure Your VM

This section outlines how to prepare the VM with the tools needed to connect to your RDS database. It includes steps to install Java 11 (required for SQLcl), download and set up SQLcl, and configure your environment for easy execution.

1. Install Java 11 Open JDK (needed for SQLcl)

   sudo dnf install java-11-openjdk

2. Install sqlcl

   # In HOME directory create a tools directory
   mkdir tools
   # Set current working directory to ~/tools
   cd tools
   # Download and unzip SQLcl
   curl -O https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-latest.zip
   unzip sqlcl-latest.zip
   # Return to HOME directory
   cd
   # For persistence, append the export line to .bashrc  
   echo 'export PATH=$PATH:$HOME/tools/sqlcl/bin' >> ~/.bashrc
   # Update Linux environment
   source ~/.bashrc