I‘m on record as saying that I would no longer maintain Gladstone, my Oracle pre-installation, prerequisite-fulfilling script. But with the release last week of Oracle 12c, I felt I should at least try to see if I could adapt Gladstone to work with it, in part because I still find the script a useful way of quickly building standalone Oracle servers which have Internet access.
Well… happily, I have adapted Gladstone and it does work with 12c: in fact, the 12c and 11g installation prerequisites are almost identical. Cunningly, Oracle appear to have implemented subtler ‘distro checking’, so that 12c installations on CentOS and Scientific Linux produce ‘this system doesn’t meet minimum requirements’ errors (even though they do!) Fortunately, such messages can be ignored, and the installation proceeds to completion without further drama. If I find out how Oracle have performed this check (unsurprisingly, perhaps, OEL passes with flying colours!), I’ll implement a workaround to suppress the alarming-looking messages. In the “old days”, we’d just hack the contents of /etc/redhat-release to achieve that, but it looks like Oracle have wised up to that! Investigations continue…
Anyway, the new 12c-enabled version of Gladstone is available from the usual place.
Ubuntu, Fedora, Mint, Sabayon and Debian users will have to stick to 11g, though, because I’m sticking to my guns on that one: non-distros are no longer something I care about.
As for 12c itself? Well, it’s obviously early days. But I have three observations:
- The multi-database model is a revolutionary change for Oracle and makes things much more like SQL Server, in fact: one installation of the software, one set of memory/processes, multiple databases. I am currently running a single database that has been used to house half a dozen different applications in a feeble attempt at “consolidation”, and it’s a royal pain to manage and tune (“No, you can’t take the database down to do that bit of vital patching tonight, because we are doing period-end procedures, though we realise no-one else is…”). I am looking forward to the new model simplifying shared-database environments. I don’t suppose I’m going to be allowed to have different plugin databases at different patch levels though (though I’m still reading the doco, so we shall see).
- RMAN acquiring the ability to restore individual tables looks interesting. The command syntax makes me think that it’s still creating an auxiliary database, recovering the table, exporting it and importing it back into the live database …and none of that would be new. It’s how you’ve done tablespace point in time recoveries since Year Dot. But to have it all in one tool with one bit of syntax looks like a nice step forward.
- I cannot believe that in this day and age, Oracle Corporation would willingly choose to inflict a Flash-ridden piece of crapola like the new 12c Database Express on anyone. But sadly, the replacement for earlier versions’ DB Console Enterprise Manager is entirely dependent on Flash. Given Oracle’s own atrocious security record with gems like Java, it is astonishing they’d inflict browser-based Flash plugins on IT Professionals. I can only assume the Oracle HTML5 team were off on a skiing holiday at the time… All that said, it’s a good tool to manage a database with (if you like GUI tools, of course!)