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…

OOW 2018: Upgrade to Oracle 18c – Live and Uncensored

Less than two weeks until the potentially busiest Oracle Open World conference I’ve ever attended. The schedule is filled up already and closed down. And I’m pretty sure I will need time off afterwards to relax and recover. But I’m looking forward to our annual big event in San Francisco. To make it as exciting as possible for you we are very happy to have high profile speakers with us in all our talks. And we promise: No marketing. Just tech facts. If you’d like to sneak into OOW 2018: Upgrade to 18c – Live and uncensored, then mark your…

New Oracle Database Upgrade Lab for Oracle 18.3.0

New Oracle Database Upgrade Lab for Oracle 18.3.0 Our new and updated Oracle Database Upgrade Hands-On Lab for Oracle 18.3.0 is finally live and can be downloaded via this link: Download Database Upgrade 18.3.0 Hands-On Lab What’s new? Of course, Oracle 18.3.0 is inside to upgrade to. But we changed the entire instructions set a bit. We included a simple load generator. And we added way more performance stuff. And of course fallback. As soon as Oracle 18.4.0 becomes available, patching will be included in the instructions as well. Everybody should have used OPatch at least once 🙂 What’s in…

Oracle Multimedia is deprecated in Oracle 18c

While I was writing the blog post about Creating CDBs and non-CDBs with less options I realized that Oracle Multimedia is deprecated in Oracle 18c – but I haven’t mentioned this here yet. Oracle Multimedia is deprecated in Oracle 18c Oracle Multimedia was called Oracle Intermedia a long time ago when we introduced it back in the Oracle 8i days. I don’t know how many people really used it, but it is part of a standard installation if you didn’t explicitly turned it off or deinstalled it. And from Oracle 18c on, Oracle Multimedia is deprecated. Meaning, it won’t develop…

Oracle ORAchk and EXAchk Version 18.3.0 are released

If you are a regular user of ORAchk and/or EXAchk, you should download the most recent and newest version as Oracle ORAchk and EXAchk Version 18.3.0 are released now. Oracle ORAchk and EXAchk Version 18.3.0 are released The new features you’ll find in ORAchk 18.3.0 and EXAchk 18.3.0 include: Beta Support for Oracle Private Cloud Appliance In EXAchk Health Check Catalog under the Engineered systems of Private Cloud Appliance and Private Cloud Appliance Plane. Automatic start from TFA install Oracle Trace File Analyzer root installations on Linux or Solaris on non-engineered systems will automatically setup and run the ORAchk daemon.The…

Oracle Database 18.3.0 on SPARC Solaris is available

Usually I don’t post twice on a day, especially not on a Friday and not in the holiday season. But since last night, Aug 2, Oracle Database 18.3.0 on SPARC Solaris is available for download from OTN. Oracle Database 18.3.0 on SPARC Solaris is available You can download it from OTN: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html And I couldn’t find it on eDelivery – where I find only the 18.1.0 version. But I simply may be not clever enough to use the right search phrase (I used “Oracle Database” as “18” leads to something different). Further Information Oracle Database 18.3.0 on premises is available…

How long can you provision database version X in the Cloud?

That’s a question I have gotten several times already: How long can you provision database version X in the Cloud? Meaning, is there a fixed date when you’ll be unable to provision an instance containing Oracle Database 12.1.0.2 for instance? How long can you provision database version X in the Cloud? First of all, it is important to note that the support time frames between on-prem and cloud are the same. But it is also important for you to notice that after a certain date you won’t be able to provision an instance with a specific database version anymore. And…

9 Upgrade and Migration Scenarios

Our doc team has put a lot of effort together with the help of my team mates and created these 9 Upgrade and Migration Scenarios as part of the official Oracle documentation. The idea is to cut out the most common use cases and give a quick and comprehensive overview on all necessary steps. 9 Upgrade and Migration Scenarios These comprehensive 9 scenarios cover non-CDB and PDB/CDB as well as changing to new hardware: Migrating and Converting Non-CDBs to a PDB with a Different Endian Operating System HTML PDF Show Details Migrating Non-CDBs to New Hardware with a Different Endian…

Clarification: Support Periods for Oracle 12.2.0.1 and 18c

Monday morning, another way-too-hot July day. Summer is crazy this year in Europe. We all enjoy nice sunny weather but nobody does enjoy a serious drought. Nowhere. While going through my inbox I spot this statement: ““Why should we go to 18.x with support till 2020?“. And this is not an unusual question. But I think I should write a Clarification: Support Periods for Oracle 12.2.0.1 and 18c. I receive plenty of such questions in the past weeks. And actually many from my colleagues. Clarification: Support Periods for Oracle 12.2.0.1 and 18c First of all, your Single Source of Truth…

Oracle 18.3.0 on premises includes 1.4GB patches?

Oracle Database 18.3.0 on premises is available for download on Linux since July 23, 2018. The other ports will follow soon. And via twitter I received a question why Oracle 18.3.0 on premises includes 1.4GB patches? Oracle 18.3.0 on premises includes 1.4GB patches? When you unzip the downloaded database image: then you may discover the following folder .patch_storage of 1.4GB size: [oracle@localhost .patch_storage]$ ls -lrt total 40 drwxr-xr-x. 4 oracle dba 4096 Jul 18 19:39 28090523_Jul_14_2018_00_03_50 drwxr-xr-x. 4 oracle dba 4096 Jul 18 19:40 28090553_Jul_11_2018_19_20_31 drwxr-xr-x. 4 oracle dba 4096 Jul 18 19:41 27923415_Jul_15_2018_10_33_22 drwxr-xr-x. 8 oracle dba 4096 Jul…

Oracle Database 18.3.0 Upgrade on premises

As Oracle Database 18c is now available on Linux on premises, I blogged about the installation already. And the next logical step is the Oracle Database 18.3.0 Upgrade on premises. In this case I will show an upgrade on the command line from Oracle 11.2.0.4 to Oracle 18.3.0. A DBUA upgrade will follow in a separate blog post later. Oracle Database 18.3.0 Upgrade on premises Before you can start with the upgrade, you may download the software first, and then install it: Oracle Database 18.3.0 on premises is available on Linux Oracle Database 18.3.0 Installation on premises If you read…

Oracle Database 18.3.0 installation on premises

Oracle Database 18.3.0 is available on Linux since July 23, 2018. And I wanted to quickly sneak into the Oracle Database 18.3.0 installation on premises. I did blog about the Oracle 18c installation a few weeks ago but this was a plain 18.1.0. This time I install the 18.3.0 on-prem edition for Linux. Oracle Database 18.3.0 installation on premises Are the any differences between an 18.1.0 and the 18.3.0 installation? No, there aren’t any (at least not anything I recognized). The most important thing: you must unzip the downloaded file into your future destination directory. In my case I unzip:…

ZDLRA ready for Oracle Database 18c

ZDLRA is one of the best acronyms ever. It took me 5+ years to not mix up the sequence of characters 🙂 And even Larry made a joke about the name a while ago at his OOW keynote (I think it was 2016). ZDLRA stands for Zero Data Loss Recovery Appliance. And that basically tells you what it is. Hence, it isn’t a bad acronym as it tells you straight forward what it does. Good news: ZDLRA ready for Oracle Database 18c. ZDLRA ready for Oracle Database 18c Why am I writing about this? Some of the customers I’m working…

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…

Oracle Fail Safe 4.2.1 is available for Oracle 12.2

It took a while – we know. But finally Oracle Fail Safe 4.2.1 is available for Oracle 12.2. You may not see the MOS notes being updated with certification information. Still you can download the software from oracle.com. This version is certified with Oracle 12.2.0.1. You should be able to use it with Oracle 18c as well but we’ll add another certification notice soon. What is Oracle Fail Safe? Oracle Fail Safe is a core feature included with every Oracle Database license for Windows Server. It is a high availability software, integrated with Microsoft Failover Cluster, that provides a fast,…

_optimizer_ignore_hints is now optimizer_ignore_hints

I’m refreshing our Hands-On Lab for Oracle Database 18c. And as part of a performance evaluation I wanted to set an underscore parameter to ignore all hints my load test tool sets. But then I learned: This does not work anymore as _optimizer_ignore_hints is now optimizer_ignore_hints. We made the underscore obsolete in Oracle Database 18c. _optimizer_ignore_hints is now optimizer_ignore_hints Actually in Oracle Database 12.2.0.1 you can find a long list of obsolete parameters here: Obsolete Parameters in Oracle Database 12.2.0.1 (Nov 10, 2016) To be precise: We obsoleted159 parameters. In addition, in Oracle Database 18c we added an additional 8…

Patching Oracle Database 18.1.0 to 18.2.0 on premises

In this part of my blog post series about upgrading from Oracle 12.2.0.1 to Oracle 18c I’d like to demonstrate patching Oracle Database 18.1.0 to 18.2.0 on premises. A while ago I showed also how to patch from Oracle 18.1.0 to 18.2.0 in the Oracle Cloud. Find the related blog posts here: Deinstalling Oracle Database 12.2.0.1 Installing Oracle Database 18.1.0 Patching Oracle 18.1.0 to 18.2.0 Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises Patching Oracle Database 18.1.0 to 18.2.0 on premises Before I can start patching to the Release Update Oracle 18.2.0 I need to download the patch and a…

Installing Oracle Database 18c

This blog post about Installing Oracle Database 18c applies to all Oracle 18c releases. I wrote a while ago about one very important change: Oracle Database 18c – Some Important Changes and explained that the installation is now image based. You’ll find other posts as part of my series on how to install and upgrade to Oracle Database 18c here: Deinstalling Oracle Database 12.2.0.1 Installing Oracle Database 18.1.0 Patching Oracle 18.1.0 to 18.2.0 Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises Installing Oracle Database 18c Oracle Database 18c on-premises is supposed to be generally available with the July 2018 Update….

When you patch, please use UPDATES – and not REVISIONS

I can just repeat what I’m saying not for almost a year: When you patch, please use UPDATES – and not REVISIONS. Updates (or Release Updates – short: RU) and Revisions (or Release Update Revisions – short: RUR) are patch bundles for the Oracle Database since Oracle 12.2.0.1. There are no PSUs (Patch Set Updates) anymore. And Revisions are not the same as PSUs. When you patch, please use UPDATES – and not REVISIONS One of the reasons why we recommend Updates, and not Revisions, simply is: Updates keep you more current whereas Revisions will let you miss a lot…

Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic)

I was quite surprised when I spotted the Update (RU) Oracle 18.2.0 mid of April in my OCI Classic (DBCS, DBaaS) account. Of course I was thrilled immediately and started the patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic). Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic) The April 2018 Updates (and Bundle Patches and Patch Set Updates for Oracle releases below 12.2) got released on April 17, 2018. You can read more here on how I applied all of them to my Oracle 11.2.0.4, 12.1.0.2 and 12.2.0.1 databases. But I was positively surprised when I…

Purging of PDB_PLUG_IN_VIOLATIONS in Oracle 18c

PDB_PLUG_IN_VIOLATIONS is a strange view in the Oracle database universe. It does not follow Oracle naming conventions – and it has too many underscores in its name. Furthermore I get always annoyed by the fact that it doesn’t get purged automatically. In addition it accumulates a massive number of useless information over time. But in Oracle Database 18c there’s a least some relief: A new call gets introduced which allows purging of PDB_PLUG_IN_VIOLATIONS in Oracle 18c. PDB_PLUG_IN_VIOLATIONS As others have written a lot already about PDB_PLUG_IN_VIOLATIONS I won’t repeat it but rather share the links with you: https://martincarstenbach.wordpress.com/2016/06/29/tales-from-the-field-potential-reasons-for-pdb-plug-in-violations-part-1/ https://martincarstenbach.wordpress.com/2016/07/14/tales-from-the-field-potential-reasons-for-pdb-plug-in-violations-part-2/ https://blog.dbi-services.com/12c-multitenant-internals-pdb_plug_in_violations/…

Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud

There’s been silence for a while – but today I’d like to show you how to unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud. I’m doing this exercise because I’ve seen questions already. And I was curious if it works as I’d expect it. Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud As usual I will use our hands-on lab environment – and a freshly deployed 18c OCI-Classic instance (formerly known as DBCS formerly known as DBaaS). It is a Single Tenant environment with one PDB. If you need for information about how to…

When will Oracle Database 18c be available on-prem?

When will Oracle Database 18c be available on-prem? Some of you will answer: It is available already, isn’t it? And you are right. But I don’t want to blog just a marketing message but some facts. Others may ask: When will it be generally available on-premises? ==> July 23, 2018: Linux 18.3.0 on-prem is available – please click here <== When will Oracle Database 18c be available on-prem? As of today, March 20, 2018, Oracle Database 18c is available already in/for: OCI and OCI-C Database services LiveSQL.oracle.com Oracle Exadata and SuperCluster on premises Oracle Database Appliance (ODA) on premises Actually…

Oracle Database 18c: A new preupgrade.jar is available

In case you plan to upgrade a database to Oracle Database 18c: A new preupgrade.jar is available for download from MyOracle Support (MOS). Oracle Database 18c: A new preupgrade.jar is available Please download it – as always – from MOS Note:884522.1. The same MOS note will get you also the most recent versions of the preupgrade.jar for Oracle Database 12.2.0.1 upgrades. Of course you can download also all previous incarnations such as preupgrd.sql for 12.1.0.2 upgrades and even utlu112i.sql for 11g upgrades. What’s new in preupgrade.jar for Oracle 18c upgrades? There are a few important and good Improvements and new…

DBMS_OPTIM_BUNDLE Package in Oracle 12.2 and 18c

Yes, I did blog about the DBMS_OPTIM_BUNDLE package in earlier Oracle releases before. And I thought (and it was documented this way) that it will disappear in Oracle 12.2 and newer. But in fact you’ll find the DBMS_OPTIM_BUNDLE package in Oracle 12.2 and 18c. Most likely … This is a very interesting case and you may see also my previous blog posts: DBMS_OPTIM_BUNDLE – only available in Oracle 12.1.0.2 – or not? Fixes for Adaptive Features are included in Oracle 12.1.0.2 October 2017 BP Package Differences between Oracle 11.2.0.4 and 12.1.0.2? DBMS_OPTIM_BUNDLE Package in Oracle 12.2 and 18c First of…