Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. ORA-12514 when try to connect to Prepackaged Reports

    ORA-12514 when try to connect to Prepackaged Reports

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Problem Symptoms
    2. Cause
    3. Resolution
    4. Additional Information
    • Product: Voyager

    Problem Symptoms

    Attempt to link tables in Prepackaged Reports, receive error:

    ODBC--call failed.
    [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    (#12514) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (#0)

    Cause

    Service name in tnsnames.ora file is not set correctly

    Resolution

    1. Open tnsnames.ora file on workstation.
    2. Replace ( SERVICE_NAME = VGER.{hostname}) with ( ORACLE_SID = VGER )
    3. Save change.
    4. Relink tables

    Additional Information

    Some older versions of Oracle may have required SERVICE_NAME instead of ORACLE_SID but current versions of Voyager should use the above in tnsnames.ora, and current template for tnsnames.ora is available in Installation and Configuration of ODBC for Voyager


    • Article last edited: 06-Feb-2019
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ORA-12170 when installing ODBC for Voyager
      • ORA-12541 TNS:no listener when trying to query Voyager
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved