How To Resolve Ora-12514: Tns: listener Does Not Currently
Resolve-Ora-12514-Tns-listener-Does-Not-Currently, Ora-12514: , Database 19c, TNS, listener, jaberit, listener does not currently
How To Resolve Ora-12514: Tns: listener Does Not Currently
How To Resolve Ora-12514: Tns:listener Does Not Currently Know Of Service Requested In Connect Descriptor How to Resolve ORA-12514 TNS. listener does not currently We saw ORA-12514 after we tried to start the closed database. Here's why: When you close the instance, you lost connection to the database and the service from the listener was unregistered, there is no more service information in the database on the listener. Therefore, ORA-12514 notifies you that you will not be able to do any more work in this database. Solution... Database 19c Steps How To Solution ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Database 19c. You need to set Oracle to listen to all IP addresses (by default, it only listens to localhost connections.) 1. You may need to edit the listener.ora file in your database. This file is located at:
Windows: %ORACLE_HOME%\network\ admin\listener.ora. 2. Replace the localhost with 0.0.0.0 LISTENER =
(DESCRIPTION_LIS…