Partitioning Enhancements in Oracle Database 12c Release 1

I was planning to cover this subject in a single article, but it got a bit bulky, so I split it down into 6 little articles.

I’ve also created a links page to bring them all together.

I guess you could call it a list of nice-to-haves, rather than something revolutionary, but I’m sure someone will come back to me saying one of them has changed their life! :)

Cheers

Tim…

The Oracle ACE Program : My 9 Year Anniversary

ace-director

It was 9 years ago today I became an Oracle ACE. Yes, it was April 1st. :)

A couple of years ago I wrote an anniversary post called Should you aim to become an Oracle ACE? I think that post still reflects my feelings about the program. :)

So that’s 9 years done and I’m starting my 10th year. It’s crazy how quick times flies!

Cheers

Tim…

PS. After 9 years, I still can’t fill in an expense claim properly…

Windows 10 : It’s like totally amazing and junk…

I decided I wanted to play with the newly released Spartan browser on Windows 10. Spartan comes with Windows 10 (build 10049), which does not have an ISO download available at the moment. So instead, I downloaded the x64 ISO image of Windows 10 (build 10041) and installed it on VirtualBox.

To get build 10049 you have to switch the Windows Update settings from “Slow” to “Fast”, which gives you access to the latests builds as soon as they are available.

Windows10UpdateFast

That done, Windows Update will then download build 10049, which is pretty much a full OS download again. Once rebooted, the OS auto-installs for ages, with a few reboots, but when it is done you are left with the latest Windows 10 build.

It boots to the desktop and feels quite similar to Windows 8.1. If you are interested in the latest start menu, here it is.

Windows10StartMenu

If I’m honest, I’ve never seen the Windows 8.1 start menu live. The Windows 8 menu was so bad I installed Classic Shell on the Windows 8 machines for my family. I’ve never removed it since the 8.1 upgrade. As a result, I don’t really know if this Windows 10 start menu is new or like the 8.1 menu. I would probably stick with this menu myself, knowing that Classic Shell is always available if it pisses me off. :)

Most importantly, THIS IS SPARTA(N)!

Windows10Spartan

Not surprisingly, it’s a just a browser and any site that sticks reasonably close to the standards will work fine.

So that was the fun bit. Now I’ve got to look at what this is going to break. I’m guessing Oracle Forms isn’t going to like it. :)

Cheers

Tim…

PS. Alex – By “and junk” I was not implying it is junk. Este Uimitor!

Update: Installed Oracle Database 12c on Windows 10 without any problems. Happy days!

Windows10Oracle12c

To patch or not to patch?

Mary Ann Davidson wrote a great piece on her security blog today, which basically talked about focusing on the important vulnerabilities, not necessarily the ones that get the most press. Added to that, the risk associated with a vulnerability may well be different for you compared to everyone else, depending on how your system is used. I agree with what she is saying, but I’m going to take a slightly different angle on the subject.

Over the years I’ve come across lots of different attitudes to database patching from management and DBAs. As more DBAs are now involved in looking after middle tier products like WebLogic, some of those attitudes to patching have moved into that world too. It seems to break down into three camps.

  1. We don’t need no stinkin’ patches. If this is the way you roll you are a dumb-ass!
  2. We only patch stuff that represents a vulnerability for us. This sounds kind-of sensible, but life can get very difficult trying to decide what constitutes a threat, especially when you have to consider all layers of the technology stack.
  3. We always apply all patches. This is logically simple, but you are going to apply a lot more patches, a lot more frequently, which is going to require a lot more testing.

Patching is not just about security.

  • Support of some products is tied into the patch version. We see this with Oracle products all the time. There are some important deadlines coming up soon! :)
  • The rest of the world is moving on around you. You might be happy with your unpatched product, but things might break because of external factors. If someone turns off SSLv3 on their application server, you aren’t doing HTTPS callouts from your database to it unless you patch up to 11.2.0.3 or later. Your applications will probably get browser compatibility issues on newer browsers and mobile devices unless you keep on top of patching your development frameworks.
  • Patches like the database PSUs come with extra functionality, including backports of features from newer releases (redaction – 11.2.0.4). They can also bring with them features that make future upgrades easier (transport database – 11.2.0.3 onward).

Choosing not to patch is not really an option these days. Your company has to understand this and allocate the correct amount of resource to getting it done. That might mean more staff resources allocated to patching and subsequent testing (rather than doing “productive” work), outsource the work where you can or moving to cloud services where regular patching is part of the deal.

Cheers

Tim…

UKOUG System Event : I’ve got a paper selected.

I’ve just found out I’ve got a paper selected for the UKOUG System Event on May 20th. Check out my badge. :)

I was a spectator at last year’s event. At first glance you might think much of the content is not directly related to my job, since I’m not a system administrator, virtual infrastructure administrator and I don’t use any Oracle engineered systems, appliances or storage products. Having said all that, it’s hard to be a DBA these days without having a finger in several pies. Most of the information discussed at these events is relevant, even if you are not using the exact same kit or doing the exact same job as the speaker.

Hope to see you there.

Cheers

Tim…

Oracle Linux 7.1 Preinstall Packages available for 11gR2 and 12cR1

Every so often I have a nose around the contents of the Oracle Linux public yum repositories and guess what I found in the OL7.1 base and OL7 latest repositories.

Yeeeeeaaaaahhhhhh!

The datestamps suggest they’ve been around since the 5th February, but I think these only became available with the release of OL7.1.

On the positive side, this means installations of 11g and 12c just got a whole lot easier on Oracle Linux 7. On the downside, I’ve got some minor rewrites to do. :)

Cheers

Tim…

Birmingham City University (BCU) Talk #2

As mentioned in a previous post, when I was at Birmingham City University (BCU) speaking at the UKOUG Next Gen event, one of the lecturers saw me and subsequently asked if I would come in and do some technical talks for the students. I did the first about a month ago. Yesterday I had the morning off work to pop across to do another talk.

This talk was on virtualization. It’s based on the slides for my “Cure for Virtual Insanity” session, but I frame the subject a little differently and skip some of the content. I like doing this talk. It’s not too heavy and it gives an introduction into virtualization, which links into the current bach of DBaaS cloud offerings. I think it’s good for people to understand some of the building blocks their “magic” cloud services are built on. :)

I feel like the talk went well and I got some questions, so people must have been paying attention. :)

Afterwards I chatted with the guys about the session and more generally about how to move this guest speaker thing forward. If everything goes to plan I will be doing 4-6 of these sessions per year. I think it’s great how they are looking for feedback from external people and companies to help develop their students. It’s not like the antiquated approach lecturers used when I was at university. :)

Onwards and upwards…

Cheers

Tim…

OUG Ireland 2015 : The Journey Home

After saying a quick goodbye to everyone, I got in a taxi and headed for the airport. I was a little on the early side, but as I’ve said before, it’s better to be early than late where airports are concerned. I wanted do have a Guinness in the bar in the airport, like I did with Patrick Hurley last year, but the queue was too long, so I settled for an authentic Irish diet coke instead. The flight home was a little less “eventful” than the flight out. I arrived in Birmingham at about 23:00 and after a taxi ride home, was in bed by 00:00. So all in all it was a 20 hour day! :)

Dublin is seriously easy for me to get to. It is cheaper (£27 return) and easier (40 mins) for me to get to Dublin than it is to get to London. I did spot one of my fellow Oracle Midlands folks there, who had also flown in for the day to check out the conference. It’s definitely worth considering the trip! This event is now one of my staples for the year!

Thanks to the folks at OUG Ireland and UKOUG for getting the event up and running. Thanks to all the attendees and speakers for turning up. Without you it would not happen. Even though this was a self-funded event for me, I would still like to thank the Oracle ACE Program for letting me fly the flag!

See you all next year!

Cheers

Tim…

OUG Ireland 2015 : The Event

Having got to OUG Ireland, here’s what happened…

The first session I got to see was Nikolay Kovachev from TechnoLogica speaking about “12c PDBs, Snapshots & Change Management”. Bulgaria in da house! The session started with an intro to ZFS (snapshots, copy-on-write (COW), clones), then a quick intro to the Oracle multitenant architecture. From there it was on to PDB snapshot cloning using ZFS. Because of the ZFS COW functionality, this is really quick. Similar cloning times to Clonedb. From there is was on to Cloud Control 12c Change Management, using the lifecycle management pack. After doing that, it was demo time, with a demo for everything covered in the session. Even with the power of modern day laptops, I am always nervous of live demos of Cloud Control. It’s resource eating beast… The ZFS and cloning demos worked fine, but there were some issues with the change management pack demo because of the amount of stuff running on a single laptop. It was a pity, but such are the joys, and pains, of live demos. I’ve been there myself several times. I definitely need to spend some time looking at the snapshot clones of PDBs in 12c.

My first sessions was “Pluggable Databases : What they will break and why you should use them anyway!” When I did this at Oracle Midlands #8 it was described as scary by a couple of people. I tried to lighten it a little this time, so I hope I didn’t scare anyone. :)

After my first talk it was off to lunch, where I got to meet up and chat with a bunch of people, which is really the best part of any conference. Can we have the soup in mugs next time please? :)

Next up was Marcin Przepiorowski from Delphix  speaking about “How To Avoid Boring Work – Automation For DBAs”. When I tweeted this one of the replies asked if it was a Delphix sales pitch. One of the things I like about companies like Delphix, Dbvisit, Enkitec and Pythian is they send people out to conferences without forcing them to do the hard sell. Marcin is a Delphix employee, but this session wasn’t anything to do with Delphix. It started off with examples of using Cloud Control to automate tasks, then moved on to using Ansible. I’ve not used Ansible, but it looks pretty neat for automation of tasks across your whole server real estate. It’s on my to-do list.

My second session was “A Cure for Virtual Insanity: A vendor-neutral introduction to virtualization without the hype“. I was kind-of expecting nobody to turn up to this session as there was a whole bunch of great sessions on at the same time and it wasn’t directly about Oracle. As it turned out I was pleasantly surprised. I like doing this session. It’s quite light and fluffy, but allows me to dispel some of the FUD associated with virtualization.

Next up was the closing keynote by Maria Colgan. Apparently, the In-Memory Column Store is a software version of walking into a pub, standing on the bar and asking which of the blokes is suitable relationship material. I tried this once and couldn’t walk straight for days. :) Maria also picked up her UKOUG lifetime achievement award for winning the best speaker prize three times. This means she can no longer be selected as best speaker, which makes it that much easier for the rest of us… :)

After the closing keynote it was drinks and nibbles then the event was over.

Thank you messages in the next post…

Cheers

Tim…

OUG Ireland 2015 : The Journey Begins

The day started early, about 1 hour before my alarm in fact. I got up, lay in the bath for a while drinking a can of Monster and considering the day ahead, got out of the bath, puked, then got my shit together ready for the taxi. I’ve been ill this week. That combined with sleep deprivation, nerves and the Monster kinda turned my stomach.

The taxi ride to the airport was really good. The driver was a really cool bloke and I enjoyed talking to him.

I arrived at the airport with a couple of hours to spare. It’s a bit silly for such a short flight when I have to check in online and I only have a laptop as baggage, but I would rather be early than late for my £27 flight to Dublin. :)

We got seated in the plane and were told we had a 60 minute delay. One guy started to freak out. It was like an episode of the Jeremy Kyle show. I was waiting for someone to come in with the DNA results, to prove he was not the father of the baby etc. No punches were thrown…

We ended up taking off about 50 minutes late. My first session was after 12:00, so I wasn’t too worried. The girls next to me used the time to do their make-up. Apparently it takes about 40 minutes to achieve “the natural look”. The combination of that, the selfies and the giggling about stuff on Snapchat made me feel very old!

On arrival it was a quick taxi ride to Croke Park, then OUG Ireland started for me.

Cheers

Tim…