ITPUB

Mar 17, 2017 · Databases

Why Oracle 12c TNS Listener Returns ORA-12514 and How to Fix It

The article recounts a troubleshooting session where a 12c Oracle standby database failed to connect via TNS, presenting the ORA-12514 error, analyzing listener and tnsnames configurations, uncovering an outdated 11g ORACLE_HOME, and detailing the steps to switch homes and restart the listener to resolve the issue.