The ten genes 11g database control would let you administer your ASM desk groups database express can’t do that it simply can’t work with desk groups which are perhaps a bit annoying there’s no interface to ASM at all in database control you can create a tablespace using data files on dis groups, yeah but you can’t administer your describes there’s simply no interface to do that and what else do we have the security you can administer users but what I really like is a performance I think what they’ve done with performance is very good indeed if you haven’t got Enterprise Manager plus the tuning pack you won’t see this tab at all but if you have got the appropriate licenses there’s a very nice capability for monitoring what’s happening in your database in release 11g 11.2 points something I forget exactly what release it came in 11.2 points something.
Oracle introduced automatic monitoring of sequel so 11.2 points something any sequel that runs for more than the phone but correctly five seconds is what they call monitored monitors earlier than 11 point to point something if you wanted to monitor your sequel you have to put in the hens Sasha star plus how to give it the monitor heads right but from 11 point to point whatever it is you don’t need to do that any more any sequel that runs for longer than five seconds is automatically monitored and that is nice tulsi interface there it is monitor sequel and we shouldn’t see anything at this point nothing but in real-time by running some ridiculous query select count star from sh dot sales cross drawing SH dot sales to do some horrendous cartesian products and within five seconds we should see the automatic monitoring kicking in and we’ll see it right here or refresh it on what’s a minute get to a five-second refresh and within a few seconds.
We should see this statement popping up assuming i’m on the right dead race well there we go and it comes up automatically and this is a nice interface you’ve got your high load sequel monitored automatically and click on it and we can do the drill down you’d expects all ready been running for 26 seconds nearly all of which is DV telling good of hanging about on some sort of weight events look at the ID and it’s a nice interface here there’s the full statement a summary of how much running and two straight in we’ve got the execution plan and we can see that we are where we are in the plan so what is decide to do is polishing range all right who rest of it 844 billion rows returned it’s going to take a while but here in real time we can see where it is in the plan and the steps that are running and currently in the plan and right now it’s doing a source at this point here yeah this is a nice interface I like this and hasn’t started we’ve started that one hasn’t done a bit my conversion your IDs.
Yet this is a nice interface now I do like this a lot so going back to performance performance hub so that’s just a very quick run through this so that’s an enterprise manager brief introduction so some reason database control no longer exists many people are extremely upset about that in early placement cloud control you’ve all got cloud control very good tool indeed but it’s a very heavy weight tool it’s a lot of work to get cloud control running a lot of work to configure it the way you want this significant overheads database express is a nice tool but it’s very limited in what it can do it is a nice too although and you know try it get used to it particularly in the environment to you don’t have crowd control it doesn’t have anything like the functionality of the old database Express got a few nice facilities though and that takes us to what I would like you to do now okay and Martin V shell I know you use unix at your site and Jenny are you familiar with some form of Unix oh that’s good enough.
You’ve got a real computer said yeah no problem there’s our classroom environments are built under Linux so and which for the level we need this is just another Unix no problem at all the only times you have issues if we have a class of 16 people who are a hundred percent Unix guys and then sometimes we do have trouble with our classroom environments now what you should have had you should have received an email with this sheet attached the workshop setup good okay now our system administrator bob has built us cloud service amazon AWS Amazon Web Services lovely call it clouds service and no not bad almost cloud servers the 64-bit machines and there’s 12 102 installed if you’d rather on all our exercises on your own systems you certainly can now any 12c database should do but we built the Amazon ones they should work well enough so how do we connect to the right if any of you did not get this sheet.
Let me know the first way to connect to them which I will be doing most of the time is I’m going to use putty stick your hand up please if you use putty or at least have got it installed well I can’t believe potty is free is just incredible so to connect to my cloud server mine store oh by the way sometimes the course of these four days at least one of you is going to log on to the wrong machine it may even be me you logged on to the wrong machine somebody always does it don’t be ashamed just admit to it so the address of the machine there’s the IP address of my machine Yuri to add your own one your own cloud server on its own IP so I take that IP address and stick it in there right the security if you’re not familiar with Amazon Cloud Servers security is a bit of a mission to get through the reason for that is that amazon cloud servers are continually being attacked.
I’m just going to put the feedbacks down by the way if I have been ignoring a raised hand please put your hand up if I’ve really known you all right okay the security issue with amazon cloud service is that the IP addresses are quite well-known so people are continually trying to hack them and for that reason, you cannot log on to these things for the password you can only log on to them by giving a public private key file you have to give it a key the Secure Sockets key and that’s pure because to sort them be hacked so how do you do that right you go to ssh off so ssh off a private key file for authentication in the email I sent out to you I did include the key file to save that key file somewhere on your pc I saved it to TMP ee privates PPK browser let’s put it there so having done this so session has the address SSH off browse that key file open and that should give you a login prompt right the logins there’s the user ID ec2 hyphen user ec2 hyphen user.
Then I get a prompt for the passphrase to open that key file and the passphrase is to uppercase ease, of course, you can’t see me typing in but it is capital e capital e to uppercase ease bang and though I’m in right having logged on like that I can then su- Oracle su to the Oracle account password lowercase Oracle and that’s got me where I need to be if we look at what’s running on this machine yes minus e yeah let’s start with the listener LSN our CTL status there should be a listener Ronnie Ellis and our CTL status there should be a listener rolling and it should know about service called class being offered by the instance class a note here is listening for sequel nets on 1521 and guess what 3g gps on 5500 so to connect our database dot hora en v source the or env file and the database instance is called class so if any of you aren’t familiar with this I’m a dot space source that script and give it the name of the instance and then sequel + / a sister yay and I’m in.
So have a go and that’s the first thing we’ll do can we connect with ssh okay it’s not a question Martin uh yeah actually to what did you say when we su as Oracle what was the password lowercase Oracle waned when in doubt false words a lowercase Oracle okay and then the other question I had out when we I’ve got the private key and whatnot but on that same email I am I don’t know if there was a zip file that was included but I know yep our email server said it strips something out there was a zip file included and that should be covered because I can email this out pretending to be someone else but it should also be covered Gary attached it to the go-to training session and somewhere other should be is that the like I’ve got of a download for skill builders manual is that what it is I let’s have a look that will be thing off that should be the slides and everything but we should also know that gratify it at a time change.
If I have I’ll make sure we’ve got everything sent to you what we should find that is the slideshow right and you should find somewhere here Gary did upload the zip file I sense x but he’s also put exercises don’t zip that should be downloadable through your go-to training interface in your go-to training interface do you have an item called materials it’s trying to think where did where do you see there now my interface has a top menu bar saying file options view help and on view, I can choose to see the materials and if I look at the material so something called exercises to zip what I’ll do is email is out anyway but I’ll just tell lies about what it’s called yeah I don’t see ok.