0 1 00:00:01,090 --> 00:00:05,010 And welcome back again to Backspace academy. 1 2 00:00:05,020 --> 00:00:09,880 This lab it's going to be similar to the other labs on connecting to an RDS instance but this 2 3 00:00:09,880 --> 00:00:15,590 time we're going to be doing it with an Oracle database and we'll be using the Oracle SQL developer 3 4 00:00:15,590 --> 00:00:19,500 software to connect into our instance remotely. 4 5 00:00:20,050 --> 00:00:25,540 So just starting off here in the RDS dashboard I will just race through quite a lot of this quite quickly because 5 6 00:00:25,540 --> 00:00:28,280 you should have a pretty good understanding of what's going on now. 6 7 00:00:28,350 --> 00:00:30,040 So we launch a DB instance. 7 8 00:00:30,190 --> 00:00:35,280 Now this time I'm going to make sure that the free tier eligible only option is unchecked. 8 9 00:00:35,290 --> 00:00:40,810 The reason being is that Oracle is only available on the free tier if you will bring if you bring your 9 10 00:00:40,810 --> 00:00:42,610 own license of Oracle. 10 11 00:00:42,610 --> 00:00:43,700 So I don't have one. 11 12 00:00:43,720 --> 00:00:49,190 So I'm just going to de-select that and go into Oracle. 12 13 00:00:49,520 --> 00:00:54,770 And again it says free tier eligible that is only if you bring your own license. If you don't have an oracle 13 14 00:00:54,770 --> 00:00:58,370 license then it's not going to be on the free tier as such. 14 15 00:00:58,370 --> 00:01:08,570 So just be careful of that. We will jump into Oracle SE 2 and we'll use the dev test environment and license 15 16 00:01:08,570 --> 00:01:11,810 model will be a license included. 16 17 00:01:11,840 --> 00:01:14,770 So I don't have a license so I'm going to bring it license included. 17 18 00:01:15,350 --> 00:01:19,920 And the DB instance class will be a t2 micro, the smallest one we can select there. 18 19 00:01:20,150 --> 00:01:24,530 We won't be doing multi AZ this is just for teaching purposes. 19 20 00:01:25,040 --> 00:01:27,900 We'll scroll down to our DB instance identifier 20 21 00:01:31,010 --> 00:01:40,200 and I'll call this backspace-rds-oracle. I'll use the same username and password of admin. 21 22 00:01:40,390 --> 00:01:43,980 And once that's filled out, then I can go to the next step. 22 23 00:01:47,070 --> 00:01:48,120 Now I'm going to leave. 23 24 00:01:48,120 --> 00:01:53,070 create new security group and all it will do is it will create a security group for me which will have 24 25 00:01:53,070 --> 00:01:55,910 an in-bound rule on database. 25 26 00:01:56,070 --> 00:02:03,310 Port 1521 for everything which will allow us to connect in remotely using the Oracle SQL Developer 26 27 00:02:03,310 --> 00:02:03,810 software 27 28 00:02:07,030 --> 00:02:10,180 We will select the backup retention period to zero days. 28 29 00:02:10,190 --> 00:02:15,110 I will disable automated backups and then we will click launch DB instance. 29 30 00:02:19,860 --> 00:02:26,520 and as as before it will change from creating and eventually go to available and then we can look at 30 31 00:02:26,880 --> 00:02:34,820 connecting to that instance. OK so now our instance is available and we can look at connecting into it. 31 32 00:02:34,820 --> 00:02:40,340 The first thing we need to do is we need to go to the Oracle Web site and there's a link in the lab 32 33 00:02:40,340 --> 00:02:44,670 notes to downloading the Oracle SQL Developer software. 33 34 00:02:44,690 --> 00:02:46,030 So go ahead and do that. 34 35 00:02:49,620 --> 00:02:57,780 OK so I'm there in the Oracle SQL Developer application. What we need to do is to file new and 35 36 00:02:57,840 --> 00:03:04,810 connections and then OK. Our connection will be whatever we want. 36 37 00:03:04,810 --> 00:03:07,930 Basically so we will just put in there Oracle DB 37 38 00:03:10,730 --> 00:03:14,000 and user name will be again admin and then our password 38 39 00:03:17,330 --> 00:03:20,520 and our hostname will be the RDS endpoint. 39 40 00:03:20,520 --> 00:03:21,870 So I will just jump in and get that. 40 41 00:03:31,410 --> 00:03:38,810 We again need to remove the :1521 on the end of it which is put in their under 41 42 00:03:38,820 --> 00:03:39,690 port. 42 43 00:03:39,690 --> 00:03:46,650 Now for SID in the, when we launched the instance, when we created the configuration for this instance 43 44 00:03:46,740 --> 00:03:54,910 there was an ORCL database that was already inputted there for us. We could always change that. 44 45 00:03:55,030 --> 00:03:57,700 But we kept that as it was. 45 46 00:03:57,780 --> 00:04:04,380 So the database will be orcl. All we need to do now is just to test that connection to make sure 46 47 00:04:04,380 --> 00:04:04,930 it's working 47 48 00:04:10,890 --> 00:04:15,820 You can see just there on the left hand side we have got there status success. 48 49 00:04:15,890 --> 00:04:18,940 So it is working fine and now we can connect in so we just click on Connect 49 50 00:04:23,290 --> 00:04:29,560 There we have on the left hand side, we've now got our Oracle DB and we can expand that to connect to 50 51 00:04:29,560 --> 00:04:29,870 it. 51 52 00:04:38,150 --> 00:04:38,760 And there we go. 52 53 00:04:38,770 --> 00:04:42,910 So we have connected into our Oracle database and everything is fine. 53 54 00:04:42,940 --> 00:04:45,240 So I'll see you in the next lesson.