Fedora 36 and Oracle

Fedora 36 was released recently. Here comes the standard warning.

Here are the usual things I do when a new version of Fedora comes out.

Why do I do this? As mentioned in the first link, Fedora is a proving ground for future versions of RHEL, and therefore Oracle Linux. I like to see what is coming around the corner. Doing this has no “real world” value, but I’m a geek, and this is what geeks do. 🙂

As an aside, when Fedora 35 was released I was having a lot of trouble getting 19c and 21c installed on it. I tried a number of times over the course of a few weeks and failed each time. When I tried those same installations on Fedora 36 they just worked, so I went back and tried on Fedora 35 again, and they worked there too. Clearly there have been some changes to underlying Fedora 35 packages that have fixed whatever the problem was with the Oracle installations. As a result, I also produced these.

Now that Fedora 36 exists, these Fedora 35 installations are not really necessary, but it’s nice to do them for the sake of completeness.

I pushed Vagrant builds to my GitHub.

If you want to try these out, you will need to build the base Vagrant boxes using Packer. You can find the Packer builds on my GitHub too.

So now you know how to do it, please don’t! 🙂

What’s New?

So what’s new with Fedora 36? It’s a bleeding edge distribution, so as you might expect, loads of package version updates, bringing most things to the latest and greatest versions. The things that stand out for me are Ansible 5 and Podman 4.0. If you want a more complete perspective on this, you might want to look here.

Cheers

Tim…

Video : SecureFiles Shrink in Oracle Database 21c

In today’s video we’ll demonstrate the SecureFiles Shrink feature, introduced in Oracle database 21c.

The video is based on this article.

You might also find these useful.

The star of today’s video is Arman Sharma. This clip was from Sangam15. To think that was seven years ago is mind-blowing!

Cheers

Tim…

Video : The PREPARE DATABASE FOR DATA GUARD Command in Oracle Database 21c

In today’s video we demonstrate the PREPARE DATABASE FOR DATA GUARD command, introduced in Oracle database 21c.

The video is based on this article.

The star of today’s video is Osama Mustafa, who was looking like a Teenage Mutant Ninja Turtle at that OpenWorld. 🙂

Cheers

Tim…

Video : EXCEPT and EXCEPT ALL Set Operators in Oracle Database 21c

In today’s video we demonstrate the EXCEPT and EXCEPT ALL set operators, introduced in Oracle database 21c.

The video is based on this article.

You might also find these useful.

The star of today’s video is Chris Saxon, who you’ll know from AskTom and his YouTube channel.

Cheers

Tim…

Video : INTERSECT ALL Set Operator in Oracle Database 21c

In today’s video we demonstrate the INTERSECT ALL set operator, introduced in Oracle database 21c.

The video is based on this article.

You might also find these useful.

The star of today’s video is Francesco Tisiot, who for some reason is incapable of understand the virtues of putting pineapple on pizza, or snapping spaghetti in half so it fits in the pan!

Cheers

Tim…

Video : MINUS ALL Set Operator in Oracle Database 21c

In today’s video we’ll demonstrate the MINUS ALL set operator,
introduced in Oracle database 21c.

The video is based on this article.

You might also find these useful.

The star of today’s video is Ludovico Caldara, who looks a little different than I remember him.

Cheers

Tim…

Video : Attention Log in Oracle Database 21c

In today’s video we discuss the attention log, introduced in Oracle database 21c.

The video is based on this article.

You might also find this useful.

The star of today’s video is Zahid Anwar, who despite being a fellow Brit, is filmed here in the USA. It’s funny how things work out. 🙂

Cheers

Tim…

Video : DBMS_XPLAN : Compare Execution Plans in Oracle Database 19c and 21c

In today’s video we’ll demonstrate the compare plans routines, added to the DBMS_XPLAN package in Oracle database 19c and 21c.

The video is based on the following article.

The star of today’s video Lumpy the donkey, who is being held by Bjoern Rost.

Cheers

Tim…

Video : ANY_VALUE Aggregate Function in Oracle Database 21c

In today’s video we’ll demonstrate the ANY_VALUE aggregate function, introduced in Oracle database 21c.

The video is based on this article.

The star of today’s video is Scott Spendolini, who I suspect has used APEX at least once or twice in his life…

Cheers

Tim…

Video : Analytic Function Exclude Clause in Oracle Database 21c

In today’s video we’ll demonstrate the analytic function exclude clause, introduced in Oracle database 21c.

The video is based on the following article.

You might also find these useful.

The star of today’s video is Rene Antunez, who took a few of us to see the Pyramids of Teotihuacan when we were in Mexico on an ACE speaker tour.

Cheers

Tim…