When and how should you change COMPATIBLE?

When and how should you change COMPATIBLE?

COMPATIBLE is an almost mystic parameter. It has a default setting for each release. But if you try to find more information what it really does, you won’t be very happy. And in reply to my previous blog post about whether you need to change COMPATIBLE when you apply an RU, I received the following question: When and how should you change COMPATIBLE? [ Read More ]

Why you should set _EXCLUDE_SEED_CDB_VIEW=FALSE

Why you should set _EXCLUDE_SEED_CDB_VIEW=FALSE

There usually a philosophic battle happening when it comes to underscore parameters. The official statement is more or less: It’s an underscore, hence it is undocumented and you shouldn’t touch it unless Oracle Support advises you to do so. I agree in many cases. But in this specific one, I don’t.… [ Read More ]

Extended Support Fee waived for EBS customers for Oracle 12.1 and 11.2

Extended Support Fee waived for EBS customers for Oracle 12.1 and 11.2

The responsible team announced it at Collaborate Conference in San Antonio, TX, a few days ago: If you are an Oracle E-Business Suite customer with Oracle Database 12.1 or 11.2 in use for your EBS environment, then you will like this announcement. As of now the Extended Support Fee has been waived for EBS customers for Oracle 12.1 and 11.2 until December 2020. [ Read More ]

My Hands-On Lab USB drives are not giveaways

Today I’ve had two very exciting labs at Collaborate 2019 conference. And no worries if you couldn’t finish the lab on time. You can download it via the blog – and instructions are up here as well.

Thanks so much for coming to the labs.

One personal note:

If I offer you USB drives to copy the lab to your laptop, I’d expect that you return them back to me.… [ Read More ]

Collaborate 2019 – San Antonio, TX – Upgrade Talks and Labs

Collaborate 2019 - San Antonio, TX - Upgrade Talks and Labs

I have to be careful when posting something today. But this is actually not an April’s fool joke. Collaborate Conference is less than a week away. And for me this means: I’m going to Texas for the first time ever. And I hope to see you at Collaborate 2019 – San Antonio, TX – Upgrade Talks and Labs.… [ Read More ]

You MUST patch 12.1.0.1 and 11.2.0.3 and older databases before June 2019

First of all, this blog post is not new. I blogged about this SCN topic a while ago already. But some of you seem to operate still older databases for various reasons. And even if you think that you are safe, double check for any older databases in your environments. You MUST patch 12.1.0.1 and 11.2.0.3 and older databases before June 23, 2019.… [ Read More ]

Oracle 18c Express Edition (XE) for Windows is available

Oracle 18c Express Edition (XE) for Windows is availableOracle 18c Express Edition (XE) for Windows is available for download as of now. Oracle XE 18c on other platforms is available since November 2018. As of now you can download the Windows version as well.

Use the Quick Start guide which explains the installation and how to connect to the database.… [ Read More ]

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 More ]

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

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

You will find the exact minimum OS and kernel version requirements in the Database Installation Guide for Linux for Oracle 19c.… [ Read More ]

Oracle Database 19.2 for Exadata is now available for download

Time flies – and we have 2019. Since a few minutes Oracle Database 19.2 for Exadata is now available for download.

Oracle Database 19.2 for Exadata is now available for download

You can download as of today Oracle Database 19.2 for Exadata from the Software Delivery Cloud (eDelivery).

Just type in “Oracle Database” into the search window:

Oracle Database 19.2 for Exadata is now available for download

And then add it to your cart:

Oracle Database 19.2 for Exadata is now available for download

Documentation

And of course, the Oracle Database 19c documentation is available as of now as well:

Oracle Database 19.2 for Exadata is now available for download

Further Information

Please read more on the Oracle Database Blog.… [ Read More ]

In case you miss DBMS_OPTIM_BUNDLE in 12.2

Strange things happen sometimes. I got alerted by a customer before Christmas about package DBMS_OPTIM_BUNDLE missing after applying a Release Update. I’ve had a conversation with Nigel Bayliss, the Optimizer PM – but Nigel hasn’t heard of such things either. We both investigated but couldn’t reproduce the issue. But after the end-of-the-year holidays I received similar messages from other customers.… [ Read More ]

DST Time Zone Patch V.32 and V.33 for Oracle 18.5.0

If you’d ever attended one of Roy’s or my workshops, you know that we talk about time zone adjustments after the database upgrade. We explain why this is important. But as everything, it depends if you really need to apply and adjust. In our workshops we recommend one single note for time zone adjustments: MOS Note:412160.1 .… [ Read More ]

Techdays Belgium – Antwerp, Feb 7+8, 2019 – Get your ticket NOW!

Next week the Techdays Belgium will take place in Antwerp on Feb 7 and 8, 2019. If you haven’t bought a ticket yet, it’s time now. The lineup is awesome. And what an agenda. It’s a very unique chance to see many of the best Oracle experts worldwide live on stage.… [ Read More ]

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

How long will Oracle Database 12.2 be supported?

But this doesn’t give you any distinction between Oracle 12.2.0.1, Oracle 18c and Oracle 19c.… [ Read More ]

Different MOS Notes for xTTS PERL scripts – Use V4 scripts

A long time ago my colleagues published PERL scripts to assist especially with cross platform Transportable Tablespace migrations. The PERL scripts allow you to utilize incremental backups. This way you can decrease the downtime in a migration with large databases significantly. But there are different MOS Notes for xTTS PERL scripts available.… [ Read More ]

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.… [ Read More ]

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.… [ Read More ]

Oracle 18.4.0 installation on AIX may fail with ORA-40238

Oracle 18.4.0 for IBM AIX is available since mid November 2018. But I’ve received several emails from people saying that Oracle 18.4.0 installation on AIX may fail with ORA-40238. And it’s true, this can happen. But there’s a simple workaround which unfortunately is not in the documentation yet. We’ll take care that it will be added soon.… [ Read More ]

How to patch all PDBs with the a new time zone file?

Yesterday I wrote about how to adjust the time zone setting in the PDB$SEED as by default the time zone scripts won’t touch the PDB$SEED when you execute them. And in addition, MOS Note:1509653.1 tells you, that the PDB$SEED can’t be adjusted. But this leads to a weird mix of time zone settings across a Multitenant deployment.… [ Read More ]

Does the PDB$SEED get “time zone” patched or not?

Today I received a question from a very experienced Oracle ACS engineer whether the PDB$SEED get time zone patched or not when a time zone patch gets applied. I’d say spontaneously “Of course, it does” but after thinking for a few seconds I started having doubts. Question is: Does the PDB$SEED get “time zone” patched or not? [ Read More ]

OPatch … oh OPatch … why is datapatch so stubborn?

Well, it is Friday night – and I’d rather should sleep or do something cool people tend to do on Friday night’s. But I try to verify a strange issue with DBMS_OPTIM_BUNDLE and the October 2018 Update for Oracle 12.2.0.1. I’m patching. Can you think of anything better on a Friday night than patching?… [ Read More ]

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.… [ Read More ]

UKOUG Tech18 – Recap, Slides, Videos and Impressions

UKOUG Tech18 - Recap, Slides, Videos and ImpressionsUKOUG Tech18 this year was an excellent event. And even though I was very skeptical of having to travel to Liverpool where you really can’t fly into except when you live in Amsterdam, I enjoyed it a lot. Liverpool is really a lovely city. And being honest, the conference center was very nice – and IMHO better than the one in Birmingham.… [ Read More ]