Connecting Cloudera Manager (6.3) to Oracle ATP on OCI using an Oracle Wallet

Question

I am trying to set up a Cloudera Cluster (Cloudera 6.3) on OCI and want to use an ATP (also running on OCI) as the DB for the Cloudera Manager (I am using these docs).

In order to connect to the ATP I downloaded the wallet, but don’t know how to set the right configurations for the Cloudera Manager so that it uses the wallet with the JDBC Driver (12.2).

I modified the class path in the script scm_prepare_database.sh for when the connection is tested to include all necessary jars for the JDBC Driver, as described in this document and set these properties when executing the script:

• databaseType: oracle
• hostname: tried jdbc:oracle:thin:@<name>_medium, jdbc:oracle:thin: and @<name>_medium
• databaseName: <name>_medium
• databaseUser: my_username
• password: my_password

However, I always receive the following error: IO Error: could not resolve the connect identifier “//<hostname>/<my_username>”

I verified that I can connect from the cluster to the ATP by following the steps described in the linked document.

Is it possible to use a wallet to connect the Cloudera Manager to an Oracle DB (ATP) and if so, what would be the necessary steps to get it working?

I really appreciate your help!

Best regards, Nils

Answer 1

The JDBC driver version and JDK version is very important. You can either use JKS or Oracle Wallets.

Can you go through the ATP using 12.2 JDBC driver and the SSL blog for the detailed instructions?