In this post, you’ll learn more about the Oracle ErrorTNS-00511: No listener with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
TNS-00511: No listener
Reason for the Error TNS-00511: No listener
Cause: The connect request could not be completed because no application is listening on the address specified, or the application is unable to service the connect request in a sufficiently timely manner.
How to fix the Error TNS-00511: No listener ?
You can fix this error in Oracle by following the below steps
Action: Ensure that the supplied destination address matches one of the addresses used by the listener – compare the TNSNAMES.ORA entry with appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange. Start the listener on the remote machine.