8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Multitenant : PDBs With Different Character Sets to the CDB in Oracle Database 12c Release 2 (12.2)


Marcin said...

Hi TIm according your experience.
I have to install production database with the different encoding that UTF.
Besides I do not have an multitenant extra cost package.
Do you recommend in my case to install CDB with one PDB or the standard one.

Tim... said...

Hi.

Personally I always use lone-PDB if I can. I only use non-CDB if there is a vendor requirement. You can create the CDB with the characterset you want and every PDB (1 one them) will all have that character set too.

Cheers

Tim...

Marcin said...

Which assets would I get? I see some in test environment. But even for Oracle developers there are some dead ends in this architecture (like move back undo tablespace to PDB)?

Tim... said...

Hi.

The old non-CDB architecture is deprecated, so you should try to use PDB where possible. At some point in the future the non-CDB architecture will go. The local undo is a great thing. It makes lots of extra things possible.

Cheers

Tim...

Marcin said...

When it comes to upgrade facilites. Do you know if it is legal to install two CDB with one PDB each on one machine. I can not buy an extra multitenant option but mabye it could be usable in upgrade process.

Tim... said...

Hi.

You can have as many instances on a box as you like, provided they each have no more than 1 PDB.

Cheers

Tim...

Marcin said...

Ok. Mabye you are right when you wrote " There is no point putting your head in the sand and hoping it will go away...".
Cheers

Marcin said...

But I have one doubt about this solution. Do you know Tim if they resolve encoding problem? Oracle recomends to use AL32UTF8 in CDB, but I need to create PDB with different encoding. Is it possible to do it easily or there are still some tricks with this process?

Marcin said...

Mabye my question was a little bit unclear. But I think that I should install PDC and PDB in one encoding (but not recomended AL32UTF8). Do you see any threats with this procedure?

Tim... said...

Hi.

You can either do:

- CDB and PDB both in a non-AL32UTF8 character set that match.
- CDB in AL32UTF8. PDB in a different character set (non-AL32UTF8).

You can't do the latter directly. It must be converted, or cloned from another instance, as I showed in this article.

Cheers

Tim...

Patrick Jolliffe said...

If you're going to use this feature, make sure you've got the fix for bug 25054064 otherwise you'll be in for some nasty surprises, we just learned this the hard way :)

Tim... said...

Hi.

Thanks for the heads-up. I'll put it into the article.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.