Have you ever asked yourself how to rename a pluggable database? I did. And today a colleague from ACS Support told me how easy it is.
Of course I had to try it out. And it seems to work quite nice in Oracle Database 126.96.36.199. In the previous release I found some nits documented in MOS.… [Read More]
You may have read already some stories about our successful collaboration with Switzerland’s most trusted insurer, Swiss Mobiliar Insurance on this blog. But today I can add an official reference story in 3 languages about how Swiss Mobiliar Boosts Performance by Upgrading its Oracle Databases.
Reference Story: Mobiliar’s Upgrade Project
And I’m very excited to link the official reference story about Mobiliar’s Upgrade and Multitenant project available in 3 languages:
Congratulations to the Team
Congratulations to a fantastic team at Swiss Mobiliar.… [Read More]
Since Oracle Database 188.8.131.52 a Multitenant container database can host PDBs with different character sets. This was a huge restriction in Oracle Database 12.1., at least outside the US and Canada. Here in Germany alone you may find plenty of different database character sets, for instance WE8ISO8859P1, WE8ISO8859P9, WE8ISO8859P15, WE8MSWIN1252, maybe still some old WE8DEC – and of course the unicode ones UTF8 and AL32UTF8.… [Read More]
What a strange topic. And I thought I never will blog about this. But as I have received the same question for the third time today, I think there’s a bit clarification needed. Lost AWR snapshots reappear in Oracle 12.2 in Multitenant pluggable databases.
Lost AWR snapshots reappear again in Oracle 12.2 in Multitenant
In a non-CDB database you have your local AWR data stored in the SYSAUX tablespace.… [Read More]
You can attempt an Oracle database upgrade without having a fallback strategy. Of course you can. If you are brave enough. But I would recommend you this Fallback Strategy: Flashback to Guaranteed Restore Points. It is simple, easy, fast. And yes, it is an Enterprise Edition only feature. I have blogged about it in the past already but I realized it need some refresh.… [Read More]
At the moment I work with one of our reference customers, Swiss Mobiliar Insurance, on their Multitenant upgrade to Oracle Database 184.108.40.206. And we encountered an “interesting” issue. After upgrade we received an ORA-44787 making it impossible to switch between containers with “
alter session set container=pdb1;” commands.… [Read More]
I have received several questions from customers in the past weeks using Oracle Multitenant about the parameter
exclude_seed_cdb_view.It magically disappeared and morphed into
_exclude_seed_cdb_view since Oracle Database 220.127.116.11. To be fair, the
exclude_seed_cdb_view is listed in the list of obsolete parameters in Oracle Database 18.104.22.168.
What is EXCLUDE_SEED_CDB_VIEW?
This parameter hides everything belonging to the
PDB$SEED from the usual queries.… [Read More]