{ "video": "89CVSTPjfCc", "seconds": 145, "title": "Create Compute Instance", "prior": ["Oracle Cloud Account Setup","Logging in to your Oracle Cloud Account"], "transcript": "In this video, we'll see how to set up a virtual machine (also known as a \"compute instance\") in the Oracle Cloud. I'll assume you already have an Oracle Cloud Account. If not, check out the videos listed above.\r\n\r\nFrom the \"Get Started\" panel of my Oracle Cloud dashboard, I'll search for \"instance\" and choose the \"instances service\" to get started.\r\n\r\nI'll click on the \"Create instance\" button to build a new virtual machine.\r\n\r\nEvery instance needs a name. It will be helpful to your professor if you use your first and last name, separated by a hyphen, as your machine name. I'll use all lowercase letters for mine.\r\n\r\nWe're going to accept the defaults to be sure our instance qualifies to run as an \"always free\" service.\r\n\r\nThe \"Image and shape\" panel is where you can select the operating system and physical characteristics of your virtual machine such as the amount of memory and how many processors. You can see that there are many options but I'm gonna stick with the defaults. This will build a single-core machine with a gigabyte of RAM, running Oracle Linux, which is a derivative of RedHat Linux.\r\n\r\nTo make a secure remote connection to this instance, I'll need a public-key private-key pair. Fortunately, I can download both of these right here. We'll see how to use these in a subsequent video.\r\n\r\nNow, I'm ready to build the instance, so I'll click \"Create.\" \r\n\r\nIt'll take a minute or two to provision the machine and get it running. After the \"instance\" tile turns green, the machine is running in the cloud. However, it is still running some code to get it fully configured, so it's best to wait about three minutes before trying to access it. To connect, I'll need the private key I downloaded as well as the public IP address that has been assigned to this instance. \r\n\r\nI'll wait a few minutes, then connect in a different video.", }

title: Setting Up an Oracle Cloud VM videos: - "Create Compute Instance" - "Connect to Oracle Cloud VM" - "Connect to Oracle Cloud VM Mac" - "Professor VM Access" - "Copy Oracle Walet to VM" - "Submit IP Address"

{ "video": "RW-NTiemvFo", "seconds": 145, "title": "Connect to Oracle Cloud VM (Windows)", "prior": "Create Compute Instance", "transcript": "In this video, we'll see how to connect to a virtual machine in the Oracle Cloud from the Windows operating system. I'll assume you already have a virtual machine running. If not, check out the videos listed above.\r\nI'll start by being sure that I have access to the private key file I downloaded while configuring the virtual machine.\r\n\r\nNow, I'll launch power shell by typing \"power shell\" in the Windows search bar and clicking the power shell option when it's available.\r\n\r\nI can see that my current working directory is the home directory for my Windows user account. That's good, because to make accessing my VM easy, I'll want to put that private key file in the expected location. It belongs in a folder called .ssh in my home directory. Let's see if that folder is already here by trying to make it the active directory.\r\n\r\nI'll type \"cd .ssh.\"\r\n\r\nI got an error message telling me that the directory does not exist. I'll create it by typing \"mk dir dot ssh.\"\r\n\r\nNow, I'll start Windows Explorer by typing, \"start .ssh\" so I can copy my private key file to the new directory. Even though I don't really need the public key file to be here, I'll keep them together by copying them both.\r\n\r\nI should be able to see these files in power shell now, so I'll ask for a directory listing of the .ssh folder. It looks as though they are here. \r\n\r\nWhen I try to connect to the remote VM, the secure shell client will automatically try to use this private key for authentication if it is in the .ssh folder and named i d, _, r s a, so I'll rename it now.\r\n\r\nNow I'll run the ssh client by typing \"ssh\" followed by the username, which is \"opc.\" Then I'll type the, \"@,\" sign followed by the public IP address of my VM and press \"enter.\"\r\n\r\nThe first time I connect to a new machine, the ssh client prompts me to be sure I want to connect. I'll type y e s and press \"enter.\"\r\n\r\nIt looks as though I'm connected. Here's the machine name I chose when I configured the machine. I'll check my current working directory. Sure enough, I'm in the home folder of the opc user. To end my remote session with the VM, I'll type \"exit,\" and press enter.\r\n\r\nThe connection is closed and I'm back at my power shell prompt on my local computer.\r\n", "code": [ { "summary": "Commands", "detail": "powershell\r\n\r\ncd .ssh\r\n\r\nmkdir .ssh\r\n\r\nstart .ssh\r\n\r\ndir .ssh\r\n\r\nid_rsa\r\n\r\nssh opc@pub.ip.add.res\r\n\r\nyes\r\n\r\npwd\r\n\r\nexit" } ] }

{ "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 " } ] }

{ "video": "VX9HXSETyUs", "seconds": 70, "title": "Accessing your Oracle Database through Cloud Console", "prior": "Logging in to your Oracle Cloud Account", "transcript": "This video shows how to log in to your Oracle Autonomous Database through the Oracle Cloud Console. I'm assuming you've already set up a database and you know how to log in to the cloud console. If not, see the prior videos in this playlist or the links to prior videos listed above.\r\n\r\nLet's start by searching for autonomous. Now choose the autonomous database service\r\n\r\nSometimes, your database won't show when you first arrive on this screen. If you don't see the database you're looking for, just click \"Autonomous Database\" here.\r\n\r\nOnce your databases are showing, just click the name of the one you want to access.\r\n\r\nIf your database is up and running, your ATP tile will be green. If not, you'll need to start it by choosing \"more actions\" and selecting \"start.\" It usually takes a minute to start up.\r\n\r\nOnce your database is running and your ATP tile is green, you can access your database by choosing \"database actions\" and selecting \"S Q L.\" This will open a new tab in your browser and you'll be signed in as the \"ADMIN\" user.\r\n\r\nNow you are ready to execute structured query language statements.", }

{ "video": "rpH8G5zbzS0", "seconds": 194, "title": "Setup Database Accounts", "prior": "Create an Oracle Autonomous Database", "transcript": "This video shows how to create two database \"user accounts\" that you'll need to complete your coursework. I'm assuming you've already set up a database and you're able to access a tool for executing commands as the ADMIN user. If not, see the prior videos in this playlist or the links to prior videos listed above.\r\n\r\nAlthough it's possible to create user accounts through the database's graphical user interface, we are going to create them using Structured Query Language.\r\n\r\nThis language is abbreviated as S Q L but it's usually pronounced \"sequel\" by data professionals.\r\n\r\nFirst, let's create an account for you to use for your class assignments. The account will be named STUDENT and it's the one you'll use for just about all the work for this course. You'll find the SQL statement to create the STUDENT account below this video. Click to display the SQL commands then you can copy and paste the code into the SQL window. Be sure to change the password from \"Temporary password 1 2 3 4\" to a strong password. You'll need to keep track of the password you choose because you'll use it each time you log in.\r\n\r\nYou'll notice that this script has several statements. One to create the user account and others to give it the needed permissions. This button allows you to execute one statement in the script at a time but we want to execute the whole thing, so click this one.\r\n\r\nI'll just scan through the script output to be sure there are no error messages, which are shown in red.\r\n\r\nEverything looks good.\r\n\r\nNow let's create the account your professor will use to access your database. You can copy the script for this from below as well. This account is similar to your ADMIN account so your professor can make administrative changes to your database if needed.\r\n\r\nFor this one, don't change the password that's in the script. Your professor will change it when he logs on to verify that you have created these accounts correctly.\r\n\r\nLet's clear the output from the last script and execute this one.\r\n\r\nI'm scanning the output.\r\n\r\nEverything looks good.\r\n\r\nNow, let's see how to use the newly created student account to login directly to the database.\r\n\r\nClick on the options menu in the upper left corner of your browser. Under the \"Administration\" heading, choose \"Database Users.\"\r\n\r\nI'll find the \"student\" user and click this button to copy the direct login link.\r\n\r\nNow I'll open an \"incognito\" browser and paste in the direct login link to verify that I can use the student account to access my database directly. \r\n\r\nI'll enter \"student\" as the username and supply the password I chose for the account.\r\n\r\nIt looks as though everything works great. We're ready to start working with data but that will be the topic for another video. \r\n\r\nTake a minute now and record the direct login link and the password that you created for the \"student\" account. With them, you'll be able to log in directly to your database without having to log in to your Oracle Cloud console first. Plus, your professor will probably ask for that direct login link to verify that your accounts are configured correctly.\r\n\r\n", "code": [ { "summary": "SQL to create Student Account", "detail": "\r\n-- USER SQL\r\nCREATE USER STUDENT IDENTIFIED BY Temporary_Password_1234;\r\n\r\n-- ADD ROLES\r\nGRANT CONNECT TO STUDENT;\r\nGRANT RESOURCE TO STUDENT;\r\nGRANT CREATE VIEW TO STUDENT;\r\nALTER USER STUDENT DEFAULT ROLE CONNECT,RESOURCE;\r\nALTER USER STUDENT QUOTA UNLIMITED on DATA;\r\n\r\n-- ENABLE REST\r\nBEGIN\r\n ORDS.ENABLE_SCHEMA(\r\n p_enabled => TRUE,\r\n p_schema => 'STUDENT',\r\n p_url_mapping_type => 'BASE_PATH',\r\n p_url_mapping_pattern => 'student',\r\n p_auto_rest_auth=> TRUE\r\n );\r\n commit;\r\nEND;\r\n\/ " }, { "summary": "SQL to remove Student Account (in case you want to practice creating it again)", "detail": "DROP USER STUDENT;" }, { "summary": "SQL to create Professor Account", "detail": "CREATE USER professor IDENTIFIED BY Temporary_Password_1234;\r\n\r\n-- ADD ROLES\r\nGRANT ACCHK_READ TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT ADB_MONITOR TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT ADM_PARALLEL_EXECUTE_TASK TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT ADPADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT APEX_ADMINISTRATOR_READ_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT APEX_ADMINISTRATOR_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT AQ_ADMINISTRATOR_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT AQ_USER_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT AUDIT_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT AUDIT_VIEWER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CAPTURE_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CONNECT TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CONSOLE_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CONSOLE_DEVELOPER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CONSOLE_MONITOR TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CONSOLE_OPERATOR TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CTXAPP TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DATAPUMP_CLOUD_EXP TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DATAPUMP_CLOUD_IMP TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DCAT_SYNC TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DV_ACCTMGR TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DV_OWNER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DWROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT GATHER_SYSTEM_STATISTICS TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT GRAPH_DEVELOPER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT HS_ADMIN_SELECT_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT LBAC_DBA TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT ODIADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT OML_DEVELOPER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT OML_SYS_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT OPTIMIZER_PROCESSING_RATE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT ORDS_ADMINISTRATOR_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT PDB_DBA TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT PROVISIONER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT RESOURCE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT SELECT_CATALOG_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT SODA_APP TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT XS_CACHE_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT XS_CONNECT TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT XS_NAMESPACE_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT XS_SESSION_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\n\r\nALTER USER PROFESSOR DEFAULT ROLE ACCHK_READ,ADB_MONITOR,ADM_PARALLEL_EXECUTE_TASK,\r\nADPADMIN,APEX_ADMINISTRATOR_READ_ROLE,APEX_ADMINISTRATOR_ROLE,AQ_ADMINISTRATOR_ROLE,\r\nAQ_USER_ROLE,AUDIT_ADMIN,AUDIT_VIEWER,CAPTURE_ADMIN,CONNECT,CONSOLE_ADMIN,\r\nCONSOLE_DEVELOPER,CONSOLE_MONITOR,CONSOLE_OPERATOR,CTXAPP,DATAPUMP_CLOUD_EXP,\r\nDATAPUMP_CLOUD_IMP,DCAT_SYNC,DV_ACCTMGR,DV_OWNER,DWROLE,GATHER_SYSTEM_STATISTICS,\r\nGRAPH_DEVELOPER,HS_ADMIN_SELECT_ROLE,LBAC_DBA,ODIADMIN,OML_DEVELOPER,OML_SYS_ADMIN,\r\nOPTIMIZER_PROCESSING_RATE,ORDS_ADMINISTRATOR_ROLE,PDB_DBA,PROVISIONER,RESOURCE,\r\nSELECT_CATALOG_ROLE,SODA_APP,XS_CACHE_ADMIN,XS_CONNECT,XS_NAMESPACE_ADMIN,\r\nXS_SESSION_ADMIN;\r\n\r\n-- ENABLE REST\r\nBEGIN\r\n ORDS.ENABLE_SCHEMA(\r\n p_enabled => TRUE,\r\n p_schema => 'PROFESSOR',\r\n p_url_mapping_type => 'BASE_PATH',\r\n p_url_mapping_pattern => 'professor',\r\n p_auto_rest_auth=> FALSE\r\n );\r\n commit;\r\nEND;\r\n/\r\n" } ] }

{ "video": "QiAaEbJvGhQ", "seconds": 27, "title": "Submit Database login link", "prior": Setup Database Accounts, "transcript": "", "extras":[ {"label":"Submit Data","postId":"submit-data"} ] }