Hi,   We have a CDH cluster with version 5.15 and we have migrated the db used by Cloudera from postgres to Oracle. We have followed the migration steps and took the cluster down. When we tried to start the cloudera server again it's failing with the below error.    022-01-13 09:53:19,028 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Schema version table already exists. 2022-01-13 09:53:19,029 INFO main:com.cloudera.enterprise.dbutil.DbUtil: DB Schema version 51300. 2022-01-13 09:53:19,029 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Current database schema version: 51300 WARN main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Failed to determine prior version. This is expected if you are starting Cloudera Manager for the first time. Please also ignore any error messages about missing tables. Moving ahead assuming no upgrade: org.hibernate.MappingException: No Dialect mapping for JDBC type: -9 2022-01-13 09:53:19,043 ERROR main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Unable to access schema version in database. javax.persistence.PersistenceException: org.hibernate.MappingException: No Dialect mapping for JDBC type: -9  Not to mention that when we ran the script scm_prepare_database script we were table to see a successful connection with the db. How can we solve this issue? Oracle version: 19c    Regards ... View more

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_mysql.html     ... View more