Adjust

Can I convert a non-CDB into a CDB?

Those of you who work with the Multitenant or CDB architecture for a longer time may find this blog post title strange. But as I learned the other week at the German Oracle User Group conference (DOAG 2024), others still have this question: Can I convert a non-CDB into a CDB?

Photo by Jeffery Ho on Unsplash

Can you convert?

Short answer: No.

End-of-blog-post.
Well, of course, not.
Let me explain this a bit more.

When you have a non-CDB database today, you can’t convert it into a CDB (Container Database). This path isn’t possible but there is another path. …

RUs contain now all available DST patches

At first, Happy New Year everybody. There was silence on the blog for some weeks but I took an extended longer time off. Well, and once you return, there are some emails in your inbox which need some work. You’ll see several new blog posts getting published in the coming days. Back to normal, yesterday night RU 19.18.0 among other patch bundles has been released. And there’s a huge fantastic surprise in it: RUs contain now all available DST patches.

RUs contain now all available DST patches

Photo by Lukas Blazek on Unsplash

What’s the story?

There are some good news. We discussed this internally …

DBMS_OPTIM_BUNDLE and Out-Of-Place Patching

Posted on August 12, 2021 by Mike.Dietrich Flaws and Pitfalls Optimizer Patch Recommendation 10

Well, you see, this is most likely my special DBMS_OPTIM_BUNDLE week. And since I receive quite a number of questions, it may be good to discuss here about DBMS_OPTIM_BUNDLE and Out-Of-Place Patching?

Photo by Didssph on Unsplash

Out-of-place Patching

When you patch out-of-place with a new home – which is clearly our recommendation – you may see another tiny pitfall with DBMS_OPTIM_BUNDLE.

When you check DBA_DIRECTORIES, you will find two directories being related to DBMS_OPTIM_BUNDLE.

SQL> select directory_name, directory_path from dba_directories where directory_name like '%OPTIM%'

DIRECTORY_NAME	     DIRECTORY_PATH
-------------------- --------------------------------------------------
DBMS_OPTIM_LOGDIR    /u01/app/oracle/product/19/cfgtoollogs
DBMS_OPTIM_ADMINDIR  /u01/app/oracle/product/19/rdbms/admin

You see the “19” in the …

Adjust

Can I convert a non-CDB into a CDB?

Can you convert?

RUs contain now all available DST patches

What’s the story?

DBMS_OPTIM_BUNDLE and Out-Of-Place Patching

Out-of-place Patching

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts