DMU reports “Need conversion” on table WRI$_SQLSET_DEFINITIONS in Data dictionary

By chance, right after my “ODC Appreciation Day” post, I’ve been asked to convert a database from character set WE8ISO8859P1 to AL32UTF8 with DMU. Apart from a few well-known issues described in MOS note 2018250.1, I got a “Need conversion” row on table WRI$_SQLSET_DEFINITIONS in data dictionary. Section D.11 of MOS note 2018250.1 states that you […]

Read More

ODC Appreciation Day : DMU – Oracle Database Migration Assistant for Unicode

(Picture from Oracle.com) It was very difficult for me to choose a topic for #ThanksODC this year 🙂 I finally decided to talk about something very useful, but maybe not so widespread. For once, I am going to praise a GUI 🙂 : The Oracle Database Migration Assistant for Unicode (DMU). Migrating a database’s character […]

Read More

Problem with datapatch, sqlpatch_bootstrap.sql and obj$

(Picture by Hermes Rivera, via Unsplash) EDIT : This bug has finally been fixed by patch 28809007 and should be included with release 20.1 🙂 ! This blog post describes a very specific problem I encountered while using datapatch. I recently patched 400+ 12.1.0.2 databases on RHEL 7.5 with Database Proactive Bundle Patch + OJVM […]

Read More