Installation

Grid Infrastructure: Bye Tomcat – welcome Micronaut

Anil Nair wrote it in his MAA Blog Post on April 28: “Oracle is simplifying the software stack by replacing Apache Tomcat application server with Micronaut framework.”. And since some of you asked already, let me give you a bit more information about this change in 19.30 and 19.31 with Grid Infrastructure: Bye Tomcat – welcome Micronaut.

Grid Infrastructure: Bye Tomcat - welcome Micronaut

Photo by Hayrullah Gozcu on Unsplash – and I know, the jet in the picture isn’t an F-14 Tomcat 🙂 

It happens automatically

At first, no action is needed from your side. This behavior change happens automatically.

It is the …

Continue reading...

Sign up for the next Virtual Classroom Seminar: Patch Smarter, Not Harder

Some of you may have realized: We moved the Virtual Classroom Seminar #27 from its original date in February to March 12 this week. Usually we don’t do this – but we ended up with so much content. If you haven’t already, it is time for you to sign up for the next Virtual Classroom Seminar: Patch Smarter, Not Harder.

What are we going to talk about?

Database Patching – with or without RAC or Data Guard. With demos, as usual.

The idea is that you may learn a lot. And of course, …

Continue reading...

AutoUpgrade 24.8 has been released adding MS Windows patching support

Our developers are amazing. And you may have felt this the past months. In September for OCW2024 we released AutoUpgrade 24.6 with the new patching ability, in October we then released 24.7 improving it significantly and fixing issues based on the first tests, and now in November 2024 AutoUpgrade 24.8 has been released adding MS Windows patching support. Of course, there’s more in AutoUpgrade.

AutoUpgrade 24.8 has been released adding MS Windows patching support

Photo by Tadas Sar on Unsplash

How to download AutoUpgrade 24.8

Not only can you download the newest AutoUpgrade and its previous versions from MOS Note:2485457.1 – Download AutoUpgrade but as I wrote a …

Continue reading...

Installation of Oracle Database 21c on Oracle Linux

As you may have expected already since Oracle Database 21c is available for download on Linux, I will publish some additional posts this week. Today, I will give a quick insight into the installation process.

CDB-only architecture

As you may or may not be aware, Oracle Database 21c is the first Oracle database release with CDB-only architecture. You can’t have a non-CDB in Oracle 21c anymore. Ah, wait a bit, didn’t I blog 1.5 years ago that Oracle Database 20c will be the first CDB-only release? True. But as you saw, there …

Continue reading...

After patching, Spatial Index creation fails with ORA-13249

Thanks again to Peter Lehmann from T-Systems for highlighting this issue to me. After patching, Spatial Index creation fails with ORA-13249. And Peter’s customer was quite worried. But see what may have caused this, and how we fixed it.

After patching, Spatial Index Creation Fails with ORA-13249

Photo by Bill Oxford on Unsplash

What happened?

Peter patched a system from 19.10.0 to 19.11.0. This database has undergone an upgrade from 12.2.0.1 to 19.7.0 before, then got patched to 19.9.0 before. The database has the Oracle Locator only but no Spatial installed. The patching including datapatch worked fine. All seemed to be good. Until the customer tried to …

Continue reading...

Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes

In an previous blog post we showed how to install and patch in one single action. And as I use this technique all the time when I setup new homes, would like to show you an Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes. The purpose of this blog post is mainly to demonstrate again how you can install and patch in one action. But also to help you avoiding a pitfall when you apply the OJVM RU from April 2021.

What do we need?

At first, let us …

Continue reading...

Do we offer patched Gold Images already?

Internally we can use a Gold Image service at Oracle. I can download a zip with 19.6.0 included. But externally for you as customers, the download of 19.6.0 required that you download 19.3.0 at first, then apply 19.6.0 on top of it. But a day ago, a tweet by my Belgium friend Philippe Fierens caught my attention. Do we offer patched Gold Images already?

Do we offer patched Gold Images already?

Photo by Sergey Pesterev on Unsplash

What is a Gold Image?

Since Oracle 18c, the installation routine has changed to the better. You download zip file containing the Gold Image, you create a directory and …

Continue reading...

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.

Oracle 18.4.0 installation on AIX may fail with ORA-40238

Oracle 18.4.0 installation on AIX may fail with ORA-40238

First of all, this is an error pattern you may see on IBM AIX only. You may receive the following error message either during installation or startup of ASM or any …

Continue reading...

Oracle Database 18.3.0 installation on premises

Oracle Database 18.3.0 installation on premisesOracle 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 …

Continue reading...

Installing Oracle Database 18c

Installing Oracle Database 18cThis blog post about Installing Oracle Database 18c applies to all Oracle 18c releases. I wrote a while ago about one very important change:

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:

Installing Oracle Database 18c

Oracle Database 18c on-premises is supposed to be generally available with the July 2018 …

Continue reading...

Non-CDB architecture still exists in Oracle Database 12.2.

I received a question whether the Non-CDB architecture still exists in Oracle Database 12.2.from 3 different colleagues in the past week:

“Does Oracle Database 12.2 still allow us to create non-CDB databases?”

And as I get this question at every customer-facing workshop these days as well before being able to talk about Single/Multitenant – I think it is important to clarify it. The statement is misleading. And I can’t blame anybody about misreading it.

Is the non-CDB architecture still available/supported in Oracle Database 12.2?

I did blog about it a while ago – but Google is not always your …

Continue reading...

Why you should remove APEX from the CDB$ROOT

Upgrade Blog posts about Oracle Application Express:


Oracle APEX (Application Express) is great piece of software. But it gets installed by default into the container database’s CDB$ROOT unless you’d customized your CDB creation via scripts in Oracle 12.1.0.2. See:

on how to customize a Single/Multitenant Database with less options.

But that is not the topic I …

Continue reading...