Oracle Database 21c

Zero Downtime Upgrade of Timezone Data in Oracle 21c and 23c?

There is a feature in Oracle Database 21c I planned to write about for a very long time: Zero Downtime Upgrade of Timezone Data in Oracle 21c and 23c. This sounds very promising – but let us take a closer look together in this blog post.

Photo by Bruno Figueiredo on Unsplash

Time Zone Upgrade?

There is of course an ongoing discussion whether and when you should upgrade the DST version of your database to a current value. Since we all live in a more and more globalized world, this topic becomes more and more important. Even more important …

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

Posted on October 11, 2021 by Mike.Dietrich Oracle Database 21c XE - Express Edition 2

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.

Photo by Fakurian Design on Unsplash

Enterprise Edition and Standard Edition 2

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

https://www.oracle.com/database/technologies/oracle21c-windows-downloads.html

Express Edition

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

Oracle Database 21c XE is available on Linux

I just posted a few week ago.

Further Links and Information

Downloads

Documentation

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

Posted on August 31, 2021 by Mike.Dietrich Oracle Database 21c 2

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 …

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

Posted on August 25, 2021 by Mike.Dietrich Flaws and Pitfalls Oracle Database 21c Upgrade / Migration 2

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 …

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

Posted on August 24, 2021 by Mike.Dietrich AutoUpgrade Oracle Database 21c Upgrade / Migration 9

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.

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 …

Installation of Oracle Database 21c on Oracle Linux

Posted on August 16, 2021 by Mike.Dietrich Oracle Database 21c 6

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.

Installation of Oracle Database 21c on Oracle Linux

Photo by Dominik Scythe on Unsplash

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 …

Oracle Database 21c is available for download on Linux

Posted on August 13, 2021 by Mike.Dietrich Oracle Database 21c 16

It took a while into 2021 – but now 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 …

Download the newest AutoUpgrade for 19c and 21c upgrades

Posted on December 16, 2020 by Mike.Dietrich AutoUpgrade Oracle Database 19c Oracle Database 21c 35

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.

Photo by Jordan McGee on Unsplash

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:

MOS Note: 2485457.1 – AutoUpgrade Tool

What’s new?

Non-CDB to PDB Upgrades
- AutoUpgrade can upgrade and convert a non-CDB to a PDB in a new

Oracle Database 21c

Zero Downtime Upgrade of Timezone Data in Oracle 21c and 23c?

Time Zone Upgrade?

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

Enterprise Edition and Standard Edition 2

Express Edition

Further Links and Information

Downloads

Documentation

Related Blog Posts

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

Upgrade-supported Releases

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

What’s the problem?

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

AutoUpgrade

Installation of Oracle Database 21c on Oracle Linux

CDB-only architecture

Oracle Database 21c is available for download on Linux

Download Location

Other OS Ports

Download the newest AutoUpgrade for 19c and 21c upgrades

Download it!

What’s new?

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts

Follow me on Twitter