Problem Description:
When starting a Hive Metatsore service from Ambari, the service fails to start with the following error: ERROR: Check db_connection_check was unsuccessful. Exit code: 1. Message: ERROR: Unable to connect to the DB. Please check DB connection properties. 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
Traceback (most recent call last): File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 506, in CheckHost().execute() File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 280, in execute method(env) File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 206, in actionexecute raise Fail(error_message) resource_management.core.exceptions.Fail: Check db_connection_check was unsuccessful. Exit code: 1. Message: ERROR: Unable to connect to the DB. Please check DB connection properties. 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
Cause:
This issue maybe a temporary condition that can occur after the listener has started and before the database instance has registered with the listener.
The following is the connection string used in this case for connecting to Oracle database:
"jdbc:oracle:thin:@//node01.hortonworks.com:1521/hdporcl"The error ORA-12514: TNS:listener does not currently know of service requested in connect descriptor means that a listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name (usually a database service). In this case it is hdporclthat either has not been dynamically registered with the listener or has not been statically configured for the listener.
lsnrctl services <listener name>
Hiveserver2 services crashes at memcpy of native frame and SIGSEGV
Insert overwrite query fails when moving the data from ".hive_staging" to the table
Hive query (Tez/ORC) is slow - 90% of runtime is on the last reducer phase
"java.sql.SQLException: ORA-01000: maximum open cursors exceeded" when running a Hive query
"Cannot read property 'name' of undefined" when using Hive View 2.0 to import a CSV file
HCC Guidelines | HCC FAQs | HCC Privacy Policy
© 2011-2017 Hortonworks Inc. All Rights Reserved.
Hadoop, Falcon, Atlas, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie and the Hadoop elephant logo are trademarks of the Apache Software Foundation.
Privacy Policy |
Terms of Service
HCC Guidelines | HCC FAQs | HCC Privacy Policy | Privacy Policy | Terms of Service
© 2011-2018 Hortonworks Inc. All Rights Reserved.
Hadoop, Falcon, Atlas, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie and the Hadoop elephant logo are trademarks of the Apache Software Foundation.