Configure WinSCP to Use SFTP with Oracle Compute Instance

WinSCP is a popular useful windows utility which is easy to use as long as users have access to a SSH server with SFTP/SCP support. 

WinSCP lets users to move files on their remote server, change permissions, create new directories or delete them. They can also edit a file directly from WinSCP by using its internal text editor. Also an external text editor can be integrated with WinSCP.

This blog post shows on how to configure WinSCP to use with Oracle Compute Instance using the Private key.

Configure Putty to SSH Into Oracle Compute Instance

In Cloud Computing environments there are many reasons why users need to access the VM environment to perform certain tasks.  Due to security concerns, Cloud vendors generally accept incoming access requests using Secure Shell (SSH) connections.

This blog post shows detailed information on how to configure Putty to access a Linux based Oracle Cloud Compute Instance using SSH.

Configure Oracle SQL Developer to Connect to Database Cloud Service Using SSH

In the previous blog post, I have shown on how to create a new Oracle Database Cloud Service (DBCS) using Oracle Cloud Infrastructure Classic environment.

In this blog post, I will show on how to configure Oracle SQL Developer tool to get connected to the DBCS service in the cloud.

By default the DBCS listener port (default value is 1521) is not exposed to the outside world so tools like SQL Developer cannot be used to get connected to the Database Cloud Service.

So how do we get connected to the Database to perform the usual basic activities such as creating tables etc?