RMAN Backup Gives RMAN-06091: No Channel Allocated for Maintenance

I really don’t want to turn this blog into an accumulation of issues and flaws. But as I explained many times before, the blog for me is also a way to dump information I likely will need the sooner or later again. Recently I blogged about another RMAN issue in Oracle 12.2.0.1 with traces. This was fixed with the July 2018 RU for Oracle 12.2.0.1. But the issue below about which Piero Ferraz from Brazil alerted me (thanks!!!), happens in exactly this RU. RMAN Backup Gives RMAN-06091: No Channel Allocated for Maintenance This issue gets introduced with the July 2018…

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…

Long Identifiers in Oracle 12.2 may cause trouble

LONG identifiers are one of the key features in Oracle Database 12.2.0.1. But as I learned the other day, you should be a bit careful when you exchange data between different databases. In certain situations, Long Identifiers in Oracle 12.2 may cause trouble. What are Long Identifiers? Long identifiers get introduced with Oracle Database 12.2.0.1. For ages, you could name a table or a column or a user or a package in Oracle with only 30 byte length. Hence, naming a table TAB_THIS_IS_MY_TABLE_AND_I_LIK is ok (30 byte – 30 characters) but naming it TAB_THIS_IS_MY_TABLE_AND_I_LIKE_IT is not possible as it requires…

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…

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…

When does patching end for Oracle Database 12.2.0.1?

This question is coming up on a regular basis for obvious reasons whenever we speak to customers about Oracle Database 12.2 and 18c: When does patching end for Oracle Database 12.2.0.1? When does patching end for Oracle Database 12.2.0.1? Actually Roy and I are explaining this topic in our The New Release and Patching Model presentation: Annual releases, such as Oracle 12.2.0.1, Oracle 18c, Oracle 19c and so on, get a minimum of 2 years patching after the succeeding release is available. This means, as soon as Oracle 18c is available, the previous release – Oracle Database 12.2.0.1 – will…

How to rename a Pluggable Database

Have you ever asked yourself how to rename a pluggable database? I did. And today a colleague from ACS Support told me how easy it is. Of course I had to try it out. And it seems to work quite nice in Oracle Database 12.2.0.1. In the previous release I found some nits documented in MOS. How to rename a Pluggable Database There’s no obvious command to rename a pluggable database such as “alter pluggable database PDB1 rename to PDB2”. But it’s not complicated if you know the right command. I’m creating a fresh pluggable database: create pluggable database PDB1…

MOS Note:742060.1 got updated with Oracle 18c information

From the Support’s Hot Topics email I learned the other day that MOS Note:742060.1 (Release Schedule of Current Database Releases) got updated with Oracle 18c information on January 18, 2018. What got added to MOS Note:742060.1? A column for Oracle 18c got added to the table of releases. You will find not information about potential release availability for Oracle 18c in the various options of the Oracle Cloud, and of course for on-premises as well. Furthermore please find the updated graph as well.     The note below the graph is very important. See MOS Note:742060.1 for further details. –Mike

Minimum Supported Version for Database Upgrades

This question comes up very often: What is the minimum supported version for database upgrades? Or a question I received today: “I have an Oracle 10.2.0.4 database, can I upgrade directly to Oracle 11.2.0.4?” Usually I have to dig into my old slides from the past to give a definite answer. And of course, the Database Upgrade Guide of each version has the same information somewhere as well. Therefore I’d like to summarize the releases supported for direct database upgrades since Oracle 11.2.0.4 below. Upgrade? When I speak about database upgrades, I mean you’ll use either the command line upgrade…

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…

Behavior Change: READ privilege for user SYSTEM in Oracle 12.2

All credits here go to Marcel Pils from Logicalis, a German Oracle partner. Thanks Marcel! In Oracle 12.2 there’s an interesting behavior change: READ privilege for user SYSTEM in Oracle 12.2. Some Background Information In Oracle 12.1 the READ privilege has been introduced. Please find more information in the Oracle 12.1 Security Guide: New READ Object Privilege and READ ANY TABLE System Privilege for SELECT Operations. The idea behind the READ object and the READ ANY TABLE system privileges is that you can enable users query database tables, views, materialized views, and synonyms. But they can’t lock rows of the…

Should we wait for Oracle 19?

What a wonderful question: “We are on Oracle 11.2.0.4 right now. Should we wait for Oracle 19 because of the proposed long term support for this release?” I have gotten this question roughly 15 times in the past week, raised either by colleagues, customers or partners via email, twitter, in web conferences or (old fashioned way) on the phone. People refer to the graph printed in MOS Note: 742060.1. And I won’t replicate it here as this graph can change anytime. And it got adjusted just a few weeks ago as the support timeline for Oracle 12.2.0.1 was drawn too…

Oracle Database RU and RUR Recommendations and Facts

Well … another post about RU and RUR patches. But after having multiple discussions personally, via web conferences, in conference calls and of course on Twitter I think some clarifications may be helpful. Below you’ll find Oracle Database RU and RUR recommendations and facts. At least some of them … Oracle Database RU and RUR Recommendations and Facts First of all, you will find more information in several blog posts about RU (Release Update) and RUR (Release Update Revision) patches: PSU or BP? Patch Set Update or Bundle Patch? RUR or RU? (May 12, 2017) More Information about RU and…

Oracle GoldenGate 12.3 is supported for Oracle Database 12.2.0.1

Finally … it took a little while but now Oracle GoldenGate 12.3 is supported for Oracle Database 12.2.0.1. Never heard of Oracle GoldeGate? Then you may look either into our slide deck and see the customer case of Amadeus. Or you may read further on OTN: http://www.oracle.com/technetwork/middleware/goldengate/overview/index.html Oracle GoldenGate 12.3 is supported for Oracle Database 12.2.0.1 Roy and I received this question quite often in the past months: When will Oracle GoldenGate be certified for use with Oracle Database 12.2.0.1? I just learned about it today via the blog post of my friend YV RaviKumar who wrote about it. And…

My thoughts about the new Oracle Database Release Schedule

Changes to a well-known release model mean a lot. I will give you some of my thoughts about the new Oracle Database release schedule. What are we changing? In my own words we basically rename the patch sets and name them what they were since years: Full releases. This means, Oracle Database 12.2.0.2 will be Oracle 18. And Oracle 12.2.0.3 will be Oracle 19. And so on. Therefore there won’t be any Oracle 12.2.0.2 anymore – and obviously no Oracle 13.1 followed by Oracle 13.2. In addition we change from Proactive Bundle Patches (BP) to Release Updates (RU) and from…

DBMS_OPTIM_BUNDLE – only available in Oracle 12.1.0.2 – or not?

The DBMS_OPTIM_BUNDLE package got introduced with the April 2014 Exadata 11.2.0.4 Bundle Patch. And it got introduced for all Oracle 12.1.0.2 databases with the April 2017 Bundle Patch (BP). DBMS_OPTIM_BUNDLE is only available in Oracle 12.1.0.2. Addition March 6, 2018: See the updated blog post about DBMS_OPTIM_BUNDLE available in Oracle 12.2 and 18c onwards. https://mikedietrichde.com/2018/03/08/dbms_optim_bundle-package-oracle-12-2-18c/ For more information on this package on Exadata in Oracle 11.2.0.4 you may look at: MOS Note:1942966.1: Exadata: DBMS_OPTIM Package Philippe Fierens’ blog post from October 2014 Purpose of DBMS_OPTIM_BUNDLE package in Oracle 12.1.0.2 The package got introduced to enable module bug fixes which cause…

Why EXCLUDE_SEED_CDB_VIEW is now an underscore in Oracle 12.2

I have received several questions from customers in the past weeks using Oracle Multitenant about the parameter exclude_seed_cdb_view.It magically disappeared and morphed into _exclude_seed_cdb_view since Oracle Database 12.2.0.1. To be fair, the exclude_seed_cdb_view is listed in the list of obsolete parameters in Oracle Database 12.2.0.1. What is EXCLUDE_SEED_CDB_VIEW? This parameter hides everything belonging to the PDB$SEED from the usual queries. For instance you ran a query against CDB_DATA_FILES but you won’t see the data files belonging to PDB$SEED in the result set. Whether this is good or bad, at least RMAN (Recovery Manager) worked always correctly. But I’m not a big fan…

Applying the first RU for Oracle Database 12.2.0.1

The first RU (Release Update) for Oracle 12.2 is available on most platforms since July 18, 2017. And of course I started applying the first RU for Oracle Database 12.2.0.1 as soon as it got released. See: https://mikedietrichde.com/2017/07/19/first-ru-oracle-12-2-0-1-available/ Download the RU 12.2.0.1.170718 for Linux First of all I downloaded the Database RU 12.2.0.1.170718 Patch 26123830 for Linux from MyOracle Support. To my absolute surprise it was very small compared to previous Proactive Bundle Patches such as the April 2017 one. It has just 40 MB in size (no typo!). Applying the first RU for Oracle Database 12.2.0.1 Then I unzipped…

Issue with 2k and 4k db_block_size – ORA-1450 when upgrading to Oracle 12.2.0.1

Recently we got alerted by a customer and a colleague from Italy about an issue with the upgrade from Oracle 12.1.0.x to Oracle 12.2.0.1 if – and only if – your database got created with 2k or 4k db block size. Problem If your database got created with 2k or 4k db block size, and you attempt an upgrade from any upgrade-supported Oracle version to Oracle Database 12.2.0.1 the upgrade – regardless of DBUA or catctl.pl – will fail with an ORA-1450: maximum key length (1478) exceeded. Analysis In the catupgrd0.log – regardless of using the DBUA or the command…

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…

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…

Hands-On Lab available: Upgrade to Oracle Database 12.2.0.1

Thanks to Roy – our Hands-On Lab “Upgrade, Migrate and Consolidate to Oracle Database 12.2” is now available for download from OTN. Download Hands-On Lab “Upgrade, Migrate and Consolidate to Oracle Database 12.2” Download the Hands-On Lab Instructions as PDF Instructions and technical requirements are clearly documented on the OTN page as well. The lab is based on Virtual Box and can be easily imported upon download and unzip. You can always access the lab via the blog’s top menu as well: Inside the lab you’ll find : UPGR – an Oracle 11.2.0.4 database ready to be upgraded to Oracle…