Cloning with Pluggable Databases in Oracle 18c

We had several discussions on the internal mailing lists the other day about cloning with Pluggable Databases in Oracle 18c (or 12.2.0.1). And I blogged about this topic a while ago but realized I may need to refresh this a bit. My example from the old blog post still works fine. But I realized that I switched my database into read-only mode. Hence, I like to repeat it and check different options. Cloning a 12.1 PDB into Oracle 18c In the source CDB1 I create a fresh PDB first, then open it and create a cloning user with the necessary…

Patching does not work – Journey to the Cloud VI

What happened so far on my Journey to the Cloud? Part I – Push a Button (Dec 3, 2015) Part II – Switch On/Off and Remove (Dec 4, 2015) Part III – Patch, patch, patch (Dec 22, 2015) Part IV – Clean Up APEX (Jan 19, 2016) Part V – TDE is wonderful (Jan 28, 2016) You are here ==> Part VI – Patching does not work (Apr 18, 2016) Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) Patching in the Cloud I would like to patch my Oracle DBaaS Cloud today. It was so simple a few weeks…

What happened to the blog post about “12c parameters”?

Two weeks ago I published a blog post about Parameter Recommendations for Oracle Database 12.1.0.2. And I took it down a day later. Why that? I’ve got a lot of input from external sources for the “Parameter” blog post. And I’d like to thank everybody who contributed to it, especially Oracle ACE Ludovico Caldara. Generally there was a bit of a misunderstanding internally about whether we should “advertise” underscore parameters to cure some misbehavior of the database. In 99% of all cases I’d agree that underscores are not a good solution – especially when it comes to database upgrades as…

DBUA and Read-Only Tablespaces – Things to Know – I

Related Blog Posts: DBUA and Read-Only Tablespaces – Things to Know – I (Feb 3, 2016) DBUA and Read Only Tablespaces – Things to Know – II (Mar 30, 2016) DBUA displays wrong RMAN Backup for Restore (Sep 21, 2015) DBUA 12c and “datapatch.pl” – things to know (Jul 20, 2015) Some people prefer the manual upgrade on the command line, others prefer the graphical tool Database Upgrade Assistant (DBUA). DBUA and Read-Only Tablespaces  The DBUA offers you an option of setting your non-Oracle tablespaces read-only during the upgrade. What the option doesn’t tell you is the purpose – and…