{ "video": "8mHxhvi-9oE", "seconds": 145, "title": "Copy Oracle Walet to VM", "prior": ["Oracle Cloud Account Setup","Logging in to your Oracle Cloud Account","Create an Oracle Autonomous Database","Create Compute Instance","Connect to Oracle Cloud VM","Connect to Oracle Cloud VM Mac"], "transcript": This video shows how to download your Oracle Autonomous Database credentials and upload them to the home directory of your Oracle compute instance.\r\n\r\nOne way to allow an application to connect to your database is by establishing an M T L S connection. To do this, you'll need to download a database credential file, which is also known as a \"wallet\". Then, you'll need to put that file in the expected location on the computer you want to use to access your data.\r\n\r\nWe'll assume you already have an Oracle Cloud account with an autonomous database configured and an Oracle Compute Instance to which you can connect to execute commands. If not, check out the videos listed above.\r\n\r\nFrom your \"Oracle Cloud\" \"Getting Started panel\", let's search for \"autonomous,\" then click on the Autonomous Database service. \r\n\r\nClick the display name of the desired database.\r\n\r\nNow, Click the \"Database Connection\" button.\r\n\r\nBe sure the \"Wallet type\" is set to \"Instance wallet.\" and click \"Download Wallet.\" \r\n\r\nWe must supply a password to protect the information in this connection file. Choose anything you like, as long as it meets the complexity requirements.\r\n\r\nClick the \"download\" button to get the file.\r\n\r\nBe sure to remember the location to which the file is downloaded. \r\n\r\nNow, I'll open power shell on my Windows computer. If you're on a Mac, you'll want to open terminal. \r\n\r\nI'll change to the directory where I downloaded the wallet and check the file listing to be sure I'm in the right place. \r\n\r\nTo copy this file from my local computer to my VM, I'll use the S C P command. SCP stands for \"Secure Copy\" and it's pretty easy to use. I'll just type the command name followed by the name of the file I want to copy. after that I'll specify the username and IP address of the destination on my VM, just like I'm establishing a secure shell with SSH. To specify the destination folder, I'll add a colon and the desired path. That's it.\r\n\r\nI can see here that the file copy was successful. Just to be sure, I'll connect to my VM and view the file listing there. \r\n\r\nSure enough, here it is.\r\n\r\nWhen your professor configures your computer with the software needed for this class, he'll configure the Oracle environment to use this file so this is all you need to do." , "code": [ { "summary": "Commands", "detail": "cd .\\Downloads\\oracle-wallet\\\r\n\r\nls *.zip\r\n\r\nscp Wallet_coursework.zip opc@your.ip.add.ress:\/home\/opc\r\n\r\nssh opc@your.ip.add.ress\r\n\r\nls " } ] }