Using SFTP to upload files to an Oracle server is an essential method for maintaining data security and confidentiality. PuTTY, a popular terminal operator provides a secure connection, to transfer data to an Oracle server using SFTP. To ensures that your file transfers remain flexible and secure, whether you use password-based authentication or the enhanced security of SSH key pairs.
Use SFTP with PuTTY upload file on Oracle server involve few steps:
Download PuTTY and PuTTYgen:
Download PuTTY and PuTTYgen application on your system.
Generate Key pairs:
Open PuTTYgen, click on Generate button. Move your mouse over the PuTTYgen windows blank area
to generate randomness, which is necessary for key security.
To save the public key, click the "Save public key" button. Choose a location and a name for the public
key file (for example publickey.pub).
To save the private key, click the "Save private key" button. Choose a location and a name for the
private key file (for example private key.ppk).
Configure PuTTY connection:
Open PuTTY configuration windows, enter the Oracle server IP address or username in the Hostname section.
Set the connection type to SSH and port to 22.
Add private key:
On the left panel, go to Connection>SSH>Auth. Click on browse and select the generated private key.
Save Session:
In the "Saved Sessions" section, enter your session name and click the "Save" button. To save the session.
Establish a connection:
To start the connection, click the "Open" button.
Enter the username and password when prompted.
Navigate to the Directory with psftp:
Open a command prompt on your local machine.
Navigate to the directory where PuTTY is installed, and you'll find psftp.exe there.
Start psftp:
To start psftp, run command:
psftp username@hostname
Replace username and hostname with the username and hostname of your Oracle server.
Upload Files:
Use the put command to upload files. e.g.
put localfile.txt
Replace localfile.txt with the name of the file you want to upload.
Now, you can securely upload files to an Oracle server using SFTP and PuTTY. Whether you use password-based authentication or SSH key pairs depends on your security preferences and server configurations.