question Re: Unable to verify database connection in Archives of Support Questions (Read Only)

Unable to verify database connection

Nishan — Fri, 16 Sep 2022 08:55:32 GMT

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]

Re: Unable to verify database connection

Nishan — Tue, 18 Mar 2014 17:14:38 GMT

Can any body help me with this?

Re: Unable to verify database connection

Clint — Tue, 18 Mar 2014 17:17:13 GMT

I notice you have the mysql-java-connector in your classpath, maybe that should be moved out of the way so that the oracle driver is the only one that can pick up the connection?

Re: Unable to verify database connection

Darren — Tue, 18 Mar 2014 17:26:58 GMT

It sounds like the user doesn't exist in your oracle database. Did you already create the user in your Oracle database?

What's the command-line invocation that you used?

Re: Unable to verify database connection

Clint — Tue, 18 Mar 2014 17:32:27 GMT

Oh, good point, and are you sure there's not a typo in the db name? Did you really create the db in Oracle as "cluderamgr"?

Re: Unable to verify database connection

Nishan — Tue, 18 Mar 2014 18:35:03 GMT

There is no mysql jdbc jar on class pasth .It is echoed from the cloudera shell.In fact I copiedmy oracle jdbc jar file to that location but I am still getting the same result.This i sthe command I run to prepare my database.

scm_prepare_database.sh -h10.x.x..x -P1000 --scm-host x.x.x.x oracle ENTLOG user pwrd.

Below is the stack trace.Any break through.I am able to telnet to this db server port from my cloudera manager host.

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 'ENTLOG'.
[ 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]
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)[ojdbc6.jar:11.2.0.3.0]
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)[ojdbc6.jar:11.2.0.3.0]
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)[ojdbc6.jar:11.2.0.3.0]
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)[ojdbc6.jar:11.2.0.3.0]
at java.sql.DriverManager.getConnection(DriverManager.java:571)[:1.7.0_51]
at java.sql.DriverManager.getConnection(DriverManager.java:215)[:1.7.0_51]
at com.cloudera.enterprise.dbutil.DbCommandExecutor.testDbConnection(DbCommandExecutor.java:229)[common-4.8.2.jar:]
at com.cloudera.enterprise.dbutil.DbCommandExecutor.main(DbCommandExecutor.java:132)[common-4.8.2.jar:]
[ main] DbCommandExecutor ERROR Exiting with exit code 7
--> Error 7, giving up (use --force if you wish to ignore the error)

Re: Unable to verify database connection

Nishan — Tue, 18 Mar 2014 18:39:11 GMT

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.

Re: Unable to verify database connection

Nishan — Tue, 18 Mar 2014 18:41:29 GMT

here is the command line invocation

scm_prepare_database.sh -h10.x.x..x -P1000 --scm-host x.x.x.x oracle ENTLOG user pwrd.

Re: Unable to verify database connection

Nishan — Tue, 18 Mar 2014 21:21:02 GMT

If some can point to the log file location it would be great

Re: Unable to verify database connection

Darren — Tue, 18 Mar 2014 21:25:21 GMT

The relevant error is already displayed. It looks like your Oracle TNS listener doesn't know the Oracle SID "ENTLOG". Is that the right TNS name?
"
[ main] DbCommandExecutor INFO Able to connect to db server on host '10.7.123.21:1530' but not able to find database 'ENTLOG'.
[ 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
"

Does the following work from the machine where you are trying to run CM server? This is basically what the scm script is trying to do. (replace with real user and password)
sqlplus user/pwrd@10.7.123.21:1530/ENTLOG

You also probably don't need to specify --scm-host, though I don't think that would cause this error.

Re: Unable to verify database connection

Nishan — Wed, 19 Mar 2014 15:54:26 GMT

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