CDB$ROOT

Choose your desired time zone version (DST) upgrade

This morning I received a very reasonable question from a customer who has a time zone mismatch between source and target database. And he wants to transport into a PDB on Exadata. Even though, this sounds trivial at first sight, unfortunately it isn’t. But a bug fix done recently for a German automotive customer is very handy here. So let me show you how you can Choose your desired time zone version (DST) upgrade.

Choose your desired time zone version (DST) upgrade

Photo by Vince Veras on Unsplash

Where does the problem start?

In this particular – and not unusual case – the customer wants to migrate …

UNDO_RETENTION not inherited to PDBs anymore since 19.9.0

Posted on July 12, 2021 by Mike.Dietrich Behavior Change 15

Behavior changes introduced via a bug fix may not be something you like a lot. And thanks to Sreedhar from one of our most important customers I learned on the weekend: UNDO_RETENTION not inherited to PDBs anymore since 19.9.0.

UNDO_RETENTION not inherited to PDBs anymore since 19.9.0

Photo by Ben Wicks on Unsplash

What is happening before 19.9.0?

Until Oracle 19.8.0 you could change the UNDO_RETENTION in the CDB$ROOT, and it applied to all PDBs automatically. You may or may not have cared. But there are cases when you’d like to change an undo related parameter in the CDB$ROOT without its propagation into all PDBs.

This behavior …

Transportable Tablespaces – Example and strange error with a PDB

Posted on July 7, 2020 by Mike.Dietrich Data Pump Single-/Multitenant Transportable 6

Yesterday I was browsing around for a useful simple example to test Transportable Tablespaces. A colleague mailed with the other day with a strange error message. The attempt to import into a PDB in Oracle 19c failed. My first thought: Oh, this is simple. But I failed, too. And even worse, I couldn’t find a single useful note in MyOracle Support (MOS) for ORA-31640, ORA-27037, Linux-x86_64 Error: 2 with Additional information: 7. So I decided to summarize this in Transportable Tablespaces – Example and strange error with a PDB.

Transportable Tablespaces - Example and strange error with a PDB

Photo by Kerensa Pickett on Unsplash

A simple Transportable Tablespace

How to patch all PDBs with the a new time zone file?

Posted on December 18, 2018 by Mike.Dietrich Patch Recommendation Single-/Multitenant Time Zone - DST 13

Yesterday I wrote about how to adjust the time zone setting in the PDB$SEED as by default the time zone scripts won’t touch the PDB$SEED when you execute them. And in addition, MOS Note:1509653.1 tells you, that the PDB$SEED can’t be adjusted. But this leads to a weird mix of time zone settings across a Multitenant deployment. Which I’d guess is not desired. Following a tweet reply by Marco Mischke I realized: I explained how to patch the PDB$SEED – but I didn’t explain how to patch all PDBs with the a new time zone file?

How to patch all PDBs with the a new time zone file?

Photo by Laureen

APEX is in CDB$ROOT again – Journey to the Cloud VII

Posted on December 21, 2016 by Mike.Dietrich APEX Cloud Single-/Multitenant 0

Well … it’s been a while … but I would like to continue my journey to the cloud …

What happened so far on my Journey to the Cloud?

Gather Fixed Objects Stats in PDBs as well?

Posted on October 21, 2016 by Mike.Dietrich Optimizer Single-/Multitenant Statistics 7

Yesterday I received an interesting customer question:

“Do we have to gather fixed objects stats inside a PDB as well or only in the CDB$ROOT?”

The customer told me he couldn’t find anything in the documentation. Neither could I. And I did check also the usual suspects this morning “Best Practices for Gathering Statistics” – but it does not say anything about PDBs and CDBs.

Therefore I did a short test:

Create a PDB in my Oracle 12.1.0.2 CDB:

SQL> create pluggable database PDB3
     admin user adm identified by adm
     file_name_convert=( '/u02/oradata/CDB1/pdbseed', '/u02/oradata/CDB1/pdb3');

Open the PDB:
```
SQL> 
```

Why you should remove APEX from the CDB$ROOT

Posted on November 19, 2015 by Mike.Dietrich APEX Removal Single-/Multitenant 11

Upgrade Blog posts about Oracle Application Express:

Oracle APEX (Application Express) is great piece of software. But it gets installed by default into the container database’s CDB$ROOT unless you’d customized your CDB creation via scripts in Oracle 12.1.0.2. See:

Create Container Databases (CDB) with less options – it’s now supported in Oracle 12.1.0.2

on how to customize a Single/Multitenant Database with less options.

But that is not the topic I …

CDB$ROOT

Choose your desired time zone version (DST) upgrade

Where does the problem start?

UNDO_RETENTION not inherited to PDBs anymore since 19.9.0

What is happening before 19.9.0?

Transportable Tablespaces – Example and strange error with a PDB

A simple Transportable Tablespace

How to patch all PDBs with the a new time zone file?

APEX is in CDB$ROOT again – Journey to the Cloud VII

What happened so far on my Journey to the Cloud?

Gather Fixed Objects Stats in PDBs as well?

Why you should remove APEX from the CDB$ROOT

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts