Accessing Oracle services securely and efficiently from a remote server can be achieved using PuTTY port forwarding feature. PuTTY, a popular SSH client for Windows, allows you to establish encrypted tunnels that allow you to interact with services hosted on a remote Oracle server. User may establish a secure connection for Oracle connections by following the procedures provided in this article, keeping data integrity and security while access to important database services.

Additionally, explore PuTTY role in establish connection from Windows EC2 instance to RDS database, offering comprehensive understanding into secure communication processes across different server settings.

Prerequisite:

Download and install PuTTY on your Windows system.

Configure PuTTY connection:

Open PuTTY configuration windows, In the Hostname section, enter the Oracle service IP address or username.

Set the connection type to SSH and port to 22.

Configure Port Forwarding:

On the left panel, go to Connection>SSH>Tunnels.

For local forwarding, enter the source port e.g. 3389.

Enter the destination in the format e.g. localhost:1521, localhost is the username of the Oracle cloud and 1521 is the port number.

Select local under the destination section.

Save Session:

In the "Saved Session" section, enter your session name and click the "Save" button. To save the session for future use.

Establish a connection:

To start the connection, click the Open button.

Enter the username and password when prompted.

Access Oracle Services:

With the PuTTY session open and port forwarding configured, you should be able to access Oracle services.

Port forwarding in PuTTY appears as an essential tool for obtaining access to Oracle services on a remote server, providing a secure and efficient connection process. 

Transfer file from local machine to Debian server using PuTTY