How long can you provision database version X in the Cloud? – NEW

A few weeks ago I published a blog post about provisioning dates in Oracle Cloud environments for different databases releases. As we did an important update, I rewrite today: How long can you provision database version X in the Cloud? – NEW. What has changed since the original post? The key point in the previous blog post was: “And by end of this calendar year, the option to provision an Oracle 12.2.0.1 instance will go away. The same will happen in less than 1 year with Oracle 11.2.0.4 instances.”. With “this calendar year” I pointed to end of 2018. That…

How long can you provision database version X in the Cloud?

That’s a question I have gotten several times already: How long can you provision database version X in the Cloud? Meaning, is there a fixed date when you’ll be unable to provision an instance containing Oracle Database 12.1.0.2 for instance? How long can you provision database version X in the Cloud? Please find the updated blog post here: How long can you provision database version X in the Cloud? – NEW –Mike

Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic)

I was quite surprised when I spotted the Update (RU) Oracle 18.2.0 mid of April in my OCI Classic (DBCS, DBaaS) account. Of course I was thrilled immediately and started the patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic). Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic) The April 2018 Updates (and Bundle Patches and Patch Set Updates for Oracle releases below 12.2) got released on April 17, 2018. You can read more here on how I applied all of them to my Oracle 11.2.0.4, 12.1.0.2 and 12.2.0.1 databases. But I was positively surprised when I…

Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud

There’s been silence for a while – but today I’d like to show you how to unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud. I’m doing this exercise because I’ve seen questions already. And I was curious if it works as I’d expect it. Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud As usual I will use our hands-on lab environment – and a freshly deployed 18c OCI-Classic instance (formerly known as DBCS formerly known as DBaaS). It is a Single Tenant environment with one PDB. If you need for information about how to…

OOW 2017 – Slides Download: Migrate to the Oracle Cloud

Thanks for coming to Roy’s and Julian Dontcheff‘s presentation about How to migrate to the Oracle Cloud – 13 different techniques and customer experiences on Tuesday at Oracle Open World 2017. The talk was very well attended, I saw many people taking pictures and notes. OOW 2017 – Slides Download: Migrate to the Oracle Cloud Personally I liked the talk a lot as it gives a very good (and very rare) complete overview on techniques how to migrate to the Oracle Cloud, advantages, use cases, database versions, where to use it. This all garnished with the experience Accenture has –…

Gather SQL Statements from AWR and Cursor Cache without need for Diag and Tuning Packs

When we talk about database upgrades and migrations the most important (and unfortunately time-/resource consuming) activity is testing. But often testing resources are limited or, even worse, don’t exist. I’ve worked with customers where we migrated a core EBS system off AIX to Linux – but only got a 6 year old Tru64 box for testing purposes (where the recompilation took 20x as long as later on the production environment). Or the classic one: Database is too big thus we test only with 10% of the data. I know that often your hands are tied. Everybody wants an 1:1 duplicate…

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

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? 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) Part VI – Patching does not work (Apr 18, 2016) You are here ==> Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) Oracle Database…

Full Transportable Export/Import – Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud

Full Transportable Export/Import – one of the coolest features in Oracle Database 12c  We blogged about Full Transportable Export/Import a while back. It is – no doubt – one of the coolest features in Oracle Database 12c. And it is part of our Hands-On Lab exercise (Hands On Lab – Upgrade, Migrate, Consolidate to Oracle Database 12c) as well. It utilizes the technique of Transportable Tablesspaces – cross-platform, cross- Endianness, cross-version – but lets Oracle Data Pump do all the “dirty” work of rebuilding everything kept in your SYSTEM and SYSAUX tablespace including views, synonyms, public objects, grants, sequences etc etc etc. You can…

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…

TDE is wonderful – Journey to the Cloud V

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) You are here! ==> Part V – TDE is wonderful (Jan 28, 2016) Part VI – Patching does not work (Apr 18, 2016) Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) Today’s journey: Learn about TDE (Transparent Data Encryption) and other secrets What I really really love about my job: Every day…

Clean up APEX – Journey to the Cloud IV

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) You are here! ==> Part IV – Clean Up APEX (Jan 19, 2016) Part V – TDE is wonderful (Jan 28, 2016) Part VI – Patching does not work (Apr 18, 2016) Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) Today’s journey: Cleanup APEX removal leftovers  When you read my “Patch” blog post from Dec 22, 2015 you’ll see that I…

Patch, patch, patch – Journey to the Cloud – III

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) You are here! ==> Part III – Patch, patch, patch (Dec 22, 2015) Part IV – Clean Up APEX (Jan 19, 2016) Part V – TDE is wonderful (Jan 28, 2016) Part VI – Patching does not work (Apr 18, 2016) Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) I haven’t stopped my journey if you wonder about the inactivity for two weeks. I just had to learn a bit…

Switch on/off + Remove – Journey to the Oracle Cloud – II

What happened so far on my Journey to the Cloud? Part I – Push a Button (Dec 3, 2015) You are here! ==> 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) Part VI – Patching does not work (Apr 18, 2016) Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) Day 2 of my Cloud exploration journey. In my blog posts about my DBaaS Cloud journey I won’t explain a lot…

Push a Button – Journey to the Oracle Cloud – I

What happened so far on my Journey to the Cloud? You are here! ==> 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) Part VI – Patching does not work (Apr 18, 2016) Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) Isn’t that a great marketing picture/poster? But the real question is: How do you move a database to the Oracle Cloud?…

Airfare Pricing vs. Oracle Multitenant for DBaaS?

I’m currently evalutating flight options to and from India for the 3 workshops in March in Mumbai, Delhi and Bangalore. As everything at Oracle is fully self-serviced I’ve got stuck in our booking tool for over an hour now just wondering … wondering … wondering … For instance I wonder why an Economy class ticket with Lufthansa and Swiss to Mumbai and return from Bangalore will cost over EUR 5000 (no joke!!!) even though Swiss is a 100% subsidiary of Lufthansa. whereas I can fly a slightly different route with Delta Airlines only from Germany to the US and back…