Hortonworks.com
  • Explore
    • All Tags
    • All Questions
    • All Repos
    • All Repos
    • All SKB
    • All SKB
    • All Articles
    • All Ideas
    • All Articles
    • All Ideas
    • All Users
    • All Badges
    • Leaderboard
  • Create
    • Ask a question
    • Add Repo
    • Add Repo
    • Create Article
    • Post Idea
    • Create Article
    • Post Idea
  • Tracks
    • All Tracks
    • Community Help
    • Cloud & Operations
    • CyberSecurity
    • Data Ingestion & Streaming
    • Data Processing
    • Data Science & Advanced Analytics
    • Design & Architecture
    • Governance & Lifecycle
    • Hadoop Core
    • Sandbox & Learning
    • Security
    • Solutions
  • Login
HCC Hortonworks Community Connection
  • Home /
  • Solutions /
  • Home /
  • Solutions /
avatar image

ERROR:"ORA-12514, TNS:listener does not currently know of service requested in connect descriptor" when starting Hive Metastore

Vani created · Dec 07, 2017 at 08:43 AM
0

SupportKB

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.
 
Solution:
To solve the issue, do the following: 
  1. Verify that the SERVICE_NAME parameter exists in the connect descriptor. You can check this by checking the entries for the Oracle database in the tnsnames.ora file.
  2. Check which services are currently known by the listener by executing the following in Oracle server: 
    lsnrctl services <listener name>
  3. Request your database administrator to check listerner.log to check for further error messages.
  4. After confirming that the listener is running and the SERVICE_NAME parameter is valid, attempt a restart of Hive Metastore
    1. If there is a change in SERVICE_NAME, make the changes in JDBC URL of Hivemetastore using Ambari Hive-Configs and restart Hive Metastore
https://docs.oracle.com/cd/B19306_01/server.102/b14219/net12500.htm


 

About:
This article created by Hortonworks Support (Article: 000005691) on 2017-05-12 02:34
OS: n/a
Type: Configuration
Version: n/a

Support ID: 000005691
thub.nodes.view.add-new-comment
solutionhwsupportHive
Add comment
10 |6000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Follow

Follow

avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image

Related posts

Hiveserver2 services crashes at memcpy of native frame and SIGSEGV

ERROR:"Failed with exception java.io.IOException:java.io.IOException: java.net.ConnectException: Connection refused Time taken:" when running a Hive query on Hive table

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

Uneven query execution time when running the same query multiple times against Hive Interactive Server(LLAP)

"java.sql.SQLException: ORA-01000: maximum open cursors exceeded" when running a Hive query

Error:"org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:ERROR 722 (43M05): Schema does not exists" when running a query from Hive to create a table in Phoenix using the Phoenix-hive storage handler

Error:"java.io.FileNotFoundException: File hdfs://hdpha/apps/hive/warehouse/db1.db/hivetb1/part=10/_tmp_410b64c1-93e5-4b05-8e31-941e0dea3a14 does not exist" when running Hive compaction on an ACID table

"Cannot read property 'name' of undefined" when using Hive View 2.0 to import a CSV file

ERROR: "ORA-01461: can bind a LONG value only for insert into a LONG column" when generating column stats for Hive table with large columns

HCC Guidelines | HCC FAQs | HCC Privacy Policy

Hortonworks - Develops, Distributes and Supports Open Enterprise Hadoop.

© 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.

  • Anonymous
  • Login
  • Create
  • Ask a question
  • Add Repo
  • Add Repo
  • Create SupportKB
  • Create SupportKB
  • Create Article
  • Post Idea
  • Create Article
  • Post Idea
  • Tracks
  • Community Help
  • Cloud & Operations
  • CyberSecurity
  • Data Ingestion & Streaming
  • Data Processing
  • Data Science & Advanced Analytics
  • Design & Architecture
  • Governance & Lifecycle
  • Hadoop Core
  • Sandbox & Learning
  • Security
  • Solutions
  • Explore
  • All Tags
  • All Questions
  • All Repos
  • All Repos
  • All SKB
  • All SKB
  • All Articles
  • All Ideas
  • All Articles
  • All Ideas
  • All Users
  • Leaderboard
  • All Badges