In late June, my team hosted our 20th webinar in our Virtual Classroom series.

You can now get a curated version of the Q&A. It contains many good questions and answers that give you deeper insight into Oracle Multitenant architecture.

The Best Questions

Consider these questions and answers a little appetizer. You find many more in the Q&A document.

Do I need to convert my database to a PDB before I upgrade to Oracle Database 23ai? No. You can do it as part of the upgrade to Oracle Database 23ai. It is easiest to use AutoUpgrade for the process

Does catcon.pl parallelism require Enterprise Edition like many other parallel options? No. You can use parallel threads in catcon.pl on a Standard Edition 2 database

Any good idea on how to avoid service name collision on a server when two CDBs tries to create a PDB with the same name? We’ve seen several customers implement procedures that create unique names for each PDB. The name of the PDB should not include information about the server or CDB because you often move PDBs around, and then it is impractical to update the PDB name. One customer we worked with created a small PL/SQL function backed by a simple table. When called, the function returned a unique PDB name. The customer used ORDS to expose the function as a web service.

Do you recommend Oracle Fleet Patching and Provisioning (FPP) in a small, but complex, environment? The bigger the environment, the more benefit you get from FPP. Especially if you are using Exadata Database Machine as well. AutoUpgrade is our preferred tool for smaller environments, but the complexity talks towards FPP. FPP comes with a license cost that you must take into consideration as well.

Did You Miss It

In case you missed it, you can find the recording on our YouTube channel and get the slides.

I Love Questions

One of the reasons I like doing webinars is that I get questions from the audience. I love that for several reasons:

• Many questions about a specific topics is an indication that I didn’t explain a topic very well. I use this as feedback to improve for the next presentation.
• I can use it to tell where our product has weakness that we can improve.
• It tells me something about how customers use our product. I always get amazed about the creativity with which our customers use Oracle Database.
• I find gaps in my own knowledge and I can learn new things.
• It allows me to help other people.

Please – always ask questions! :)