Using MongoDB Relational Migrator to migrate Oracle Pluggable Database (PDB)

Dung_Hoang · 2024-07-31T03:27:45.661Z

Hi MongoDB Community,

I am currently working on migration of a source Oracle PDB to a MongoDB Replica Sets using MongoDB Relational Migrator. There was an error in the CDC stage because Oracle Logminer cannot run on PDB. I believe Debezium connectors have an option to run for Oracle PDB. Please provide us how to config MongoDB Relational Migrator in order to run CDC on Oracle PDB.

Thank you.

Mark_Bereznitsky · 2024-07-31T05:18:53.272Z

Hey @Dung_Hoang ! Thanks for using Relational Migrator, we hope to get you up and migrating quickly.

The way to add this property is to alter a file named “user.properties” found in one of these locations: https://www.mongodb.com/docs/relational-migrator/installation/file-location/

The following line should be added somewhere in that file with the right PDB name. Migrator then needs a restart.

migrator.connector.source.common.database.pdb.name: PDBNAMEHERE

Thank you!

Dung_Hoang · 2024-08-05T15:27:59.828Z

Hi Mark,

Thanks for your reply. I assume that in order to use this config you need to run Relational Migrator with Kafka deployment mode right?

Mark_Bereznitsky · 2024-08-06T03:26:31.227Z

It should work with the local deployment mode just fine as well