Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: upgrade
From Database 18.3 to 18.5 (on Windows)
Contrary to wild rumours on the internet, it was not a fear of the number 13 that led to a numbering jump from version 12c to version 18c. The jump was part of our new, more flexible release mechanism so that we can get…
My APEX 18.2 upgrade in a nutshell
As always, you should read the Installation/Upgrade manual from top to bottom before upgrading any piece of software, and be aware of all of the pre-requisites and processes. But for me, my Application Express 18.2 upgrade was as simple as: Download Application Express Unzip…
18.2 patch… painless for me
18.2 was released a few days ago, so I thought I’d throw it against my 18c instance and see how things played out. This was just a single instance database, running with a single pluggable. Step 1 for me was to download the latest…
18c–If you can’t wait
You’ve seen the tweet !! but perhaps the accompanying blog post has tempered your enthusiasm You might be thinking: “I’m not on Exadata – how can I play with 18c?” Well, there is still a way to get ahead of the game and skill…
Oracle Database 18c
Yup…it’s arrived! New name obviously, because we’ve jumped to our new naming model to align with the calendar year as opposed to version number. You might be thinking “So what?” but it’s a significant change in the way we getting software to customer. Mike…
Upgrade with no effort
We all know what upgrades mean. Installation…Configuration…Patching…Testing…Deployment…Change approvals…Meetings…Long hours…Perhaps pulling an “overnighter” but hopefully never having to enact the dreaded “Backout Plan”. Or…. that stuff can “just happen” without you worrying about it at all! I logged on to my Exadata Cloud Express database…
Apex upgrade 4.2 to 5.0.2
Just a quick note for anyone upgrading Apex on their systems. The installation (into a non-multitenant 12.1.0.2 instance) went through with no problems, but tracing the installation suggests it will flush the shared pool 6 times during installation/upgrade. That might have some impact on…
Virtualbox 5.0
I like it when stuff just “works”. I’ve been using Virtual Box 4 for a long time now, and since my needs are relatively simple (ie, run a VM!) then I’ve not had any great cause to move to version 5. But today I…
Upgraded and can’t see the tables you could before ?
If you take a look at the “alter user” command in the old 9i documentation, you’ll see this: DEFAULT ROLE Clause Specify the roles granted by default to the user at logon. This clause can contain only roles that have been granted directly to…
Cross-platform database migration
Last weekend, we faced one of the larger challenges that we’ve faced in my time at my current client. Migrate multiple database systems, across multiples sites, all to new hardware (with new endian format), new database version (12.1.0.2)…and of course, try to do it…
Edition based redefinition – an apology
In April 2008 (wow, does time fly!) I used the following picture in my “11g features for Developers” presentation at the Australian Oracle User Group conference. I think the picture is from the movie “Indiana Jones and the Last Crusade”… where they sought the…
Upgrade to 12c … credentials
We did a “real” upgrade to 12c this weekend, where “real” means a production system, as opposed to my laptop, a play VM etc etc 🙂 It all went relatively smoothly except for one interesting thing, that I can’t 100% say was caused by…
