Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ORA-12541 TNS:no listener when trying to query Voyager

    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

    Problem Symptoms

    Try to query Voyager from Access Reports and receive error:

    ODBC--call failed.
    [Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener (#12541) [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed (#0)

    Cause

    ORA-12541 error is usually a communication error

    Resolution

    1. On impacted workstation, Start menu > open command prompt (cmd)
    2. Type: tnsping VGER 1521
    3. Press Enter

    If this fails, check firewall and other connection-related configurations. 

    The Oracle Listener may not be running on the server.  See: How to tell if the Oracle Listener is running on a Voyager server

    Otherwise, you may need to uninstall the drivers and then reinstall the ODBC Drivers.  See the Overview of version requirements for Voyager ODBC drivers for information about Voyager version compatibility considerations and which ODBC drivers you should install.

    Additional Information

    This is an example of what an error looks like when running tnsping:

    C:\WINDOWS\System32>tnsping VGER 1521

    TNS Ping Utility for 64-bit Windows: Version 19.0.0.0.0 - Production on 08-FEB-2021 04:33:11

    Copyright (c) 1997, 2019, Oracle.  All rights reserved.

    Used parameter files:
    C:\oracle\19_full\network\admin\sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.3.3)(PORT = 1521))) (CONNECT_DATA = (SID = VGER)))
    TNS-12541: TNS:no listener

    This is an example of what a success looks like:

    C:\WINDOWS\System32>tnsping VGER 1521

    TNS Ping Utility for 64-bit Windows: Version 19.0.0.0.0 - Production on 08-FEB-2021 04:34:29

    Copyright (c) 1997, 2019, Oracle.  All rights reserved.

    Used parameter files:
    C:\oracle\19_full\network\admin\sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.3.53)(PORT = 1521))) (CONNECT_DATA = (SID = VGER)))
    OK (140 msec)
    OK (90 msec)
    OK (80 msec)
    OK (100 msec)
    OK (70 msec)
    OK (80 msec)
    OK (100 msec)
    OK (70 msec)
    OK (80 msec)
    OK (100 msec)

    ^C
    C:\WINDOWS\System32>

     


    • Article last edited: 27-Sep-2020
    • Was this article helpful?