Connection to the database fails with error TNS No Listener

Document ID : KB000011476
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Connection to the database fails with the following entry in the WebFort Server log file: 

 

ReportError: SQL Error State:08001, Native Error Code: 30FD, ODBC Error:

[DataDirect][ODBC Oracle driver][Oracle]ORA-12541: TNS:no listener

Answer:

Check for the following:

  1. Make sure that the Listener service on your database server is configured properly and running..
  2. Ensure that the Connectivity parameters are specified properly in odbc.ini file and arcotcommon.ini file
  3. Check the connectivity using any Tool like SQL developer or SQL server management studio to ensure connectivity is getting established.