Cloud Control 12c R1 Installation on Oracle Linux 5.7 and 6.1…

While I was at Open World I tried a few times to get hold of the new Cloud Control software, but the hotel network wasn’t up to the job, so I had to wait until I got home.

The installation is pretty simple compared to previous versions of Grid Control and it installs fine on both Oracle Linux 5.x and 6.x. As always it’s a little greedy on the memory front, with the recommendation for a small installation being 4G for the Cloud Control and 2G for the repository database. That’s not including the OS requirement. On the subject of the repository database, you can use a number of 10g and 11g versions, but anything before 11.2.0.2 requires additional patches, so I stayed with 11.2.0.3.

You can see what I did here.

Cheers

Tim…

Mike Carey: Vicious Circle…

The second in the Felix Castor series by Mike Carey. In Vicious Circle, Felix has to save the ghost of a girl from getting killed (sort of). File under supernatural detective with similarities to The Dresden Files. Pretty cool if you are into this sort of thing, like I am, but not for everyone.

My favorite character has to be Juliette, the succubus. To paraphrase one of her comments regarding attempting to use her abilities on some people suffering from demonic possession, “They should have only been capable of spontaneous orgasm.” It seems demonic possession gets in the way of your average succubus innocently going about their business… 🙂

Second favorite character has got to be Nikki, a zombie conspiracy theorist. It’s good to know that Zombies care about their appearance too. Nikki tries to prevent his corpse decaying by using industrial air conditioning and avoiding bacterial contamination as much as possible. Nikki is rather surprised by his physical reaction to Juliette, which should be impossible for a zombie as their congealed blood does not flow. I’ll leave it up to you to guess what happened to him. 🙂

Cheers

Tim…

OOW11: Wednesday…

Wednesday: This was actually my last proper day at Open World. I fly home Thursday morning, effectively missing the last day of the conference. It’s a shame, but it’s the way things worked out and I’m totally burnt out now. 🙂

Wednesday was definitely “the day after the night before”. I was a little bit under the weather the previous day, so I didn’t feel great on Wednesday morning. Once I got out of the hotel and moving things got a little better. Bagels with cream-cheese in the OCP Lounge helped also. I went to see Cary Millsap speaking about instrumentation, a subject close to my heart. Everyone knows Cary is a great presenter, so I will not big him up any more or his head will pop. 🙂 After that I hung around the RAC Attack in the OTN Lounge, then it was the big keynote. @brost sent Gwen Shapira and I up to the Hilton to watch a stream of the keynote. They didn’t have it there so we had to walk back to Moscone North and sit on the floor to watch it.

Keynote: The keynote was more-or-less what I expected from the ACE Director briefing. There were a few inconsistencies from what we were told, but nothing to write home about. It was all engineered-cloud-exa-grid, with a bit of “everyone else is rubbish” thrown in for good measure. Larry was on good form, but the “live”-ish demo went on a bit too long and I lost interest.

Steve Jobs: I was sorry to hear about the death of Steve Jobs. It’s always sad when people die young. I wish the press would stop making him out to be some sort of Messiah or Saint. He was just a very clever man. Let’s not turn his death into a farce.

Blogger’s Party: After that is was off to the Blogger’s Party, sponsored by Pythian. As with previous years, there were prizes for a number of things, including an iPod Touch for the person who got the most signatures on a Pythian bandana. I made a conscious decision to go for it this year and managed to get a signature from everyone at the event. When it came to the judging I had won, but then felt a little guilty because everybody else hadn’t taken it quite so seriously as me, so I gave the prize to the lady (DBA Kevlar) who came in second place. The sweet smell of victory was easily more important than the prize. 🙂 Thanks to Pythian for another great event.

Once the Blogger’s Party was starting to wind down, most people moved on to the Appreciation Event. I was not really feeling up for it, so I gave my wristband away. I would have only stayed an hour or so, which would have been a bit of a waste. I hope the person who got my wristband ate loads, drank loads and enjoyed Tom Petty and Sting. 🙂 Instead, I went for some food with Chris Muir and Bex Huff, then crashed in my room.

OOW11 Take Home Messages:

  • “Exa” means an engineered solution from Oracle that includes a bit of “magic sauce” software that you can’t run on anyone else’s hardware.
  • Appliance means an engineered solution with stock software running on it. You could build it yourself, but why would you want to?
  • Oracle now do NoSQL (based on the Berkeley DB Storage Engine) as a product. You can get this wrapped up with Hadoop on an engineered system called the Oracle Big Data Applicance. Not sure I will ever touch one of those, but it sounds kinda cool.
  • If BI is your thing, Oracle now provide an Exalytics product that has loads of memory allowing you to do much of your BI workload directly from memory. Once again, sounds cool, but not sure I’ll ever get to touch one.
  • There’s a new version of Grid Control called Enterprise Manager Cloud Control 12c. I guess we now know the next version of the database will be called 12c. 🙂
  • The movement in the Linux and VM space has got Oracle to the point where they can finally acknowledge that cloud exists and they can build one for themselves. See cloud.oracle.com. If Oracle do this well it could be great for them. If they stuff it up there will be plenty of vendors waiting in the wings to point the finger.
  • Fusion Apps actually exists! Nuff said!
  • Lots of people know about my website, but very few people have got a clue about who I am. That’s the way it should be I guess. 🙂

Cheers

Tim…

OOW11: Monday and Tuesday…

Monday: I went to some presentations, hung around in the OTN lounge and ate at every possible opportunity. Tanel Poder‘s presentation on “Large-Scale Consolidation onto Oracle Exadata: Planning, Execution, and Validation” was pretty cool.

In the evening I planned to meet a former colleague at the OTN party. I decided they best way to find him was to visit every food station at the party, which of course meant sampling the goods. Unfortunately I spent too much time eating and not enough time looking for him. Sorry Ian! The cool thing about Open World is you can enter a giant tent full of thousands of people and pretty much guarantee you will bump into loads of people you know. 🙂

Tuesday: I spent most of Tuesday helping out at RAC Attack in the OTN Lounge. I did manage to get to see Greg Rahn‘s presentation called “Real-World Performance: How Oracle Does It”, which focussed on Real-Time SQL Monitoring. Greg’s presentation style is really easy to listen to and you know this isn’t just theoretical knowledge. He’s in the trenches doing this stuff as part of the Real-World Performance Group.

As the afternoon progressed I felt a little tired, so I went back to the hotel, puked and fell asleep. I think this was more to do with being over-tired than anything else. That meant I missed some of the later sessions and didn’t hook up with anyone in the evening.

This morning I feel a little ropey, but I’m going to head on down to RAC Attack again and see if I can make myself useful. Tonight is the appreciation event, but I’m not sure if I will be able to “appreciate it” unless I get a major energy injection at some point today. 🙂

Cheers

Tim…

Oracle Database 11gR2 on OL6 / RHEL6: Certified or Not?

There seems to be a little confusion out there about the certification status of Oracle Database 11gR2, especially with the release of the 11.2.0.3 patchset which fixes all the issues associated with RAC installs on OL/RHEL 6.1.

Currently, 11gR2 is *NOT* certified on OL6 or RHEL6. How do I know? My Oracle Support says so! Check for yourself like this:

  • Log on the My Oracle Support (support.oracle.com).
  • Click the “Certifications” link.
  • Type in the product name, like “Oracle Database”
  • Select the product version number, like “11.2.0.3.0”.
  • Select the platform, like “Linux x86_64” or a specific distro beneath this.
  • Click the “Search” button.

From the results you will see that Oracle Database 11.2.0.3 is certified on OL and RHEL 5.x. Oracle do not differentiate between different respins of the major version. You will also notice that it is not currently supported on OL6 or RHEL6.

Having said that, we can expect this certification really soon. Why? Because Red Hat has submitted all the certification information to Oracle and (based on previous certifications) expects it to happen some time in Q4 this year, which is any time between now and the end of the year.

With a bit of luck, by the time I submit this post MOS certification will get updated and I will happily be out of date… 🙂

Cheers

Tim…

Update: It’s finally certified. See here.

OOW11: Saturday and Sunday…

Saturday: This was my day off before OOW11 started. I spent the morning following Chris Muir round toy shops, trying to find something cool to take home for his kids. Then we went and registered for the conference. After that it was back to the hotel to chill out a bit before the OakTable Network party in the evening.

I have to admit to feeling a little daunted about the OakTable Network party. I wasn’t able to go last year because it clashed with the Oracle ACE party, so this was my first time. I’ve met many of the members before, but standing in Graham Wood’s house surrounded by a bunch of people with brains the size of planets tends to make a grunt DBA/developer like me feel a little paranoid. Luckily, everyone is really low temperature, so I quickly felt at home. Graham and Joan certainly know how to throw a party. Vast quantities of food and drinks along with great conversation. I’m already looking forward to the next one, but I must eat less next time. 🙂

Sunday: I started the day of with Marcelle Kratochvil‘s session about unstructured data and multimedia. If you know Marcelle, you’ll know that she is passionate (a massive understatement) about multimedia and is now starting up a multimedia and unstructured data user group called OMMUDS. It’s early days at the moment, but I hope things go well because it is a fascinating subject and one that will do nothing but grow in importance in the coming years.

After that I went to see Scott Spendolini do a brief history of APEX, which is a pretty cool intro session for the APEX symposium. I was planning to watch some more of the APEX symposium, but I got pleasantly side-tracked and ended up going to get some food with Frits Hoogland. That developed into a couple of hours of geeking-out about Exadata. I know very little about Exadata, but Frits knows loads, so I guess I got a lot more out of it than him. 🙂 During that time he showed me some of the stuff he’s presenting at UKOUG this year. If you have the opportunity you should definitely go to his sessions. He has some really neat stuff to show you.

In the evening it was the ACE party. Once again, a cracking event, but once again I ate far too much. Victoria also forced me into taking a doggy-bag home with me, which I really didn’t need, but emptied anyway. 🙂 I spent a lot of time talking with Oded Raz and Liron Amitzi. With a bit of luck I might get to present in Israel in the future. Just as it was closing time I bumped into Steven Feuerstein and we had a little chat. Don’t forget to try my questions on the PL/SQL Challenge in October. 🙂

I’ve continued to get to the gym a couple of times each day, but considering the amount of food I’ve eaten, I’m not sure it will do me much good. This morning both Lillian and Victoria were at the gym, but there was no sign of Justin. Come one dude, you are letting the side ACE Program down. 🙂

Cheers

Tim…

OOW11: Oracle ACE Director Briefing Day 1 & 2…

If you’ve followed Twitter over the last couple of days you’ll have seen cryptic posts about the content of the ACED briefing. We all had to sign non-disclosure agreements (NDAs) to make sure we didn’t tweet or blog about the Oracle Games Console (OGC) before Larry announces it next week. Day 2 is done and we have a day off before OOW11 starts for everyone else. I’m already totally knackered. 🙂

It’s quite freaky to think the ACE program has got so many of us together in one spot and essentially provided a 2 day conference just for us. It’s even more amazing to think that they were able to get so many important people to take time out during the busiest time of their year to come and speak to us. I don’t think many people can pin down Thomas Kurian for an hour this close to Open World. It says a lot about the amount of work Justin, Victoria and Lillian have put in over the last few years, that they can get this level of buy-in for the program. Despite being a tired and grumpy old man, I am extremely grateful to be part of the program.

If you are coming to OOW, you are going to hear a lot of interesting announcements this week. If you can’t make it, you might want to keep an eye on the Oracle YouTube channel. It will have live content streaming, which should help keep you up to speed with what’s going on over here.

I mentioned in a previous post Jeremy Schneider invited me to help out at RAC Attack at OOW 2011. I’ll be doing a couple of shifts on Tuesday. Come along and have go. It should be fun.

I’ve managed to drag myself into the gym quite a bit. I did the evening of my arrival and morning and evening on both days since. Once the mayhem surrounding OOW kicks in I don’t know how easy it will be to keep it going. Time will tell.

Cheers

Tim…

PL/SQL Challenge: October SQL Quiz Questions by Me…

I’ve done quite a few certification exams, so I’ve seen a lot of OCP questions in my time. In the past I’ve been openly critical of some of the OCP questions, but always said that it must be a really tough job to create the exams. With that in mind, when Steven Feuerstein asked me if I would be interested in providing the October questions for the SQL quizzes on the PL/SQL Challenge, my first reaction was OMG!

After the initial panic/fear/denial had subsided I decided to bite the bullet and get a feel for how hard a job it really was. I would love to say it was really simple, but that would be a complete lie. 🙂 The initial questions themselves were pretty easy to write, but the fine tuning to make sure they were properly focussed and reduce the chances of accidentally misleading people was quite a big job.  The team of question reviewers deserve medals for helping me knock the questions into shape. Big thanks to all those involved.

During October, you will be able to judge for yourself how well I got on by trying the SQL Quizzes. In addition to the normal feedback channels, feel free to contact me directly and let me know. Please be gentle. 🙂

Cheers

Tim…

Arrived at San Francisco (OOW & ACED)

There were no real dramas on the way from Birmingham to San Francisco, which makes a change for me. 🙂

I got to San Francisco at 16:00 local time and told myself I would go to bed at 21:00 at the latest. I trotted off to the gym, got cleaned up and went down to the bar to say hello to some people. Fatal mistake. I did my normal trick of talking incessantly until about 01:00. Luckily I was not drinking pints of “jetlag” like others I could mention. 🙂

So at about 01:00 I was in bed. I woke up at about 04:15. 🙁 If nothing else it meant I got to catch up on all my emails and go to the gym again. I think there are going to be a few very tired people during the ACED meeting today. I apologise in advance if I fall asleep in your session.

As always, I’m a little daunted at the start of this week. Having 2 days of ACED meetings followed by the main 5 day conference is a lot more difficult than it sounds, especially when everyone knows enough to make you paranoid about your own abilities. Having said that, I know it’s going to be fun and I know I’ll be glad I came.

Cheers

Tim…

PS. Already missing the people I know can’t make it this year. Excited about meeting up with everyone again.

PPS. Must remember to speak less and listen more.

PPPS. Must try remain calm this year, not act like a kid in a sweet shop. 🙂