We have an oralce 816 client on Win NT with third party software connecting to Oracle816 DB on linux using "Merant ODBC" driver. I am getting lot of "TNS-12502: TNS:listener received no connect data from client messages" in the listener log file. I checked the tnsnames.ora on the client and it does have CONNECT_DATA specified. Does anyone know what is happening?
It's happening consistently. I checked the tnsnames.ora file and the entries are correct.
We have an NT server with a third party software and Oracle client software 8.1.6. Third part software makes a connection to the Oracle Server dirver on linux using ODBC and it needs the connection open all the time. Also this is production environment i can't afford to bring down the NT server.
If i try to connect with another application (Excel, Acess etc..) and if i get this error "TNS-12502: TNS:listener received no connect data from client " how can i figure out which app is causing this error.
in the tnsnames. set the service_name = ... instead of SID. You can know the service name from the initSID.ora file or by querying the v$parameter as sys or system. Check your ODBC connection configuration to see whether there are any timeouts defined.