How to fix Oracle TNS Listener Issues
A few times over the course of working with Oracle, I’ve come across environments which had issues making connections to databases set up across a network. These were failing with the error “ORA-12514: No TNS Listener”. I eventually found that to fix this, you need to follow the steps below: Install the Oracle Data Access Components (ODAC) on the machine attempting to make the connection Navigate to C:\app\<username>\product\<oracle_version>\client_1\Network\Admin\Sample (note that this… Read More »How to fix Oracle TNS Listener Issues