I am running Lyris ListManager on a Win 2008 server. It connects to Oracle 12c on another machine.
I have successfully configured and tested the connection using the Net Manger (or Net Configuration Assistant). However, when I run ListManger, I receive this Oracle error (TNS: could not resolve the connect identifier specified).
I checked the configuration file for the ListManager (lmcfg.txt), which correctly specifies everything.
Previously, we had Oracle 11g database, and 11g client on this server, which worked fine. DB upgrade to 12c was successful (other applications, on other servers, work fine), and I removed 11g client and installed 12c. It successfully connects to the Oracle server with the correct service ID, but Lyris ListManger application can't connect.
What am I missing here?
The root of the problem was in multiple client installations. At some point during the troubleshooting, I installed, and then uninstalled 64-bit client. After that, I installed 32-bit client and got it to connect through the Net Manager. However, that 64-bit client wasn't correctly and completely removed, and the ODBC driver was still looking at its original path for DLL libraries (which weren't there anymore).
I had to add a new ODBC driver entry for the 32-bit Oracle client. Once this was properly configured, the ListManager application was able to connect to Oracle server.