Why does your most important database run on Oracle 10.2.0.4?

Today is a sunny day. A wonderful beautiful spring day. Flowers are blooming. Trees are getting green. Birds are singing. All fine. And then I find this email in my inbox. A customer wants to migrate between two Big Endiann platforms with a important ERP system. Nothing special – until I read this: The ERP system is currently on Oracle 10.2.0.4 – and it should stay on Oracle 10.2.0.4. The first question I have: Why does your most important database run on Oracle 10.2.0.4? In 2018. Why does your most important database run on Oracle 10.2.0.4? This is of course…

ORA-44787 – Don’t mess with the Default Oracle Service

At the moment I work with one of our reference customers, Swiss Mobiliar Insurance, on their Multitenant upgrade to Oracle Database 12.2.0.1. 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. Lesson learned now: If you don’t want ORA-44787 – Don’t mess with the Default Oracle Service. What has happened? Very simple case. We approach a database upgrade with a Multitenant deployment of over 90 PDBs. Source database version is Oracle Database 12.1.0.2.BP170117, destination version is Oracle Database 12.2.0.1.RU170718. The upgrade runs fine. But…