Oracle Multimedia will be removed in Oracle Database 19c

With Oracle Database 19c being available on Exadata now, and most likely soon on-prem as well, there’s a significant change you should be aware of when using image processing features inside the database: Oracle Multimedia will be removed in Oracle Database 19c. Oracle Multimedia will be removed in Oracle Database 19c When you upgrade or migrate your database to Oracle 19c, then Oracle Multimedia APIs will be still exist but won’t function anymore. Read here in the Oracle Database 19c Upgrade Guide: Desupport of Oracle Multemedia Oracle Multimedia is desupported in Oracle Database 19c, and the implementation is removed. As…

Oracle Database 19c requires OL7, RHEL7 or SLES12 or newer

Oracle Database 19.2 for Oracle Exadata systems is available for download since yesterday night. One important thing you need to take into account once Oracle 19c will be generally available: On Linux, Oracle Database 19c requires OL7, RHEL7 or SLES12 or newer. Database Installation Guide for Linux You will find the exact minimum OS and kernel version requirements in the Database Installation Guide for Linux for Oracle 19c. Please see here the Operating System Checklist for Oracle Database Installation on Linux: Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 4: 4.1.12-112.16.7.el7uek.x86_64 or later Oracle Linux 7.4 with the Unbreakable Enterprise…

How long will Oracle Database 12.2 be supported?

This question sounds very simple: How long will Oracle Database 12.2 be supported? Right? But I learned at a customer site recently that the information about the support periods for Oracle 12.2 may puzzle people sometimes. Hence I thought some clarification may be useful. Lifetime Support Policy Brochure First of all, when you have a look into the Lifetime Support Policy brochure the answer you’ll read there is: Premier Support until March 2023 Extended Support until March 2026 But this doesn’t give you any distinction between Oracle 12.2.0.1, Oracle 18c and Oracle 19c. These three releases fall under the Oracle…

Oracle 19c is available in LiveSQL

As Willie Hardie, VP Oracle Database Produce Management, wrote in his blog post, Oracle Database 19.2 is available in LiveSQL since yesterday. You can try out scripts and such in a container. Of course, feature usage is restricted. But that’s a pretty nice thing for an early start with Oracle Database 19c. Try it out Try it out on: liveSQL.oracle.com And find more information in Willie Hardie’s post: https://blogs.oracle.com/oracle-database/oracle-database-19c-now-available-on-livesql –Mike  

Happy New Year 2019 to all of you!

Happy New Year 2019 to all of you! And thanks for reading the blog. And thanks also for the warm feedback you gave me in the past 20 months since I started this blog on a new platform. I wish you all a very good start into the new year. If you wonder why I post this while the year is already 7 days old, we Germans have a lot of holidays – and this season it was pretty attractive to take two weeks off with just spending 5 vacation days. Hence, my working year 2019 starts more or less…

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…

To which release should you upgrade to? Plus: Extended Support?

A few days ago I blogged about the Current Support Status for Oracle Database Releases. And you’ve sent several questions to me. Some asked about clarification to which release should you upgrade to? Plus: Extended Support questions were quite frequent. So let me clarify this previous blog post a bit. To which release should you upgrade to? A few weeks ago we initiated global communication to all customers who had opened an SR within the past 3 years explaining to which release you should upgrade to. Just in case you haven’t seen this communication, I will give you more details…

Oracle 12.2 and higher: Set _cursor_obsolete_threshold to old default

Sometimes development groups change default parameter settings because it fits well for a specific feature. This has happened with _cursor_obsolete_threshold in Oracle Database 12.2. But there’s now an official recommendation for Oracle 12.2 and higher: Set _cursor_obsolete_threshold to old default. What is _cursor_obsolete_threshold? First of all, this is obviously an underscore parameter. And usually the policy is: Don’t change underscore parameters unless either you clearly understand what you are changing. Or unless Oracle Support (or another Oracle authority) advises you to do. We introduced this parameter in Oracle 11.2.0.3 for an issue of growing child cursors. An enhancement request was…

Drop public synonym XMLCONCAT prior to upgrade

Thanks to my team mates, Cindy and Hector, who alerted me on this newly detected issue. When your database has been upgraded from release to release, it could happen that a public synonym XMLCONCAT exists. And before you upgrade to Oracle 12.2.01 or Oracle 18c you must drop this public synonym to avoid upgrade errors. Drop public synonym XMLCONCAT prior to upgrade The public synonym XMLCONCAT in pre-9.2.0.2 Oracle databases pointed to a PL/SQL function of the same name. In 9.2.0.2, this PL/SQL function was changed to a C function.The public synonym was no longer needed nor pointing to a…

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…