This could the possible solution, Please share the CM server logs
1) log into CM server host and take a backup file of /etc/default/cloudera-scm-server to a backup location
2) Open /etc/default/cloudera-scm-server file and add the following to the CMF_JAVA_OPTS:
With the above configuration, the file looks like this:
export CMF_JAVA_OPTS="[...existing...javaoptions] -Dlog4j.configurationFile=file:/etc/cloudera-scm-server/log4j2.properties"
3) Create the /etc/cloudera-scm-server/log4j2.properties file.
#chmod 644 /etc/cloudera-scm-server/log4j2.properties
4) We noticed some issues with the ODBC connector:
#ls -ltr /usr/share/java/mysql-connector-java.jar
*Not existing file
6) We copied the ODBC from a different environment. Cloudera Manager is able to start, but it is failing to connect to DB, We granted more connections in the db.properties file:
#vi /etc/cloudera-scm-server/db.properties and add the below line in this file:
> com.cloudera.cmf.orm.hibernate.c3p0.max_statements=0 <
7) After the restart, the CM server started successfully