Home » Oracle » How to Create SSH Tunneling or Port Forwarding in Linux to connect with Oracle database on Cloud

How to Create SSH Tunneling or Port Forwarding in Linux to connect with Oracle database on Cloud

How to Login to Oracle Cloud Database on port 1521 using SSH tunnel with Linux client

$ ssh -i private-key-file -L local-port:target-ip-address:target-port opc@target-ip-address

private-key-file is the path to the SSH private key file.

local-port is the number of an available port on your Linux system. Specify a port number greater than 1023 and less than 49152 to avoid conflicts with ports that are reserved for the system. As a good practice, and for the sake of simplicity, you should specify the same port number as the one to which you are creating a tunnel.

target-ip-address is the IP address of the target compute node in xyz.xyz.xyz.xyz format.

target-port is the port number to which you want to create a tunnel.

If this is the first time you are connecting to the target compute node, the ssh utility prompts you to confirm the public key. In response to the prompt, enter yes.
After the SSH tunnel is created, you can access the port on the target compute node by specifying localhost:local-port on your Linux system

Related Articles
Port Forwarding from Putty in windows
Oracle Cloud Infrastructure
SSH Putty Commands :- 41 Useful SSH commands to help you manage the VPS /Dedicated Server
ssh passwordless:- How to Enable ssh passwordless login setup between two servers
Remote Desktop Manager : – Awesome Free Remote Desktop manager
install SSH on Ubuntu : How to install SSH on Ubuntu with Detailed steps and Problem faced

See also  alter table modify column in oracle database

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top