Back to: Oracle DBA Tutorials
Installing WinSCP Software and Transferring Files
In this article, I am going to discuss Installing WinSCP Software and Transferring Files. Please read our previous article where we discussed Installing Putty Software and Testing Connections.
Installing WinSCP Software and Transferring Files
In the previous article, we installed putty software. Now we are going to install another software called “WinSCP” in order to transfer files from the client machine and server machine. This is much better than the shared folder.
Step1: Go to Google and search for “Winscp software”.
Step2: After searching for Winscp software. You need to search for the below website. This is the official website where we can download the Winscp software.
WinSCP :: Official Site :: Download
Step3: Open the website and scroll down a little bit you can see the download button below. Click on it.
Step4: It popups for the software to download. Let the download complete.
Step5: Once the download is completed. Open the file and it popups for the installation process. Click Accept.
Step6: Select Typical Installation and Click Next.
Step7: Select the Interface style as Commander and click Next
Step8: This is the installation page. This displays all the permissions and tasks that the application will perform. Click Install.
Step9: After Clicking install the installation process will take a few minutes and prompt this dialog box. Click Finish.
Step10: Open the Winscp software. After opening the Winscp it prompts for the login portal.
Step11: You need to enter the hostname as your virtual machine hostname and enter the username as oracle and password for the user oracle. Click Login.
After Clicking Login, you may be got a popup. Click yes.
Step 12: Transfer files between the Client Machine and Server Machine.
Now we are going to learn the transfer of files between the client machine and the server machine. We have connected to the server as an oracle user. On the left side, the files and folders are part of the computer. On the right side, you can see the files and folders are part of the Linux machine.
Let us try to copy a file from the windows computer to the Linux machine. Let us create a sample text document on the windows computer. I named this file abcd.txt. So, let’s try to copy this file to a Linux machine.
Open the Winscp application and right-click on the left side (i.e) on the windows file system and you can see the option Go to click that and select the open Directory/ Bookmark option. This just allows you to move from one folder to another. I have saved this abcd.txt file on the desktop so we are going to the desktop folder.
You will get a small dialog box to select the path that you need to go. Select the desktop folder and Click Ok.
After Clicking Ok on the left side, you can see the Desktop folder of the computer and on the right side, you can see the Linux machine folder. You can see the file abcd.txt is present on the left side. Just select that file and drag and drop it to the right side.
After dragging and dropping to the right side you will receive a popup. Click ok here and the transformation of the file will be completed. This is a very small file of size 1kb. So, it hardly took two seconds to complete the transfer. You can check in the Linux machine.
You can see the below screenshot that I have transferred the file from the computer to the Linux machine. I have copied it to the “Desktop/Jaya/” folder you can copy it in any folder.
Note: This is the use of the Winscp application. This is far better than the shared folder and too fast. We will learn about this once we are working on the database files.
In the next article, I am going to discuss Installing SQL Developer (Client Side). Here, in this article, I try to explain Installing Winscp Software and Transferring Files and I hope you enjoy this Installing Winscp Software and Transferring Files article.