Marc Wagner

MySQL Metadata Store service not able to start on an ODA

I was recently doing some consulting on some ODA at one of our customers, and I faced an issue with the DCS Agent and the MySQL Metadata Store. In this blog, I will show you the problem and how I(…)

Starting ODA 19.29 – Old grid version cleanup

We know that during the ODA patching, a new grid version will be installed. To avoid the /u01 file system to fill up, we need to cleanup the old version. In this blog, I will show you how you can(…)

ODA 19.30 prepatch report failing on OS patches

I had to recently patch several ODAs from 19.28 to 19.30, and one ODA patching failed running the prepatch report which is mandatory and helpful before going to patch the ODA. For each step (server, grid or storage) a prepatch(…)

How to check if my Oracle dbhome is RO or RW?

As you might know, RO (Read Only) dbhome was introduced in Oracle 18c and became default configuration in Oracle 21c. Oracle came back with RW (Read Write) dbhome as default configuration in 23ai. It might be interesting to know how(…)

Possible to relocate a PDB on ExaCC with move option?

In some of my previous blogs, I showed how we were migrating on-premise databases to the ExaCC using Oracle ZDM at one of our customer. I also explained in some article how it was important in some case to relocate(…)

ZDM 21.5 Physical Online Migration failing during TEMP tablespace encryption

The ZDM 21.5 version brings some new functions like encrypting automatically now the TEMP, SYSTEM, SYSAUX and UNDO tablespaces. There is no need to do it manually any more after the ZDM migration, ZDM will take care of it on(…)

Oracle ZDM 21.5 new features

I have already written several articles about my experience migrating databases with Oracle Zero Downtime Migration. At that time, the version available was 21.4. The current version is now 21.5. Recently, I had the opportunity to patch our customer ZDM(…)

Automatisation for Oracle ZDM installation and update

Let's have a look how we can install and update Oracle Zero Downtime Migration tool, and see how we can automatise it with ansible...

What will happen to your spare clones during a switchover on ExaCC?

As you might know, on ExaCC, it is possible to create spare clones. This is based on snapshot technology. There is no physical copy and the modified blocks will be written to the sparse clone, and in our case these(…)

dbaascli database move failing with ORA-01691 on ExaCC

I recently had to move a database from a 19.23 to a 19.26 dbhome on an ExaCC. This will include the database to be patched. The command dbaascli database move failed during the datapatch steps with following error: DBD::Oracle::st execute(…)