21c

Oracle Database 21c for Windows is available as EE, SE2 and XE

Oracle Database 21c for Windows is available as EE, SE2 and XE now for download following the Linux version with a few weeks of delay.

Enterprise Edition and Standard Edition 2

Please find the download for Oracle Database 21c and Oracle Grid Infrastructure 21c for Windows here:

Express Edition

Regarding Oracle Database 21c XE, please see this blog post regarding the Linux version:

I just posted a few week ago.

Further Links and Information

Downloads

Documentation

Related Blog Posts

Continue reading...

Oracle Database 21c XE (Express Edition) for Linux

I haven’t blogged for a while. And I know, there are a lot of comments waiting in the queue to be approved and answered. But meanwhile, let me tell you that Oracle Database 21c XE (Express Edition) for Linux is available for download now.

It’s been a while

Oracle XE (Express Edition) is the free version of the Oracle Database with almost full Enterprise Edition feature set but with some additional restrictions. The last version being available was Oracle 18.4. Now the 21c version is available for Linux.

If you wait for the Windows …

Continue reading...

Which releases allow you to upgrade to Oracle Database 21c?

As I wrote before, the release you should upgrade to is clearly Oracle Database 19c. Unless you need to use one of the new features in Oracle 21c. But as you have seen in the past, some of them get backported to 19c as well. Still, in case you can’t resists or you love upgrades as much as we do, the question may be: Which releases allow you to upgrade to Oracle Database 21c?

Upgrade-supported Releases

The Database Upgrade Guide for Oracle 21c is your best friend here. Right at the beginning in the first chapter you will find this …

Continue reading...

Pitfall: Upgrade to 21c fails when ORDIM is present but no SDO

You may have read my previous blog post about Upgrading a non-CDB to Oracle Database 21c. And I referred to a potential Pitfall: Upgrade to 21c fails when ORDIM is present but no SDO. In this blog post I would like to explain how to avoid this pitfall beforehand and explain what needs to be done.

Pitfall: Upgrade to 21c fails when ORDIM is present but no SDO

Photo by Sara Codair on Unsplash

What’s the problem?

In my previous blog post I showed you the ideal and normal way. But during my tests I came across an issue I was not aware of – and I simply had no …

Continue reading...

Upgrading a non-CDB to Oracle Database 21c with AutoUpgrade

Yesterday I wrote about the installation of Oracle Database 21c on Linux. But today it is time for Upgrading to Oracle Database 21c with AutoUpgrade.

Upgrading a non-CDB to Oracle Database 21c with AutoUpgrade

Photo by Arjun MJ on Unsplash

AutoUpgrade

You may have heard it already from us and other colleagues, but we can’t repeat it often enough: There is only one recommended tool to upgrade your databases – and this is AutoUpgrade.

In my 21c home, I’m checking the deployed version of AutoUpgrade at first:

[CDB3] oracle@hol:/u01/app/oracle/product/21/rdbms/admin
$ java -jar autoupgrade.jar -version
build.hash 57ab246
build.version 21.1.3
build.date 2021/04/21 13:32:13
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production

Now please …

Continue reading...

Oracle Database 21c is available for download on Linux

It took a while into 2021 – but now Oracle Database 21c is available for download on Linux.

Oracle Database 21c is available for download on Linux

Photo by Kahika on Unsplash

Download Location

Please go to either oracle.com or edelivery:

On edelivery you need to search for “Oracle Database”:

Oracle Database 21c is available for download on Linux

On oracle.com you need to scroll down a bit:

Oracle Database 21c is available for download on Linux

Other OS Ports

As you can see in MOS Note: 742060.1 – Release Schedule of Current Database Releases  – Table 2, Oracle Database 21c will be available on Linux x86-64, Microsoft Windows x64 and HP-UX Itanium. It won’t be available on SPARC or Intel Solaris, neither will it …

Continue reading...

New version of AutoUpgrade (21.2) is available for download

As we often tell you, our Upgrade Development team is working hard to ensure an agile release cycle for AutoUpgrade. And the New version of AutoUpgrade (21.2) is available for download.

How to download?

As usual, you can (and should) always download the most recent version of AutoUpgrade from this MOS Note: 2485457.1. Usually the tool gets refreshed every 6-8 weeks. And the version you will download is guaranteed newer than the one you could get on disk.

New version of AutoUpgrade (21.2) is available for download

The fact the tool has a 21c versioning does not affect 19c upgrades. There …

Continue reading...

aioug Webinar Series July 2021: Database Upgrade and Migrations

Many people on the northern hemisphere will escape during July into the summer holidays. But we won’t. Instead, thanks to Sai Penumuru, we will give seven webinars for the aioug. And we are looking forward to talk to you soon at the aioug Webinar Series July 2021: Database Upgrade and Migrations.

aioug Webinar Series July 2021: Database Upgrade and Migrations

When will it happen?

This morning I looked into my calendar. And I realized: Wow, July 2021 is just a few days away. Roy will start with the first session on Friday, July 2. And then myself, Rodrigo, Daniel, Fred and Bill will …

Continue reading...

Messaging Gateway – Upgrade can’t find mgwu122.sql

Thanks to Christian Ballweg from Optiz Consulting who brought this issue to my attention. I haven’t seen it before since I haven’t installed it but you may encounter this if you have the Messaging Gateway – Upgrade can’t find mgwu122.sql.

What is the Messaging Gateway?

Actually I steal this from the documentation:

Messaging Gateway enables communication between applications based on non-Oracle messaging systems and Oracle Database Advanced Queuing.

Oracle Database Advanced Queuing provides propagation between two Oracle Database Advanced Queuing queues to enable e-business (HTTP through IDAP). Messaging Gateway extends

Continue reading...

Virtual Classroom: Database Upgrade Internals – and so much more

Register here!

for Feb 10, 2021 – 10:00h CET

Virtual Classroom Web Seminar No.8:

Database Upgrade Internals – and so much more

Do you want to speed up your database upgrades? Did you ever ask yourself what AutoUpgrade does in the background? And do you want to know what all the logfiles are meant for? Or how you monitor 20 database upgrades with one simple call? In this webinar, we’ll not only cover database upgrade internals—we want to deliver real insights. We’ve invited Frederick Alvaraz from the AutoUpgrade development team to join us and share his expertise.

In addition, …

Continue reading...

Virtual Classroom: Cool Features not only for DBAs

Register here!

for Jan 14, 2021 – 10:00h CET

Virtual Classroom Web Seminar No.7:

Cool Features not only for DBAs

with special guests Jeff Smith and Connor McDonald

Oracle Database offers a ton of features. But not all are explained in broad detail. And many don’t make it onto the marketing slides. This webinar will focus strictly on useful features for everyday use, from a technical and practical perspective. It won’t be the typical feature-feature-feature talk, but instead will demonstrate the very best of Oracle Database 12c to 21c. Discover many hidden gems and some well-kept secrets—and much more …

Continue reading...

Cool Features not only for DBAs – Virtual Classroom Series No.7

Happy New Year to all of you. I hope you are all well. After an heavily active 2020 with more virtual seminars than ever before it’s time to start in 2021 with Cool Features not only for DBAs – Virtual Classroom Series No.7 on Jan 14, 2021.

Why Cool Features for DBAs?

Actually the idea is not new. And we’ve included some slides into our workshops already for quite a while. But there are simply too many cool features. Our focus is in features which usually don’t make it into advertising or …

Continue reading...

Download the newest AutoUpgrade for 19c and 21c upgrades

It’s out now and available since yesterday: AutoUpgrade 21c. Download the newest AutoUpgrade for 19c and 21c upgrades with many new features and improvements.

Download it!

This is the current version of AutoUpgrade:

build.hash 8ee6880
build.version 21.1.1
build.date 2020/12/14 14:41:34
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production
48 bug fixes since v21.0.0 release
Tag: v21.1.1
Description: This is the release for 21.1.1 MOS only

As usual, download it please from:

What’s new?

  • Non-CDB to PDB Upgrades
    • AutoUpgrade can upgrade and convert a non-CDB to a PDB in a new
Continue reading...

Oracle Database 21c is available in the cloud – plus documentation

It’s time for a new release. And as of this morning, Oracle Database 21c is available in the cloud – plus documentation is accessible as well. This is just the first blog post about Oracle Database 21c – more will follow within the next days. Stay tuned 🙂

Oracle Database 21c

Oracle Database 21c is now available on Always Free Autonomous Database (only in the following regions: IAD, PHX, LHR, FRA) and Database Cloud Service (RAC and single-instance on VM; single-instance on Bare Metal).

In addition, you can download the 21c client from the …

Continue reading...

APAC OUG: AutoUpgrade to 19c and 21c

October 19-30 – APAC Virtual Groundbreakers Tour

Continue reading...