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
- On impacted workstation, Start menu > open command prompt (cmd)
- Type: tnsping VGER 1521
- 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