X

Archived Database Upgrade Blog

Cloud

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...

Thursday, January 26, 2017 | Cloud | Read More

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) ==> Part VI - Patching does not work (April 18, 2016) Patching in the Cloud I would like to patch my Oracle DBaaS Cloud today. It was so simple a few weeks ago. But I didn't patch it yet up to the January 2016 PSU...

Monday, April 18, 2016 | Cloud | Read More

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) . Today's journey: Learn about TDE (Transparent Data Encryption) and other secrets What I really really love about my job: Every day I learn something new. But sometimes learning can be frustrating at the...

Thursday, January 28, 2016 | Cloud | Read More

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). Today's journey: Cleanup APEX removal leftovers  When you read my "Patch" blog post from Dec 22, 2015 you'll see that I was left with an incomplete Oracle Application Express (APEX) removal situation....

Tuesday, January 19, 2016 | Cloud | Read More

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) . I haven't stopped my journey if you wonder about the inactivity for two weeks. I just had to learn a bit as my pretty naive approach caused me some trouble. Based on my last experience I had to find out why...

Tuesday, December 22, 2015 | Cloud | Read More