And welcome back again to Backspace academy. 1
This lab it's going to be similar to the other labs on connecting to an RDS instance but this 2
time we're going to be doing it with an Oracle database and we'll be using the Oracle SQL developer 3
software to connect into our instance remotely. 4
So just starting off here in the RDS dashboard I will just race through quite a lot of this quite quickly because 5
you should have a pretty good understanding of what's going on now. 6
So we launch a DB instance. 7
Now this time I'm going to make sure that the free tier eligible only option is unchecked. 8
The reason being is that Oracle is only available on the free tier if you will bring if you bring your 9
own license of Oracle. 10
So I don't have one. 11
So I'm just going to de-select that and go into Oracle. 12
And again it says free tier eligible that is only if you bring your own license. If you don't have an oracle 13
license then it's not going to be on the free tier as such. 14
So just be careful of that. We will jump into Oracle SE 2 and we'll use the dev test environment and license 15
model will be a license included. 16
So I don't have a license so I'm going to bring it license included. 17
And the DB instance class will be a t2 micro, the smallest one we can select there. 18
We won't be doing multi AZ this is just for teaching purposes. 19
We'll scroll down to our DB instance identifier 20
and I'll call this backspace-rds-oracle. I'll use the same username and password of admin. 21
And once that's filled out, then I can go to the next step. 22
Now I'm going to leave. 23
create new security group and all it will do is it will create a security group for me which will have 24
an in-bound rule on database. 25
Port 1521 for everything which will allow us to connect in remotely using the Oracle SQL Developer 26
software 27
We will select the backup retention period to zero days. 28
I will disable automated backups and then we will click launch DB instance. 29
and as as before it will change from creating and eventually go to available and then we can look at 30
connecting to that instance. OK so now our instance is available and we can look at connecting into it. 31
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
notes to downloading the Oracle SQL Developer software. 33
So go ahead and do that. 34
OK so I'm there in the Oracle SQL Developer application. What we need to do is to file new and 35
connections and then OK. Our connection will be whatever we want. 36
Basically so we will just put in there Oracle DB 37
and user name will be again admin and then our password 38
and our hostname will be the RDS endpoint. 39
So I will just jump in and get that. 40
We again need to remove the :1521 on the end of it which is put in their under 41
port. 42
Now for SID in the, when we launched the instance, when we created the configuration for this instance 43
there was an ORCL database that was already inputted there for us. We could always change that. 44
But we kept that as it was. 45
So the database will be orcl. All we need to do now is just to test that connection to make sure 46
it's working 47
You can see just there on the left hand side we have got there status success. 48
So it is working fine and now we can connect in so we just click on Connect 49
There we have on the left hand side, we've now got our Oracle DB and we can expand that to connect to 50
it. 51
And there we go. 52
So we have connected into our Oracle database and everything is fine. 53
So I'll see you in the next lesson.