Oracle Database 18c for AIX, HP-UX and zLinux available

I rarely blog twice a day – but this message is the one a good number of people have waited for quite a while. Oracle Database 18c for AIX, HP-UX and zLinux available for download from eDelivery as of now. The software is not on OTN or oracle.com yet in the usual download section. I’m blindly guessing that it will be there soon, maybe tonight already. Oracle Database 18c for AIX, HP-UX and zLinux available → Please go to eDelivery (also known as the Oracle Software Cloud) and type into the search line: “Oracle Database” – then hit “Search“. →…

Current Support Status for Oracle Database Releases

Yesterday a former colleague from the UK pointed me to a very old blog post about the fact that no patches will be produced for Oracle 11.2.0.3 anymore. Which is a true fact. But it reminded me that it may be time for an overview on the current support status for Oracle database releases as of October 2018. Current Support Status for Oracle Database Releases First of all, the single source of truth in case you’d like to look up support dates and patching periods is MOS Note:742060.1. Please always check this note first. Our Support Lifetime Policy brochure does…

OOW2018: The new AutoUpgrade for the Oracle Database

As I wrote the other day, OOW 2018 is not too far away anymore. And if you’d like to see something really new, something which can really really ease your database upgrades in the near future, then you may visit our first talk right on Monday morning at OOW2018: The new AutoUpgrade for the Oracle Database. What is this talk all about? First of all, let me emphasize that we don’t do marketing. We would like to introduce you to a brand new tool we’ll currently have in beta operation at selected customers. And which we’ll release in the new…

Video: The New Database Release and Patching Model

The last Office Hours I’ve run about the New Release and Patching Model didn’t go very well technically. I’ve had screen/display issues. And Steven Feuerstein tried to save the best parts – but despite Steven’s awesome work neither him nor I did really like the result. So I decided that it may be better to record a Video: The New Database Release and Patching Model again (which I actually planned for quite a while already anyway. Video: The New Database Release and Patching Model The video is based on the slide deck you’ll find in the Slides download section of…

What does DEPRECATED mean? And DESUPPORTED?

There’s sometimes a misunderstanding about what we mean with the term DEPRECATED? And what is the difference to DESUPPORTED? Actually there’s a full chapter in the Database Upgrade Guide listing deprecated and desupported features. Deprecated and Desupported – Oracle Database 12.1.0.2 Upgrade Guide Deprecated Especially this message puzzled a lot of customers stating that the non-CDB architecture is deprecated in Oracle Database 12c. In the Database Upgrade Guide we clearly explain what deprecated means: “By deprecate, we mean that the feature is no longer being enhanced but is still supported“ So for you it means just be aware that we…

It’s always the Optimizer, isn’t it?! – Part 1

Wouldn’t you agree? My colleagues from the Optimizer Development might forgive me but a lot of people would say: “Everything went fine after upgrade – except for those tiny 3 queries!”. And I know, you have tested a lot. I’d like to tell you about a few issues we’ve seen post upgrade with 11.2.0.2. You have captured your plans in Oracle 10.2 pre-upgrade. You have moved these plans from your SQL Tuning Set into the SQL Plan Baseline in Oracle 11.2. But the optimizer doesn’t pick them although you have: (a) ACCEPTED and (b) FIXED them. Why? It might be…