Support Questions

Find answers, ask questions, and share your expertise

Unable to verify database connection

avatar
Champion Alumni

Trying to point cloudera manager to  the database while installation.I am pastinng the error trace.Any one knows what the issue could be.I have the  oracle db driver.

 

Executing: /usr/java/default/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/share/cmf/schema/../lib/* com.cloudera.enterprise.dbutil.DbCommandExecutor /etc/cloudera-scm-server/db.properties com.cloudera.cmf.db.
[ main] DbCommandExecutor INFO Able to connect to db server on host '10.7.123.21:1530' but not able to find database 'cluderamgr'.
[ main] DbCommandExecutor ERROR Error when connecting to database.
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)[ojdbc6.jar:11.2.0.3.0]

1 ACCEPTED SOLUTION

avatar
Champion Alumni

It was a problem with specifying the TNS name.Got That resolved.Thank you all.

View solution in original post

10 REPLIES 10

avatar
Champion Alumni

I am able to connect to this db using other tools like toad,db visualzer etc using the same credentials.Any thing else I need to set up.

I was able to set up this yesterday against a postgres db.