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

ORA-44787 - Don't mess with the Default Oracle ServiceAt 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.… [Read More]

My thoughts about the new Oracle Database Release Schedule

Changes to a well-known release model mean a lot. I will give you some of my thoughts about the new Oracle Database release schedule.

My thoughts about the new Oracle Database Release Schedule

What are we changing?

In my own words we basically rename the patch sets and name them what they were since years: Full releases. This means, Oracle Database 12.2.0.2 will be Oracle 18.… [Read More]

News about the new Oracle Database Release Schedule

News about the new Oracle Database Release Schedule

Old release numbering

There are news about the new Oracle Database release schedule. Oracle updated MOS Note 742060.1 containing release information recently.

A few weeks ago we changed from PSUs and BPs to RURs (Release Update Revisions) and RUs (Release Updates) beginning with Oracle Database 12.2.

And now MOS Note 742060.1 – Release Schedule of Current Database Releases is updated as well.… [Read More]

XDB Clean Up in Oracle Database 11.2-12.2

XDB Clean Up in Oracle Database 11.2-12.2XDB Clean Up in Oracle Database 11.2-12.2 will apply to Oracle Database 11.2.0.x only as XDB became a mandatory component since Oracle Database 12.1.0.1. You can’t have an Oracle 12c database without XDB. Therefore the following blog post won’t explain how to clean up XDB from an Oracle 12c database.… [Read More]

JAVAVM and XML Clean Up in Oracle Database 11.2-12.2

JAVAVM and XML Clean Up in Oracle Database 11.2-12.2JAVAVM and XML clean up in Oracle Database 11.2-12.2 is a tough topic. Many have suffered from the rolling patch upgrade issues with the OJVM (Oracle Java Virtual Machine) even though most of the issues have been cured with the recent patches.

Please see my previous blog posts starting here:

And please see also this very important MOS Note: 2217053.1 – RAC Rolling Install Process for the “Oracle JavaVM Component Database PSU” (OJVM PSU) Patches explaining the improved process for OJVM patching avoiding downtime in many cases.… [Read More]

OTN Tour South America 2017: Uruguay, Argentina and Brazil

Time flies – and the OTN Tour South America 2017: Uruguay, Argentina and Brazil is over for me. I’m back home.

OTN Tour South America 2017: Uruguay, Argentina and Brazil

But Id like to thank many people. It was an awesome tour again. I participated for the forth time. And I learned a lot again.… [Read More]

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2Enterprise Manager (EM) clean up in Oracle Database 11.2-12.2 is targeting Enterprise Manager Database Control only. EM DB Control does not exist anymore since Oracle Database 12c and got replaced by EM Express, a light-weight EM.

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2As Enterprise Manager Database Control gets replaced by EM Express since Oracle Database 12.1.0.1 its repository must be removed when upgrading to Oracle Database 12c or later.… [Read More]