Video : Multitenant : PDB Snapshot Carousel in Oracle Database 18c Onward

In today’s video we take a look at the PDB Snapshot Carousel feature, introduced in Oracle 18c.

I also have a Multitenant YouTube playlist.

There’s a lot more information about this feature and other multitenant functionality in these articles.

The star of today’s video is Nassyam Basha. 🙂

Cheers

Tim…

Video : Multitenant : Proxy PDB in Oracle Database 12.2 Onward

In today’s video we demonstrate the Proxy PDB feature, introduced in Oracle database 12.2.

I also have a Multitenant YouTube playlist.

There’s a lot more information about this feature and other multitenant functionality in these articles.

The star of this video is Anton Els of Dbvisit fame. I recorded this video last week and picked Anton for the “.com”, then they go and release Dbvisit Standby 9. Coincidence or conspiracy? 🙂

Cheers

Tim…

PS. Mike, I’ve downloaded version 9 and I’m going to give it a run through… 🙂

Video : Multitenant : Refreshable PDB Switchover in Oracle Database 18c Onward

Today’s video is a run through the Refreshable PDB Switchover feature introduced in Oracle 18c.

I also have a Multitenant YouTube playlist.

If you prefer reading over watching a video, you can find all the information and more here.

The star of today’s video is Kamran Agayev A. When he’s not working with Oracle technology and helping people to pass their OCM exam, he’s choking people out at Brazilian Jiu Jitsu. 🙂

Cheers

Tim…

Video : Multitenant : PDB Refresh in Oracle Database 12.2 Onward

Today’s video demonstrates the PDB refresh functionality introduced in Oracle database 12.2.

If you prefer to read rather than watch, you can get all the information from this video from here.

The star of today’s video is Markus Michalewicz. He’s so serious in this clip it makes me laugh. 🙂

Cheers

Tim…

Video : Multitenant : PDB Archive Files in Oracle Database 12.2 Onward

Today’s video is a run through the PDB Archive File functionality introduced in Oracle 12.2.

If you prefer your content in text form, this video is based on the articles here.

The star of today’s video is Maris Elsins. 🙂

Cheers

Tim…

Video : Multitenant : Relocate a Pluggable Database (PDB) in Oracle Database 12.2 Onward

Today’s video is a brief run through the PDB relocate functionality, introduced in Oracle 12.2.

As always, this is based on articles with a lot more information, which you can find here.

The star of this video is none other than Martin Bach. 🙂

Cheers

Tim…

Video : Multitenant : Hot Clone a Pluggable Database (PDB) in Oracle Database 12.2 Onward

Today’s video is a run through the hot cloning functionality introduced in Oracle 12.2 multitenant.

You might also be interested in this playlist.

If videos aren’t your thing, you can always read the articles, which contain more information.

The star of today’s video is Craig Shallahamer. Craig is a really dynamic presenter, and I think this is the only time you will ever see him standing still! 🙂

Cheers

Tim…

Multitenant Enhancements in Oracle Database 12.2 (Some More Articles)

The Oracle Database 12c Release 2 (12.2) learning process continues. I’m determined to get to the bottom of all this new multitenant stuff. 🙂

Here’s the latest batch of articles.

So the last one is actually for 12.1, but I hadn’t written about it already, so I added it.

I also updated this article to include the “CONTAINERS Hint” feature functionality.

There is a new feature listed in the docs as as “Support for PDBs with Different Character Sets, Time Zone File Versions, and Database Time Zones in a CDB”. I’ve already written about the PDB character set stuff and it is also listed separately as a new feature. The time zone stuff works in 12.1, so it doesn’t appear to be a 12.2 new feature. The different Time Zone File Versions functionality, as far as I can see, relates to OCI client connections to the server and was introduced in 11.2. With all that in mind, I’m really not sure what this listed new feature specifically relates to. If someone can clear that up for me I would be really grateful, as I’m wondering if I’ve just missed the point somewhere. 🙂

I’ve added these to the list of all my multitenant articles here.

Cheers

Tim…

Multitenant Enhancements in Oracle Database 12.2 (The Next Batch)

I’ve continued playing with some of the new multitenant functionality in Oracle Database 12c Release 2 (12.2).

Here’s the latest batch of articles.

This article is not a multitenant article as such, but you can use the functionality in a PDB.

I’ve added these to the list of all my multitenant articles here.

Cheers

Tim…

Multitenant : It’s easy to screw up!

multitenantSome things happened to me yesterday which I thought I would pass on, in case it helps others. This is not necessarily a criticism of the Multitenant architecture itself, but more about my misuse of it. 🙂

I’ve complained numerous times about the inclusion of the shared APEX installation used with the Multitenant option. I’m sure it is great for some companies that provide APEX as a service, but it’s not the right option for me. I would typically recommend removing it before you create a PDB, as described here. So what did I do yesterday? I banged out a script as a variant of a non-CDB build and totally forgot about the shared installation. When everything was finished I patted myself on the back, then noticed my mistake. 🙁 I had to remove the PDBs from 3 instances, remove the shared APEX installations, the recreate the PDBs. Luckily it was early on in the process, so it wasn’t a great drama. It would have been significantly more annoying if I hadn’t noticed for a few days!

Next up I nearly cloned a PDB, which would have left me with 2 PDBs in the instance, and potentially a big bill for the Multitenant option. I was literally about to hit the return key when I realised what I was doing. 🙁 Needless to say I immediately added a trigger to all my instances to prevent any future stupidity on my part. You can see what I did here. As I say in the article, I’m not sure if there is some hidden long term tracking of the maximum number of PDBs in a CDB, but I’m a paranoid type… 🙂

As an aside, I also noticed that when I add a new PDB to a CDB it takes Cloud Control 13c a long time to notice the PDB is there. I did try to give it a nudge by doing the following, but it didn’t seem to notice.

  • Highlight the CDB in the database target list.
  • Click the “Configure” button.
  • Scroll down and click the “Sync Pluggable Databases” button.

It didn’t recognise the change, even though it was clear in the V$PDBS and CDB_PDBS views. Not sure if this is normal or if I just got unlucky. Everything looks OK now… 🙂

Cheers

Tim…