Is it possible to migrate the Postgres db to Oracle for Cloudera 5.13.3?

[#1]

I have a cluster that uses a Postgres db with version 9.4.17 installed on a host in the cluster and I want to migrate to an external Oracle db. I have researched about the methods to do this in Cloudera documentations and I found that I have to have a Cloudera version higher than 5.15. Would it make any difference if we do the migration using Cloudera 5.13? what could be the differences between 5.13 and 5.15 in terms of db?

"""Configuration uses Cloudera Manager 5.15.0 or later on supported platforms."""

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_...

[#2 · Accepted solution]

@reca This should work. The Oracle Database earlier versions are supported for C5.13. Please see the support matrix here. 

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_...

Once you decide the Oracle DB version you can just follow this guide for migrating a Postgres DB to Oracle. 

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_...

[#3]

---

@GangWar wrote:

@reca This should work. The Oracle Database earlier versions are supported for C5.13. Please see the support matrix here. 

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_...

png to ico

Once you decide the Oracle DB version you can just follow this guide for migrating a Postgres DB to Oracle. 

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_...

---

Thanks for the info, much appreciated!

[#4]

@reca, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.