OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers

Yes, OOW starts next week. And I’d like to introduce the third of our 4 talks. And let me say upfront about this talk at OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers. This is not the usual “cloud” talk 🙂 The official title is: Oracle Database Cloud Migration: Fast, Simple, Universal. Well, we should discuss the “simple“. But that’s why you want to see this talk. It will happen on Thursday, 9:00 a.m.. Hence, remember to leave the party the night before not too late. You need to be awake when you visit our talk…

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? First of all, it is important to note that the support time frames between on-prem and cloud are the same. But it is also important for you to notice that after a certain date you won’t be able to provision an instance with a specific database version anymore. And…

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…

When will Oracle Database 18c be available on-prem?

When will Oracle Database 18c be available on-prem? Some of you will answer: It is available already, isn’t it? And you are right. But I don’t want to blog just a marketing message but some facts. Others may ask: When will it be generally available on-premises? ==> July 23, 2018: Linux 18.3.0 on-prem is available – please click here <== When will Oracle Database 18c be available on-prem? As of today, March 20, 2018, Oracle Database 18c is available already in/for: OCI and OCI-C Database services LiveSQL.oracle.com Oracle Exadata and SuperCluster on premises Oracle Database Appliance (ODA) on premises Actually…

Oracle Database 18c released for Oracle Cloud and Engineered Systems

Oracle Database 18c has been released Friday, February 16, 2018 in the Oracle Cloud and for Engineered Systems. What is new in Oracle Database 18c? Please read this comprehensive description by Dominic Giles, Master Product Manager for Oracle Database on https://blogs.oracle.com/database/oracle-database-18c-:-now-available-on-the-oracle-cloud-and-oracle-engineered-systems. Dominic summarizes the most important features in the areas of Multitenant, In-Memory, Sharding, Performance, High Availability, Security, Spatial/Graph and of course Developer features. You’d like to read more about New Features? In case you’d been now interested please see the New Features Guide for more details in Oracle Database 18c. Well, and there’s not only a New Features Guide…

MOS Note:742060.1 got updated with Oracle 18c information

From the Support’s Hot Topics email I learned the other day that MOS Note:742060.1 (Release Schedule of Current Database Releases) got updated with Oracle 18c information on January 18, 2018. What got added to MOS Note:742060.1? A column for Oracle 18c got added to the table of releases. You will find not information about potential release availability for Oracle 18c in the various options of the Oracle Cloud, and of course for on-premises as well. Furthermore please find the updated graph as well.     The note below the graph is very important. See MOS Note:742060.1 for further details. –Mike

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…

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…

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…