- SSH: You can connect to your cloud instance using SSH keys (Private and Public Keys) and Port 22. You have to generate Private and Public key pair (using PuttyGen) on your local PC and then create one cloud instance using that Public key. Then connect to the Cloud instance using private key (via Putty) and SSH Port 22.
- IPSec VPN: You can set up a VPN connection to establish a secure communication channel between your data center and your cloud instance. You can use either a supported third-party VPN device or Corente Services Gateway (an Oracle-provided IPsec solution) installed on a host.
- Fast Connect: This option allows you to access your instances through a direct connection from your on-premises. Transferring data over a direct connection provides better privacy and ensures consistent performance with dedicated bandwidth and controlled latency in your network traffic.
Issue:
Trainee was using first method that is SSH to connect to Cloud instance. He was trying to copy a file from on-premise database to cloud instance using scp command as shown below.
Cause:
Fix:
1. We need to convert the private key (.ppk) file as it will not work on Linux. We will use this converted open ssh file while copying the data on cloud from source. Steps to concert private file via puttygen are below
- Open Puttygen and click on conversion and Import file to import your private file.
- Click on conversions and then Export OpenSSH Key.
- Now give any name to the file without any Extension and select All Files(*) under save as and save the file.
2. After copying converted open ssh file on your server, give permission 600 to the file before running scp command.
If you want to learn more about Oracle Cloud and troubleshooting like above then check our Oracle Database Cloud Service (DBCS) Certification (1Z0-160), where we cover each and every topic required to clear your 1z0-160 certification with both a theoretical and practical approach.
Related/Further Reading
If you are just starting out in Cloud then I highly recommend you to go through these posts first
- Cloud Service Model: SaaS | PaaS | IaaS
- 12 Point Checklist for DBA for Beginner to Expert Cloud DBA (Facebook Live)
- If you are confused to pick Amazon AWS or Oracle Cloud then check this
- Check tasks performed by Oracle DBAs in Cloud here.
- Step by Step Activity Guides to Clear Oracle Database Cloud Certification (1Z0-160).
- Our Course Oracle Database Cloud Service (DBCS) Certification (1Z0-160)
Do you want to Move Ahead in your Oracle Cloud Journey?
NO! So your next task is to get yourself to register for our FREE Webinar on Learn How To Build Your First Database On Cloud (PaaS) to start your cloud journey. Click on the image below to register for FREE.
Pullvius says
Hello,
I have been telling everyone I know about your site and plan on completing all of your lessons.
For a few days, I have been stuck with the same ‘Permission denied’ issue as this trainee using the ppk.
I have the OpenSSH Key but am confused as to your point 2:
After copying converted open ssh file on your server, give permission 600 to the file before running scp command.
How would a user copy the file to the server if their very issue is not being able to copy files to the server?
Huge, massive, big thanks in advance if you or anyone can help as I have spent over 20 hours trying to do this so far.
Warmest regards.
Rohit Pathak Pathak says
Hi Pullvius,
Could you please tell, where you have created your Database and how you accessing it.
Thanks & Regards,
Rohit