Premier Support Extension for Oracle 19c – and more

Wait a bit. Oracle Database 19c is not out yet (only in beta right now) but how can we initiate a Premier Support Extension for Oracle 19c already? Well, Oracle 12.2.0.1, Oracle 18c and Oracle 19c all together sail under the cover of the “Oracle 12.2 Release Family” and hence have a common support frame. What has been announced? The single-source-of-truth MOS Note:742060.1 got updated. Roy tweeted about it already. And the major change in the note is the extension of the Premier Support for Oracle 19c until March 2023. That is one year more than it was before. And…

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

A few weeks ago I published a blog post about provisioning dates in Oracle Cloud environments for different databases releases. As we did an important update, I rewrite today: How long can you provision database version X in the Cloud? – NEW. What has changed since the original post? The key point in the previous blog post was: “And by end of this calendar year, the option to provision an Oracle 12.2.0.1 instance will go away. The same will happen in less than 1 year with Oracle 11.2.0.4 instances.”. With “this calendar year” I pointed to end of 2018. That…

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…

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? Please find the updated blog post here: How long can you provision database version X in the Cloud? – NEW –Mike

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…

Deinstalling Oracle Database 12.2.0.1

This is part of a blog post series where I install Oracle 18c on-premises in our Hands-On Lab and upgrade the Multitenant 12.2.0.1 database as well. But in order to save space, deinstalling Oracle Database 12.2.0.1 is my next task. You find all the blog posts connected to each other 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 Deinstalling Oracle Database 12.2.0.1 In the Oracle Installation documentation you’ll find this part: Removing Oracle Database Software The documentation lists two removal options: Deinstallation with the Oracle Universal…

RMAN backup generates traces in Oracle 12.2.0.1

Oracle 12.2.0.1 seems to be the “tracing” release without further patch or parameter treatments. After posting about MMON unconditional traces in Oracle 12.2.0.1 a day ago, I received a couple of comments either on the blog, via LinkedIn or Twitter regarding other trace facilities in Oracle Database 12.2.0.1. One of them is the case that RMAN backup generates traces in Oracle 12.2.0.1. And please, very important upfront: Oracle Database 12.2.0.1 is a very stable and reliable release based on all the customer feedback Roy and I received so far. For instance, when we check for optimizer issues causing trouble in…

MMON unconditional traces in Oracle 12.2.0.1

I love visiting customers onsite. Last week I visited die Mobiliar in Bern, Switzerland. I received a list of open issues to discuss – which is very good to prepare a visit. And when we all were sitting together there was this “Ah, one final thing”. They have an issue with traces the databases writes every few seconds. As a remedy the DBAs increased the backup interval to remove the traces as otherwise the system would potentially run out of inodes or space. All the traces had the same pattern. And I learned quickly: these are MMON unconditional traces in…

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…

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…

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…

Oracle Database 12.2 on Oracle Database Appliance (ODA)?

“Can I download and install Oracle Database 12.2 on Oracle Database Appliance (ODA)?” I received such questions multiple times in the past weeks by different customers. One did ask me about their older X5-2, another person wanted to know where to download the image. At RMOUG somebody asked me when ODA will apply Bundle Patches (or Updates) instead of PSUs? And thanks to my PM mate Tammy Bednar, here’s the information also as a reminder to myself. ODA stands for Oracle Database Appliance – it is an engineered system of software, servers, storage and networking that offers a simple, reliable, low-cost…

Don’t drop the AUDSYS user before upgrading

This is a very interesting case Martin Berger sent to me a week ago. A colleague and him were basically wondering if they should follow the advice in the Oracle 12.2 upgrade guide and drop the AUDSYS user, or if they better don’t drop the AUDSYS user before upgrading. What is AUDSYS meant for? In short, it is the auditing user schema for Oracle 12c and especially Unified Auditing. You’ll find a bit more information regarding Unified Auditing on this blog: Unified Auditing – is it ON or OFF in Oracle 12.1.0.2? Unified Auditing – is it ON or OFF…

DBCA 12.2 does not update /etc/oratab in GI / RAC

Interesting things happen. And I learned (credits to Arun Gupta and others) that there is a change in Oracle Database 12.2 environments I wasn’t aware: The DBCA 12.2 does not update /etc/oratab in GI / RAC environments. Let me give you some extra information and hints on this topic as it may cause some strange situations. DBCA 12.2 does not update /etc/oratab in GI / RAC Arun Gupta commented on the blog: Another case in point. DBCA fails to update the /etc/oratab file in 12.2 when a database is created. There is no documentation of this behavior. So, I opened…

Differences between PSU / BP and RU / RUR

Since Oracle Database 12.2.0.1 we change our patching model as well, switching from Patch Set Updates (PSU) and Proactive Bundle Patches (BP) to Release Updates (RU) and Release Update Revisions (RUR). But what are actually the differences between PSU / BP and RU / RUR patch bundles? Is there any or is it just a renaming of well known patch bundles? No change on MS Windows First of all, let me say that there won’t be any changes on the Windows platform. If your preferred operating system is MS Windows then stop reading here. On Windows you’ll see exactly the…

Create Multitenant databases with DBCA – Things to Know

When you create Multitenant databases with DBCA there are some Things to Know. And in Oracle Database 12.2.0.1’s Database Creation Assistant (DBCA) there is a common pitfall in the “Options” screen. It was grayed out in the previous release but when you choose to create a “custom” database you can select the options/components now. Be careful … Previous posts I did blog several times about the DBCA already: Always create databases as customer databases Use your own templates in DBCA when you create databases Does DBCA execute datapatch in Oracle Database 12.2? Create Container databases with less options And there…

September 2017 releases of preupgrade.jar and preupgrd.sql are available

On a regular basis the Database Upgrade Team releases new and improved versions of the preupgrade tools via a MyOracle Support note. And it’s time again: the September 2017 releases of preupgrade.jar and preupgrd.sql are available for download. September 2017 releases of preupgrade.jar and preupgrd.sql are available Please ALWAYS download the most recent versions of preupgrade.jar for upgrades to Oracle Database 12.2 and preupgrd.sql (including utluppkg.sql) for Oracle Database 12.1.0.2 upgrade from MOS Note: 884522.1. The version you’ll download is way newer than the version you’ll get with the base installation. preupgrade.jar – Rel.7 – September 2017 Please find the…

New version of preupgrade.jar (build 5) is available

There’s a new and improved version of the preupgrade.jar (build 5 – May 2017) available for download from MyOracle Support: MOS Note:884522.1: How to Download and Run Oracle’s Database Pre-Upgrade Utility The same note will get you access also to the most recent builds of preupgrd.sql for upgrades to Oracle Database 12.1 and utlu112i.sql for the unlikely event you’ll have to upgrade a database to Oracle 11.2.0.4. Please always exchange the version getting installed by default with the version we offer via MOS Note:884522.1 as the downloadable version is usually much newer and improved over the one getting deployed with the…

Is “imp” still supported in Oracle Database 12.2?

Good question we receive quite often: Is “imp” still supported in Oracle Database 12.2? For clarification: I don’t talk about “impdp” but about old “imp” (import). And yes, it is still supported in Oracle 12.2. The old “exp” got desupported with Oracle Database 11.1.0.6 – but “imp” is still supported, even in Oracle Database 12.2.0.x. You should be able to import your old dumps into the newest release of the database and migrate even VERY old releases directly to Oracle Database 12.2. Actually, the biggest step upwards we’ve heard about a year ago was an exp from Oracle V5 and…

Oracle 12.2.0.1 Bundle Patch 12.2.0.1.170516 DBBP on Linux x86-64 is available [not anymore]

All credits go to Ricardo Maeda as I knew that we’ll release a Bundle Patch for Oracle 12.2.0.1 sometime this week – but I couldn’t find it linked from the usual MOS notes. And please don’t ask my why that is. Anyhow, with patch 2579308 you’ll get access to the first BP for Oracle Database 12.2.0.1. There will be a first bigger Proactive Bundle Patch in July at the usual schedule – but this one is at least a start. Plus in addition get the OPatch version 12.2.0.1.7 via patch 6880880. The BP contains: Obrigado, Ricardo! Update June 9, 2017…

GIMR DB in Oracle Database 12.2

I did blog in the past already about the Grid Infrastructure Management Repository Database (GIMR DB): Grid Infrastructure Management Repository (GIMR)database now mandatory in Oracle GI 12.1.0.2 SID and DBNAME are kept the same in Oracle Database 12.2. But there are a few changes and additions in Oracle Database 12.2.0.1. GIMR DB in its own Disk Group During a fresh installation of Oracle Grid Infrastructure 12.2.0.1 you’ll have the chance to create a disk group for GIMR DB: But you can migrate GIMR DB into a separate disk group as well – just make sure the size is large enough…

PGA_AGGREGATE_LIMIT enforces default since Oracle Database 12.2.0.1

The init.ora/spfile parameter PGA_AGGREGATE_LIMIT got introduced in Oracle Database 12.1.0.1. As per documentation in Oracle Database 12.1 it got defined as: “PGA_AGGREGATE_LIMIT specifies a limit on the aggregate PGA memory consumed by the instance.“. Furthermore the algorithm for its setting got described as: “By default, PGA_AGGREGATE_LIMIT is set to the greater of 2 GB, 200% of PGA_AGGREGATE_TARGET, and 3 MB times the PROCESSES parameter. It will be set below 200% of PGA_AGGREGATE_TARGET if it is larger than 90% of the physical memory size minus the total SGA size, but not below 100% of PGA_AGGREGATE_TARGET.” Default Value Change in Oracle Database…

Is your APEX version certified with your Database release?

Last week I’ve had an interesting discussion with a customer about the certification of APEX and Oracle Database 12.2.0.1. I did a bit of research and emailing – and thanks to the APEX team – this is the source of truth for APEX certifications. Minimum Database version for APEX See MOS Note:1344948.1: Application Express (APEX) Database and Web Server Certification Reference: For APEX 4.0, the minimum database version is 10.2.0.3 For APEX 5.0, the minimum database version is 11.1.0.7 For APEX 5.1, the minimum database version is 11.2.0.4 Minimum APEX version per Database See MOS Note:1344948.1: Application Express (APEX) Database…

What happens to PASSWORD_VERSIONS during an upgrade to Oracle 12.2?

I did blog a day ago about ORA-1017 connection issues in Oracle Database 12.2 once you would like to use the deprecated init.ora/spfile parameter SEC_CASE_SENSITIVE_LOGON=FALSE: Having some fun with SEC_CASE_SENSITIVE_LOGON and ORA-1017 But how can this change actually happen? Let’s check how the PASSWORD_VERSIONS is set in a fresh Oracle Database 12.1.0.2 database with the January 2017 Proactive Bundle Patch applied to it: SQL> select username, password_versions from dba_users order by 1; USERNAME PASSWORD_VERSIONS —————————— —————– ANONYMOUS APPQOSSYS 10G 11G 12C AUDSYS 10G 11G 12C DBSNMP 10G 11G 12C DIP 10G 11G 12C GSMADMIN_INTERNAL 10G 11G 12C GSMCATUSER 10G 11G…